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
auto lock box in ar 11i
-
harikumarc1981@rediffmail
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
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
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
[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
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
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.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.
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 valueshere we have to give transimission name. once i click there it is showing no values in the list.
Cheers,
Saravanan
-
harikumarc1981@rediffmail
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
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 valuesBank 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.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.
here we have to give transimission name. once i click there it is showing no values in the list.
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
-
harikumarc1981@rediffmail
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
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 valuesBank 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.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.
here we have to give transimission name. once i click there it is showing no values in the list.
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
-
harikumarc1981@rediffmail
- Posts: 110
- Joined: Mon Oct 27, 2008 9:50 am
- Location: India
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 valuesBank 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.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.
here we have to give transimission name. once i click there it is showing no values in the list.
Cheers,
Saravanan
<i><div align="right">Originally posted by tgs100
Who is online
Users browsing this forum: Ahrefs [Bot] and 4 guests