The Option B, E and F reports are good reports to use when reconciling DynamicZip tax reports to Microsoft Dynamics GP sales transaction history reports.
These reports are “document centric” meaning that the individual tax detail records associated with each transaction on which you are reporting are handled as a single unit. The Option B tax report is sorted by Jurisdiction but breaks out the Sales, Freight and Miscellaneous amounts. The Option E tax report can be printed in detail and sorted by Document Number. The Option F Tax Report when sorted by Document Number and printed in summary provides perhaps the most useful report of all for reconciliation purposes.
Reconciling transactions entered in the Sales Transaction Entry window. We added the report summary section primarily to assist in reconciling the report to other sales reports printed from Microsoft Dynamics GP For example if you print the Option B report (limited to SOP transactions), the report summary numbers should agree with the report summary for the same range of transactions printed from Reports » Sales » History » Sales Transaction History.
Reconciling transactions entered in the Receivables Transaction Entry window. This may be best done using Microsoft Dynamics GP Smart Lists in conjunction with the above reports - particularly the Option F Tax Report printed in summary and sorted by Document Number.
The results of the above report can be compared to the following.
The resulting Smartlist will contain positive numbers for all document types (Invoices, Returns, Credit Memo or whatever). Since by default the Smartlist contains a column for the Sales Amount, but not for the Trade Discount Amount, the Misc Amount, the Freight Amount or the Tax Amount, you will need to add those columns to see the complete picture. To make totalling easier, we recommend that you create three Smartlist Excel spreadsheet files with the following differences:
To calculate the totals for comparison to the Option F Tax Report subtract the above #2 and #3 from #1.