OSPP Price field calculation?

[Former Member]

Hi all, i had noticed the following, but as after 30 minutes still cant figure, so i think its easier to ask:

There is item 1, which has the price of 19,56 EUR in it's pricelist.

There is a special price for BP on it with 15% discount on that pricelist. That is 16,63 EUR (19,56*0,85=16,626 ~16,63) which is correct.

But in the OSPP table i see the following:

Price: 14,23

Currency: EUR

I tried lots of different approaches, but non gives the result of 14,23...

Could someone please shed some light on the issue?

Thanks,

Regards,

Daniel

[Former Member]

You are probably right. Just update the price list to see the result.

[Former Member]

HI,

thanks, but as i wrote updateing is not helping.

So may i conclude that we don't really have any other idea?

[Former Member]

I could not think of any just based on the info now. However, something may still be done if I can access the database.

[Former Member]

Open the item in the price table, double click the row and verify the "Valid From" Date.

Also verify the price list isn't based on another price list.

Edited by: M. Jenkins on Oct 3, 2011 9:38 PM

[Former Member]

How many price lists and special price lists do you have?

[Former Member]

10 price lists,

~180 unique OSPP cardcode's, total ~250000 lines

[Former Member]

For so many lines in the table, system must find another price that meet the condition which override what you expected one.

Try a query SELECT * FROM ITM1 WHERE ItemCode = '[%0\]' AND Price = 14,23 to find it out.

[Former Member]

Hi Gordon,

nothing.

I found this note a while ago:

849386

But what it describes doesn't seem to work.

That price seems to be the old price, but i can't figure out why does'nt it update. Probably the "Auto" checkbox?

Regards,

Daniel

[Former Member]

Try this: SELECT * FROM ITM1 WHERE ItemCode = '[%0\]' AND Price Between 16,73 and 16,75

[Former Member]

Thanks Gordon, but there is no such value around.

There is like ~10 records for this items, all 0EUR but 3 values:

19.56EUR

17.20 EUR

and a 11 eur value.

[Former Member]

You may have some other discount setup such as discount groups?

[Former Member]

Gordon, no such records.

No other pricing is in effect in my research except to the

List price * BP based discount.

Probably do to some logic, SBO simply doesn't update this field..

[former_member218051]

Hi,

Do you have any period and or volume based special prices ?

Check them in child tables.

SPP1 : Period Based Discounts

SPP2 : volume Based Discounts

Thanking you

Malhaar

[Former Member]

Hi,

Thanks Gordon, Malhaar.

That was my first idea too. SPP2 is empty, SPP1 has no matching data.

Any other ideas?

Thanks,

Regards,

D

[Former Member]

Hi Daniel,

Have you checked SPP1 and SPP2 tables?

Thanks,

Gordon