auto lock box in ar 11i

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
harikumarc1981@rediffmail
Posts: 110
Joined: Mon Oct 27, 2008 9:50 am
Location: India

auto lock box in ar 11i

Post by harikumarc1981@rediffmail »

hi in AR 11i using autolockbox we can create receipt in ar. the receipts are directly created in receipts window or any report we have to run to transter the receipts from interface table to receipts window. if yes which report we have to run

thanks
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

You need to use 'Submit Lockbox Processing' screen to import, validate date and create receipts.

Transaction steps are given below.

1. Receive file (from bank/from other resources) in the required format.
2. Move the file to oracle server
3. Submit Import (Use Submit Lockbox Processing (SLP) Screen)
Data is transferred to AR_Payments_interface_all table
4. Submit validation (using same SLP window)
Data is transferred to AR_Interim_Cash_Receipts_all
and AR_interim_cash_rcpt_lines_all
5. Submit Post Quick Cash (Using SLP window)
Data is transferred to
AR_Payments_Interface_all
AR_Cash_Receipt_History_All
AR_Distributions_All
AR_Receivable_Applications_All
AR_payment_Schedules_All

When you submit Post Quick Cash, receipts will be created and invoices are applied (if applicable) against the receipt.


Cheers,
Saravanan
harikumarc1981@rediffmail
Posts: 110
Joined: Mon Oct 27, 2008 9:50 am
Location: India

Post by harikumarc1981@rediffmail »

[quote]You need to use 'Submit Lockbox Processing' screen to import, validate date and create receipts.

Transaction steps are given below.

1. Receive file (from bank/from other resources) in the required format.
2. Move the file to oracle server
3. Submit Import (Use Submit Lockbox Processing (SLP) Screen)
Data is transferred to AR_Payments_interface_all table
4. Submit validation (using same SLP window)
Data is transferred to AR_Interim_Cash_Receipts_all
and AR_interim_cash_rcpt_lines_all
5. Submit Post Quick Cash (Using SLP window)
Data is transferred to
AR_Payments_Interface_all
AR_Cash_Receipt_History_All
AR_Distributions_All
AR_Receivable_Applications_All
AR_payment_Schedules_All

When you submit Post Quick Cash, receipts will be created and invoices are applied (if applicable) against the receipt.


Cheers,
Saravanan


<i><div align="right">Originally posted by tgs100
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

we will get the control file from the banker and we will transfer to oracle server. is it possible to create a new control file in oracle receivables. if yes how? if we want to transfer the bank control file to oracle server how it will be. if you have any screen shots regarding this can you send it.
Bank will not give you control file, they will only send you data file. The data file should be transferred to oracle server. Contact the technical people to write scripts to move the file to server.
here we have to give transimission name. once i click there it is showing no values in the list.
If you are importing a new bank file, check the New Transmission check box, then enter a new transmission Name (of your choice). If you are resubmitting an existing lockbox transmission, you can select a name from the list of values

Cheers,
Saravanan
harikumarc1981@rediffmail
Posts: 110
Joined: Mon Oct 27, 2008 9:50 am
Location: India

Post by harikumarc1981@rediffmail »

we will get the control file from the banker and we will transfer to oracle server. is it possible to create a new control file in oracle receivables. if yes how? if we want to transfer the bank control file to oracle server how it will be. if you have any screen shots regarding this can you send it.
Bank will not give you control file, they will only send you data file. The data file should be transferred to oracle server. Contact the technical people to write scripts to move the file to server.
here we have to give transimission name. once i click there it is showing no values in the list.
If you are importing a new bank file, check the New Transmission check box, then enter a new transmission Name (of your choice). If you are resubmitting an existing lockbox transmission, you can select a name from the list of values

Cheers,
Saravanan




<i><div align="right">Originally posted by tgs100
harikumarc1981@rediffmail
Posts: 110
Joined: Mon Oct 27, 2008 9:50 am
Location: India

Post by harikumarc1981@rediffmail »

we will get the control file from the banker and we will transfer to oracle server. is it possible to create a new control file in oracle receivables. if yes how? if we want to transfer the bank control file to oracle server how it will be. if you have any screen shots regarding this can you send it.
Bank will not give you control file, they will only send you data file. The data file should be transferred to oracle server. Contact the technical people to write scripts to move the file to server.
here we have to give transimission name. once i click there it is showing no values in the list.
If you are importing a new bank file, check the New Transmission check box, then enter a new transmission Name (of your choice). If you are resubmitting an existing lockbox transmission, you can select a name from the list of values

Cheers,
Saravanan




<i><div align="right">Originally posted by tgs100
harikumarc1981@rediffmail
Posts: 110
Joined: Mon Oct 27, 2008 9:50 am
Location: India

Post by harikumarc1981@rediffmail »

we will get the control file from the banker and we will transfer to oracle server. is it possible to create a new control file in oracle receivables. if yes how? if we want to transfer the bank control file to oracle server how it will be. if you have any screen shots regarding this can you send it.
Bank will not give you control file, they will only send you data file. The data file should be transferred to oracle server. Contact the technical people to write scripts to move the file to server.
here we have to give transimission name. once i click there it is showing no values in the list.
If you are importing a new bank file, check the New Transmission check box, then enter a new transmission Name (of your choice). If you are resubmitting an existing lockbox transmission, you can select a name from the list of values

Cheers,
Saravanan




<i><div align="right">Originally posted by tgs100
Post Reply

Who is online

Users browsing this forum: Google Adsense [Bot] and 4 guests