Baan4c4: For one of the purchased items the standard cost price has changed.I am still unable to figure out if the system on its own can trigger any such thing as i don't see any changes in the item data.I have checked the purchase orders,receipts and created purchase order history by item which have the correct prices.
Thanks

Baan is great, but it cannot trigger a cost price update by itself. Best table to check is ticpr300 for your item, assuming projects is not used. Find the item in question and check the last date that the price was rolled up and updated. By the way ticpr300 is a good table to audit along with a few others...

Thanks for the reply.I checked in ticpr300 .On a certain date the cost price had been triggered and calculated wrongly.The previous calculation (date which i saw in the above mentioned table ) is correct. What data should i check which could have resulted in this wrong calculation.The purchase price in item data is correct.

Regards

That's a difficult question: the reason being that baan does not store old value/new value except in ticpr300. I assume the item is of type 'purchased' then the factors used in determining the cost price are:

Check the live cost price calculation code purchase price priority:
Si = simulated purchase price
Cp = current purchase price (from item master form 3)
Ap = average purchase price (ditto)
Lp = latest purchase price (ditto)

Ap/Lp are determined when matching invoices to orders.

Anyway one of the above is used based on your priority... then added to that you may have surcharges based on item group or simply by item.

Please note that it is incredibly difficult to determine what numbers were used in determining the cost price after the update has completed - you have to choices: what we have done is create a report that prints all of these factors before an update of the cost price is done -> anyone not doing this on our system will be shot.
The other choice is to audit all the tables that are possibly used in determining the cost price. (very data intensive)

If you'd like a copy of the report let me know...

Regards,
Rupert

I have already checked for the live cost price calculation code purchase price priority which you are saying.
Thanks.

Hi

Baan will not trigger a cost price updation automatically.In the integration trnx you can find out the user who updated the cost .

As to how cost has been calculated will depend upon the priorities as explained by Rupert. It would also depend upon the setting in the PO parameters- Current inventory or cumulative purchases, when did you last run the session tdpur4225m000- Equate balance of purchases with inventory and whether purchase invoices have been matched and approved in finance. So it would be very difficult to say how the cost was calculated at a particular point in time.

Thanks for the reply.I have checked the purchase integration transactions and the purchase invoices.The price what is paid to the supplier against the quantity is correct.
regards

Hi

I am sorry I was not clear in my reply about integrations. You can find out which users has updated the cost price by looking at the 'Warehouse Order Revaluation '

As regards how the cost was calculated, it would be difficult to know at this point in time. What do your fields 'Average Pur Price' and Latest Pur Price show in the item master

Jayant, unfortunately the warehouse order revaluation will only be triggered if there is indeed inventory recorded in the system. I am not sure if swatcat is looking for someone to blame or an answer as to how the price was determined??

I wonder if this will ever be resolved, as we do not have ready access to all the information required?

Regards,
Rupert

Thanks for all this help.I am aware that some one has calculated the cost price .Thats o.k.
But i am interested in knowing how the price was determined??
Regards

there is no "one right answer" as to how cost price is calculated. It depends on the particular configuration. Start with your cost price calculation code priority, find the purchase price that applies, add any surcharges (by item or item grp), and if purchased in foreign currency, convert to home currency.

Thanks for the reply.In the cost price calculation code priority ap is no 1. which already has changed in the item data ..and i am wondering why? when all the purchase invoices/receipts are at correct price.Then no 2 is Lp which is also correct for that item.
As you have mentioned about currency the item is purchased in home currency.Surcharges i will have to check if any.
Thanks

Average purchase price and latest purchase price are updated in invoice approval (tfacp1140s000) and change price / discount after delivery( tdpur4122m000) .

So if the average price is changed through this session and cost price is recalculated for the item , then cost price changes and warehouse/revaluations will be generated.

Hey! Thanks to all of you for your help.The matter has been resolved.The cost price calc script which was written in-house had a bug.