Showing posts with label Account Receivables. Show all posts
Showing posts with label Account Receivables. Show all posts

Wednesday, 8 July 2015

AR Receipt application - table changes

When a cash receipt is created , sooner or later the Cash receipt will be applied to an open AR transaction in the system.

In this post we will discuss the entries in the table  and how are the records affected during this process.

1. Receipt Creation : When cash receipt is created entry will be made in the system in the tables
   AR_CASH_RECEIPTS_ALL --> storing details of the Cash receipt
   AR_CASH_RECEIPT_HISTORY_AL --> Detail of the changes made to the receipt which need                tracking Eg : Creation , reversal etc
   AR_RECEIVABLE_APPLICATIONS_ALL --> Detail of the RECEIPT creation record with STATUS = UNAPP , Amount_applied as the Receipt amount

2. Receipt Application : When the Cashe Receipt is applied to an AR transaction the open amount of         the Receipt and the Ar invoice will decrease. Entry is made into the table AR_RECEIVABLE_APPLICATIONS_ALL with 2 records .one with Status = UNAPP and a negative amount of the amount applied debiting the acutal account affected when the receipt was created , since the Open balance in the account decreases.
Another entry is made with status = APP , Amount_applied is the actual amount applied to the receipt and the column applied_customer_trx_id , applied_payment_schedule_id all get populated with the details of the AR Invoice which has been impacted.  In the relevant columns the split of LINE and TAX amount is also visible.


Eg : Receipt crearted for amount : 100

entry is made in table AR_RECEIVABLE_APPLICATIONS_ALL with amount : 100 , STAUS = UNAPP
60 is applied to a transaction

2 entries are made in the table : AR_RECEIVABLE_APPLICATIONS_ALL

1. Amount : -60 , status = UNAPP debiting the actual account
2. Amount : 60 , status = APP , Crediting the receivale Account and also storing the details of the affected invoice in the columns applied_customer_trx_id , applied_payment_schedule_id.

Depending on the Receipt method used and the Receipt method Setup  , If the receipt is fully applied the status will be remitted or cleared

If Receipt is using a receipt method with Setup : By Matching and receipt is fully applied the status will be remitted . Once the receipt is matched with Bank statement the status will be cleared.

Tuesday, 8 July 2014

Auto application of Credit Note to Invoice Using AutoInvoice

When Creating a Credit note by Auto Invoice import Oracle provides the option of auto application of a Credit Note to an invoice i.e. When you are creating a credit note as soon as a credit note is created it will be immediately applied to an AR invoice.
This functionality can be used by by populating the reference_line_attribute columns of ra_interface_lines_all tables By populating the reference line_id or the combination of reference line_context and reference line attributes which correspond to a given AR invoice line you can apply the CM line being created to an existing Invoice.
Ensure that the CM line which you want to apply has an amount less than or equal to the invoice line open amount else you will get an error by Auto Invoice if over application is not enabled.
This is an efficient way of Creating credit notes and also applying them to Open invoices/Debit notes in the system if the information of application is available beforehand

Thursday, 22 August 2013

Auto Invoice Error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of

When importing invoice from ra_interface_lines_All table the user can be faced with an error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of.
This error message is generally reported because of either of the below reason:

  1. The Unit of Measure specified for the item in ra_interface_lines_all is different from what is specified in the item setup
  2. The item is not assigned to the warehouse for which the invoice line is being tried to be imported