"Tax structure errors were found in the following invoices" in Error Log when updating invoices, even if tax structure is valid in Sage 100
Resolution
For Sales Order:
Edit the invoice InvalidTaxCalc field in SO_InvoiceHeader:
- Open Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
- Browse to ..\Mas90\Mas_xxx\SOxxx\ (xxx = company code).
- Open SO_InvoiceHeader.
- Click the Key Scan lookup button, and select the affected invoice number.
- Click Edit, and select the following:
- Field Number = 45 – InvalidTaxCalc$
- Change = N
- Click OK.
- Restart the Sales Order invoice update.
For Accounts Receivable:
Edit the invoice InvalidTaxCalc field in AR_InvoiceHeader:
- Open Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
- Browse to ..\Mas90\Mas_xxx\ARxxx\ (xxx = company code).
- Open AR_InvoiceHeader.
- Click the Key Scan lookup button, and select the affected invoice number.
- Click Edit, and select the following:
- Field Number = 25 – InvalidTaxCalc$
- Change = N
- Click OK.
- Restart the Accounts Receivable invoice update.