Purchase Details - Vendor Details
Purpose
This report is used to verify the data displayed on the Receive Note is displayed in the report.
How to Access
On the navigation bar, click the Reports Tab
Under the Purchase Reports section, locate the tab called Purchase Details and click the tab
Once the report is displayed, below the following information should be displayed:
- Filter Section: Filter by:
Sku/Description
Start Date
End Date
Types
Locations
Report Type - Vendor Details
Report Type - Product Purchases
- Columns Displayed:
Vendor Name
Date
Category
Invoice
Net Total
Vat
Total
Total Net Total
Total Vat
Total Grand Total
How to Audit
On the navigation bar, click the Reports Tab
Under the Purchase Reports section, locate the tab called Purchase Details and click the tab
Select a Date Range
Select report type “Vendor Details” and click the apply filters.
Export the Report to Excel using the export button located under the Actions button.
Verify the columns on the export match the columns in the system
Verify the Net, Vat and Grand Total values on the export match the values in the system.
Run a formula to verify the Total for each line item is correct. Formula (Net Total+Vat = Total)
Sum all of the Net Values from step 8 and verify the overall Net Total is correct.
Using the Invoice Number, go to the Receive Note list page, search for the Invoice Number and confirm the data displayed in the report match the data displayed on the Receive Notes for at least five (5) transactions.
Test all filters available and verify the data displayed in the system match the export and receive notes.
Verify only Purchase Orders that are at processed or partially received status are displayed in the report.
Things to Know
The data displayed on the report is based on the filters selected
Under the Actions button, the user has the ability to export the report to excel
Only use Receive Notes to verify the information in this report.