Understanding historical inventory valuation for the data warehouse - HxGN EAM - 12.0.1 - Installation & Upgrade

HxGN EAM Application Installation

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
12.0.1

The data warehouse ETL process includes data marts, two of which are a stores daily snapshot (SDS) and a parts daily snapshot (PDS). The SDS data mart captures daily summaries of the value of your inventory by store, organization, and part class. The PDS data mart captures daily summaries of the value of your inventory by part. However, PDS only captures daily summaries for the parts for which you have indicated to save historical data using the Save History check box on the Record View tab of the Parts page when creating parts.

This section describes the manner in which the SDS and PDS derive historical inventory valuation data for the data mart when executing the initial data load for the SDS and PDS and how the ETL process calculates historical inventory valuation for the data warehouse for different inventory scenarios.

Inventory valuation is normally calculated using the sum of stock value as it exists at the time that the ETL process is executed. Historical stock values are derived using stock transactions in reverse order and backing out the changes to stock quantities and prices. However, some historical stock value information is either not available or is impractical for use in calculating historical values.

Because of the manner in which historical inventory value must be determined for the data warehouse, the calculation of historical inventory value for some of the inventory scenarios may result in an approximate value that is as close to the exact value as possible.