Title: Incorrect Vendor GSTIN in Detailed GST Ledger Entry – Standard Business Central India GST
Hi Community,
I am facing an unusual issue in Microsoft Dynamics 365 Business Central – India GST localization.
We have multiple registered vendors with their respective GST Registration Numbers correctly maintained in the Vendor Master.
However, in some posted Purchase Invoices, I found that the Buyer/Seller Reg. No. in the Detailed GST Ledger Entry is incorrect.
For example:
Vendor 2000312 has GSTIN: 29LMNOP4321Q1Z7
This GSTIN is correct for Vendor 2000312.
However, the same GSTIN 29LMNOP4321Q1Z7 is also appearing in Detailed GST Ledger Entries of other vendors, even though those vendors have different GST Registration Numbers.
At the same time:
- Vendor Ledger Entry shows the correct GSTIN for the respective vendor.
- Vendor No., Vendor Name, Document No., GST Amount, GST Base Amount, Location GSTIN, etc. are correct.
- There are no other Vendor Order Addresses defined for these vendors.
- There is no customization involved in the GST posting process.
Investigation performed
To identify the issue, I created a copy of the production database in a test environment and recreated/reposted the same type of invoice for the affected vendor.
Interestingly:
- Recreating the old invoice → GSTIN posted correctly
- Creating a completely fresh Purchase Invoice → GSTIN posted correctly
- The issue could not be reproduced in the current setup.
This makes the issue more confusing because the original transactions were posted with an incorrect GSTIN, while the same transactions are posting correctly now.
My Questions
- How can the GSTIN of one vendor be populated in the Detailed GST Ledger Entry of multiple other vendors, while the Vendor Ledger Entry contains the correct vendor GSTIN?
- Is there any standard temporary GST table/record or GST calculation buffer involved during posting where the previous vendor's GSTIN could potentially be carried forward?
- Could this happen because of some historical standard GST posting issue/data state, even though the current setup and reposting are working correctly?
- What would be the recommended way to trace the original posting flow and identify the source of the incorrect GSTIN, without directly modifying the posted Detailed GST Ledger Entry?
Any guidance regarding the standard Business Central India GST posting flow and the exact table/field that should be traced would be highly appreciated.
Thanks.
