Stock Evaluation Enhanced Export

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 Stock Evaluation Enhanced Report with an output designed for importing into personal productivity tools such as Excel.

Selection Criteria

Run time choices, user selectable.

• Restricted Stock Location(s)

• Bay / Storage Area(s)

• Supplier(s)

• Product Group(s)

• Sales Departments, Level 1 to 3

• Show Stock Values for full paid orders

  • Show All / Exclude Costs & Selling / Exclude Selling Prices / Exclude Cost Prices

• Include

  • All Stock / Sold Stock Only / Free to Sell Stock Only

Print Sequence Detail

As indicated by blue numbered squares in the report example.

• Not Applicable

Report Totals

As indicated by yellow numbered squares in the report example.

• There are none

Printed Fields

Fields printed on the report.

• Stock Location

• Bay / Storage Area

• Product Group

• SKU

• Supplier / Vendor

• Range / Collection

• Product Description

• Product Options

• Quantity

• Line Cost

• Line MRP

• Line Selling Price

• Stock ID

• Sales Order Number

• Payment Status

• Sales Dept 1

• Sales Dept 2

• Sales Dept 3

• Purchase Order ID

• Date Received

• Category Name

• Is Display Indicator

• Cannot Sell Indicator

• Imperfect Indicator

• Display Indicator

• Imperfect Reason

• Imperfect Notes

Attachments (1)

image-20230126-110933.png
41 KB