Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC234


IC234 - Period End Valuation

**Form Purpose
Run Period End Valuation (IC234) to valuate 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 valuate 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).

**Processing Effect
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 valuate inventory based on a specified costing method (Standard,
Average, LIFO, or FIFO). Refer to the Inventory Control User Guide 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.



$8 IC2351
**Form Purpose
Run Lower of Cost or Market Valuation (IC235) to show the inventory item
material cost, inventory item overhead cost, and the inventory item average
unit add-on cost at a given inventory location. IC235 is an inventory
valuation report that lists and totals these inventory item costs. The average
cost is without average add-on cost included.




Updated Files

    ADDRDATA   -

    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.

    INSTCTRYCD -

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

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

    PORECADJLN -

    PORECLINE  - Used to obtain purchase order receiving records.


INVOKED Programs

    IFCU
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFLU
    IFOB
    IFAU
    IFSG
    SLSE
    SLSU