How can we find the receipts related to a transmission?

Posted by Jiltin     Tags: 24 February, 2009    3,508 views    (1) Comment

Every lockbox loading has a transmission name in oracle applications. How can we find the receipts stuck or related to a transmission if they stored in interface? Note: If you have setup to purge/delete the interface records after successful receipts, you may not get the receipts with this query. SELECT transmission_id FROM                       Ar_transmissions_all                   Read Full Article (Click here)...

Categories : 11i Scripts, Receivables Tags :

What is auto lockbox in oracle applications?

Posted by Jiltin     Tags: , , , , 18 November, 2008    6,451 views    (1) Comment

Lockbox is a service provided by banks by which your company gets the customers payments directly to a lockbox interface tables and creates receipt for the payments deposited into your account. If you have an Auto Lockbox, the bank records the information that you request such as check number, check amount, numbers and amount for the invoices to be paid. Oracle provides you with the tools to: * Oracle interface tables for the data received from the bank * Validate the data to see if it is Read Full Article (Click here)...

Categories : Receivables Tags : , , , ,