Consolidated Daily Inventory Counts

The Consolidated Daily Inventory Counts report is used to monitor inventory levels at all locations within the selected hierarchy for items that are counted multiple times during the course of a day. The report displays physical inventory count records in the order in which they were entered and calculates an Intraday Book Quantity and Value for each product count record by applying variances accumulated during prior inventory count events for the same product and inventory date to the Book Quantity and Value.

   

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Daily Inventory Counts
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Daily Inventory Counts

 

Transactions Included: Scheduled Inventory Counts by Template

 

Report Controls

From/To: Calendar widgets; 31-day limit based on selected "From" date.

Hierarchy: Select the desired hierarchy level from the drop-down

Group By: Date, Location Name

Funnel (Filters): Product Name, Product #, Category/Subcategory/Microcategory, GL Code/Description, Template, User Defined Category, Inventory Type.  For filtering tips, click HERE.

• If generated for more than one day, you can filter by the "generic" template for a single intraday event to see the counts and variances for just that one event.
• To focus on the results of a single product, filter the report to display just that product since the report cannot be grouped at this time.

Printer (Export): PDF, Excel, CSV formats

Sort: This report automatically sorts product rows based on the date of the scheduled counts and the time the counts were entered; it does not allow for any other sort options at this time.

Report Columns:

• Date – The date of the scheduled inventory count.
• Time – The time of day that the count was entered.
• Inv. Description – The name of the template used for the scheduled count.
• Product # – The company product number.
• Product Name – The company product name.
• Inv. Unit – The company product inventory unit.
• Phys. Qty. – The count entered during scheduled inventory.
• Intraday Book Qty. – For first product count this = Book Qty; for each successive count, this is calculated as [ Book Qty + Cumul. Variance Qty. ]
• Intraday Variance Qty. = [ Physical Qty + In Transit Qty – Intraday Book Qty ]
• Cumul. Variance Qty. = The sum of the Intraday Variance Qty. for that product
• Intraday Variance Value = [ Physical Value + In Transit Value – Intraday Book Value ]
• Cumul. Variance Value – The sum of the Intraday Variance Value for that product

 

Note that although "In Transit" is used to calculate the Intraday Variance Qty/Value, it is not displayed as a column in the report.

Report Totals:

• Intraday Variance Qty. = The sum of the Intraday Variance Qty. for all products
• Intraday Variance Value = The sum of the Intraday Variance Value for all products

 

 

 

Related Topics