Purhcase Reconciliation tool finds mismatch even though tax amount is appearing in the PI

[amrit-citrusleaf]

Information about bug

First of all, thanks a lot for maintaining this life-and-time-saver Frappe app!

Now, onto the issue-

While using the purchase reconciliation tool to match GST invoices, we found some “mismatch“ entries. Lots of these entries have incorrect GST amount as compared to their respective Purchase invoices.

An example is below-

In this case the GST amount in the ERPNext PI is not set, according to the reconciliation tool. However, the purchase invoice has taxes set-

But the GST breakup table is empty-

Version

Ecommerce Integrations: v1.17.0 (HEAD) ERPNext: v14.74.5 (HEAD) Frappe Framework: v14.82.1 (HEAD) India Compliance: v14.30.5 (HEAD)

Relevant log output / Stack trace / Full Error Message.

No response

Code of Conduct

• [x] I agree to follow this project's Code of Conduct

_{Huly®: IC-2802}

[vorasmit]

Hi, Looks like in invoice gst details are not set correctly. Have you specified these GST Accounts in GST Settings?

[amrit-citrusleaf]

Here comes the interesting part- for some invoices, the GST amount (CGST, SGST, IGST) are set to zero while the invoice itself has a tax template, and hence tax in the taxes and charges table.

Taxes are item level are zero-

Taxes at the invoice level are non zero-

I think the reconciliation tool checks the GST amount at item level, rather than at the form level. Please confirm if my understanding is correct.

[vorasmit]

Yes correct.

What are the accounts specified in GST Settings?

[amrit-citrusleaf]

Got it. So the way out is to patch the existing data?

Or can I select the "Accept" button on the detail view and the system will update the 2A/2B status?

And, these are the accounts in GST settings-

[vorasmit]

You can easily patch existing data.

• Change accounts in GST Settings.
• Execute this patch manually.

You can do above for all set of accounts that you have. Afterwards,

• Transfer balances to new account (combined). Use only accounts from here for the future transactions.

---

Closing this issue, as no fix is required for this.

[amrit-citrusleaf]

Thanks for the help @vorasmit .

I will run the patch (the accounts shall remain the same as the accounts team is used to their incorrect name)