Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DT60


DT60.1 - Remittance Selection by Due Date

After you run DT160 (Remittance Selection) to select bills of exchange for
remittance, use DT60.1 (Remittance Selection By Due Date) or DT60.2
(Remittance Selection By BOE Nbr) to adjust the group of bills of exchange
selected. You can remove, or "unselect," a bill of exchange from the
remittance or assign an available bill of exchange to the remittance. When you
unselect a bill of exchange, the system changes status of the bill of exchange
from Select for Remit to Accepted. When you assign an eligible bill of
exchange, the system changes the status from Accepted to Select for Remit.

You can define selection criteria to limit the bills of exchange that display
by choosing the Filter button to access the Selection Criteria subform.

Updated Files

    ADDRDATA   -

    ARCOMP     - Used to validate the accounts receivable company. The file is
                 updated in an API called by DT60.1.

    ARCUSTOMER - Used to validate the accounts receivable customer. The file is
                 updated in an API called by DT60.1.

    ARCUSTPER  - Updates file in a API called by DT60.1.

    ARDISTRIB  - Updates file in an API called by DT60.2.

    ARDRAFTS   - Record will by updated for status, remit-company, remit
                 process level, cash code, and remit type. If the bill of
                 exchange is being selected these fields will be filled in. Upon
                 being unselected, the fields will be cleared. Status will be 2
                 for selection and 1 for unselection.

    ARPAYMENT  -

    ARPYMNTHDR -

    CBBANKENT  - Used to validate bank and update used flag.

    CBBANKINST - Used to validate the bill of exchange payment code and update
                 used flag.

    CBCASHCODE - Used to validate the cash code and update used flag.

    CBCPYCASH  - Used to validate the relationship between company and cash
                 code.

    CBCREDRISK - Used to validate the credit line on a discounted remittance.
                 The credit limit will be checked before adding a bill of
                 exchange to a discounted remittance. If the actual amount plus
                 the bill of exchange amount is greater than the credit limit,
                 an error message displays. The actual amount will be updated
                 with bill of exchange amount upon adding the bill of exchange
                 to the remittance.

    CUSTDESC   - Used to validate the accounts receivable customer. The file is
                 updated in an API called by DT60.1.

    DTREMIT    - Used to validate the remittance record. When a bill of
                 exchange is added to the remittance, the remit amount is
                 increased by the bill of exchange amount.

    MXLISTHDR  -

    NATBALANCE - Updated in an API called by DT60.1.


Referenced Files

    ARCODE     - Used to validate the accounts receivable code.

    ARCUSTGRP  - Used to validate the accounts receivable customer group.

    ARCUSTTOTS - Used to check for process level exclusion.

    ARPROCLEVL - Used to validate the accounts receivable process level.

    CBUSER     - Used to determine user access to cash code.

    CBUSRCLASS - Used to determine user access to cash code.

    CUCONV     - Used to determine if exchange rate exists between currencies.

    CURELAT    - Used to determine if relationship exists between currencies.

    DTCUSTBANK - Used to validate the customer bank.

    GLADDRESS  - Used to validate general ledger company address.

    GLCHART    - Validates general ledger company chart information.

    GLSYSTEM   - Used to determine if general ledger company has been set up.

    INSTCTRYCD -

    NATACCT    - Used to validate national account relationships.


DT60.2 - Remittance Selection by BOE Number

After you run DT160 (Remittance Selection) to select bills of exchange for
remittance, use DT60.1 (Remittance Selection (By Due Date)) or DT60.2
(Remittance Selection (By BOE Nbr)) to adjust the group of bills of exchange
selected. You can remove, or "unselect," a bill of exchange from the
remittance or assign an available bill of exchange to the remittance. When you
unselect a bill of exchange, the system changes status of the bill of exchange
from Select for Remit to Accepted. When you assign an eligible bill of
exchange, the system changes the status from Accepted to Select for Remit.

You can define selection criteria to limit the bills of exchange that display
by choosing the Filter button to access the Selection Criteria subform.

Updated Files

    ADDRDATA   -

    ARCOMP     - Used to validate the accounts receivable company. The file is
                 updated in an API called by DT60.2.

    ARCUSTOMER - Used to validate the accounts receivable customer. The file is
                 updated in an API called by DT60.2.

    ARCUSTPER  - Updated in a API called by DT60.2.

    ARDISTRIB  - Updated in an API called by DT60.2.

    ARDRAFTS   - The record will by updated for status, remit-company, remit
                 process level, cash code, and remit type. If the bill of
                 exchange is being selected these fields will be filled in. Upon
                 being unselected the fields will be cleared. Status will be 2
                 for selection and 1 for unselection.

    ARPAYMENT  -

    ARPYMNTHDR -

    CBBANKENT  - Used to validate the bank and update used flag.

    CBBANKINST - Used to validate the bill of exchange payment code and update
                 used flag.

    CBCASHCODE - Used to validate the cash code and update used flag.

    CBCPYCASH  - Used to validate the relationship between company and cash
                 code.

    CBCREDRISK - Used to validate the credit line on a discounted remittance.
                 The credit limit will be checked before adding a bill of
                 exchange to a discounted remittance. If the actual amount plus
                 the bill of exchange amount is greater than the credit limit,
                 an error message displays. The actual amount will be updated
                 with bill of exchange amount upon adding the bill of exchange
                 to the remittance.

    CUSTDESC   - Used to validate the AR customer.  The file is updated in an
                 API called by
                 DT60.2.

    DTREMIT    - Used to validate the remittance record. When a bill of
                 exchange is added to the remittance the remit amount is
                 increased by the bill of exchange amount.

    MXLISTHDR  -

    NATBALANCE - Updated in an API called by DT60.2.


Referenced Files

    ARCODE     - Used to validate the accounts receivable code.

    ARCUSTGRP  - Used to validate the accounts receivable customer group.

    ARCUSTTOTS - Used to check for process level exclusion.

    ARPROCLEVL - Used to validate the accounts receivable process level.

    CBUSER     - Used to determine user access to cash code.

    CBUSRCLASS - Used to determine user access to cash code.

    CUCONV     - Used to determine if exchange rate exists between currencies.

    CURELAT    - Used to determine if relationship exists between currencies.

    DTCUSTBANK - Used to validate the customer bank.

    GLADDRESS  - Used to validate general ledger company address.

    GLCHART    - Validates general ledger company chart information.

    GLSYSTEM   - Used to determine if general ledger company has been set up.

    INSTCTRYCD -

    NATACCT    - Used to validate national account relationships.


INVOKED Programs

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