Transfers In
Purpose
This report is used to display all processed Transfers In transaction and allows management to quickly view the total value sent to the multiple outlets.
How to Access
On the navigation bar, click the Reports Tab
Under the Inventory Reports section, locate the tab called Transfers In 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
Branch
- Columns Displayed:
Date Target
To Location
From Branch
Item Sku
Item Description
Item Default UOM
Item Quantity Transferred In
Item Unit Price
Line Total for each Item Transferred In
Net Total for all items transferred in
Vat Total for all items transferred in
Grand Total for all items transferred in
How to Audit
On the navigation bar, click the Reports Tab
Under the Inventory Reports section, locate the tab called Transfers In and click the tab
Select a date range
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 Net Value for each line item is correct. Formula (Quantity*Unit Price = Net Total)
Sum all of the Net Values from step 7 and verify the overall Net Total is correct.
In a new tab on the system, click the Transaction tab on the Navigation Bar and select Transfers In from the drop-down menu.
Filter the Transfers In List page to the same date range as the report.
Using the Transaction and Report, compare the data displayed in the transaction is reflected on the Report for at least three (3) transactions.
Verify only transactions with the Processed 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 Processed Transactions should be displayed in the report