When I run the Update Purchase Items Maintenance from the Purchase Order Module, the Price field gets updated with the current cost price from the item card.

The problem with this is, I am using Weighted Average as my cost model. Because of this, I have the Upd. Cost Price at Goods Receipt radio button set to Weighted Average on my item card.

So, when I run the Update Purchase Items Maintenance, the price on my purchase item is getting updated with my weighted average price, not my last purchase price, which is obviously what I need, seeing as that is the last price I paid for the item.

How can I get my purchase items updated with my last purchase price automatically or with this maintenance?

Thanks
Alan

Version 6.3 110726