July 19, 2010

AR LOCKBOX

AutoLockbox automated tool used to receipts which are sent to bank directly.


It Validates data before transferring then to recievables.
 
Steps Performed by AR Lockbox:


Make required Functional setups for defining Lockbox.

1.Create Transmission format.





  • Give Transmission Name

  • LOCKBOX HEADER,RECIPET,OVERFLOW RECIPET

  • LOCKBOX HEADER with identifier:






SAMPLE CONTROL FILE:

LOAD DATA


APPEND

-- Type R2- Overflow Receipt

INTO TABLE AR_PAYMENTS_INTERFACE_ALL

WHEN RECORD_TYPE = ’R2’

(STATUS CONSTANT ’AR_PLB_NEW_RECORD’,

RECORD_TYPE POSITION(01:02) CHAR,

LOCKBOX_NUMBER POSITION(03:05) CHAR,

INVOICE1 POSITION(06:19) CHAR,

AMOUNT_APPLIED1 POSITION(20:30) CHAR,

OVERFLOW_SEQUENCE POSITION(31:34) CHAR,

OVERFLOW_INDICATOR POSITION(35:35) CHAR,

ITEM_NUMBER POSITION(36:38) CHAR,

CURRENCY_CODE POSITION(39:41) CHAR)

-- Type R1 - Payment

INTO TABLE AR_PAYMENTS_INTERFACE_ALL

WHEN RECORD_TYPE = ’R1’

(STATUS CONSTANT ’AR_PLB_NEW_RECORD’,

RECORD_TYPE POSITION(01:02) CHAR,

LOCKBOX_NUMBER POSITION(03:05) CHAR,

BATCH_NAME POSITION(06:08) CHAR,

TRANSIT_ROUTING_NUMBER POSITION(09:18) CHAR,

ACCOUNT POSITION(19:36) CHAR,

CHECK_NUMBER POSITION(37:46) CHAR,

REMITTANCE_AMOUNT POSITION(47:56) CHAR,

DEPOSIT_DATE POSITION(57:62) DATE ’RRMMDD’,

ITEM_NUMBER POSITION(63:65) CHAR,

CURRENCY_CODE POSITION(66:68) CHAR,

DEPOSIT_TIME POSITION(69:72) CHAR)

-- Type R0 - Lockbox Header

INTO TABLE AR_PAYMENTS_INTERFACE_ALL

WHEN RECORD_TYPE = ’R0’

(STATUS CONSTANT ’AR_PLB_NEW_RECORD’,

RECORD_TYPE POSITION(01:02) CHAR,

LOCKBOX_NUMBER POSITION(03:05) CHAR,

ORIGINATION POSITION(06:14) CHAR)

2.Create a loader file(Flat File) in specified format.

Sample Data File:


R0P14043000096

R1P1400002130937 612955 20002914640005587025990901018USD2003

R2P142424068 0000102900000010018USD


3.Place the control file in AR_Top bin directory.



4.In AR run the interface program lockbox with transmission name,control file,data file with path.

Note: Give the control file name without extension and path.

5.sumbit for validation(to get the receipts transferred to base tables.

5.sumbit the lockbox interface program.

6.the output will have the details of transferred recepits.



Interface tables involved are




WITHOUT vALIDATION



AR_PAYMENTS_INTERFACE_ALL



FOR VALIDATION



AR_INTERIM_CASH_RECEIPTS_ALL and

AR_INTERIM_CASH_RCPT_LINES_ALL



BASE TABLES



AR_CASH_RECEIPTS_ALL

AR_CASH_RECEIPT_HISTORY_ALL

AR_DISTRIBUTIONS_ALL

AR_RECEIVABLE_APPLICATIONS_ALL

AR_PAYMENT_SCHEDULES_ALL

No comments:

Post a Comment