Tax Tracking Header (TXAUDH) Field "POSTDATE" should equal to Posting Date in source entries as part of consistency on data records.
Tested with current SAGE 300 version 2016/2017, upon AP Invoice entered and posted, these fields will be updated:
1. Document Date = DOCDATE in TXAUDH, DATEINVC in both APIBH/APPJH
2. Posting Date = DATEBUS in both APIBH/APPJH
3. Session Date = POSTDATE in TXAUDH
The posting date is useful to a company who have Fiscal Year/Period different with Calendar Month, and their tax authority required them to make tax report by Calendar Month.
In some scenario, the company receive a January invoices in February, where they have submitted the tax report of Jan to Tax Authority. And the company do not want to modify the original invoice date for system entries.
Therefore when they produce tax report based on Document Date, or by Fiscal Year/Period, both cannot fulfil their needs.
by: Dylan L. | over a year ago | General Enhancements
Comments
This and other tax reporting problems can be resolved very, very simply by flagging transactions in the tax tables once they have been confirmed as reported. Then, in the next reporting period, it is easy to report on all new, unreported tax transactions irrespective of date.
All other software does it this way and Sage have had it planned for Sage 300 for years.