Looking for ideas and a solution for my client.
They use FIFO Items, and JobOps. They do purchase direct to the job, but when they do a PO Receipt of Invoice, if that job had special pricing it updates the item master with the Total Last Cost. So a $ 300 item they purchase routinely is now updated with the special price (let's say $ 200) as the Total Last Cost, because it was purchased at a discount price for a special project. In their case, that "special pricing" was for a special project, and not really applicable to how they buy things on a day to day basis. They use BOM Cost Roll Up to help them develop sales prices on new BOM's. They want the most current costs so they use Last Cost on the BOM Cost Roll Up. Unfortunately, that item that was received at a special price, will negatively impact their quoting process if it is using a special price on an item (or two or three).
Looking for a method to stop the Special Pricing PO Receipt of Invoice from updating the Item Total Last Cost.
Any suggestions or recommendations?
------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------