c2c-oerpscenario team mailing list archive

[Sébastien BEAU - http://www.akretion.com <sebastien.beau@xxxxxxxxxxxx>]

This have been fixed in rev 434 of the stable v6
http://bazaar.launchpad.net/~magentoerpconnect-core-editors/magentoerpconnect/magentoerpconnect-v6/revision/434

** Changed in: magentoerpconnect
       Status: New => Fix Released

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

Title:
  tax bug in order_line discount_amount mapping ?

Status in Magento OpenERP Connector:
  Fix Released

Bug description:
  
  Usecase:
  - Sale Shop in OpenERP is configured with "Prices include tax"=true

  - Module sale_tax_include installed, but tried without this module
  also. no effect !

  - defined a shopping cart price rule in magento with an discount of
  50%. Btw in catalog price rules everything seems to be fine.

  - bought a Product  for 149 EUR (including 19% tax) which should generate following order line:
  Qty 1 / Discount 50 % / Unit Price 149 EUR / Net Price 74,50 EUR / Subtotal w/o tax 62,61 EUR / Subtotal 74,50 EUR

  - after importing this order into OpenERP the order line looks like this:
  Qty 1 / Discount 59,50 % / Unit Price 125,21 EUR / Net Price 50,71 EUR / Subtotal w/o tax 50,71 EUR / Subtotal 60,34 EUR

  The problem is the order_line discount_amount mapping which is
  independent of product_tax_rate and expected net values always. I
  attached some calculation examples

  I tried following fairly hardcoded mapping for discount_amount and it
  "solved" the issue for products with 19% tax

  result=[('discount',
  float(data['price']) != 0 and float(data['qty_ordered']) != 0 and float(100*float(ifield)/float('1.19'))/(float(data['price'])*float(data['qty_ordered'])) or 0)]

  But changing this mapping is not the best way, i think. Best way would
  be always calculate with gross values OR net values directly
  (depending of "Prices include tax" configuration in Sale Shop)

  We have a lot of rounding issues by calculating arround with
  percentage rates combined with price_accuracy=2 (1 Cent differences) >
  no automatic reconcilation of invoices.

  Can anyone give me some hints for solution or can anyone confirm ?

  regards,
  Thomas

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/615903/+subscriptions