Originally written by John Hardwick, last updated Apr 25, 2024, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
This report details all goods receipted within the user specified location and date range.
Grouped by purchase order within receipt location sequenced by GRN number within receipt date, it is possible to see the stock booked in.
The report will show or omit the cost price, dependent upon the setting on the GOODS_REC_AUDIT_SHOW_COSTS application parameter.
Crystal report name Goods Received Audit 24
-
Detailed mode is as per above without the light blue information boxes.
-
Summary collates by SKU omitting the individual stock details
-
Total produces the total grid (3 identified above)
Dependent upon the order status, one of the following messages will appear in a box below the current location.
-
Goods overdelivered by supplier
-
Goods ordered on Internal Order XXXXX
-
Goods overdelivered by supplier and allocated to sales order XXXXX
-
Goods ordered for Sales Order
-
Goods ordered on Internal Order XXXXX and allocated to Sales order XXXXX
Red text indicates the sales location the goods are linked to.
Selection Criteria
Run time choices, user selectable.
-
Goods Receipt Date Range
-
Format
-
Summary (SKU/Option Totals) / Detail / Detail with Sold Goods Selling Prices / Totals Only
-
-
Purchase Order Number
Specify the PO number or leave set to 0, which turns this filter off).
-
Goods Receipt Number
Specify the GRN number or leave set to 0, which turns this filter off).
-
Group
-
PO - Date - GRN sequence / GRN - Date - PO sequence
-
-
Restricted GRN receiving Location(s)
-
Restricted Selling Location(s)
-
Supplier(s)
-
Include
-
All GRNs / GRN/s Linked to Sales / GRN’s Linked to IOs
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 GRN Receipt Location
2 Purchase Order Number or GRN Number
3 GRN Date
4 GRN Number or Purchase Order
5 SKU
Report Totals
As indicated by yellow numbered squares in the report example.
1 Receipt Date
2 Receiving Location
3 Grid Totals
Printed Fields
Fields printed on the report.
-
Goods Receipt Location
-
Purchase Order Number
-
Receipt Date
-
GRN Number
-
Delivery Note Reference
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Stock ID (detailed only)
-
SKU
-
Range / Collection
-
Product Description & Options
-
Stock Holding Location (detailed only)
-
Bay / Storage Area (detailed only)
-
Quantity
-
Unit Code
-
Total Cost
-
Sales Order Number (detailed only)
-
Selling price (detailed selling price only)
-
Gross Profit (detailed selling price only)
-
Margin % percentage (detailed selling price only)
-
Sales Location (detail only)
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