Dear Community,
I’m sharing how our company successfully addressed the tax adjustment issue in Bill records.
Problem Statement:
We encountered minor decimal rounding differences between our Bill and the vendor’s invoice, typically around 0.01 to 0.03 cents. To correct this, the Finance team previously had to manually add a line in the Bill for GST adjustment. However, this also changed the amount before tax, requiring an additional line to re-balance the total amount — a time-consuming workaround.
Our Solution:
We implemented a simple yet effective fix by adding a custom field in the Bill record called “Tax Adjustment Amount.” This allows users to enter the difference directly, automatically adjusting both the tax amount and the gross amount accordingly.
A short script was created to update the tax amount based on the input in this field.
For example:
- Item A amount = 28.40
- Tax (9%) auto-calculated = 2.56 (28.40 × 9%)
- Vendor’s invoice shows tax = 2.54
- By entering –0.02 in the Tax Adjustment Amount field, the tax now matches the vendor’s invoice exactly.
The standard NetSuite VAT reports now display the correct net and tax amounts, resolving the issue efficiently.