Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DT181


DT181 - Bank Presentation Cashing Update with Remit Control

Run DT181 (Bank Presentation Cashing Update with Remittance Control) to
create general ledger  distribution records for remittance activity that has
occurred since the last  time DT181 was run

You can use this program only if your company uses remittance control.

DT181 automatically processes all the Presented bills of exchange produced by
DT161 or DT70.1 for a specific date and cash code and changes the status of
the obligations applied to those bills of exchange to Historical.

If any bill of exchange has any bank or administrative expense associated
with it, you need to first use DT80.1 (Bill of Exchange Cashing Selection) to
enter the expense information.  With remittance control, you can only enter
summary bank expense information, not information for individual BOEs.

Updated Files

    ADDRDATA   -

    ARCUSTOMER - Updates last payment amount and date.

    ARCUSTPER  - Updates 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    - Updates invoice header information.

    AROITEMS   - Updates status of open items to fully applied.

    AROPIVOT   -

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

    DTCASHING  - Updates general ledger update flag.

    DTREMIT    - Updates status of remittance.

    JBOOKHDR   - Validates the journal books.

    MXLISTHDR  -

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

    TXCODEMAST - Updates the tax code and tax type to be used.

    TXCOMPANY  - Validates the tax company.

    TXTAXCODE  - Validates the tax code.

    TXTAXTABLE - Updates the tax table information applicable to the
                 transaction.

    TXTAXTRAN  - Updates the tax transaction records.


Referenced Files

    APACCRCODE - Validates Accounts payable accrual codes.

    APCOMPANY  - Validates Accounts Payable company.

    APVENGROUP - Validates vendor group information.

    ARAPPLIED  - Referenced to change status of open transactions.

    ARCODE     - Validates accounts receivable code.

    ARCOMP     - Validates AR company.

    ARPROCLEVL - Validates the process level.

    ARREASON   - Validates adjustment reason code.

    CBADJUST   - Checks if adjustment record exists.

    CBBALANCE  - Validates cash code to check for balance.

    CBSTATEMNT -

    CBSTMTDTL  - Validates bank statement detail information.

    CBUSER     - Validates user access to cash code.

    CBUSRCLASS - Validates userclass access to cash code.

    CUACCT     - Validates currency account.

    CUCONV     - Provides currency conversion.

    CURELAT    -

    DTCREDIT   -

    GLADDRESS  - Validates general ledger company address.

    GLCHART    - Validates company chart of account information.

    GLCODES    - Validates General Ledger codes.

    GLSYSTEM   - Validates Genral Ledger company.

    INSTCTRYCD -

    JBKOPCODE  - Validates journal book operator code.

    JBKSYSCODE - Validates journal book system codes.

    NATACCT    - Validates national account relationship.

    TXTAXRATE  - Maintains tax rates for tax codes used.


INVOKED Programs

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