We are using a Suppler Schedule Order with a Supplier Price List but for some reason some times it simply takes the incorrect or the last price used insteead of using the price from the corresponding price break. Here is the setup we have for one item:
Supplier Schedule Order has the Fixed Price box un-checked on the main PO screen and on the line item screen, also on the line item the discount table is set to the corresponding price break list.
In the Supplier Price List we have the same PN as the Supplier Schedule order, same UM, the start and end dates are OK and the ammount type is "P" and it has the folllowing price levels:
1 = 995
5 = 296.75
10 = 188.65
25 = 118.75
50 = 85.55
75 = 70.25
100 = 65.95
125 = 61.45
150 = 59.85
900 = 55.75
Having this setup the last receipt was for 75 PC and it took the price of the 150 level, before this we have the following from latest to earliest receipts:
595 @ 55.75 (Incorrect price level, should have taken 59.85)
-600 @ 59.85 (Correct price level)
600 @ 55.75 (Incorrect price level, should have taken 59.85)
before these there was one case were 5 were received and it took the 1 PC price but before that a 117 PC receipt used the correct price of 65.95.
What could be causing the system to take an incorrect price level at seemingly random occacions? Any one else seeing this?
Thank you for your help.