18 Jun 2015

Automatic Debit Memo not getting created for Return to Vendor transaction

As per standard functionality after Return to Supplier transaction and completion of Receiving Transaction Processor (RTP) concurrent a Debit Memo should get generated.
If the automatic Debit Memo hasn’t got created after the completion of RTV transaction, check the following.
  1. Flag "Create Debit Memo for RTS transactions" is checked at Vendor Site (Menu: Purchasing, Tab: Self Billing)
 This can also be checked from backend with the following query,
select CREATE_DEBIT_MEMO_FLAG from po_headers_all a1, po_vendor_sites_all b1
where a1.segment1 = '&po_number'
and a1.vendor_site_id = b1.vendor_site_id;
  1. The return is returned to Supplier, not to Receiving.
  2. There is already an original invoice in AP for the PO receipt being returned.
  3. Check to make sure that the invoice is not in the AP invoice interface (it must be a valid invoice at time of Return)
  4. The Supplier Site is both a Pay Site and has a Purchasing Site (you can have alternate pay site) there just has to be some capability for the site to be paid.
  5. The return quantity is not causing the quantity invoiced to go negative, i.e. the return quantity is equal to or less than the quantity invoiced.
  6. The Create Debit Memo check box is also checked on in the Return form at the line being returned.

  1. The debit memo package in AP called "AP_AUTO_DM_CREATION_PKG" is VALID
Use the following query to know the status
select status from dba_objects
where object_name = 'AP_AUTO_DM_CREATION_PKG'
  1. No error messages in the Receiving concurrent request log file of the Return transaction.
  2. Check whether document sequencing is enabled & assigned to debit memos.

---X---

No comments:

Copyright © 2015 an ORACLE APPS blog. All Rights Reserved.