While making sale invoice, we do not round our tax values. The problem arises during Purchase Invoice entries where different suppliers manage their tax rounding individually. Some prefer to keep the tax amount rounded up, some round it down, and some leave it as it is in decimals (like we do).
Our ERPNext is setup where our CGST, SGST or IGST do not get rounded in Sale Invoices. How do we match specific Purchase Invoice entries with that of the supplier’s invoice in the following case:
Supplier has rounded down the tax value.
Supplier has rounded up the tax value.
We tried to change the entry Type to “Actual” instead of “On Net Total” before entering the actual tax amount but it returns a “Tax Row #2: Charge Type is set to Actual. However, this would not compute item taxes, and your further reporting will be affected.” error and doesn’t allow saving of the Purchase Invoice.
There are other ways to allow for rounding without using Actual.
For eg we can add a setting for round up, round down etc and that can be selectable by the UI.
This is a real problem being faced because the Suppliers create Purchase Invoices their own way. Ideally we should be able to match those values for our billing/expenses also not just accept supplier values to reconcile for GST. Otherwise even if we make the total of the invoice match using an actual rounding off, the tax will not match up with what the supplier has given. Only because we have put a constraint in the ERP as to how the tax will be charged
We evaluated that there was no significant benefit of handling the complexity of Accept Supplier Values in Purchase Reconciliation tool and hence we would scrap that option to avoid confusion.
