Create an EDI 867 Vendor Audit Report to tally and validate the actual dollar amounts sent to your vendor on the EDI 867 Product Transfer and Resale Report. When you create the EDI 867, the system generates a standard Product Sales Report, EDI 867s for each of the branches for which you run the report, and places a report in your Hold file that mimics the data in each of the branch reports. The system uses the data in the Hold file when you generate an EDI 867 Audit Report.
You can only run the audit report after running the 867 Product Transfer and Resale Report.
The audit uses the same start and end date you used on the Product Transfer and Resale Report, if you run the two in succession without closing the report driver window.
To run an EDI 867 Vendor Audit Report:
Run an EDI 867 Product Transfer and Resale Report, or generate an 867 document using the Product Sales Report.
From the Reports > End of Month Reports > Product Sales Reports menu, select Product Sales to display the Product Sales Report window.
Complete the fields in the General tab and click the Additional tab.
In the 867 Audit Vendor field, select the vendor for which you want to run the audit.
The report lists the products that were sent on the 867 for the same sales date range and EDI trading partner.
If you use the Print or Hold menu options, depending on your authorization level, the system may prompt you to choose whether to view generic (commission) costs, cost of goods sold, or no costs on the report. Select an option to run the report.
See Also: