mgakhar
20th January 2004, 23:03
How and when does the Latest Purchase Price in the Item Master get updated ? I believe its when you invoice a PO with the new Pur Price but just want to confirm.

This is for BaanIV.

Thanks,
MG.

jonah001
21st January 2004, 00:21
Hi,
what you say is correct but don´t forget to change or update the priority of purchase price field in the session "price calculation code" (if you have baan V, the session is ticpr1500m000).

For Baan IV you can see the session ticpr1101m00 to check the priority. if you want last price it must be first priority Lp

thanks

jonah

Scott2001
21st January 2004, 06:43
The setting of the Purchase Price Priority field in the session "Maintain Cost Price Calculation Codes" (ticpr1101m000) only determines what purchase price Baan (IV) uses to calculate cost price in Calculate Cost Prices (ticpr2210m000), it does not control when the latest and average purchase prices in the Item Master are updated.

The setting of "Integration with Baan Finance" in Maintain Financial Integration Parameters (tdpur6100m000) determines when the Average Purchase Price and Latest Purchase Price in the Item Master are updated.

If "Integration with Baan Finance" is Yes, the Average Purchase Price and Latest Purchase Price are updated on approval of the purchase invoice (in tfacp1140s000).

If "Integration with Baan Finance" is No, the Average Purchase Price and Latest Purchase Price are updated by Process Delivered Purchase Orders (tdpur4223m000).

Please see thread http://www.baanforums.com/baanboard/showthread.php?threadid=9932&highlight=latest+purchase+price or search the forums for “Latest Purchase Price” and “Average Purchase Price” for more discussions.

Scott

Hitesh Shah
21st January 2004, 09:56
Scott2001 is correct. Additionally I think it's updated when u change prices discounts in tdpur4122m000 .

Scott2001
21st January 2004, 16:33
Thanks, Hitesh. I forgot about updating price after receipt. But since that session updates the PO Line item price, wouldn't the actual update of latest price field in the Itrem Master still be processed at the same points (i.e. approval of the purchase invoice or Process Delivered Purchase Orders)?

Scott

Hitesh Shah
25th January 2004, 22:18
To the best of my memory , the latest and average prices are calculated at the time of purchase receipt , change price/discounts after delivery , invoice approval etc .

Currently I am not in front of Baan and in a position to check this . U may check the whereused programs for tdpurdll0019 , to get the correct list or else create a simple test.

Also keep this post updated.