So perhaps I am wrong. Maybe there is a way to get at this with a function?
Sorry I’m late but the best way is to look at the standard, be it standard cost or a custom field to store your quoted cost. Then compare that baseline to the average, next PO receipt or whichever ‘new’ cost you choose. This delta should be multiplied by every future use of the part which will be on partdtl. Factor in on-hand quantity and order multiples to dial it in even better. This extended dollar value would be called something like ‘Cost Impact’ and should be reverse sorted to find the dragons to slay. At the other end of the report, the negative values, one could reward the buyers for a job well done.
This is just one part of a price change program. Our buyers are not allowed to deviate from the quoted cost because we are contract manufacturers and need to decide whether we absorb the cost increase or pass it on to the customer. So we use a UD table and several BPMs to manage the communication cycle between the buyers, program managers and accounting.
2 Likes
Mark, it sounds like you have a good process down and a nice way to do this for your given business practices. thank you so much for sharing, I will definitely use your approach in some way.