Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
This report replicates the Goods Received Audit with an output designed to be fed directly into a spreadsheet.
Crystal report name Goods Received Export 2
Selection Criteria
Run time choices.
-
Date Range - Transaction Date
-
Restricted GRN Location(s)
-
Supplier / Vendor
Print Sequence
As indicated by blue numbered squares in the report example.
1 GRN Date
2 GRN Number
3 Supplier / Vendor
4 Purchase Order Number
Report Totals
As indicated by yellow numbered squares in the report example.
There are none.
Printed Fields
Fields printed on the report.
-
Stocked (GRN) location
-
Purchasing Department
-
Sales Order Date
-
Sales Order Number
-
Customer’s Full Name
-
Purchase Order Number
-
PO Cost
-
GRN Date
-
Supplier’s Name
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Supplier’s Account ID
-
Stock Detail Number
-
SKU
-
Product Description
-
Quantity Received
-
GRN Number
-
Delivery Reference
-
Model Number
-
Cost Price
-
Accounts ID (Receiving Location)
-
Product Group Code
-
Product Group Description
-
Special Order Indicator
-
Owner Location
-
Sales Department (1 to 3)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article