ERPstuff - Oracle EBS Community

Hi Guru's,


Please let me share with u

The issue
we have uploaded the receipts and invoices data from back end

Normally we have so many cheque receipts are there while uploading the data we have conolidated all the receipts and make it to an one receipt,uploaded the data and appiled to invoices

now the issue in those recevied cheques one cheques is bounesed
if we reverse the receipt the whole amount will be reversed now what will be best solution for this

Please advise me on this issue

Which is why we have Debit Memo and Credit Memo functionality provided for adjusting the balances.......

you mean to say create Cr memo or Dr memo apply to upload receipt and create a fresh receipt and apply to invoice


This is the solution

What i have stated is workaround....
That is you have uploaded all individual receipts as a one single lot and uploaded in the tables...
Now for a customer, the cheque he paid is dishonored by bank, in this case what we must be doing is, we need to increase the outstanding balance of the customer with the amount that is dishonoured by bank.
Instead of disturbing the AR transaction and Receipt which is already uploaded, it will be much easier, if you can raise a Debit memo for the customer so that customer balance will be increased and then apply the receipt when ever e pays in future.

by creating debit memon we can apply to an receipt but it updates the customer balance abd what would be effect for

1) Creation of Transaction

Will increase the Customer Balance

2) Receipt from customer for the Transaction or any receipt from customer

Will decrease the customer balance

3) Debit Memo for a Customer

Will increase the customer balance

4) Dishonor of check or unapply of receipt

Will increase the customer balance


In your case you cannot perform the 4th point, which is why workaroung 3 will suit the business need.

Ok Guru


Workaround 3 will be best solution for this issue

Thanks a lot.