Forum - Update Purchase Items Maintenance

Update Purchase Items Maintenance

2014-09-03

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

This answer was correct

Created by18:06 3 Sep 2014

Hi,

If you want to update your Purchase Item cost price with last purchase price, you should:
select 'Last Purchase Cost (incl. extras)' or 'Last Purchase Cost (excl. extras)' - (depends if you want to include extra costs) as your cost model for Updating Cost Price at Goods receipt.

In this case your Purchase Item Cost price will be updated with the last purchase price.

If you have any other queries, please do not hesitate to contact us again.

HansaWorld UK Team

Reply

This answer was correct

2014-09-03

Hi,

If you want to update your Purchase Item cost price with last purchase price, you should:
select 'Last Purchase Cost (incl. extras)' or 'Last Purchase Cost (excl. extras)' - (depends if you want to include extra costs) as your cost model for Updating Cost Price at Goods receipt.

In this case your Purchase Item Cost price will be updated with the last purchase price.

If you have any other queries, please do not hesitate to contact us again.

HansaWorld UK Team

Reply

2014-09-03

Created by18:06 3 Sep 2014

Hi, If you want to update your Purchase Item cost price with last purchase price, you should: select 'Last Purchase Cost (incl. extras)' or 'Last Purchase Cost (excl. extras)' - (depends if you want to include extra costs) as your c

Thanks for the reply,

However, I have just been through the process of turning on chronology of stock, part of this process was to set my updating cost price at goods receipt radio button to weighted-average.
This was on the advice from Kaido, who said, everyone who is using weighted-average as their cost model should have the radio button set this way.
If you have your radio button set to last purchase cost, then the gross profit calculation on sales invoice will be different to the gross profit calculation done in the normal ledger!

There should really be an option on the maintenance routine, to be able to choose which cost is used when updating your purchase items.
Are there any other workarounds for this issue?

Reply

2014-09-04

Created by18:06 3 Sep 2014

Hi, If you want to update your Purchase Item cost price with last purchase price, you should: select 'Last Purchase Cost (incl. extras)' or 'Last Purchase Cost (excl. extras)' - (depends if you want to include extra costs) as your c

Thanks for the reply,

However, I have just been through the process of turning on chronology of stock, part of this process was to set my updating cost price at goods receipt radio button to weighted-average.
This was on the advice from Kaido, who said, everyone who is using weighted-average as their cost model should have the radio button set this way.
If you have your radio button set to last purchase cost, then the gross profit calculation on sales invoice will be different to the gross profit calculation done in the normal ledger!

There should really be an option on the maintenance routine, to be able to choose which cost is used when updating your purchase items.
Are there any other workarounds for this issue?

Reply