The Invoice does not go on Hold with “Quantity billed exceeds quantity received” when Matched to a Purchase Order


Reason could be : No Goods Tolerance has been setup in the supplier site.

When a PO is created for 3 or 4 way match there are no holds placed on the invoice when the items have not been received.

— Steps To Reproduce:
1) Create PO 3 or 4 way match
2) Quick match PO to invoice
3) Validate the PO
4) No holds are placed on the Invoice
5) Expected hold is ‘QTY REC’, “Quantity billed exceeds quantity received”

Invoices are being paid when items have not been received.

Follow the steps below.

1) Setup a Goods Tolerance: 
    a) Accounts Payable – Setup > Invoices > Tolerances

2) To default the Goods Tolerance to suppliers:
    a) Accounts Payable – Setup > Options > Payables – Supplier tab
    b) Select the Goods Tolerance from step 1 
    c) This will now default to new suppliers created

3) For existing suppliers:
    a) Accounts Payable – Supplier > Query
    b) Go to the Supplier Site
    c) Go to the Controls tab
    b) Select the Goods Tolerance setup in step 1

To determine which supplier sites do not have a Goods Tolerance run the following select:
select vendor_name, vendor_site_code, s.creation_date date_site_created, s.created_by site_created_by, tolerance_id, vendor_type_lookup_code
from po_vendor_sites_all s, po_vendors v
where v.vendor_id = s.vendor_id
and tolerance_id is null
and nvl(inactive_date,sysdate + 1) > sysdate
and nvl(end_date_active,sysdate + 1) > sysdate
and pay_site_flag = ‘Y’
and purchasing_site_flag = ‘Y’
order by 1;

Advertisements

2 thoughts on “The Invoice does not go on Hold with “Quantity billed exceeds quantity received” when Matched to a Purchase Order

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s