Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

MA40

MA40.1 - Invoice

Use this form to add and maintain both purchase order and nonpurchase order
invoices, debit memos, and credit memos.

If the invoice is a purchase order invoice, you can set the Automatch flag.
If you set the Automatch flag to Yes, the system calculates PO Total.

The PO Total is the sum for all purchase order lines of the unapproved
quantity multiplied by unit cost. (Unapproved quantity is unapproved,
released, received quantities for inventory, nonstock, and special items, and
unapproved, released purchase order quantities for service and dropship
items.)

The system also adds the miscellaneous distributions specified on the bottom
part of this form to the automatch total. If the calculated total matches the
invoice amount, the invoice is automatched, all approvals are created, and the
invoice is ready to release. If the totals do not match, you can optionally
create the approvals and then manually review and maintain them to bring the
invoice into balance.

The following always default on the invoice from the purchase order: vendor,
due days, discount days, and discount rate. Optionally, process level may
default from the purchase order. You can override any of these values.

If the invoice is a purchase order invoice, the currency code must be the
same as that on the purchase order. (A purchase order invoice has a PO Invoice
Flag that is set to Yes.) If the invoice is an Add-on Cost invoice, the
currency code on the invoice can be different from the currency code on the
purchase order. (An Add-on Cost invoice has a PO Invoice flag that is set to
A.)

The Invoice Matching system directly interfaces with the Lawson Accounts
Payable system. The parameters you defined for your company in the Accounts
Payable system dictate how invoices are maintained in both the Accounts
Payable and Invoice Matching systems. Once an invoice has been added to the
Invoice Matching system, you can maintain it in the Accounts Payable system.
You must approve all the purchase order lines on all the orders unless the
purchase order line is for a no-charge item. Since these purchase order lines
are free of charge, you do not need to create an approval. Use the Accounts
Payable system to release all invoices and use the Accounts Payable Invoice
Maintenance form to maintain released invoices.

Use this form to add credit memos for two kinds of returns. Add credit memos
for vendor returns for which no automatic credit memo was created.
Alternatively, add credit memos for returns handled as regular purchase order
receivings adjustments. To add regular credit memos (not for vendor returns
added in PO31.1 (Vendor Return)), a released invoice must already exist. For
instructions on how to add a credit memo, see the Invoice Matching Procedures
Manual.

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.

    APACCRCODE - Used to validate the Accounts Payable accrual code.

    APASTDTL   - Used to create asset detail records.

    APAUTHOR   - Used to validate authority code records.

    APBATCH    - Updates the control total fields for the invoice batch.

    APCOMMENTS - Deletes comments record when invoice is deleted.

    APCOMPANY  - Updates last voucher number.

    APDISTRIB  - Creates, changes or deletes distribution records.

    APDRAFTS   - Used in Accounts Payable common routine.

    APHLDINV   - Used to create records of invoices on hold.

    APHOLDCODE - Used to validate Accounts Payable hold code records.

    APINCCODE  - Edits the income code.

    APINVOICE  - Header file maintained by program.

    APMONITOR  - Used to edit the monitor.

    APPAYMENT  - Adds, changes, or deletes payment records.

    APUAVAL    - 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.

    APVENGROUP - Updates the last voucher number.

    CBBANKINST - Used in Accounts Payable common routine.

    CBCASHCODE - Used in Accounts Payable common routine.

    CBCHECK    - Used in Accounts Payable common routine.

    CBCPYCASH  - Used in Accounts Payable common routine.

    GLCOMMENT  - Used to validate General Ledger comments.

    INSTDETAIL - Updates Intrastat detail records.

    INSTHEADER - Updates Intrastat header records.

    INSTNBR    - Generates the next available Intrastat number.

    JBKSEQNBR  - Generates the next available journal book sequence number.

    JBOOKHDR   - Used to edit and default information from the journal book
                 header.

    MMDIST     - Used to create 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.

    POAOCDTL   - Update with approval information.

    POAOCSPRD  - Created when add-on cost approvals are spread across purchase
                 order line items.

    POAPPROVE  - Created with purchase order line item approval information.

    POINVOICE  - Created with purchase order invoice information.

    POLINE     - Updated with purchase order line item approval information.

    POMESSAGE  - Created when approval has buyer message.

    PURCHORDER - Used to default purchase order information on invoice.

    RJBRIDGE   - Used to update recurring journal information.

    RJCONTROL  - Used to update recurring journal control information.

    RJSCHEDULE - Used to update recurring journal schedule information.

    TERMS      - Used to obtain payment term information.

    TXCODEMAST - Used to validate the tax code and display information.

    TXCOMPANY  - Used to validate the tax company record.

    TXTAXCODE  - Used to validate tax code.

    TXTAXTABLE - Used to obtain tax table information.


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.

    APAPPROVAL - Used to validate an approval record for a given company or
                 vendor.

    APCOMMENTS - Deletes comments record when invoice is deleted.

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

    APDISCCODE - Used to validate an Accounts Payable discount code.

    APDISTCODE - Used to validate an Accounts Payable distribution code.

    APDISTHDR  - Used to validate an Accounts Payable distribution code header
                 and default the distributions from the distribution code.

    APDRFTCDES - Used in Accounts Payable common routine.

    APPAYGROUP - Used to validate a paygroup record.

    APPROCLEV  - Used to edit Accounts Payable process level.

    APUDISTCD  - 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.


    APVENCLASS - Used to edit vendor class.

    APVENLOC   - Used to edit vendor location.

    APVENMAST  - Used to edit the vendor.

    APWTHCODE  - Used to validate the Accounts Payable income withholding code.

    CBUSER     - Used in Accounts Payable common routine.

    CBUSRCLASS - Used in Accounts Payable common routine.

    CUCONV     - Used to obtain currency conversion information.

    CURELAT    - Used to edit currency relationship

    EEADVANCE  - Used in Accounts Payable common routine.

    EEEXPENSE  - Used in Accounts Payable common routine.

    GLADDRESS  - Used to obtain the general ledger address information.

    GLCHART    - Used to validate system accounts.

    GLCODES    - Used to edit subledger control.

    GLINTCO    - Used to edit intercompany.

    GLNAMES    - Used to validate the General Ledger account.

    GLSRCCODE  - Used to default source code for General Ledger records.

    GLSYSTEM   - Used to validate General Ledger company.

    GLZONE     - Used to validate zone relationships.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the Inventory Control inventory location.

    INSTATPROC - Used to validate Intrastat statistical procedure codes.

    INSTCMDTY  - Used to validate Intrastat commodity codes.

    INSTCTRYCD - Used to verify that the origin and destination countries in a
                 transaction are part of the European community and the
                 transaction is therefore subject to
                 Intrastat reporting.

    INSTNOTC   - Used to validate Intrastat nature of transaction codes.

    INSTPORTS  - Used to validate Intrastat port codes.

    INSTREGN   - Used to validate Intrastat region codes.

    INSTUOM    - Used to validate Intrastat secondary units of measure.

    ITEMMAST   - Used to validate item type.

    JBKOPCODE  - Used to edit the journal book operator code to see if the
                 operator is authorized.

    JBKSYSCODE - Used to validate if the system can use the journal book.

    POCOMMENTS - Used to obtain purchase order comments.

    POCOMPANY  - Used to validate the Purchase Order company.

    POFRTTERM  - Used to obtain freight term information.

    POPROCLEV  - Used to obtain purchase order process level information.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used to obtain line item receiving information.

    PORETURNHD - Used to update the header record for a purchase order return
                 with credit memo amount.

    PORETURNLN - Used to obtain information from purchase order return line
                 detail to be used in creating Accounts Payable distributions.

    POVENDOR   - Used to update open purchase order amount.

    REQHEADER  - Used to validate, display, and default header information for
                 a requisition.

    SYSTEMCODE - Used to validate system code information used for remote site
                 processing.


    TXTAXRATE  - Used to obtain tax rate information.

    TXUSAGECD  - Used to validate tax usage codes.

    WFSETUP    -


MA40.2 - Miscellaneous Distribution

Use this form to add and maintain Accounts Payable Miscellaneous
Distributions for the invoice. These distributions are a part of the invoice
balancing total. Accounts Payable Miscellaneous Distributions may be created
for tax as well as expense payments. Accounts Payable Miscellaneous
Distributions are usually created for nonspecific invoice related payments
that are not included on the purchase order. If the user has set the purchase
order to include Miscellaneous AOCs, then when the invoice is added and that
add-on cost is approved, an Accounts Payable Miscellaneous Distribution is not
created. The distributions that are created from purchase order Miscellaneous
AOCs and purchase order line items are created and maintained using the
Miscellaneous AOC form or one of the Line Matching forms.

Updated Files

    APACCRCODE - Used to validate the Accounts Payable accrual code.

    APASTDTL   - Used to create asset detail records.

    APAUTHOR   - Used to validate authority code records.

    APBATCH    - Updates the control total fields for the invoice batch.

    APCOMMENTS - Deletes comments record when invoice is deleted.

    APCOMPANY  - Updates last voucher number.

    APDISTRIB  - Creates, changes or deletes distribution record.

    APDRAFTS   - Used in Accounts Payable common routine.

    APHLDINV   - Used to create records of invoices on hold.

    APHOLDCODE - Used to validate Accounts Payable hold code records.

    APINCCODE  - Used to edit income code.

    APINVOICE  - Header file maintained by program.

    APMONITOR  - Used to edit the monitor.

    APPAYMENT  - Adds, changes, or deletes payment records.

    APUAVAL    - 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.

    APVENGROUP - Updates last voucher number.

    CBBANKINST - Used in Accounts Payable common routine.

    CBCASHCODE - Used in Accounts Payable common routine.

    CBCHECK    - Used in Accounts Payable common routine.

    CBCPYCASH  - Used in Accounts Payable common routine.

    GLCOMMENT  - Used to validate General Ledger comments.

    INSTDETAIL - Updates Intrastat detail records.

    INSTHEADER - Updates Intrastat header records.

    INSTNBR    - Generates the next available Intrastat number.

    JBKSEQNBR  - Generates the next available journal book sequence number.

    JBOOKHDR   - Used to edit and default information from the journal book
                 header.

    RJBRIDGE   - Used to update recurring journal information.

    RJCONTROL  - Used to update recurring journal control information.

    RJSCHEDULE - Used to update recurring journal schedule information.

    TERMS      - Used to obtain payment term information.

    TXCODEMAST - Used to validate the tax code and display information.

    TXCOMPANY  - Used to validate the tax company record.

    TXTAXCODE  - Used to validate tax code.

    TXTAXTABLE - Used to obtain tax table information.


Referenced Files

    AMASSET    - Used to validate the asset.

    AMTEMPLATE - Used to validate the asset template.

    APAPPROVAL - Used to validate an approval record for a given company or
                 vendor.

    APCOMMENTS - Deletes comments record when invoice is deleted.

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

    APDISCCODE - Used to validate an Accounts Payable discount code.

    APDISTCODE - Used to validate an Accounts Payable distribution code.

    APDISTHDR  - Used to validate an Accounts Payable distribution code header
                 and default the distributions from the distribution code.

    APDRFTCDES - Used in Accounts Payable common routine.

    APPAYGROUP - Used to validate a paygroup record.

    APPROCLEV  - Used to validate Accounts Payable process level.

    APUDISTCD  - 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.




    APVENCLASS - Used to validate vendor class.

    APVENLOC   - Used to obtain vendor location information.

    APVENMAST  - Used to validate the vendor.

    APWTHCODE  - Used to validate the Accounts Payable income withholding code.

    CBUSER     - Used in Accounts Payable common routine.

    CBUSRCLASS - Used in Accounts Payable common routine.

    CUCONV     - Used to obtain currency conversion information.

    CURELAT    - Used to validate currency relation

    EEADVANCE  - Used in Accounts Payable common routine.

    EEEXPENSE  - Used in Accounts Payable common routine.

    GLADDRESS  - Used to obtain the general ledger address information.

    GLCHART    - Used to validate the system account.

    GLCODES    - Used to validate subledger control.

    GLINTCO    - Used to validate intercompany.

    GLNAMES    - Used to validate the General Ledger account.

    GLSRCCODE  - Used to default source code for General Ledger records.

    GLSYSTEM   - Used to validate General Ledger company.

    GLZONE     - Used to validate zone relationships.

    INSTATPROC - Used to validate Intrastat statistical procedure codes.

    INSTCMDTY  - Used to validate Intrastat commodity codes.

    INSTCTRYCD - Used to verify that the origin and destination countries in a
                 transaction are part of the European community and the
                 transaction is therefore subject to
                 Intrastat reporting.

    INSTNOTC   - Used to validate Intrastat nature of transaction codes.

    INSTPORTS  - Used to validate Intrastat port codes.

    INSTREGN   - Used to validate Intrastat region codes.

    INSTUOM    - Used to validate Intrastat secondary units of measure.

    JBKOPCODE  - Used to edit the journal book operator code to see if the
                 operator is authorized.

    JBKSYSCODE - Used to validate if the system can use the journal book.

    POAOCDTL   - Used to obtain add-on cost information.

    POAPPROVE  - Used to obtain purchase order approval information.

    POCOMMENTS - Used to obtain purchase order comment information.

    POCOMPANY  - Used to validate the Purchase Order company.

    POINVOICE  - Used to validate the purchase order invoice.

    POLINE     - Used to obtain purchase order line information.

    POMESSAGE  - Used to validate and default buyer message information.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used to obtain receiving line information.

    PURCHORDER - Used to obtain purchase order information.

    REQHEADER  - Used to validate, display, and default header information for
                 a requisition.

    TXTAXRATE  - Used to obtain tax rate information.

    TXUSAGECD  - Used to validate tax usage codes.

    WFSETUP    -


INVOKED Programs

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