Tax reporting on anomalous transactions

• Receivables documents with no tax details were omitted from SQL Optimized reports if the related customer master record was missing.
• Receivables documents where the tax detail record's tax amount does not equal the total of the sales tax amount, the freight tax amount and the miscellaneous tax amount. With these documents, the DZ reports showed the tax details with a zero total amount and with exempt and taxable amounts that offset each other. The reconciling adjustment then adjusted the report correcting the erroneous amounts.
• Receivables documents with tax details having a value in the tax amount field but showing a sales tax amount of zero, a freight tax amount of zero and a miscellaneous tax amount of zero. The DZ reports showed these tax details with no tax amount. The reconciling adjustment then adjusted the report for the missing tax amount.
• Non optimized reports included an SOP document's subtotal in both the taxable and the exempt amount column when the documents line-items are missing.

• Purchasing documents were omitted from SQL Optimized reports if the related vendor master record was missing.
• Purchasing documents with tax details having a Type of Sales instead of Purchases. The DZ reports were rejecting the details and creating a “no details found” record in their place.

• Documents with tax but no tax details were appearing as exempt in the DZ reports.
• Documents with tax details showing a tax amount but a total sales amount of zero and a total taxable amount of zero. The tax details for these documents were reported as zero total, zero taxable and zero exempt but with a tax amount. The reconciling adjustment then adjusted the report for the missing amounts.

Build 69