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.

1. Restrict the Option F Tax Report to the desired date range. For starters, do not select Detailed Report.
2. Select Print Column Headings.
3. Select Source = Receivables.
4. Select Document Type = All.
5. Set your file Destination. A tab or comma delimited export file is typically the easiest to open in Microsoft Excel.

The results of the above report can be compared to the following.

1. Open the Smartlist window in Microsoft Dynamics GP.
2. Select the Sales module.
3. Within the Sales module, select Receivables Transactions.
4. Open the Search window and require the Batch Source to contain RM_Sales.
5. Restrict the Document Date to be the same date range specified above for the Option F Tax Report.

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:

1. Document Type is not equal to Credit Memo, and Document Type is not equal to Return. Doing this will return the positive transactions.
2. Document Type is equal to Credit Memo. This one will give you the Credit Memos.
3. Document Type is equal to Return. This one will give you the Returns.

To calculate the totals for comparison to the Option F Tax Report subtract the above #2 and #3 from #1.

Frequently Asked Questions