Goods Received Audit

Created by Migration Bot, Modified on Fri, 23 Oct at 11:28 AM by Migration Bot

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article