Reports for Taxes on Purchases and Sales

[former_member613804]

Dear Friends,

This is with respect to "Reports for Taxes on Purchases and Sales". We have gone through scope item "1J2". Request you to please let us know whether there exists any other reports for the same.

Thanks & Regards,

[Anirban_Dutta · Accepted solution]

Hi SatyaPrasad,

In the app finder , please check the apps under "General Ledger - Tax Declaration". There are some apps here relating to processes and reports which you may find useful.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi Anirban Dutta

Thanks for the response. I have gone through the area "general Ledger - tax Declaration" wherein i have found an application "Create Advance Return on Sales/Purchase Tax".

In that app, i am able to see the supplier wise invoice amount plus tax component. However, if in a document there is SGST and CGST, the system is showing in two different line items and thereby the tax base amount is also coming two times (duplication).

Attached the screenshot for your reference.

Thanks & Regards,

[Anirban_Dutta · Accepted solution]

Hi sathyamsighakolli ,

Is the same Tax code deducting both SGST and CGST? I guess the behavior is because of the reason that the same taxable base applies for both the calculations. Is it showing duplicate lines only in the spool? Or is it wrong on the certificate / return as well. If you see that the taxable base is wrong in the return/certificate , please raise an incident for correcting the same.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi anirban2018

Thanks for the response.

1) As you rightly mentioned, same tax code is deducting both SGST and CGST. Transaction is happening withing the state and we have SGST and CGST applicable in the invoice.

2) We are not using this report for any return / certificate purpose. We are using this application to see the Report of Taxes on Purchase / sale transactions. As we do not find any other report wherein we can see the transactions with respective taxes, we though of using this as workaround.

If any other report could give all the transactions of taxes on purchase / sale, that could also suffice my purpose.

Thanks & Regards,

[Anirban_Dutta · Accepted solution]

Hi sathyamsighakolli ,

You can check the app "Tax Declaration Reconciliation" . Here , you can provide the tax code and posting period as inputs. You can also further drill down to the document numbers from the output.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi anirban2018

Thanks for the response.

I have already checked this application.

Inputs given are Company code, and Fiscal year - system is saying NO DATA FOUND.

Thanks & Regards,

[Anirban_Dutta · Accepted solution]

Hi sathyamsighakolli ,

I tested the app and it should provide output if relevant data exists. Please create an incident for the same.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi anirban2018

I am checking this APP in FIORI APPS LIBRARY, wherein it is specified that The app does not support company code in the following countries:

Brazil

Canada

India

United States

Shall i still raise this to SAP..!

[Anirban_Dutta · Accepted solution]

Hi sathyamsighakolli ,

Thanks for checking. In that case , please do not raise.

Regards,

Anirban

[former_member613804 · Accepted solution]

anirban2018

But I am surprised that it is working for you.

[Anirban_Dutta · Accepted solution]

sathyamsighakolli ,

I checked for a different country.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi anirban2018 ,

Thanks for all the replies.

But is it really true, that there exists no GST reports / tax reports for country India..?

[Anirban_Dutta · Accepted solution]

Hi sathyamsighakolli ,

You are welcome.

GST reporting for India is covered under Scope Item 1J2 as these are compliance related. Please check Sec 4.2 of test script for 1J2 (country version India) for details.

Regards,

Anirban

[former_member613804 · Accepted solution]

Hi anirban2018

I have checked 1J2 where in GSTR1 Report is mentioned. I have done respective configuration and simulated the report.

In the output of the report, i am getting as below.

invoices each GSTIN number

withing which , i will get only one document in one screen,

within which i have to select item wise in a screen.

This doesn't seems to be a report at all

I mean, for example, can't i see a report where i can get list of invoices, each supplier wise, for a period, with base amount and tax amount..?

isn't there at least a single simple report in S4HC system like this..?

Just wanted to know, if someone could help on this..!

[MarNow · Accepted solution]

All the information can be obtained from app: 'Advance Return for Tax on Sales/Purchases'. Please note that in section 'Output lists' you can configure layout to your convenience.

Regards,

Marcin

[former_member613804 · Accepted solution]

mnowacki

Thank you for the Response