Special Processing

This section explains some functionality for the One View Inventory Valuation Analysis Inquiry application:

The system uses the default Sales/Inventory Cost method (CSIN value as I in F4105 table) for the item to calculate inventory values (for example, on hand, backordered, future committed) of the item. The inventory value is calculated by multiplying the quantity retrieved from the item location table with the cost. For example, for the item MEKEYBOARD the on hand quantity is 1000, and the default cost value is 5, which indicates that the on hand inventory value is 5000 (1000 * 5).

You can specify any two of the cost methods from the following nine hard coded cost methods in the processing options:

• 01 - Last In

• 02 - Weighted Average

• 03 - Memo

• 04 - Current

• 05 - Future

• 06 - Lot

• 07 - Standard

• 08 - Purchase- Base Cost No Adds

• 09 - Manufacturing Last Cost

The cost associated with the cost method specified in the processing options is retrieved from the Item Cost File (F4105). Inventory values are calculated by multiplying the cost with current inventory levels.

The cost method is restricted to two in the processing options because of performance reasons.