magentoerpconnect-community team mailing list archive

[Albert Cervera i Areny <albert@xxxxxxxxxxx>]

A Dilluns, 5 d'abril de 2010, Albert Cervera i Areny va escriure:
> Hi list,
> I've recently started to evaluate and use the Magento connector. First of
>  all, I wanted to thank you for your work!
> 
> The thing I was most worried about was if there could be differences
>  between amounts in Magento and OpenERP, so I imported almost two thousand
>  orders of a Magento test database and I created a process that showed
>  differences between total amounts in Magento and OpenERP.
> 
> Unsurpisingly there were differences. The numbers were that 1.823 orders
>  had exactly the same total amount while 157 showed different values.
>  (That's about 8% of the total). Of course, the problem is not with the
>  amount of money because there's one or two cents of difference between
>  them, but it can be very ugly to send a customer an invoice of 10.13 EUR
>  while he paid 10.15 EUR.
> 
> How are you solving this problem in your current installations?

I've just commited a new module in extra-addons repo called 
nan_external_prices which handles this properly in a generic way. The module 
simply adds some fields so that modules like magentoerpconnect can use to fill 
in Magento's calculated values. Those orders and invoices will use Magento's 
values instead of default OpenERP calculations so there are no differences in 
amounts between both applications.

I've tested this with magentoerpconnect but have not yet pushed those changes 
to our branch. That should happen in the next few days, in case somebody is 
interested.

> 
> One idea would be to store the total amount (and tax amounts) in some
>  fields in the order and use them when the invoice is created so at least,
>  those values match what the customer paid.
> 


-- 

Albert Cervera i Areny
http://www.NaN-tic.com
OpenERP Partner
Mòbil: +34 669 40 40 18