IC233 - Inventory Valuation Run this program to print the Inventory Valuation report. It also values stock-on-hand quantities based on a specified costing method (Standard, Average, LIFO, or FIFO). By default, inventory valuation is based on the costing method defined for the company. Refer to Inventory Control Procedures Manual for costing method calculation formulas. You can select the inventory valued on this report by location, report group, and general ledger category. Otherwise, inventory valuation is based on all locations and general ledger categories. This report lists general ledger category, location, and company summarized totals. You can include item detail and exclude items with zero stock-on-hand quantities. If you print item detail, this report prints by location and general ledger category the item number, description, unit of measure, unit cost, intransit quantities, stock-on-hand quantity, and stock-on-hand value. Note: The report prints the run date and time and lists a composite total of Item Location records as of that run date and time. The report multiplies the current stock-on-hand times the unit cost. It does not take into consideration when the transaction that updated the inventory took place. If all inventory transactions (including Order Entry, Purchase Order, and Requisitions) have been processed to the General Ledger system, the report should balance to general ledger account totals. Updated Files CKPOINT - Referenced Files CUCONV - Used in a Currency conversion common routine. CURELAT - Used in a Lawson Currency Conversion common routine. GLADDRESS - Used in a General Ledger common routine. GLCHART - This file contains chart and system account information in the General Ledger system. GLSYSTEM - Used in a General Ledger common routine. ICCATEGORY - Used to obtain general ledger account numbers. ICCOMPANY - Used to validate the existence of the Inventory Control company. ICLOCATION - Used to validate the existence of a location. ICRECEIPTS - Contains the documents with the quantities. ICRPTGRP - Used to validate the existence of a report group. ITEMLOC - Used to obtain the costing method for an item. ITEMMAST - Used to print the description and stock unit of measure. INVOKED Programs IFCC IFCR IFSG IFCU |