c2c-oerpscenario team mailing list archive

["Robin \(www.cgbs.com.au\)" <716289@xxxxxxxxxxxxxxxxxx>]

I created a new database with demo data.

I installed the CRM, Warehouse Management, Purchase Management, Sales
Management, Accounting & Finance Applications.

(png images - screenshots attached in zip file)

Set up a UOM for a Carton - (see 1 - setup of carton uom.png)

Set up a UOM for Bottles - (see 2 - setup of UOM for bottles.png)

Set up the new product (Red Wine) normally sold by the carton. Note
default UOM and also Sale Price of $120 - (see 3 - new product config
for wine normally sold in carton.png)

Now in the first example I use a price rule against the Default Public
Price List Version to sell the Red Wine if selling a full carton. Note
the Min Quantity of 1 and the sequence of 1. (see 4 - price rule for red
wine at normal price if full carton ordered.png)

I then set another price list rule for a broken carton surcharge of 4%
if selling less than a carton. Note sequence of 2 and surcharge of 4%.
(see 5 - price rule for red wine broken carton surcharge of 4
percent.png)

Image (6 - default price rule.png) shows that the default rule is left
in place and is left with sequence 5.

Notice results on the sales order. One carton of red wine is correctly
priced at $120.00. One bottle however is priced at $10.00 per unit, when
in fact it should have $10.40 per unit (because of the 4% surcharge).
Yet if I sell 0.5 cartons, (6 bottles as a carton), it gets the 4%
surcharge. (see image 7 - sale order using default config so far.png)

NOW I REMOVE THE TWO RULES i SET UP IN THE DEFAULT PRICE LIST TO
HIGHLIGHT ANOTHER RELATED ISSUE.

The original Public Pricelist is now back to its original format.

I create a new Sale Pricelist called Test Pricelist. I set up similar
rules to my original issue, but this time the rules are based on OTHER
PRICELIST, in this case the PUBLIC PRICELIST. (see images  8, 9 and 10).

Notice the results of the new sale order based on the new test
pricelist.  My carton gets the correct price, but my bottles not only do
not get the surcharge (when under 12 bottles), but they are also 120 /
12 /12 = 0.83. Factoring has reared its ugly head again. (see image 11 -
sale order using pricelist based on another prcielist).

** Attachment added: "Configuartion - Screenshot Images"
   https://bugs.launchpad.net/openobject-addons/6.0/+bug/716289/+attachment/2163438/+files/screenshots%20of%20configuration.zip

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/716289

Title:
  Pricing Does Not Work When Multiple UOM On A Product

Status in OpenERP Modules (addons):
  Invalid
Status in OpenERP Addons 6.0 series:
  Confirmed

Bug description:
  The price lists enable you to establish pricing on the quantity that
  is purchased.

  Lets imagine that 64 units of an item constitute a pallet. You set up
  pricing to say that if 64 units are purchased, then there is a
  discount of say 10% (purchase by the pallet and get a 10% discount).

  Now sell 1 pallet to a customer (as you have already set up a UOM
  with a bigger than reference at a ratio of 64).

  The pricing will not give a 10% discount until you sell 64 of any
  units of measure.

  I would have thought that because of the pallet constituting 64 units,
  that the pricing applied for this single pallet would get the 10%
  discount.

  This pattern can be replicated across all combinations where the UOM
  is different to the UOS.

  This is making it impossible to set up price rules if sell by multiple
  UOM.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/716289/+subscriptions