Hi Forum, I have a client on version 4.0 SP2 who twice a year has to increase the cost of Items. They are given a list of items that have increased in price and they then change the Last Direct Cost to reflect the increase. However some Items that they increase have outstanding PO’s at the old cost. When they invoice these, the Last Direct Cost is changed back to the old cost For example, Item ABC123 has a Last Direct Cost of £10.00 and they raise an Order. They then get a list showing that the Item has increased to £15.00 so they change the Last Direct Cost to £15.00. The oustanding order is invoiced and the Last Direct Cost changes back to £10.00. All Items have a Costing Method of FIFO.
They want to know if there is anyway to prevent the Last Direct Cost being changed back when Invoicing. I have suggested that they dont manually change the prices and let the system do it when the new price comes thru on an invoice but they want to do it beforehand. I hope I have explained this clearly enough.