Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DT80


DT80.1 - Bill of Exchange Cashing Selection

Use DT80.1 (Bill of Exchange Cashing Selection) to cash individual encashed
bills of exchange that have reached their due date or have been cleared by the
bank. This program displays all encashed bills of exchange that were submitted
for the cash code in DT165 (Generation of Bank Remittance).

You can define selection criteria to limit the bills of exchange that display
by choosing the Filter button to access the Bill of Exchange Cashing
Selections subform.

To enter bank charges for a cash code, choose the Bank Expense button to
access the Bank Expenses subform. To enter bank charges for a specific bill of
exchange, choose the Expense button to access the Cashing Distribution More
subform.

Before you run DT180 (Bank Presentation, Cashing Update), you can reverse, or
"uncash," a cashed bill of exchange by selecting the Undo line function code
next to the bill of exchange you want to uncash. This action returns the bill
of exchange to a Presented for Remittance status.

Updated Files

    ADDRDATA   -

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

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

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

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

    ARDRAFTS   - Updates cashing expenses, cashed date, and status to cashed.

    ARPAYMENT  -

    ARPYMNTHDR -

    ARSUMMARY  - Updates file with bill of exchange amount upon cashing.

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

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

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

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

    CUSTDESC   - Updates file in API called by program. Not used in DT80.1.

    DTREMIT    - Updates the cashed amount and status to cashed.

    MXLISTHDR  -

    NATBALANCE - Updates bill of exchange balance at national account level.


Referenced Files

    ARCODE     - Validates accounts receivable code.

    ARCUSTGRP  - Validates customer group relationship.

    ARCUSTTOTS - Validation to check 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    - Validates currency relationship.

    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 -

    NATACCT    - Validates national account relationship.


DT80.2 - Bill of Exchange Cashing Selections

Use the Bill of Exchange Cashing Selections subform to define criteria used
to select bills of exchange for display.

Updated Files

    CBBANKINST - Updates used flag of payment code. Not used in DT80.2.


Referenced Files

    ARCOMP     - Validates company.


DT80.4 - Bank Expenses

Use the Bank Expenses subform to enter bank charges associated with
processing bills of exchange at a summary level.

Updated Files

    CBBANKINST - Updates used flag of payment code.

    CBCASHCODE - Updates used flag of cash code.

    CBCPYCASH  - Update used flag of company cash code.

    DTCASHING  - Primary file created by program.


Referenced Files

    ARCOMP     - Validates accounts receivable company.

    CBUSER     - Validation to determine user access to cash code.

    CBUSRCLASS - Validation to determine user access to cash code.

    CUCONV     - Validates currency exchange rate if exists.

    CURELAT    - Validates currency relationship.

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


INVOKED Programs

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