1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Invoices keep on hold with quantity billed exceeds quantityor dered/received

Discussion in 'Oracle Financials' started by Vina, Jun 28, 2016.

  1. Vina

    Vina Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    United Kingdom
    Hello everyone


    Could you please advise the invoice (matched with Service PO) on hold case below?
    The invoice keeps on hold even the tolerance is 100% which I don't understand why.


    Invoices keep on hold with the following holds
    Quantity billed exceeds quantity ordered
    Quantity billed exceeds quantity received


    Setup is as follows
    Receiving Tolerance at Receiving Options = 100%
    Invoice tolerance >> Ordered tolerance = 100%, Received tolerance = 100%


    Sample transaction
    PO Qty = 99
    Receipt Qty = 99
    Invoice, Qty matched = 100.92 (total invoice = 110, Tax = 9.08)


    Supplier
    Hold from payment option (at site level) >>
    [ ] All Invoices
    [ / ] Unmatched Invoices
    [ ] Unvalidated Invoices

    Are there any setup that I should look into?

    Regards
     
  2. Rajesh A V N

    Rajesh A V N Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Hyderabad
    Hi,

    If you want don't hold the invoice it is better to don't give the limit rather than 100%.

    Might be received quantity more than 100% of PO quantity. Because of this reason it holds invoice.

    Regards,

    Rajesh A V N
     
  3. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi,

    Check the Line Type mentioned on the Invoice Tolerance-PO Line Type.

    Also as Rajesh mentioned, If you enter no value then Payables will allow infinite variance.