blanchap
7th July 2008, 23:54
Hi,

is there a table where Baan keeps the history of all purchase price changes, same way that It keeps an history of all standard cost price changes?

I see that there is a average purchase price field and a latest purchase price field. Are they calculated fields or the data stored somewhere?

Regards

PB

TebbyTan
8th July 2008, 05:28
Hello,

from my understanding in purchasing module, there is no specific table just mainly track the price history. You be a ble to extract data from Purchase History table (tdpur451) for the price history.

Else you can maintain all purchase price using purchase price book (tdpcg0131m000)

Good day

rkathait
8th July 2008, 12:24
Purchase price in Item-Purchase data (Item Master in Baan4) gets updated in Default Purchase Price book (maintained in Pricing Parameter), so if you check the Default Purchase Price book you will get the history of all the price changes you have done in Item-Purchase data (Item Master).

I haven't seen Baan4 for years now, so pls check if the purchase price from item master gets updated in default purchase price book :)

Regards,

blanchap
9th July 2008, 17:56
The problem is that Baan IV does not have a purchase price book.
I think my best option is to go through the purchase history table like tebbytan said.

Thanks both of you for your feedback on this

Regards

PB