mattan
1st June 2005, 11:51
Hi,

I am calculating average purchase price based on current inventory. I would like to know whether in this formula, the current inventory is the inventory before or afer the new receipt.

Thanks.

Paul P
2nd June 2005, 05:31
BaanERP weighted average purchase price automatically weighs in the inventory level when calculating average purchase price.

New avg pur price =((old inv x old avg pur price)+(receipt qty x pur price))/(old inv + receipt qty)

Rgds,
Paul

mattan
2nd June 2005, 07:18
Hi Paul,

Thks for the valuable information.

Just to confirm further, if I set the parameter "Method of Calculating Average Purchase Price" to "Current Inventory" in "Maintain Purchase Order Parameters", it will use the formula you stated, right.

Thks and rdgs,
Matt

Moon Lok
2nd June 2005, 11:34
May be this can help you.