Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DT70


DT70.1 - Remittance Presentation

Use DT70.1 (Remittance Presentation) to modify a bill of exchange remittance.
You can:

1. Remove a bill of exchange from a bank remittance created in DT165
(Generation of Bank Remittance). To remove a bill of exchange, choose the BOE
button next to the remittance you want to modify. In the Remittance BOE
Maintenance subform, select the "U" (Unselect) line function code next to the
bill of exchange you want to remove from the remittance. The program changes
the status of the bill of exchange to Accepted. If the bill of exchange was
presented for discount, the program removes the bill of exchange amount from
the bank credit risk total. If the bill of exchange has been processed by
DT180 (Bank Presentation, Cashing Update), the program creates reversing
general ledger entries. If you remove all bills of exchange from a remittance,
the program changes the status of the remittance to Canceled.

2. Mark a remittance as presented to the bank. Select the "P" line function
code next to the remittance you are presenting to the bank. The program
changes the status of each bill of exchange to Presented to Bank.

3. Mark a discounted remittance as cashed and enter bank charges. Select the
"C" line function code next to the remittance that has been cashed. The
program changes the status of each bill of exchange to Cashed and updates
customer balances. To enter bank charges for the remittance, choose the
Expenses button to access the Bank Expenses subform.

4. Cancel an uncashed remittance. Select the "C" (Cancel) line function code
next to the uncashed remittance you want to cancel. The program change the
status of each bill of exchange to Selected for Remittance. If the bills of
exchange have been processed by DT180 (Bank Presentation, Cashing Update), the
program creates reversing general ledger entries.

5. Reverse, or "undo," a presented remittance or, if you have not run DT180
(Bank Presentation, Cashing Update) a cashed remittance. The program reverses
your last remittance status change. If you reverse a presented remittance that
has been processed by DT180, the program also creates reversing general ledger
entries. Select the "U" line function code next to the remittance you want to
reverse. The program returns a cashed remittance to a Presented status (bills
of exchange changed to a Presented to Bank status) and a presented remittance
to a Generated status (bills of exchange changed to a Included in Remittance
status).

Updated Files

    ADDRDATA   -

    ARCOMP     - Updates remit number in API called by program. Not used in
                 DT70.1.

    ARCUSTOMER - Updates current balance and bill of exchange balance in API
                 called by program. Not used in DT70.1.

    ARCUSTPER  - Updates period paid totals in API called by program. Not used
                 in DT70.1.

    ARDISTRIB  - Creates records for reversing entries if transaction is posted
                 to general ledger.

    ARDRAFTS   - Updates present date, cashed date, and status of bill of
                 exchange upon presenting and cashing.

    ARPAYMENT  -

    ARPYMNTHDR -

    ARSUMMARY  - Updated with bill of exchange amount upon cashing.

    CBBANKENT  - Updates used flag of bank in API called by program. Not used
                 in DT70.1.

    CBBANKINST - Updates used flag of payment code in API called by program.
                 Not used in DT70.1.

    CBCASHCODE - Updates used flag of cash code in API called by program. Not
                 used in DT70.1.

    CBCPYCASH  - Updates used flag at company-cash code level in API called by
                 program. Not used in DT70.1.

    CBCREDRISK -

    CUSTDESC   - Updated in API called by program. Not used in DT70.1.

    DTREMIT    - Updates present date and status.

    JBOOKHDR   -

    MXLISTHDR  -

    NATBALANCE - Updates national account balance in API called by program. Not
                 used in DT70.1.


Referenced Files

    ARCODE     - Validates accounts receivable code.

    ARCUSTGRP  - Validates customer group relationship.

    ARCUSTTOTS - Validates process level exclusion.

    ARPROCLEVL - Validates process level.

    CBUSER     - Validation to determine user access to cash code.

    CBUSRCLASS - Validation to determine user access to cash code.

    CUCONV     - Validation to determine currency exchange rate if transaction
                 currency is not same as company base currency.

    CURELAT    - Validation to determine if currency relationship exists.

    DTCUSTBANK - Validates customer bank and account number.

    GLADDRESS  - Validates general ledger company address.

    GLCHART    - Validates chart name of general ledger company.

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

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    NATACCT    - Validates national account relationship.


DT70.3 - Remittance Bill of Exchange Maintenance

Use the Remittance BOE Maintenance subform to remove individual bills of
exchange from a Generated status remittance.

Updated Files

    ADDRDATA   -

    ARCOMP     - Updates remit number in API called by program. Not used in
                 DT70.3.

    ARCUSTOMER - Updates current balance and bill of exchange balance in API
                 called by program. Not used in DT70.3.

    ARCUSTPER  - Updates period paid totals in API called by program. Not used
                 in DT70.3.

    ARDISTRIB  - Creates records for reversing entries if transaction is posted
                 to general ledger.

    ARDRAFTS   - Updates bill of exchange status to accepted.

    ARPAYMENT  -

    ARPYMNTHDR -

    CBBANKENT  - Updates used flag of bank in API called by program. Not used
                 in DT70.3.

    CBBANKINST - Updates used flag of payment code in API called by program.
                 Not used in DT70.3.

    CBCASHCODE - Updates used flag on cash code in API called by program. Not
                 used in DT70.3.

    CBCPYCASH  - Updates used flag at company cash code level in API called by
                 program. Not used in DT70.3.

    CBCREDRISK - Updates the risk amount by bill of exchange amount if
                 discounted bill of exchange is unselected.

    CUSTDESC   - Updates customer description file in API called by program.
                 Not used in DT70.3.

    DTREMIT    - Updates remit amount and status if bill of exchange is
                 unselected from remittance.

    JBOOKHDR   -

    MXLISTHDR  -

    NATBALANCE - Updates national account balance in API called by program. Not
                 used in DT70.3.


Referenced Files

    ARCODE     - Validation of accounts receivable code.

    ARCUSTGRP  - Validates customer group relationship.

    ARCUSTTOTS - Validates for process level exclusion.

    ARPROCLEVL - Validates process level.

    CBUSER     - Validation to determine user access to cash code.

    CBUSRCLASS - Validation to determine user access to cash code.

    CUCONV     - Validation to determine currency exchange rate if transaction
                 currency is not same as company base currency.

    CURELAT    - Validation to check if currency relationship exists.

    DTCUSTBANK - Validates customer's bank and account number.

    GLADDRESS  - Validates general ledger company address.

    GLCHART    - Validates general ledger company chart information.

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

    INSTCTRYCD -

    JBKOPCODE  -

    JBKSYSCODE -

    NATACCT    - Validates national account relationship.


INVOKED Programs

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