Skip to Content
0
Nov 14, 2013 at 09:30 AM

B1 9.0 Changed behaviour SPP and Items per Unit

44 Views

Dear all,

using B1 8.82 we were adapted to the following behavior of price calculation.

Let's assume we have the following volume discounts in prices:

Quantity Price per unit
1000 1,00 EUR 3000 0,80 EUR 5000 0,70 EUR

Expected Behaviour in B1 8.82 in a sales document:

Qty: 1000 pcs

Items per unit: 1

Price logic: 1000 * 1,00 EUR * 1 Item per Unit = 1000 EUR

Qty: 1000 pcs

Items per unit: 3

Price logic: 1000 * 1,00 EUR * 3 Items per Unit = 3000 EUR

The important point is, that for a quantity of 1000 pcs and a Items per Unit of 3 the price per unit of 1000 pcs is taken from the volume discount price list. This is our expected behavior and was valid for all SAP B1 8.x versions.

New (unexptected) behaviour in B1 9.0 PL06 in a sales document:

Qty: 1000 pcs

Items per unit: 1

Price logic: 1000 * 1,00 EUR * 1 Item per Unit = 1000 EUR - so far, so good

Qty: 1000 pcs

Items per unit: 3

Price logic: 1000 * 0,80 EUR * 3 Items per Unit = 2400 EUR

As you can see, B1 9.0 first calculates 1000 * 3 Items per Unit = 3000 pcs. Then it gets the price per unit for 3000pcs from the volume discount pricelist, instead of the 1000pcs as in all B1 versions before 9.0.

----

In fact, just by updating from 8.82 to 9.0, we sell our products 20% cheaper in this case. I am really upset at this point and cannot believe SAP is changing such a business critical program logic without any further notice?!

Can anyone suggest a solution what to do?

Best,

Oliver