Inventory Reports

Description

Nearly all of the Reports in SwiftPOS can be filtered by either a date range or data. The date range can either be selected from the drop down list of Periods or entered manually.

Stocktake Reports

The following reports are run from here.

Report Name	ID	Sample	Report Description
PDE Inventory Count in Scan Order	SSPE001	R	Reports the Counts imported (either from a file or Denso device) in the order they were counted/scanned. Lists the Barcode/PLU, Count, Location, Date, Clerk and Product.
Inventory Not Counted Report	SSPE005	R	Reports on all Purchase Item type Products that have not been added to the inventory count for the selected Location(s). Lists Location, Product, Size, PLU and Stock on Hand. This report is grouped by Location.
Unmatched Inventory Report	SSPE006	R	Reports on all Products in the inventory count that do not match any Barcodes/PLU's currently in the database. Lists the Barcode/PLU, Count, Location, Product and the related error. It also reports on the 2 Products (Surrounding Products) that were scanned before/after the unmatched Products. This is to facilitate easier identification.
Variance Report	SSPE009	D S D S	Reports on all Products that have recorded a variance as a result of a Stocktake. Lists the Location, Product Group/Master Group, Variance Qty and Value. In addition the detailed version lists the Order #, Products, Barcode, Inventory (SOH) and Stocktake Count.
Alternate Variance Report	SSPE012	R	Reports on all Products that have a variance as a result of a Stocktake. Lists the Location, Product Group, PLU/Product Code, Opening Stock, Purchases, Sales, Transfer In (Xfer In), Transfers Out (Xfer Out), Wastage (Waste), Adjustments (Adjs), Closing Stock, Variance Qty, Variance Value, Variance % and the number of Days since the last recorded Period Opening Stock.
Count Sheets	INV006	R	Reports on all Products selected for Stocktaking not grouped, or grouped by Product Group or Category. Lists the Product, Size/UOM, PLU, SOH and Location. Also provides columns for the recording of the stocktake count results and a Total counted. Optionally, it can also list the current Cost of the Product reported.
Recount Sheets	INV007	R	Reports on all Products selected for a recount. Lists the Product, Size, PLU, SOH and Location. Also provides columns for the manual recording of the counted Stock and a counted Total. Count Variance Tolerance options can also be provided to ensure only those Products that have Count Variances outside the Tolerance options specified, are included as part of the Recount.
Recount Sheets By Location	INV007	R	Reports on all Products selected for a recount. Lists the Product, Size, PLU, SOH and Location. Also provides columns for the manual recording of the counted Stock and a counted Total. Count Variance Tolerance options can also be provided to ensure only those Products that have Count Variances outside the Tolerance options specified, are included as part of the Recount.Recount Sheets can now also be generated for selected Locations.
Inventory Theoretical Value Report	SSPE013	R	Lists the Product, PLU, Count and Counted Value.
Period Location Summary (Counted Value)	SSPE008	R	The Stocktake Variance (All Locations) report is almost identical to the previous variance report except that it displays variances across all Locations currently being counted and also displays total variance quantities and values.
Stocktake Report	SSPE014	R	Reports on Stocktake information grouped by Product Group and then Location. Lists the Location, Product Group, Product, Opening Stock, Net Transfers, Net Purchases, Sales, Closing Stock, Count, Variance Qty, Variance Value and Count Value. This report can report also include Products that have not been counted.
Variance Report (Since Last Stocktake)	SSPE012	R	To be continued ...

Inventory Reports

The following reports are run from SwiftPOS Back Office > Reports > Inventory.

Report Name	ID	Sample	Report Description
Back Order Report	INV001	R	Reports on those Stock items that are on order grouped by Product Group. Lists the Product Group, Product, Size, Case Qty, Location #, Minimum, Maximum and the Qty On Order. This report can be sorted by Product Code or Description.
Calculated SOH by Location	INV038	R D D	Reports on Calculated Stock on Hand (SOH) values as at the start and end of a selected period, as well as stock movements. Lists the Location, SOH as at the start of the selected period, Purchases, Transfers In/Out, Sales, Other Stk Movements, Stocktake, SOH as at the end of the selected period, Current Cost, SOH Value as at the end of the selected period. In addition the detailed versions lists: By Master Group - The Master Group and Product information. By Product Group - The Product Group and Product information. With Advanced Host Integration registration this report can be filtered using: Metcash Departments Metcash Categories Metcash Commodities Metcash Sub-Commodities Metcash Sub-Range
Count Sheets	INV005	R	Reports on all Inventoried Products and provides a count field for the manual entry of Stocktake counts. This report can be sorted by Product Code or Description. This report can be grouped by Product Group.
Inventory Audit	INV004	R	Reports on Products that have had stock movements backdated prior to a stocktake during the selected period. Details are grouped by Location. Lists the Location, Product, Transaction Type, Reference, Qty, Transaction Date/Time, Stocktake Date/Time and SQL Post Date/Time.
Inventory Transfers	INV014	D S	Reports on Stock Transfers grouped by the Location. Lists the From/To Location, Qty Out, Cost Out, Qty In and Cost In. This report can be sorted by Product Code or Description. In addition the detailed version lists the Products.
Inventory Turnover Ratio Report	INV015	R	Reports on To be continued ... grouped by Location and then Product Group. Lists Location, Product Group, Product, Opening/Closing Stock values, Stock On Hand, Cost of Sales and Turnover Ratio. This report can be sorted by Product Code or Description.
Location Group Stocktake Variance	INV037	D S	Reports on Stocktake Variance for a selected Location Group (Venue) and groups them by Product Groups. Lists Product Group, Total Variance and then the Variance for the Locations in the selected Location Group (Venue). The Variance can be reported in either Quantity or Value. This report can be sorted by Product Code, PLU or Description. In addition the detailed version lists the Product and Size.
Location Value by Group	INV016	R	Reports on the current value of Stock on Hand grouped by Product Group. Lists the Product Group, Product, Size, Location, Unit Cost, Stock On Hand, Total Cost, Sale Value and Gross Profit %. This report can be sorted by Product Code or Description.
Movements Audit	INV002	D S	Reports on all Stock Movements. Lists Product, Transacted Date, Posted Date, Clerk/Staff Member, Reference, Movement Type, Location, Cost and Qty. This report has 2 levels of sorting available. Sorting can be done by Transaction Date, Posting Date, Product Description, Product Code, Movement Type or Reference. Note : When the Movement Type option <<ALL> Exclude Sales is selected, a calculated column New SOH is reported, providing a running total of the SOH. In addition, the detailed version lists the Retail Value of the Stock movements based on the Location's default Price Level at the time the report is run.
Movements Summary	INV036	R	Reports on all Stock Movements (excluding sales) grouped by Location. Lists the Location, Product, Entry (Movement) Type, Qty, Cost and Value. This report can be sorted by Product Code, Product Description or Movement Type. This report can be grouped by either Location or Product.
Non-Inventoried Products	INV017	D S	Reports on all Non-Inventoried Products (including Non-Diminishing Products) grouped by Product Group. Lists the Product Group and Price. This report can be sorted by Product Code or Description. In addition the detailed version lists the Products.
Overstocked Report	INV011	R R	Reports on Overstocked or Understocked Products. Lists Location, Product, Case Qty, Stock on Order, SOH, Min/Max Qty and Re-order Qty Min/Max. This report can be sorted by Product Code or Description.
Period Location Summary	INV018	D S D S D S D S S S	Reports on Stock Opening/Closing and Stock Movement values for a selected Opening Stock Period range. The report can be grouped by Location, Product Group or Master Group. It also can be generated to report using Quantities, $ Values or both. This can be achieved by selecting the appropriate Type option. When grouping either by Product Group or Master Group, the report can also be generated in Detail level. The report lists the Location, Product Group or Master Group, Opening Stock, Purchases, Transfers, Draw From Transfers, Closing Stock, Net Cost of Goods, Sales, Rebates, Stocktake Variances and Write Off/On Variances. Noteworthy Opening Stock - Qty and/or Value of the SOH as at the start of the selected Period. Purchases - Qty and/or Value of Products purchased in the selected period Transfers - Qty and/or Value of Products transferred between Locations in the selected period Draw From Transfers - Qty and/or Value of Products sold with a different Draw From Location. Closing Stock - Qty and/or Value of the SOH as at the end of the selected Period. Net Cost of Goods - Opening Stock + Purchases + Transfers + Draw From Transfers) - Closing Stock calculated using either the Qty and/or Value. Note : Opening Stock, Transfers and Closing Stock are subject to variations in value based on the Costing Method selected. For example, if a SOH 10 Products valued at $24 ea ($240), exist, and then a further 10 Products at $30 ea ($300) are purchased using the New Cost Method, then a Cost of Sales profit of $60 will be created. The same rule applies if Stock is written Off for that same period. The Net Cost of Goods Closing Stock Value will be affected even though there may have not been any sales in the same Location. Sales - Qty and/or Value of Products sold in the selected Period. GP % - Gross Profit as a percentage. Rebates - Qty and/or Value of Rebates on the Products sold in the selected Period. Stocktake Variance - Qty and/or Value of the difference between the Expected Stock and the Counted Stock. Write Off/On Variances - Qty and/or Value of Receipts + Adjustments + Damaged Stock + Returns + Wastage + Promotions. % Shrink - Value of Write Off/On Variances as a % of the Cost of Goods. Note : If no Trading Period ranges are available to be selected, then: Try closing and reopening the Reports Menu. If still none are available, then the Trading Periods are not being used or a Record Period Opening Stock has never been done. For sites that MAKE USE of Trading Periods run the Period Location Audit (SLA042) report to check for sales mistakenly processed outside of the selected Trading Period range. For sites that DO NOT make use of Trading Periods run the Calculated SOH by Location (INV038) report as a guide.
Product Location Sell and Cost Prices	INV019	R	Reports the Pricing Levels of Products for each Location grouped by Product Group. Lists the Product Group, Product, Location, Stock On Hand, Cost, Prev Cost, Price Levels 1 - 10. This report can be sorted by Product Code or Description.
Recipe Listing	INV020	R	Reports on all Reciped Items grouped by Product Group and Recipe Item. Lists the Product Group, the Recipe Item Product, the Recipe Item Size, the Recipe Item PLU #. Then it list the Parent Item's Product, Qty, the Parent Product size, average cost per item and % of Cost. This report can be sorted by Product Code or Description.
Recipe Listing by Location	INV021	R	Similar to the Recipe Listing report, except it is grouped by Location, Product Group and Recipe Item. This report can be sorted by Product Code or Description.
Recipes Used	INV022	R	Similar to the Recipe Listing report, except it lists the Parent Items grouped by Product Group and which Reciped Items they are used in. Lists Product Group, the Parent Product, the Recipe Item Product and Used Qty. This report can be sorted by Product Code or Description.
Reorder by Supplier	INV023	R	Reports the Products to be Re-Ordered grouped by Supplier. Lists the Supplier, Product, the Supplier's Product Code, Qty Last 7 Days, Qty Last 28 Days, Min Qty, Max Qty, On ORder, On Hand, Case Qty, Reorder Qty and Value at Cost. The value at Cost is based on the Supplier's Last Cost. This report can be sorted by Product Code or Description. This report can be grouped by Product Group.
Replenishment Report	INV024	R	Reports on Products that need to be transferred between 2 Locations to ensure the SOH levels of Products in the To Location are replenished to their maximum level. Selecting in the Reports screen, the Add to Batch option, this will ensure that not only is a report generated, but also a Batch Transfer is created with all the same Products and their replenishment Qtys (Cases and/or Units) are included, to easily facilitate the transfer of stock to achieve the replenishment of SOH levels. Products listed in the Batch Transfer, can of course be changed and committed at a later time. Note : Both a From and To Location must be selected in order for the report to run successfully. The report can be filtered by Location, Product, Group and Category. It can be run as a Batch Report via the EOD process and create a Batch Transfer (using the Add to Batch option). This would then enable Bottleshop or Cellar staff to prepare the restocking of stock levels for the Bar Staff. The report can only be run for one Location at a Time. For the main Stock Holding Location (Bottleshop or Cellar) run the Inventory Forecast report to evaluate the predicted time left for current SOH. Then run the Purchase Order Wizard to create Supplier orders to replenish the stock levels in the main Stock Holding Location. How this is used in a typical Bottleshop/Tavern scenario. ? Setup a replenishment report per bar Location to automatically print at 6am each morning for a staff member to complete to ensure all bars are completely topped up. ? Recall the Pending Batch Transfer, make any adjustments to the quantities as per availability of stock prior to committing the transfer. ? When an order is conducted the staff member responsible then simply has to order only for the main Location plus the odds and ends like kegs and post mixes that live in the bar stock stores.
Requisition Picking Slip	INV040	R	Reports on the Products that have been Requisitioned (via Warehouse Requisitioning) and need to be picked. Lists the Requisition #, requesting Location, Date Required, Posting Date, Reference, From/To Locations. It also lists the Bin #, Qty, Product and Picked/Received checkboxes for each of the Products to be picked and transferred. Lastly it provides room for a signature and any hand written comments. The second report (or last page) is used as a sign off sheet to confirm the Products have been received and that the Transfer can be submitted. This report can be run from here.
Requisitions Report	INV041		To be continued ...
SOH Products with Promo/Sales	INV039	R R R R	Reports on inventoried Products and their Promo and Sales data, by either Product/Master Group and by Location, or just by either Product/Master Group. Lists the Location, Product/Master Group, Product, Size, Supplier, SOH (Stock on Hand), Promo, Savings, Qty, Cost, Sales, GP $ and GP %.
SOH Products with Promotions	INV044	R R	Reports on inventoried Products and their Promotions and Sales data, by either Product/Master Group and by Location, or just by either Product/Master Group. Lists the Location, Product/Master Group, Product, Size, Supplier Code, Case Qty, SOH (Stock on Hand), Promo (Ex/Inc), Savings (Ex/Inc) and Qty.
Status Report	INV025	R	Reports the status of all Inventoried Stock grouped by Product Group. Lists Product Group, Product, Date Last Sold, On Order Qty, Stock On Hand, Min/Max Levels and Post Stocktake Inventory. This report can be sorted by Product Code or Description.
Status Report by Location	INV026	R	Similar to the Status Report report, except it is grouped by Location. Lists Location, Product Group, Product, Date Last Sold, On Order Qty, Stock On Hand, Min/Max Levels and Post Stocktake Inventory. This report can be sorted by Product Code or Description.
Stock on Hand by Primary Supplier	INV027	R	Reports all Products by Primary Supplier. Lists Supplier, Product, Case Qty, Stock On Hand and Stock on Hand in Cases/Units.
Stocktake Listing	INV028	R	Reports the Locations that have had a Stocktake in the selected period. Lists the Lists Location, the Clerk/Staff Member # and Name, the Posting Date/Time and the Reference.
Stocktake Summary Report	INV013	R	Reports the Stocktake Variance Quantity and Value per Product Group and grouped by Location. Lists the Location, Product Group, Variance Qty and Value (based on the Cost price). This report can be sorted by Product Code or Description. This report can be grouped by Location or Product Group.
Stocktake Variance Audit Report	INV012	R	Reports the Stocktake Variance per Product Group and grouped by Location. Lists the Location, Product Group, Variance Qty and Value (based on the Cost price). This report can be sorted by Product Code or Description. This report can be grouped by Location or Product Group.
Summary Group Variance	INV042	R R	Reports the Stocktake Variance and percentage either by Master Group or Product Group and then by Location and Location Group. Lists the Location Group, Location, Master Group/Product Group, SOH Value, Variance value and pecentage.
Transfers by Group	INV029	D S	Reports on Stock Transfers grouped by Location, Transfer From/To and then Product Group. Lists the Location, Transfer From/To, Product Group, Qty, Cost Out/In and Date Transferred as well as the Reference. This report can be sorted by Product Code or Description. Note : Cost Out/In value reported is total Cost value of the Transfers based on the Cost price in the From Location. In addition the detailed version lists the Products.
Transfers by Location	INV030	R	Reports on the value of Stock Transfers by Location. Lists the Location and Value (based on the Cost price at the time of the Transfer). This report includes Transfers in SwiftPOS Back Office and at the POS.
Transfers by Product	INV031	R	Reports on Stock Transfers grouped by Location and then Transfer From/To. Lists the Location, Transfer From/To, Qty, Cost Out/In (based on the Cost price at the time of the Transfer) and Date Transferred as well as the Reference. This report can be sorted by Product Code or Description. Note : Cost Out/In value reported is total Cost value of the Transfers based on the Cost price in the From Location.
Transfers by Product (2 Locations)	INV032	R	Similar to the Transfers by Product report, except it is for 2 Locations. Note : Cost Out/In value reported is total Cost value of the Transfers based on the Cost price in the From Location.
Value by Group	INV033	R R	Reports on the current Stock on Hand (SOH) and Value grouped by Location and summarised by either Product Group or Master Group.
Value by Location	INV034	D S D S D S	Reports on the current Stock on Hand (SOH), Cost and Sale Value, and Gross Profit values grouped by either Location, Product Group or Master Group. By Location - Lists the Location, SOH, Total Cost, Sale Value and Gross Profit %. This report can be sorted by Product Code or Description. In addition the detailed version lists the Products and Size. By Product Group - Lists the Product Group, SOH, Total Cost, Sale Value and Gross Profit %. This report can be sorted by Product Code or Description. In addition the detailed version lists the Products and Size. By Master Group - Lists the Master Group, SOH, Total Cost, Sale Value and Gross Profit %. This report can be sorted by Product Code or Description. In addition the detailed version lists the Products and Size.
Value by Location including Tables	INV035	D S	Similar to the Value by Location report, except it deducts the Stock that is associated with Tables that are currently open (not finalised). Note : This requires the Table Tracking database to be configured at all Locations which cater for Table service.
Wastage Summary	INV043	R	Reports the Wastage information grouped by Reason Code and then Location and Location Group. Lists the Reason, Location Group, Location, Qty, Cost and Retail Value.
Inventory Transfer	STRF001	R	Reports on the Products that have been selected for Transfer via the Batch Transfer screen. Lists the Trading Date, Reference, From/To Locations, Qty, Cost, Product and PDE Scan Date. This report can be run from here.
Picking Slip	STRF003	R	Reports on the Products that have been identified to be picked for Transfer via the Batch Transfer screen. The report consists of 2 reports. Each report for each of the From/To Locations. The first report (first page at a minimum) lists the Posting Date, Reference, From/To Locations. It also lists the Bin #, Qty, Product and Picked/Received checkboxes for each of the Products to be picked and transferred. Lastly it provides room for a signature and any hand written comments. The second report (or last page) is used as a sign off sheet to confirm the Products have been received and that the Transfer can be submitted. This report can be run from here.

Help

Inventory Reports

Description

Stocktake Reports

Inventory Reports

Noteworthy

Related Topics