Odoo Addons (MOVED TO GITHUB)

Purchase Goods From Supplier based on a Foreign Currency Pricelist

Bug #1157619 reported by Ashley Marc
24
This bug affects 5 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Confirmed
Medium
OpenERP R&D Addons Team 1

Bug Description

Hi,

Please find appended below the details of the above mentioned issue:

1) OpenERP Version 7.0 (Test done on www.openerp.com demo account)

2) Inventory accounting method: Anglo Saxon Accounting (Setup for input/valuation/Output/price difference accounts all done accordingly)

3) Inventory valuation method: Real-Time Automated (Average Cost)

4) Test 1: Company currency in $SGD. Set up currency table and updated SGD as 1.0000.
     Test 2: Company Default Currency in Euro set at 1.000.

5) Test 1: Supplier pricelist in GBP based on default purchase pricelist version $SGD (Cost Price).
     Test 2: Supplier pricelist in SGD based on default purchase pricelist version Euro (Cost Price).

6) Proceed to create purchase order for goods bought from overseas supplier in GBP.

7) Tried to process receipt of goods by clicking receive goods on P.O. form this error message appears on both tests:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ValidateError

Error occurred while validating the field(s) amount_currency: The amount expressed in the secondary currency must be positif when journal item are debit and negatif when journal item are credit.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Kindly advise further. Thank you for your kind attention.

Warmest Regards,

Ashley Marc

Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
importance: Undecided → Medium
status: New → Confirmed
Amit Parik (amit-parik)
Changed in openobject-addons:
assignee: OpenERP R&D Addons Team 3 (openerp-dev-addons3) → OpenERP R&D Addons Team 1 (openerp-dev-addons1)
Revision history for this message
Joël Grand-Guillaume @ camptocamp (jgrandguillaume-c2c) wrote :

Dear all,

I'm really busy currently and will not have the time to reproduce this bug. As it is a confirmed one, I can think that this exception is raised...

What I'm sure about is that the constraint we've put here is good. We need positive amount currency at debit and negative at credit and this should NEVER be made otherwise...

So I think the trouble comes from the generated entries that should respect the constraints. So please, do not change the constraints to solve the bug :) !

Looking the code, may be we forget in the constraint the case where debit AND credit = 0.0, but this sounds a use case that should not happened. As long as we are not in that case, the correction need to be made where the entries have been generated. Again, do not touch the constraints as it was there to prevent such case.

Hope this helps.

Regards,

Joël

Revision history for this message
Ashley Marc (ashleymarc-6) wrote : Re: [Bug 1157619] Re: Purchase Goods From Supplier based on a Foreign Currency Pricelist

Dear Joel,

Thank you so much for your prompt reply despite your busy schedule. Yes
indeed, we will await the outcome of this bug and review it at a later
date.

Warmest Regards,

Ashley Marc

On 4/10/2013 5:53 PM, Joël Grand-Guillaume @ camptocamp wrote:
> Dear all,
>
>
> I'm really busy currently and will not have the time to reproduce this bug. As it is a confirmed one, I can think that this exception is raised...
>
> What I'm sure about is that the constraint we've put here is good. We
> need positive amount currency at debit and negative at credit and this
> should NEVER be made otherwise...
>
> So I think the trouble comes from the generated entries that should
> respect the constraints. So please, do not change the constraints to
> solve the bug :) !
>
> Looking the code, may be we forget in the constraint the case where
> debit AND credit = 0.0, but this sounds a use case that should not
> happened. As long as we are not in that case, the correction need to be
> made where the entries have been generated. Again, do not touch the
> constraints as it was there to prevent such case.
>
> Hope this helps.
>
>
> Regards,
>
>
> Joël
>

Revision history for this message
Ashley Marc (ashleymarc-6) wrote :

Dear Joel,

So in short, just for your reference while creating purchase order /
supplier invoice automated journal entries created by the system does
not meet the requirements of the proposed constraint. If i were to
manually enter multi-currency journal items i could include a positive
or negative figure but where else if i were to create a purchase order
the system has to automatically create these entries. Please correct me
if i am wrong?

Regards,

Marc

On 4/10/2013 5:53 PM, Joël Grand-Guillaume @ camptocamp wrote:
> So I think the trouble comes from the generated entries that should
> respect the constraints. So please, do not change the constraints to
> solve the bug:) !

Revision history for this message
Aleksander Opoczynski (aleksander-opoczynski) wrote :

Dear All,

I encountered the same problem.

My main currency is PLN with exchange rate 1,0000.
Purchase currency was EUR with exchange rate 0,241359.
Costing method: average
OpenERP 7.0 installed on my server with Ubuntu 12.10

When it comes to goods reception (Incoming shipment) and I press the "RECEIVE" button I get the same error message as Ashley.

If I make the purchase in PLN - everything goes perfect.

If I change the valuation method to standard price everything also goes correctly. Probably because standard price is in PLN.

Regards,
Aleksander

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.