[6.1] Anglosaxon accounting : wrong price diff when multicurrency

[Frederic Clementi - Camptocamp]

Hello,

OpenERP do not handle price diff correctly on purchases invoice journal entry when multicurrency

See attached doc.

Many thanks

Frederic

[Ashley Marc (ashleymarc-6)]

This bug has to be confirmed as it is affecting the whole Accounting / Stock process. Price difference is not able to read multi-currency thus the only way out is to take out the price difference. Any chance this bug will be fixed?

[Amit Dodiya (OpenERP) (ado-openerp)]

Hello,

This issue is fixed with following branch:
Branch: lp:~openerp-dev/openobject-addons/6.1-opw-582323-ado
Revision-id: <email address hidden>
Revision-no: 7092

Soon our experts will review and merge it with stable(6.1) addons.

Regards,
Amit

[dana ilinca (dilinca)]

Hello,

I checked your solution, is not correct :
line price_diff = i_line.price_unit- standard_price must be replaced with
price_diff = prices - standard_price.
And the Journal Items amounts are in the company currency .

Regards,
Dana Ilinca

[Ashley Marc (ashleymarc-6)]

Good Day Dana,

Thank you for your advice however in my opinion and through various test
it is somehow impossible to get the price difference account to work
when purchasing in multi-currency. The amount posted to the price
difference account is always based on the difference in exchange rate.
Any suggestion on how you've worked around it thus far?

Regards,

Ashley Marc

On 12/13/2012 11:11 PM, dana ilinca wrote:
> Hello,
>
> I checked your solution, is not correct :
> line price_diff = i_line.price_unit- standard_price must be replaced with
> price_diff = prices - standard_price.
> And the Journal Items amounts are in the company currency .
>
> Regards,
> Dana Ilinca
>

[Alexandra Stanescu (astanescu)]

Hello,

You can find an attached document of the expected result. I hope it’s correct as we only use something similar to the anglo-saxon accounting.

As you can see, I’ve mentioned the “movement date” on the journal entry generated by the incoming shipment. “Normally”, this date automatically takes the system date at which the movement is processed. But if you use an extra module (stock_move_change_delivery_date), you can specify the move date (move_line.date) when processing a movement.

Unfortunately, the generated journal entry does not use the currency rate at this movement date, but uses the system date. This problem should also be revised.

Regards,
Alexandra

[Ashley Marc (ashleymarc-6)]

Hi,

Kindly advised if the bug has been fixed. I am still unable to achieve the expected results. Correct me if i am wrong.

Cost Price of product is 595 USD. Using Supplier GBP pricelist amount is automatically converted to 344 GBP on PO. PO automatically creates an Supplier invoice. No changes in price from PO to Invoice and invoice is confirmed @ 344 GBP. Why is there a price difference amount?

[Amit Dodiya (OpenERP) (ado-openerp)]

Hello Ashley Marc,

I have checked your issue as per your specification but after applying the merge proposal it's working fine and generate the journal entries as per the behavior with no price difference entry.

I have also attached a video here with all configuration and results please check the attached video and notify me if i'm missing something.

Regards,
Amit Dodiya

[Frederic Clementi - Camptocamp (frederic-clementi)]

I tested the patch and it is fine for me.

Please merge it

Many thanks

Frederic Clementi

[Alexandra Stanescu (astanescu)]

Hello again,

We are still unable to get the correct result for this bug. The correction works if there is no price difference, calculated as the difference between the purchase cost (on the supplier invoice) and the average cost (on the product form).

The test case in the video does not modify the average price on the product (595.00 EUR i.e. 495.81 GBP) so no price difference entry is created.

Could you please try and redo the test using a different cost price, other than the average one?

Thanks,
Alexandra

[Frederic Clementi - Camptocamp (frederic-clementi)]

Hello,

Alexandra is right.

I think the test we have done on the proposed patch is too basic and hide a
 wrong computation of the price difference.

please see attached doc.

[Frederic Clementi - Camptocamp (frederic-clementi)]

Hello,

Alexandra is right.

I think the test we have done on the proposed patch is too basic and hide a
 wrong computation of the price difference.

please see attached doc.