ERPstuff - Oracle EBS Community

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

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

[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

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

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

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

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