Inventory/Stock

Provides a list of Inventory/Stock related reports available in Back Office. To access, select the Reports option in the Inventory menu in Back Office, to open the Reports screen. Then expand any one of the Inventory or Inventory Quick Reports options listed on the left-hand side of the screen, to view the list of Inventory/Stock reports.

About ▲ ▼

What's New?

What Is New? ▲ ▼

In Swiftpos:

Period Location by Product Group (INV018)
- This report has been enhanced in Swiftpos v10.78.28+, v10.79.6+ and v10.80+ to provide more consistent inventory, cost and gross profit reporting. Particularly for Venues using Draw From Locations and reciped items/products.
  
  Key enhancements include:
  - Draw-from transfers and Net Cost of Goods now more accurately reflect the Location where stock is held.
  - Recipe ingredient costs are consolidated against the parent item/product when Show Detail is enabled, providing clearer item/product-level cost and margin reporting.
  - GP% is now calculated using the actual cost recorded against each sale.
  - Opening Stock is correctly sourced from the first selected period when reporting across a period range.
  - Write Off/On Variance totals have been improved to align with the report detail.
  - Closed-period Draw From Transfer values are now reported more consistently.
  - These changes will be most noticeable at Venues using recipe items/products across Locations with draw-from inventory configuration. Venues where each Location holds its own stock, or where recipe items/products are not used, should see little or no change.
  - Historical reporting - The enhancement does not rewrite historical stock movements already stored in the database. Reports covering periods containing earlier affected movements may therefore continue to show the previous figures. New movements posted, and periods rolled up after upgrading will use the enhanced reporting logic.
  - The enhancements made can be grouped as follows:
    - Incorrect Stock Movements No Longer Generated
      - Draw From is now resolved from the parent item's setting, which is the value that actually governs where stock is held. Draw From Transfers and Net Cost of Goods now reflect only real stock movement.
      - Also, all totals have been corrected and reflect the sum of the details reported. This will be of interest to Venues using Draw From inventory, as well as recipes/family items/products.
    - Cost And GP Calculation Re-worked
      - GP% is now calculated from actual cost of sales. It now uses the cost recorded against each sale line. GP% amounts will change at detail, subtotal and total level.
      - Ingredient cost now rolls up to the parent item/product. In detail mode, a child's ingredient Net Cost of Goods is aggregated onto its parent item/product at the stockholding Location, apportioned by recipe quantity. Child ingredient lines will now show $0.00 Net Cost of Goods, with the parent line carrying the total of the children. Write Off/On Variances roll up the same way. This rollup behaviour only applies when the Show Detail option is selected. Summary reporting is not affected.
      - Cost at non-stockholding Locations moves to the stockholding Location. A Location that draws its stock from elsewhere no longer carries its own Net Cost of Goods; that cost is attributed to the Location holding the stock. The drawing Location retains only its Transfers and Draw From Transfers values.
      - Opening Stock across a period range. When reporting a range of periods with an open period, Opening Stock now comes from the first selected period rather than the last. The new behaviour is the correct one for a range.
      - Draw From Transfers for closed periods now reads the stored Draw From value rather than deriving it from Transfer In/Transfer Out costs.
    - The Report may run slower as a result of the changes. This will be noticeable when the Show Detail option is selected, or there are large hierarchies of reciped items/products.

Reports ▲ ▼

Inventory
Inventory Quick Reports
Stocktake

Inventory Reports ▲ ▼

Back Order Report	INV001	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	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	Reports on all Inventoried items/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	Reports on items/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	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 items/products.
Inventory Turnover Ratio Report	INV015	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.
Venue Stocktake Variance	INV037	Reports on Stocktake Variance for a selected Venue and groups them by Product Groups. Lists Product Group, Total Variance and then the Variance for the Locations in the selected 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 item/product and Size.
Location Value by Group	INV016	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	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. Notes... 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	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 item/product.
Non-Inventoried Products	INV017	Reports on all Non-Inventoried items/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 items/products.
Overstocked Report	INV011	Reports on Overstocked or Understocked items/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	Refer HERE for more information. 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 items/products purchased in the selected period Transfers - Qty and/or Value of items/products transferred between Locations in the selected period Draw From Transfers - Qty and/or Value of items/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. Notes... Opening Stock, Transfers and Closing Stock are subject to variations in value based on the Costing Method selected. For example, if a SOH 10 items/products valued at $24 ea ($240), exist, and then a further 10 items/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 items/products sold in the selected Period. GP % - Gross Profit as a percentage. Rebates - Qty and/or Value of Rebates on the items/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. Notes... 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 Venues 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 Venues 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	Reports the Pricing Levels of items/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	Reports on all reciped items/products 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 lists 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	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	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	Reports the items/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	Reports on items/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 items/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. Items/Products listed in the Batch Transfer, can of course be changed and committed at a later time. Notes... Both a From and To Location must be selected in order for the report to run successfully. The report can be filtered by Location, item/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 Bottle Shop 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 (Bottle Shop 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 Bottle Shop/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	Reports on the items/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 items/products to be picked and transferred. Lastly, it provides room for a signature and any handwritten comments. The second report (or last page) is used as a sign off sheet to confirm the items/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	Reports on inventoried items/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	Reports on inventoried items/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	Reports the status of all inventoried items/products 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	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	Reports all items/products by Primary Supplier. Lists Supplier, Product, Case Qty, Stock On Hand and Stock on Hand in Cases/Units.
Stocktake Listing	INV028	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	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	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	Reports the Stocktake Variance and percentage either by Master Group or Product Group and then by Location and Venue. Lists the Venue, Location, Master Group/Product Group, SOH Value, Variance value and percentage.
Transfers by Group	INV029	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. Notes... 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 items/products.
Transfers by Location	INV030	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	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. Notes... 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	Similar to the Transfers by Product report, except it is for 2 Locations. Notes... 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	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	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 items/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 items/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 items/products and size.
Value by Location including Tables	INV035	Similar to the Value by Location report, except it deducts the Stock that is associated with Tables that are currently open (not finalised). Notes... This requires the Table Tracking database to be configured at all Locations which cater for Table service.
Wastage Summary	INV043	Reports the Wastage information grouped by Reason Code and then Location and Venue. Lists the Reason, Venue, Location, Qty, Cost and Retail Value.
Inventory Transfer	STRF001	Reports on the items/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	Reports on the items/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 items/products to be picked and transferred. Lastly, it provides room for a signature and any handwritten comments. The second report (or last page) is used as a sign off sheet to confirm the items/products have been received and that the Transfer can be submitted. This report can be run from HERE.

Inventory Quick Reports ▲ ▼

Select from the Reports available and then configure the filters/options specific to the selected report.

Filters/Options ▲ ▼

Notes ...

The filters/options available, vary depending on the Report selected.

Date Selection - Nearly all of the reports in Swiftpos can be filtered by a date range. The date range can either be selected from the drop-down list of Periods or entered manually.
Product Filters - Select from the filters available. The filters available will depend on the Report selected.
Options - Select from the options available. The options available will depend on the Report selected.
Venue and Location Selection - Select from the Venue and Location related filters.
Sorting - Select from the options available.

Reports ▲ ▼

Cost of Goods	QIH014	Use the Period Location Summary Report for more accurate reporting in Trading Periods. Reports opening/closing Stock values and Actual Cost of Sales grouped by Product Group and Location. Lists Location, Product Group, Products, Opening Stock value, Nett Transfers, Nett Purchases, Closing Stock, Closing Mix, Actual Cost of Sales, Discount, Sales value, Sales Mix, Stocktake Variance, Wastage/Adjustment, Gross Profit %, Gross Profit Mix %. Values can be reported as $ values or quantities. This report can be sorted by Product Code/PLU or Description. The opening and closing values for this report are also generated using the end of day option as is with a number of other reports in this section. In addition, the detail version of this report lists the items/products.
Damaged Inventory	QIH004	Reports on the quantity/value of Inventory/Stock Damaged in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Damages over the previous 6 months from the From date specified in the filters.
Inventory Adjustments	QIH003	Reports on the quantity/value of Inventory/Stock Adjustments in the previous 6 months grouped by Product Group. Lists the Product Group. Products and the values of the Adjustments over the previous 6 months from the From date specified in the filters.
Inventory Forecast	QIH013	Reports on the calculated Forecast in Weeks and Days the current SOH will last per item/product. The report uses the number of items sold per items/product in the Period selected and compares the sales to the current SOH level and calculates the Forecast values. Lists the Product PLU and Description, Supplier Code, Case Qty, Size, Cost of Sales, Qty, Sales (Excl./Incl. Tax), Gross Profit %, Stock on Hand (SOH), Location Cost, Value of SOH and the Forecast in Weeks and Days. Notes... This report automatically consolidates to parent items as the report would not be accurate with this option disabled.
Inventory Movement	QIH001	Reports on the quantity/value of Inventory/Stock Movements in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Movements over the previous 6 months from the From date specified in the filters.
Inventory Promotions	QIH006	Reports on the quantities/value of Inventory/Stock Promotions in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Promotions over the previous 6 months from the From date specified in the filters.
Inventory Purchases	QIH005	Reports on Stock Purchases summarised by Calendar month (for each of the 6 months prior to the To Date selected) and grouped by Product Group. Lists the Product Group, Product and Sales value per month, plus a total.
Inventory Receipts	QIH007	Reports on the quantity/value of Inventory/Stock Receipted in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Receipts over the previous 6 months from the From date specified in the filters.
Inventory Redemptions	QIH008
Inventory Returns	QIH009	Reports on the quantity/value of Inventory/Stock Returned in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Returns over the previous 6 months from the From date specified in the filters.
Inventory Wastage	QIH011	Reports on the quantity/value of Inventory/Stock Wasted in the previous 6 months grouped by Product Group. Lists the Product Group. Items/Products and the values of the Wastage over the previous 6 months from the From date specified in the filters.
Movements Summary	QIH012	Use the Period Location Summary Report for more accurate reporting on Trading Periods. Reports on Inventory/Stock Movements grouped by Product and then Product Group. Lists the Product Group # and Description, Product Code, PLU and Description. Location #, Opening Stock, Sales, Adjustment, Damaged, Promotion, Wastage, Nett Purchases, Nett Transfers, Stocktake Variance and Closing Stock. This report can be sorted by PLU # or Product Description.
Stocktake Variance	QIH002	Reports on Stock Variance ($ value or quantity) monthly totals for the 6 months leading up to the date selected, grouped by Product Group. Lists the Product Group, Product, Month total for each of the 6 months and the Total. This report can be sorted by PLU, Description or Product Group.
Transfer Cost Variances	QIH010	Reports on only those Inventory/Stock Transferred that resulted in a Cost Variance grouped by Product Group. That is, the difference in the cost value of the goods transferred between the From and To Locations. This generally will only occur when the Product's Cost Price differs between Locations. Lists the Product Group. Items/Products and the values of the Variances over the previous 6 months from the From date specified in the filters. Also reports the Total value of Variances.

Stocktake Reports ▲ ▼

PDE Inventory Count in Scan Order	SSPE001	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	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	Reports on all items/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 items/products that were scanned before/after the unmatched items/products. This is to facilitate easier identification.
Variance Report	SSPE009	Reports on all items/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	Reports on all items/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	Reports on all items/products selected for stocktaking not grouped or grouped by Product Group or Category. Lists the Location, Product, Size/UOM, PLU and Total. Also provides a Count column for the recording of the stocktake count and a Total counted column. Optionally, it can also list the current cost of the item/product reported.
Recount Sheets	INV007	Reports on all items/products selected for stocktaking not grouped or grouped by Product Group or Category. Lists the Location, Product, Size/UOM, PLU and Total. Count variance tolerance options can also be provided to ensure only those items/products that have Count variances outside the tolerance options specified, are included as part of the recount.
Recount Sheets By Location	INV007	Reports on all items/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 items/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	Lists the Product, PLU, Count and Counted Value.
Period Location Summary (Counted Value)	SSPE008	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	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 also include items/products that have not been counted.
Variance Report (Since Last Stocktake)	SSPE012	To be continued ...

Venues

End of article ▲

Inventory/Stock

Back Office - Reports

Subjects ▲ ▼

About ▲ ▼

What Is New? ▲ ▼

Reports ▲ ▼

Inventory Reports ▲ ▼

Inventory Quick Reports ▲ ▼

Filters/Options ▲ ▼

Reports ▲ ▼

Stocktake Reports ▲ ▼