"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:

  1. Open Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
  2. Browse to ..\Mas90\Mas_xxx\SOxxx\ (xxx = company code).
  3. Open SO_InvoiceHeader.
  4. Click the Key Scan lookup button, and select the affected invoice number.
  5. Click Edit, and select the following:
    • Field Number = 45 – InvalidTaxCalc$
    • Change = N
  6. Click OK.
  7. Restart the Sales Order invoice update.

For Accounts Receivable:

Edit the invoice InvalidTaxCalc field in AR_InvoiceHeader:

  1. Open Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
  2. Browse to ..\Mas90\Mas_xxx\ARxxx\ (xxx = company code).
  3. Open AR_InvoiceHeader.
  4. Click the Key Scan lookup button, and select the affected invoice number.
  5. Click Edit, and select the following:
    • Field Number = 25 – InvalidTaxCalc$
    • Change = N
  6. Click OK.
  7. Restart the Accounts Receivable invoice update.