My Oracle Support Banner

GST Settlement Management Form Considers Wrong Tax Type for Tax Regime Being Settled (Doc ID 2872570.1)

Last updated on JUNE 02, 2022

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.


When GST Settlement is done in one Regime (Eg. CGST) involving transactions with Taxes applied from different Regimes (CGST+SGST), Tax amount booked under other Regime (SGST) is also appearing in Settlement form and same issue is observed when Settlement is queried for other Regime (SGST). Once Settlement is processed, invoice for entire Tax Liability amount (CGST + SGST) is getting generated for the Authority site belonging to Regime under which Settlement is processed.

Settlement form should display Tax types from only the Regime that is being queried on the form and once Settlement is processed invoice should be generated for only the Tax Liability amount that got booked under same Regime. Here it is expected to settle GST Taxes at individual Tax level (CGST,SGST,IGST) and pay off to three different Tax Authority sites.

Steps for replication

The issue can be reproduced at will with the following steps:

1. Create individual Regimes CGST and SGST with separate Tax Authority sites for each Regime.

2. Create First Party Registration in each Regime with same GST Registration number.

3. Define Recoverable Tax Type (CGST & SGST) in each Regime and create Tax Rates and Tax Categories to be applied on transactions.

3. Create Accounts Payables invoice and apply both CGST + SGST tax on same. Validate the invoice.

4. Claim the transaction in respective Regimes. Claim is successfully processed in individual Regimes with respective Tax type amount.

5. Book a Sales Order with CGST + SGST Taxes applied and Ship Confirm to book Tax liability.

6. Define Tax Type Netting setup with CGST netting itself and SGST netting itself.

7. On Settlement form enter CGST Regime registration and other details and save. Observe that SGST tax appears in CGST regime settlement.

8. After processing the settlement in CGST, AP invoice for entire Tax liability (CGST + SGST) is generated for only CGST Tax Authority.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.