Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DT180


DT180 - Bank Presentation, Cashing Update

**Form Purpose
Run Bank Presentation, Cashing Update (DT180) to create general ledger
distribution records for bill of exchange activity that has occurred since the
last running of DT180. This includes bills of exchange that have been
presented for remittance, cashed at a discount, cashed on their due date, or
dishonored.

**Processing Effect
DT180 automatically cashes bills of exchange that were presented to a bank
for encashed remittance if their due date plus the margin days you define
falls on or before the system date. You can also run DT180 to update only
bills of exchange marked as Cashed in DT80.1 (Bill of Exchange Cashing
Selection).

When DT180 processes a cashed bill of exchange, it changes the status of the
open item(s) paid by the bill of exchange to historical.

The program creates a listing of remittances and bills of exchange that have
been presented, cashed for discount, cashed at due date, and dishonored.




Updated Files

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

    ARCUSTOMER - Update last payment amount and date.

    ARCUSTPER  - Update period paid totals.

    ARDISTRIB  - Creates distributions for general ledger posting.

    ARDRAFTS   - Updates bill of exchange status to cashed and set general
                 ledger update flag.

    AROIHDR    - Used to validate open item header record.

    AROITEMS   - Updates status to fully applied.

    AROPIVOT   -

    ARPAYMENT  -

    ARPYMNTHDR -

    ARSUMMARY  - Updates summary of bill of exchange to cashed.

    ARXIND     -

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

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

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

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

    CBDISTRIB  - Creates records for posting to general ledger.

    CBTRANS    - Primary file updated by program.

    CKPOINT    - Updates file to determine the program restarting point.

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

    DTCASHING  - Updates general ledger update flag.

    DTREMIT    - Updates status of remittance.

    JBOOKHDR   - Used in journal book processing.

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

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates tax code.

    TXTAXTABLE - Validates tax table transaction records.

    TXTAXTRAN  - Creates tax transaction records for distribution taxable
                 distribution lines.


Referenced Files

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    ARAPPLIED  - Referenced to change status of open transactions.

    ARCODE     - Validates accounts receivable code.

    ARCUSTGRP  - Validates customer group relationship.

    ARCUSTTOTS - Validates process level exclusion.

    ARPROCLEVL - Validates process level.

    ARREASON   - Validates adjustment reason code.

    CBADJUST   - Validates to check if adjustment record exists.

    CBBALANCE  - Validates cash code to check for balance.

    CBCCTRNJB  - Used as part of cash ledger validation.

    CBSTATEMNT -

    CBSTMTDTL  -

    CBUSER     - Validation to determine user access to cash code.

    CBUSRCLASS - Validation to determine user access to cash code.

    CUACCT     - Validates currency account.

    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.

    DTCREDIT   -

    DTCUSTBANK - Validates customer bank and bank account number.

    GLADDRESS  - Validates general ledger company address.

    GLCHART    - Validates general ledger company chart information.

    GLCODES    - Validates general ledger codes.

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

    JBKOPCODE  - Used in journal book processing.

    JBKSYSCODE - Used in journal book processing.

    NATACCT    - Validates national account relationship.

    TXTAXRATE  - Validates tax rate.


INVOKED Programs

    API4
    ACAC
    ACCL
    IFCU
    IFSG
    IFAC
    SLSE
    SLSU
    IFSC