Adaco: Inventory Valuation (Historical) Report

Inventory Valuation (Historical) Report

The Inventory Valuation (Historical) report is used to see the inventory counts that had or had not yet been put in by users or, if rollover, what the system had calculated the period ending amount on-hand.

• To run the this report, go to Report Center > Inventory Reports > Inventory Valuation (Historical)
• To open the report criteria screen​, double-click Inventory Valuation (Historical) report or select the report and click Run Report, as per Fig.1

Fig.1 - Running the Inventory Valuation (Historical) report

Report Criteria:

Enter report criteria below to get desired results, as per Fig.2 below.

Fig.2 - Report Criteria for the Inventory Valuation (Historical) report

 

Fields	Description
Report Type	Detail: generates the report with the inventory counts per product. Summary: generates the report with category and account totals.
Report Selection	All Outlets: generates the report with all outlets marked for inventory, as defined under  Property > Setup > Location > Outlet. Selected Outlets: generates the report with only the chosen outlet(s). Outlet Category: generates the report with only the outlets assigned to the chosen category/ies, as defined under Property > Setup > Location > Outlet > Cost Category. Location: generates the report with only the chosen locations of outlets marked for inventory.
Period	The available, closed, inventory periods.
Detail Options	(Select All): generates the report with all options. Show Group Totals: generates the report with a total inventory count and cost per category. Show Purchase Quantity: generates the report with the Purchase Count / Unit column. Show Zero Count: generates the report with products that does not have an inventory count put in or the inventory count is zero.
Product Category	All Categories: generates the report with all categories associated to products. Selected Categories: generates the report with only products associated to the chosen category/ies.
Group By	Inventory: generates the report following the outlet's guide, as defined under Inventory > Maintain Guides. Category: generates the report numerically by the Adaco category number, as defined under Property > Setup > Categories > Categories. Category and Subcategory: generates the report numerically by the Adaco category number and then the Adaco sub category number, as defined under Property > Setup > Categories > Categories. Account: generates the report numerically by the Adaco account number, as defined in Property > Setup > Accounting > Accounts.
Dates	Automatically populates the current date in the first field and the period end date in the second field.
Options	Page Break by Outlet:​ generates the report by starting the inventory of a new outlet on the next page. Show Retail: generates the report with the product's retail information if the outlet is a retail outlet, as defined under Property > Setup > Location > Outlet.

 

Report Results

When the Inventory Valuation (Historical) report is generated, the result should look similar to Fig.3.

Fig.3 - Inventory Valuation (Historical) report results​
 

Fields	Description
Document Map	Allows the user to quickly access different categories easily in the report.
Product Number	The Adaco number for the product.
Product Description	The name of the product.
Purchase Unit	Count: the number entered in the physical inventory count screen, found under Inventory > Physical Inventory Count. Unit: the purchase type for the product.
Inventory Unit	Count: the number entered in the Physical Inventory Count screen, found under Inventory > Physical Inventory Count. Unit: the inventory type for the product.
Bin Number	The bin number assigned on the Product Master.
Unit Cost	The current inventory cost of the product.
Extended Cost	The total cost for the on-hand inventory. The Purchase Unit field uses the total inventory units in each Purchase Unit to determine the number of units in inventory.  Calculation: EXTENDED COST = PURCHASE UNIT COUNT(TOTAL INVENTORY UNIT) + INVENTORY UNIT COUNT x UNIT COST Example: $20.00 = Purchase Unit Count 1 (pack of 15) + Inventory Unit Count 5 x $1.00 Unit Cost
Outlet Number	The Adaco outlet number.
Outlet	The name of the outlet.
Category	The name of the category to which the products are assigned.
Total	The total inventory count for the category and the total extended cost.
Category Recap	Category Number: the Adaco category number. Category Name: the name of the category. Total: the total cost for each category. Category Total: the sum total for all categories.
Account Recap	Account Number: the Adaco account number. Account Name: the name of the account. Total: the total cost for each account. Account Total: the sum total for all the accounts.
Categories Grand Totals Recap	Category Number: the Adaco category number. Category Name: the name of the category. Total: the total cost for each category in all the outlets. Categories Grand Total: the sum total for all the categories in all the outlets.
Accounts Grand Totals Recap	Account: the Adaco account number. Account Name: the name of the account. Total: the total cost for each account in all the outlets. Accounts Grand Total: the sum total for all the accounts in all the outlets.