Difficulty Level - Advanced Impact - Organization Level

Inventory Reporting lets you manage the inventory controls for your organization - like which sales components to use when viewing inventory costing reports, whether or not to use forecast data as the basis of calculations, reporting controls, etc.

To access Inventory Reporting settings:

  1. Click on on the quick links Located at the top right corner of a page, it contains icons that allow you to quickly access important pages. bar from any page.

  2. In the Settings window:

    Settings associated to a page automatically show in the List box. If the setting that you want to access is in the List box, you can skip step a.

    1. Select Inventory from the Filter drop-down list.

    2. Click on Inventory Reporting from the List box in the left pane.

Make sure you click on the Update button at the bottom of the page to save any changes you make.

ClosedChoose which sales amount to use in calculations:

The settings in this section determine which sales figure is used to calculate each of the following. The sales figures that can be used for the calculations are:

  • Net Sales: Found in Cash Sheet > Summary, it is obtained after subtracting deductions from the adjusted gross.

    Net Sales = Adjusted Gross - Deductions

    OR

    Net Sales = Gross Sales - Non-Food Sales - Tax^ - Deductions

  • Adjusted Gross: Found in the Cash Sheet > Summary page, it is obtained after deducting the Tax^ and a few other items* (depending on how your POS is set up) from the gross sales.

    Adjusted Gross = Gross Sales - Non-Food Sales - Tax^

  • PLU Sales: Found in the Cash Sheet > Product Mix page, it is the Total Group Sales of all items.

Actual Inventory Cost

The sales figure selected under this head is used to calculate:

  • The figure in the last column of the Category Cost, Sub-Category Cost and Item Cost Actual Usage reports.

  • The actual cost % on the Category Cost, Sub-Category Cost and Item Cost Variance Report reports.

  • The actual cost % on the Category Cost, Sub-Category Cost and Item Cost Variance Report with Waste reports.

Theoretical Inventory Cost

The sales figure selected under this head is used to calculate:

Waste Cost

The sales figure selected under this head is used to calculate:

  • The Usage %, Waste % and Total % on the Theoretical Usage page.

  • The Waste % on the Executive Summary page.

  • The Waste as a percentage of Sales figure (where Sales is the sales figure selected in this control) on the Waste page.

Forecasting / Product Projections

The sales figure selected under this head is displayed on the first line of the Freezer Pull Worksheet and Prep Chart Worksheet.

Product Yields / Ordering

The sales figure selected under this head is used to calculate suggested ordering Ordering quantities calculated by Clearview to meet forecasted demand until the next supplier delivery date, without carrying too much inventory. quantities using case yields on the Create Purchase Order page.

Further settings for suggested ordering Ordering quantities calculated by Clearview to meet forecasted demand until the next supplier delivery date, without carrying too much inventory. using case yields can be found on the Sales Yield Worksheet.

ClosedUse forecasted data to populate the following:

The settings in this section determine whether forecasted data is used along with actual data for calculations on the pages indicated:

  • No - The averaged actual sales figure is used in the calculations.

  • Yes - The averaged actual sales figure is adjusted with forecasted data and then used in the calculations.

    The settings for the forecasted data can be found in Forecasting.

Preparation Charts

The option selected under this head affects the Prep Chart Worksheet.

Freezer Pulls

The option selected under this head affects the Freezer Pull Worksheet.

Drop Charts

The option selected under this head affects the Drop Chart Worksheet.

ClosedReporting Controls:

Cost Display on Reports

Indicates which costs are included (as columns or rows) on the Executive Summary, Store Managers Summary and Food Cost Worksheet.

ClosedWaste:

Waste Entry Method

Determines whether waste is recorded as categories or as inventory and menu items:

  • Raw & Completed: Uses the current list of inventory items and menu items.

  • Waste Categories: Requires waste categories to record waste.

    Click here to learn how to create, edit and delete Waste Categories in Settings.

If you're just setting up your organization in CLEARVIEW or have recently decided to use the Inventory module, we recommend you set the Waste Entry Method to Raw and Completed as it automatically allows for waste entry of all inventory and menu items.

ClosedPhysical Counts:

Count Entry Method

Indicates if physical counts are recorded by inventory item or by supplier product An inventory item in a package size available from a particular supplier.:

While Multi-Product is the more accurate measure and will hence result in more accurate reports, it also means storing different supplier products separately so that they can be counted separately. We hence recommend you choose the option that works best for your organization.

Display Theo-on Hand

Indicates whether the theoretical count (calculated based on the last count, purchases, orders and waste recorded) is included when creating a count.

  • No - Will not provide the theoretical count when creating counts.

  • Yes - Will provide a Display Theoretical on Hand option on the Create Count page.

The theoretical count will be displayed on new count sheets only when this option is set to Yes and a checkmark is placed in the Display Theoretical on Hand box when creating the count.

Use Full Count for Hot Items

Determines whether creating full inventory counts also automatically generates mini inventory (Hot Item) counts.

  • No - When you create a full inventory count, only a full inventory count sheet will be created and available for the day.

  • Yes - Will automatically generate mini inventory counts for all active Hot Item sheets each time a full inventory count is created.

    The mini inventory (hot item) count sheets do not have to be filled in these instances, as the counts will automatically populate from the full inventory count sheet.

ClosedPurchase Orders:

Display Negative Theo-on Hand

Determines how negative On Hand values (when calculations result in negative values) are treated when Use Theoretical quantity on hand is selected on the Create Purchase Order page.

ClosedAudit

Click on the Audit button to see all changes made to the control(s) on the page. Changes that were made to the control(s) will be listed in a table.

Related CLEARVIEW Pages

^or HST or GST and/or PST or VAT/VAT Exempt (as per your location)

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.