Hello,

We have the following problem with our latest and average purchase prices for some items. For some reason or other, these fields get reset to "0". We do no have any clue on how this is possible.

The items have stock and are current; They were recently purchased with current purchase prices.

We can not du-plicate the same result in our test company,
BaaN IV SP 14 (I believe).

We do have a multi finance structure and just turned on single logistics multi finance for this company. Purchase is fulle integrated with finance. Perhaps this is the problem?

Has anyone experienced similar problems?
Any help ore pointers would be greatly appreciated..!

Best regards,

thieuf

Dear thieuf,

as far as i remember you will get a 0 price if the stock is negativ.

The reason for this could be, purchase orders having values for tdpur45.stsd (status <> fully approved) are NOT calculated for the current stock.

OR: tdpur041.quap (quantity approved) is unequal order quantity.

Example:

On Stoc: 10 Item A

Order with orderquantity 15 Item A (Status <> fully approved), 5 are on backorderquantity.

Current stock for calculation of average purchase price = 10 - 15 = - 5 -> baan calculates with current stock = 0.

If you now have e.g. a purchase order with negativ orderquantity, e.g. sending back 5 bad goods to the supplier, the calculation is:

current stock * current.avpr + orderquan * purchase_price
---------------------------------------------------------
current stock + orderquan

0 * 10 USD + -5 * 11 USD 0 + 0 (negative gets 0)
-------------------------- = ------ = 0
0 - 5 1 (negative gets 1)

if the result is negativ baan gives 0 USD for the avpr (which results in wrong cost calculation for the inventory).

Another reason could be that you use purchase orders instead of purchase contracts (wrong business process).

Example:

You buy 10.000 Units in one order position, which will be send in units by 100 per month. The whole 10.000 Units are not taken into account for the stoc calculation until all 10.000 Units are delivered -> Status: all aproved.

Whe had resulting 0 prices and also strong fluctuating prices.
That was the reasons i found (after lot of debugging).

For further investigation you could set the fields ltpr and avpr (tiitm001) under audit management, so you get information what date (approval of purchase invoice) the values are changed.

Regards,

Kozure

Hello,

thanks for the reply.

I am not able to follow your calculation, but we use current stock to calculate
the average price. the stock level of the items i tested has not been negative for quit a few years now so that should not be the problem.

We do have some strange invoiced records in tdpur051, related to very old orders, but with a date of december 2006.

Thanks again...

Dear thieuf,

sorry for confusing you (i am more programmer).

The point is:

If you use current stock -> baan calculates the current stock without quantities on stock which originates from purchase order if the position is not all aproved.

Exampel:

Current Stock (inv report): 100 Units

Within this 100 Units there are 10 Units originating from an orderposition with 15 Units. So 10 are already in the stock, 5 are on backorder quantity.

Now Baan calculates like this:

Current stock 100 Units - all order positions (status <> all aproved) 15 units = current stock for calculating the avpr = 100 - 15 = 85 Units. (NOT 100 Units).

If you have low stock e.g. 10 Units, and large orderpositions e.g. 100 Units (Status <> all aproved) BaaN calculates: 10 - 100 = - 90 (if negativ, BaaN calculates with current stock = 0 therefore the current inventory is evaluated with 0 * old avpr = 0 USD -> you loose the historical avpr, the ltpr has 100 % effect to the new avpr.

It is not enough to show INV or ILC Reports with historical inventory, you have to lower the values with orderpositions (status not all aproved) from the historical stock.

Hope this helps.

Regards,

Kozure

Dear Kozure,

thenk you for your reply,

I checked you calculation against some of the items and orders and this would indeed explain the "0" for average price. However we also have a "0" on the latest purchase price. This price is also getting reset???

ANy ideas?

thanks in advance

regards thieuf

Do you have orderpositions with 0 prices (better solution is: price with 100 % discount -> so the late price is not overwritten with 0 -> the cost price is also good -> the inventory value is also ok).

This field is calculated within the tdpurdll0019.

The procedure is:

latest price = amount / quantity

The total stoc has to be > 0 while calculating otherwise the field tiitm001.avrp = 0!

As fas as i remember the user is interactively asked if the current purchase price should be transfered to the item master table (tiitm001).

We have the following implementation:

purchase price in item master always 0.01 (because of EDI, likes no zero values).

The prices are stored in price lists per supplier.

So if a purchase price of 0.01 appears the user knows it does not originates from a price liste -> user has to update the pricelist.


Regards,

Kozure

What is the parameter set for the calculation of Average purchase price?