Article Code

SKU, Name, Brand, Category, Bay, Qty, Sell Rate

Stock Location (Detail)

SKU, Name, Qty, Location, Date in, Usebydate, Batch, Notes, Sell Rate 

Item Category 

Website 

GP by SKU/Sales Channel

Stock Location (Consolidated)

Brand, SKU, Name, Qty, Av Cost

Stock Adjustment Audit

Who, when, Ref#, Item Name, Qty, direction (increase/decrease), location, description

Stock Adjustment Journals

Who, when, Ref#, SKU, Article, Qty, $/item, $Value, Warehouse, GL code, GL name, Description, Comments, Supplier, Brand, branch, department, cost cente, subtype

Manufactured Items

SKU, Name, Estimated Production Time, Production Batch Size

Slow Moving Stock

Various details for a SKU: SKU, Item, Brand, SOH, Sellrate1 (units per day average over last 3 months), Min, Max, Status, Last sale date, Av cost

For the specified warehouse, returns all SKUs with > 0 SOH ordered by sell rate and SOH

POS lines picked OOS

Sales made via the POS are a Debtor Prompt Payment (unless the customer has an account).  If a product is scanned at the POS then it is in the store so it can be sold.  However if there is no stock in the store then no COGS journal will be created.  This situation can occur if purchase orders are received and put away without updating the system.  This report alerts stock issues in the store.

CDS - Container Deposits

For a state for a month - all movements of stock items that have container deposit qty - for legislated reporting (sending and receiving from the warehouse)

Journal Date, Customer, Qty, Order#, SKU, UOM, EPA Container Qty, packsize, Supplier, From postcode, to postcode, type

Stock In / Out Report

The stock in out report is intended to show all stock movements through a warehouse between a number of dates.  The POS lines picked Out of Stock qty indicates that a sale was made but no COGS journal was created as no stock was in the warehouse

The report has the following columns

SKU, Name, SOH, Target (Max target stock level), Retail Sales qty (DPP), OOS picked (retail sales - see POS lines picked OOS above), COGS Qty, PO's qty, Stock not yet received on PO's but expected.

Aged Stock Report

The Aged stock report is a view of stock on hand and the age of that stock across all warehouses - it does not show warehouse level stock levels and does not respect the warehouse filter.  It does respect the product category filter.

The report starts with the current stock on hand and looks back to see how old that is by looking at when stock has been receipted on Purchase orders or created via stock adjustments until it has found all the sources of the stock.  The age of the stock is determined this way.  The report uses the latest average cost and prices and max (from min / max settings) by warehouse.

The report uses Sales Orders data of delivered quantity or shipped quantity to determine weekly sales looking back to the first sales order found in the period covered by "Sell Rate Days" on stock control form then calculating weekly sell rate.  The most recent sales order date and qty are shown.