| Autolockbox Validation [message #236972] |
Fri, 11 May 2007 08:19  |
kuda.oracleapps@gmail.com
Messages: 10
Registered: May 2007
|
Junior Member |
|
|
Could someone please tell me how to validate that a customer already exist in the system. I am importing receipts via Autolockbox and have created a staging table ar_payments_iface that resembles ar_payments_interface_all. I would also like to know the sql statement that would validate the receipt number for me. I would appreciate any help as I have to have this completed by next Monday, so it is rather urgent. Thanks
So far this is the code I have.
--cursor to select the records to be validated
CURSOR cur_rcpt IS
SELECT a.* FROM ar_payments_iface a
WHERE nvl(a.process_flag,'E') = 'E';
-- Cursor to check the active customer already exists
CURSOR get_cust(p_cust_ref IN ra_customers.customer_number%TYPE) IS
SELECT hca.cust_account_id
FROM hz_cust_accounts hca
WHERE hca.orig_system_reference = p_cust_ref
AND hca.status = 'A';
|
|
|
|
| Re: Autolockbox Validation [message #237879 is a reply to message #236972] |
Wed, 16 May 2007 01:20  |
vin_odks
Messages: 153
Registered: July 2006
Location: -
|
Senior Member |
|
|
Hi,
There are many other validation to be performed for auto lock box
1) Validate operating unit (org_id)
2) Validate Exchange rate (Functional and entered currency)
3) valdiate Cross currency (Invoice currency is different from Receipt currency)
4) Validate sum of remittance amount does not exceed the applied amounts
5) Validate customer reference with BILL_TO usage
6) Validate customer account number
7) Validate if invoice number is valid
 As far as the receipt number is concerned , they are usually the check number provided ..
9) Generate Item number ,overflow indicator,Overflow sequence
10) Much more depends on your Lock box transmission formats.
Regards
Vinod
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
