Auto Lock Box
-
- Posts: 2
- Joined: Fri Oct 12, 2007 1:19 am
- Location: India
Auto Lock Box
what is lockbox in AR any one help me how to define
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi
Lockbox functionality is basically the customer goes and deposit the moeny directly into your Bank account for the due invoices and the Banker provides a data file to you. You need to have Lock box set up to create a Transmission Format which matches the datafile format in your Instance.
When you run the Lockbox Concurrent process the system checks the datafile and matches the Transmission Format then if it matches it creates receipt in Receivables Module and then applies to Invoices also based on the set up you have made for lockbox
If there is no matching invoice then the system places the amount as unapplied receipt or on account receipt according to your setup.
Hope this helps
Regards
Sivakumar
Lockbox functionality is basically the customer goes and deposit the moeny directly into your Bank account for the due invoices and the Banker provides a data file to you. You need to have Lock box set up to create a Transmission Format which matches the datafile format in your Instance.
When you run the Lockbox Concurrent process the system checks the datafile and matches the Transmission Format then if it matches it creates receipt in Receivables Module and then applies to Invoices also based on the set up you have made for lockbox
If there is no matching invoice then the system places the amount as unapplied receipt or on account receipt according to your setup.
Hope this helps
Regards
Sivakumar
-
- Posts: 2
- Joined: Fri Oct 12, 2007 1:19 am
- Location: India
-
- Posts: 31
- Joined: Sat Mar 17, 2007 1:16 am
- Location: India
Auto Lock Box
AutoLockbox automatically creates receipts in Receivables using electronic information that your
bank provides. Receivables let you specify the payment method for each Lockbox you define. Payment methods provide the default accounting information for receipts you create through AutoLockbox.
Examples for Lock Box :
We will be paying our Mobile Bills by dropping a cheque in a Drop Box specific to the operators like Airtel, Idea and Hutch. The banker collects all the Cheques and realizes the Cheques amounts on behalf of the operators. While dropping the cheque the customer at the back side of the Cheque will write his/her mobile number and operator. By this information (like Mobile Number, Customer Name etc.,) all the realized amounts will be send to the Operator through a Flat file or excel file.
Using this Excel or Flat file the mobile operator, using Auto lock-box facility will be taken as Receipts from the customer. This is a regular and routine process.
Other Examples are E-Seva (in Andhra Pradesh), third party collection agents.
Request the team to correct me if I am wrong.
AutoLockbox automatically creates receipts in Receivables using electronic information that your
bank provides. Receivables let you specify the payment method for each Lockbox you define. Payment methods provide the default accounting information for receipts you create through AutoLockbox.
Examples for Lock Box :
We will be paying our Mobile Bills by dropping a cheque in a Drop Box specific to the operators like Airtel, Idea and Hutch. The banker collects all the Cheques and realizes the Cheques amounts on behalf of the operators. While dropping the cheque the customer at the back side of the Cheque will write his/her mobile number and operator. By this information (like Mobile Number, Customer Name etc.,) all the realized amounts will be send to the Operator through a Flat file or excel file.
Using this Excel or Flat file the mobile operator, using Auto lock-box facility will be taken as Receipts from the customer. This is a regular and routine process.
Other Examples are E-Seva (in Andhra Pradesh), third party collection agents.
Request the team to correct me if I am wrong.
-
- Posts: 31
- Joined: Sat Mar 17, 2007 1:16 am
- Location: India
-
- Posts: 150
- Joined: Wed May 30, 2007 6:05 am
- Location: India
-
- Posts: 8
- Joined: Tue Jun 19, 2007 1:05 pm
- Location: India
Hi,
Auto Lockbox is a feature that banks offers customer to outsource their receivable payment processing, thus eliminating the manual data entry by processing automatic receipts which is sent directly to bank.
Following are the Steps:
Import: During this step it reads & formats the data from bank file into interface table AR_PAYMENTS_ALL using SQL loader.
Validation: Here it checks the validation and if validated it will transfer to Quick cash tables AR_INTERIM_CASH_RECEIPTS_ALL & AR_INTERIM_CASH_RCPT_LINES_ALL.
Post Quick: Here it will updates customer balance.
Bank File (Submit Import) --> AR_PAYMENTS_INTERFACE_ALL (Submit Validation)
--> AR_INTERIM_CASH_RECEIPTS_ALL,
AR_INTERIM_CASH_RCPT_LINES_ALL (Submit Post Quickcash)
--> AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPS_ALL,
AR_CASH_RECEIPT_HISTORY_ALL, AR_DISTRIBUTIONS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_PAYMENT_SCHEDULES_ALL
Regards
Auto Lockbox is a feature that banks offers customer to outsource their receivable payment processing, thus eliminating the manual data entry by processing automatic receipts which is sent directly to bank.
Following are the Steps:
Import: During this step it reads & formats the data from bank file into interface table AR_PAYMENTS_ALL using SQL loader.
Validation: Here it checks the validation and if validated it will transfer to Quick cash tables AR_INTERIM_CASH_RECEIPTS_ALL & AR_INTERIM_CASH_RCPT_LINES_ALL.
Post Quick: Here it will updates customer balance.
Bank File (Submit Import) --> AR_PAYMENTS_INTERFACE_ALL (Submit Validation)
--> AR_INTERIM_CASH_RECEIPTS_ALL,
AR_INTERIM_CASH_RCPT_LINES_ALL (Submit Post Quickcash)
--> AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPS_ALL,
AR_CASH_RECEIPT_HISTORY_ALL, AR_DISTRIBUTIONS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_PAYMENT_SCHEDULES_ALL
Regards
-
- Posts: 7
- Joined: Mon Oct 13, 2008 2:50 am
- Location: India
-
- Posts: 38
- Joined: Fri May 18, 2007 12:58 am
- Location: India
Hello,
Can anyone send me the documnet for implementing Auto lock box.
Email Address: elakkia1980in@yahoo.co.in
Can anyone send me the documnet for implementing Auto lock box.
Email Address: elakkia1980in@yahoo.co.in
Who is online
Users browsing this forum: No registered users and 9 guests