Stock & Analysis Reports
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. End-User | Stock Control
      3. Stock & Analysis Reports

      17 | COGS By Stocktake Report

      This article outlines the COGs by Stocktake Report which allows for viewing Cost Of Goods data over the time span of two (2) Stocktake Periods where the Date/Time of the 1st Stocktake is the beginning of the Reporting Period and the Date/Time of the 2nd Stocktake is the end of the Reporting Period.

      This article outlines the COGs by Stocktake Report which allows for viewing Cost Of Goods data over the time span of two (2) Stocktake Periods where the Date/Time of the 1st Stocktake is the beginning of the Reporting Period and the Date/Time of the 2nd Stocktake is the end of the Reporting Period.

      This offers greater flexibility for analysis of Cost of Goods data beyond using the '_History' View of the standard Stocktake Report and this Report can provide a great deal of financial insight and perspective.

      Use the Reporting Options to configure the Report as desired; select a Venue and Store, choose the desired Stocktakes, and select various flags and/or Product List options to cater to the Report as required.

      The Standard View for this Report provides a plethora of useful information for analysis including various Costs, Units Sold, Profit Amounts and Percentages, and Days On Hand.

      Prerequisites
      • To access COGs features, the applicable Operator Privileges   will need to be enabled 
        • Operator Maintenance 'Reporting' Tab
          • Other Reports: "Allow Analysis Reports" flags
      Accessing the Report
      • To locate the COGs By Stocktake Report - after logging into BackOffice, navigate to the side menu where Analysis Reports can be found
      • After expanding the Analysis Reports menu, the COGs By Stocktake Report will be available for selection
      • Select the Report and once the tab opens choose the preferred Reporting Options (see below for details) and then click the Display/Refresh button to run the Report

      Reporting Options
       

      Option

      Description

      Visual/s (if applicable)
      Venue drop-down
      • The Venue drop-down allows for selecting a specific Venue for Reporting if there are multiple Venues in the database
      • The list in the drop-down will replicate the list of Venues in the System's database

       

       

       
      Store drop-down
      • The Store drop-down allows for selecting a specific Store from the selected Venue for Reporting
        • Optionally, choose 'All Stores' to Report on Stocktake COGs for all Stores within the Venue
      • The list in the drop-down will replicate the list of Stores that belong to the Venue that has been chosen in the Venue drop-down

       

       

       
      StockTake drop-downs
      • Both the StockTake1 and  StockTake2 drop-downs allow for selecting the two (2) desired Stocktakes to set the Start and End Stocktakes for the Report
      • The lists will replicate all of the available Stocktakes that have been conducted and applied for the selected Venue
      • The Stocktake selected for StockTake 1 must be earlier than the Stocktake selected for StockTake 2

       

       

       
      Sub Products & Inactive flag
      • This flag is only applicable when using the Full Tree or List Only options
        • When using the List Only option, the following information is only applicable if 'All Parent Groups' is selected
      • If this flag is enabled, the Report will display data for all Sub Products and Inactive Products that belong to the selected Product Group
      • With this flag disabled, the Report will only show data for the selected Parent Group's first set of Child Groups (if the selected Parent Group has Child Groups)
      • If the selected Parent Group doesn't have Child Groups, this flag will not change the Report data

       

       

       

       

       
      Entered Only flag
      • This flag controls whether or not Products or Product Groups which have had counts entered in the selected Stocktakes will display in the Report
      • If the flag is disabled then all Products or Product Groups belonging to the selected Parent Group will be displayed in the Report
      • When the flag is enabled, only Products or Product Groups which have had counts entered in at least one of the selected Stocktakes will display in the Report
      		  
      Stocktake Details
      • The Stocktake Details section  - while not a Reporting Option - will display information dependent upon the Stocktakes that have been selected for Reporting
      • Details include:
        • Start Operator - this is the Operator who applied StockTake1
        • Start Date Time - this is the date & time that StockTake1 was applied and is the date/time that 1st Period Data in the Report is retrieved from
        • End Operator - this is the Operator who applied StockTake2
        • End Date Time - this is the date & time that StockTake2 was applied and is the date/time that 2nd Period Data in the Report is retrieved from

       

       
      Full Tree radial
      • When the Full Tree radial is selected, the Product List will display all Product Groups in the database and they will be laid out in a tree-like structure with Parent Groups and Child Groups
      • This allows for selecting any specific Product Group to Report on
      		  
      List Only radial
      • When the List Only radial is selected, the Product List will display the lowest-level Product Groups from each Parent Group and they will be laid out in an alphabetical list
      • This limits the Report to only have the capability to report on the lowest-level Product Groups
      		  
      Hide List radial
      • With the Hide List radial selected, the Product List will be hidden altogether and the report will display all of the Products in database which are applicable to the Reporting Options selected
      		  
      Group By drop-down
      • This drop-down allows for selecting how the Report data will be Grouped if desired to do so
      • Grouping the Report data allows for further refinement and analysis
      • Each Group will have its own Totals line and can also be collapsed or expanded within the Report
      • Select from the following options:
        • None
        • Parent Name
        • Parent Tree
        • Export Codes 1 - 4
        • Product Type
        • Type Group
        • Product Sort
        • Sort Group
        • Supplier
        • User Layout

       

       

      ===

      Standard View

      • The COGs By Stocktake Report has a Standard View which is unique to this Report
        • Alternatively, additional Views can be added by selecting the View icon and completing the standard procedure for Adding and/or Editing Views
      • The '_Standard' View of the COGs By Stocktake Report contains the following columns:
        • Product ID
        • Name
        • Stock Type Qty which refers to the Product's Base Volume or Size; e.g. if a Product has a Base Volume of 750 Mills, the Stock Type Qty will be 750
        • Avg CostEx StockTake
        • End Qty which refers to the End Quantity of the 1st Period (Stocktake 1) and this is the starting Quantity On Hand for the time span being Reported
        • CostEx Received
        • CostEx XferIn (transferred in)
        • CostEx XferOut (transferred out)
        • CostEx Loss
        • 2nd Period End Qty
        • Qty Units Sold
        • CostEx StockSold
        • NettTotal
        • Profit Amt
        • Profit%
        • Adjusted ProfitAmt
        • Adjusted Profit%
        • Variance%
        • Cost Variance%
        • 2nd Period End Cost Ex
        • Days On Hand