Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

PO180

PO180 - GL Transaction Register

Use this program to update the general ledger with inventory transactions
created by purchase order receipts and adjustments and inspection rejections.
This program is used to post inventory tracked items only. The program posts
all the receipt and adjustment and inspection rejection transactions since the
last time the program was run in update mode (which you can run throughout the
month).

For example, a debit is posted to the inventory account for the received
purchase order line as defined in IC04.1 (General Ledger Category). This
account defaults onto the purchase order line for the inventory item. The
credit is  created to the Received not Invoiced or Invoiced Not Received
account. These  accounts can default from MA05.1 (Process Level) or MA00.4 (GL
and Invoicing  Setup).

This report does not serve the same purpose as PO135 (Received, Not Invoiced
Report). The system does not create reversal transactions in the General
Ledger. The Accounts Payable system runs the Invoice Distribution Closing
program. It passes two values to the GL interface file:
- A debit to the Received Not Invoiced or Invoiced Not Received account,
- A credit to the AP accrual account.

This report is sorted by process level. For each process level the report
lists this information based on the selection criteria you enter:

- Received Not Invoiced account
- Invoiced Not Received account
- purchase order variance account
- transaction type
- ship-to location code
- item identification code
- quantity of the item
- item BUOM
- item unit cost
- transaction amount
- transaction date and GL posting date
- standard cost
- variance
- document code
- line number

Note: You can capture a receipt audit trail if you run PO180 in report mode.
You will only be able to access unposted receivings, or receivings that have
not been posted by an update run of PO180, though. Once receivings are run
through PO180 in update mode, the receivings will no longer show up on reports
produced by PO180. Therefore, you can only obtain an audit trail for date
ranges since the last update run of PO180.

Updated Files

    ACCOMMIT   - Used to reference and update Activity Management commitment
                 records.

    ACCOMMITX  - Used to create or update commitment records in the Activity
                 Management system.

    CKPOINT    - Used to determine if restart information exists.

    ICHISTORY  - Creates or changes receipts type records.

    MMDIST     - Referenced or updated by purchase order common routines and
                 creates account distribution records for noninventory type
                 items.

    MMUAVAL    - Used to store user analysis values defined for transactions.
                 User analysis values represent information your organization
                 can use to measure profitability. To utilize this measure of
                 organizational profitability, you must be set up to use the
                 Strategic Ledger system.


    PORECLINE  - Used to update the receiving line item record.

    SYSTEMCODE - Used to update the system code record.


Referenced Files

    ACACCTCAT  - Used to validate the account category.

    ACACTGRP   - Used to validate the activity group.

    ACACTIVITY - Used to validate the activity.

    ACCAL      - Used to validate the calendar year records.

    ACCALX     - Used to validate that the calendar records exist for the
                 complete date range.

    AMASSET    - Used to validate the asset.

    AMTEMPLATE - Used to validate the asset template.

    APCOMPANY  - Used to validate the Accounts Payable company.

    APCPYVND   - Used to retrieve company-specific defaults for a vendor.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APVENCLASS - Used to validate vendor class or to default vendor class
                 information.

    APVENGROUP - Used to validate vendor group or to default vendor group.

    APVENMAST  - Used to validate the vendor ID and obtain vendor display
                 information.

    BUYER      - Used to validate a buyer code and to display the buyer name.

    CUCONV     - Used to access general ledger and currency information.

    CURELAT    - Used to validate currency relationships.

    GLADDRESS  - Used to obtain the General Ledger company address.

    GLCHART    - Used to validate the system account.

    GLINTCO    - Used to validate the intercompany relationship.

    GLSYSTEM   - Used to validate the General Ledger company.

    ICCATEGORY - Used to obtain General Ledger category account information for
                 inventory items.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the Inventory Control inventory location and
                 to get location address information.

    ITEMLOC    - Used to update Inventory Control item location average cost.

    ITEMMAST   - Used to validate the item and to obtain item descriptive
                 information.

    POCOMPANY  - Used to validate the purchase order company information.

    POLINE     - Used to validate and default purchase order line information.

    POPROCLEV  - Used to determine general ledger accounts to use for creating
                 general ledger distributions.

    PORETURNHD - Used to validate or default header information from a purchase
                 order return.

    PURCHORDER - Used to validate and default purchase order information.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFFC
    IFGT
    IFOB
    IFRS
    IFSC
    SLSB
    SLTV
    SLFD