Hi Experts,
Supplier price list capture wrong amount. Price in PO is 1.90 but receipt capture 2.15. How can i update this field?
We are currently experiencing the same. What is the solution please?
You will need to check the Supplier Price List screen on the Parts > Detail tab as Bruce said above.
Make sure you also check the Parts > Price Breaks > Detail tab.
How this works is it takes the Base Unit Price from the Parts > Detail tab and if there is anything in the Price Modifier field on the Parts > Price Breaks > Detail tab, it checks the Minimum Quantity to see which Price Break to use. If there is only one and your ordered quantity is at least that amount, it will add whatever is in the Price Modifier field to whatever is in to the Base Unit Price from the Parts > Detail screen.
So, for example:
You are buying part number 12345 from your supplier and the quantity you are buying is 1,000 each.
There is a Base Unit Price of .10 each
On the Parts > Price Breaks > List tab, you have 3 price breaks setup:
| Minimum Quantity | Base Unit Price | Price Modifier | Total Cost of Each Part |
|---|---|---|---|
| 1 | 0.10 | 0.10 | 0.20 |
| 100 | 0.10 | 0.05 | 0.15 |
| 1000 | 0.10 | 0.00 | 0.10 |
So in the example above, the cost of each part would be .10 each.
But, if you ordered only 999 parts, then the cost would be .15 each.
Hopefully this makes sense.
1 Like