Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AP520

AP520 - Invoice Interface

Run AP520 (Invoice Interface) to interface or convert invoice, split invoice
payment, and general ledger distribution information from a non-Lawson system
to the Lawson Accounts Payable system. You must select a batch number or an
authority code if you are interfacing or converting unreleased invoices. The
batch number or authority code is optional when interfacing or converting
released (open) or historical invoice, split invoice payment, and distribution
records.

You can use AP52 (Invoice Interface Adjustments) to add invoice, payment, and
distribution information to the invoice, distribution, and payment conversion
files or to maintain information already loaded into these files before you
run this program. After the appropriate invoice, payment, and distribution
information has been loaded into the conversion files, you can run this
program to edit the information for completeness and accuracy, create new
invoice, payment, and distribution records in the Lawson Accounts Payable
system, and purge the corresponding records from the conversion files.

Note that you must set up the following codes and information as valid records
if this information is to be converted as part of the invoice, split invoice
payment, or distribution records: cash codes, payment codes, accrual codes,
distribution codes, hold codes, vendor location codes, currency codes, tax
codes, activities, and asset information.

You can maintain unreleased invoice records in AP20 (Invoice Entry) and
released (open) invoice records in AP30 (Invoice Adjustments) you convert
them.





Updated Files

    ACCOMMIT   - Creates activity commitments detail.

    ACCOMMITX  - Creates activity commitments transactions.

    APASTDTL   - Creates asset detail records.

    APBATCH    - Updates batch record.

    APCDISTRIB - Deletes conversion invoice distribution record.

    APCINVOICE - Deletes conversion invoice record.

    APCOMPANY  - Updates company.

    APCPAYMENT - Deletes conversion invoice payment records.

    APDISTRIB  - Creates invoice distribution records.

    APHLDINV   - Creates records of vendors, invoices, and payments that are on
                 hold.


    APINVOICE  - Creates invoice record.

    APMONITOR  - Creates and deletes monitor record while processing.

    APPAYMENT  - Creates invoice payment records.

    APUAVAL    - Creates and updates user analysis information.

    APVENBAL   - Creates and updates vendor balances.

    APVENCLASS - Creates vendor class record.

    APVENGROUP - Updates vendor group.

    APVENMAST  - Creates vendor records.

    CBBANKINST - Validates payment code and updates used flag.

    CBCPYCASH  - Validates company cash and updates used flag.

    CKPOINT    - Used to store restart information.

    INSTDETAIL - Maintains Intrastat detail information.

    INSTHEADER - Maintains Intrastat header information.

    INSTNBR    - Keeps track of most recently assigned Intrastat number and
                 assigns the next number to the next transaction that requires
                 Intrastat reporting.


    JBOOKHDR   - Used to validate system control journal books for a company.

    TERMS      - Validate terms code.

    TXCODEMAST - Validates tax code master.

    TXCOMPANY  - Validates tax company.

    TXTAXCODE  - Validates tax code.

    TXTAXTABLE - Validates tax table.

    TXTAXTRAN  - Creates tax transaction records.


Referenced Files

    ACACCTCAT  - Validates the activity account category.

    ACACTGRP   - Validates the activity group.

    ACACTIVITY - Validates the activity.

    ACCAL      - Validates the activity calendar information.

    ACCALX     - Validates activity detailed calendar information.

    AMASSET    - Referenced by asset management common routines.

    AMTEMPLATE - Referenced by asset management common routines.

    APACCRCODE - Validates invoice accrual code.

    APAPPROVAL - Validates whether the transaction needs approval.

    APAUTHOR   - Validates authority code.

    APCPYVND   - Lookup file for default codes on the invoice.

    APDISCCODE - Validates discount code.

    APDISTCODE - Used to access distribution code detail.

    APDISTHDR  - Validates the distribution code.

    APHOLDCODE - Validates hold code.

    APINCCODE  - Validates income code.

    APPAYCOREL - Validates relationship between pay group and company.

    APPAYGROUP - Validates pay group.

    APPROCLEV  - Validates process level.

    APUDISTCD  - Updates user analysis information.

    APVENLOC   - Validates vendor location.

    APWTHCODE  - Validates income withholding code.

    CBCASHCODE - Validates cash code and updates used flag.

    CBCHECK    - Validates payment records.

    CUCONV     - Referenced by currency common routines.

    CURELAT    - Used in currency common routine.

    GLADDRESS  - Referenced by general ledger common routines.

    GLCHART    - Referenced by general ledger common routines.

    GLCODES    - Referenced by general ledger common routines.

    GLINTCO    - Edits intercompany relationship.

    GLSYSTEM   - Validates general ledger company.

    INSTATPROC - Validates the Intrastat procedure code.

    INSTCMDTY  - Validates Intrastat commodity code.

    INSTCTRYCD - Validates the country code for VAT and Intrastat reporting.

    INSTNOTC   - Validates Intrastat nature of transaction code.

    INSTPORTS  - Validates Intrastat port code.

    INSTREGN   - Validates Intrastat region code.

    INSTUOM    - Validates Intrastat secondary unit of measure.

    JBKOPCODE  - Validates the operator's access to the system control journal
                 books.


    JBKSYSCODE - Validates that system journal books can be applied to the
                 general ledger system.


    SYSTEMCODE - Validates the system code updating general ledger and updated
                 the object id.


    TXTAXRATE  - Retrieves tax rate based on tax code and date.

    WFSETUP    -


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    SLSS