on 06-05-2014 8:13 AM
Hi All,
The user wants to know why for a particular line item in invoice, there is price varinace "X"(Blocked) because of which the invoice is showing Payment Block "R"(Delta Price Block). I have checked and found that for the two materials in PO, there is a price differece in GR and Invoice as follows.
Header 1 | Value at the time of GR | Invoice Value | Price Variance Block |
---|---|---|---|
Material 1 | 0.40 EUR | 1621.58 EUR | X |
Material 2 | 0.13 EUR | 590.23 EUR |
Here, I have checked that the net price in PO has been changed after posting the GR. That is why the value is very less in GR.
I have checked the Tolerance limit in OMR6.The Upper Limit it is set for Value as 30.00 and for Percentage as10%(for Price variance).
If this was the case, the blocking should happen for both the materials, right? Here, the price variance block was only for Material 1.
Please suggest.
Thanks,
Rosh
Hi,
The R block will occur only when there is a between Value and QTY ,
if you have increase the Access of IR which is less than the PO value then also R will be occur
what you have to do easy is reverse the IR which is access the amount and amend the PO for the correct value
hope this will help you
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check may be the price variance for Material 2 doesn't cross the percentage of tolerance..
Calculate the PO quantity with net price at the time of IR and GR for both material's line item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dev,
The PO net value and Invoice Value is same.
Material 1
PO Qty - 4800 CT
Net Price - 337.83 EUR per 1000 CT
PO Total value - 1621.58 EUR
Material 2
PO Qty - 1560 CT
Net Price - 378.35 per 1000 CT
PO Total Value - 590.23 EUR
The price variance is to be checked with the GR Value right? ie, if the invoice value exceeds 10% more than the GR value, then it does not come under tolerance limit, right? Please correct me if I am wrong.
If that is the case, then the block should be there for both the materials.
Thanks,
Rosh
Yes. You are right.
By the way what is the tolerance limit you are using in OMR6 ?
You have given the current PO price which you will consider for MIRO,
Now compare this to your GR price.
You will get the GR price in your Purchase Order History tab
Here I have the PO price is 60. But here my GR price is 100/5 = 20.
Hi Dev,
Thanks for your reply.
IN PO History, it is as follows
Material 1
Amount in LC - 0.40EUR
Qty - 4800CT
Material 2
Amount in LC - 0.13EUR
Qty - 1560 CT
I have chacked the Item changes in PO. They have changed the condition pricing Unt (from 1EUR to 1000EUR) and net price also for both the materials.
In Item Details, in PO Reference Tab of Invoice Document, under column Prc( Blocking Reason Price) for Mtaerial 1, is showong Blocking Symbol "X".
Also at Header Data, in Payment Tab, it is showing Pmnt Block as "R"(Delta price Block)
What I feel is because of line item block only, it is showing Delta price Block.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.