IC234 - Period End Valuation

Run this program to evaluate inventory as of a specific date. This report is
identical to the Inventory Valuation Report printed in IC233 except you can
run this program for a previous date to evaluate inventory for a specific
time. This program lets you balance inventory valuation totals with inventory
general ledger account totals calculated when you ran IC130 (General Ledger
Interface).

This program values stock-on-hand quantities based on the costing method
defined for the company in IC01.1 (Company). You can run IC233 (Inventory
Valuation) to evaluate inventory based on a specified costing method
(Standard, Average, LIFO, or FIFO). Refer to the 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 optionally include
item detail and exclude items with zero stock-on-hand quantities. Item detail
includes the item number, description, unit of measure, unit cost, intransit
quantities, stock-on-hand quantity, and stock-on-hand value.

If you use the Update Date and Time option, IC234 reports the valuation as it
is actually updated to inventory.

If your general ledger posting date does not equal the update date, you may
not be able to balance to general ledger.

If you use the Transaction Date and Time option, IC234 reports the valuation
as if processed by transaction date. The quantities will be correct. However,
if your company is an average or standard cost company, your costs may not be
correct. IC234 captures your costs based on the update date, but the general
ledger valuation is based on the general ledger date. If the transaction date
does not equal the general ledger date, you still might not balance to general
ledger.

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 for an item
                 location.


    ICCOMPANY  - Used to validate company number.

    ICLOCATION - Used to validate an inventory location.

    ICRECEIPTS - Used to extract item location costing information.

    ICRPTGRP   - Used to validate report groups parameters.

    ICTRANS    - Used to obtain transaction records for an item location.

    ITEMLOC    - Used to obtain item location stock-on-hand quantities.

    ITEMMAST   - Used to obtain the item description and other item master
                 information.


    PORECLINE  - Used to obtain purchase order receiving records.


INVOKED Programs

    IFCC
    IFCR
    IFSG
    IFCU