Stock Cost Analysis

Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).

Part of: Stock Reports

This report is designed to show cost price changes for selected products providing graphical representation of cost movements along with, where required, a detailed analysis of cost changes.

Selection Criteria

Run time choices, user selectable.

• Supplier(s)

• Range(s)

• SKU(s)

• Date Range

• Format

  • Detail / Summary

• Product Group(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Supplier / Vendor

2 Range / Collection

3 SKU

4 Stock ID (Detail Mode)

Report Totals

As indicated by yellow numbered squares in the report example.

1 SKU

Printed Fields

Fields printed on the report.

• Supplier / Vendor

• Range / Collection

• SKU

• Product Description

• Cost against time chart

• Stock ID (detail only)

• PO Cost (detail only)

• SO Cost (detail only)

• Acknowledged Cost (detail only)

• Invoice Cost (detail only)

• Current Cost (detail only)

• Sold Price (detail only)

• Minimum, maximum and average cost values

Attachments (2)

image-20230821-131105.png
120 KB

image-20230821-131226.png
95.9 KB