Error converting currencies Payment suppliers

[Pak Ricard]

Hi:

Paying a supplier from Suppliers --> Enter a Payment to has an error converting the currencies if supplier has Currency A, paid from a bank account in Currency .

After doing the tx, checked at Bank Reconciliation and the balance was a huge error number.
Example was:
Pay 225.000 THB from bank account in USD to supplier in THB (rate is aprox 30 THB/USD), so should be a deduction of 7.500 USD from bank account BUT The bank statement showed a balance of some - 67.500.000 USD :-(

Some data is multiplied instead of being divided by the rate, I guess.

Rgds,
Ricard

[Pak Ricard (pakricard)]

BTW:

It seems the problem only arises when functional currecy is C, different from bank and supplier currecies, so 3 currencies are involved.

Regrds,
R

[Tim Schofield (tim-weberpafrica)]

Hi Ricard, I am having trouble replicating this, are you sure your exchange rates are the correct way around, ie 1 unit of your functional currency = ? units of other currency?

Sorry if that seems a silly question :-)

Thanks
Tim

[Pak Ricard (pakricard)]

Hi Tim:

Rates are OK and automatically updated.

When paying a supplier FROM or TO functional currency it's working fine. I
think the problem arises when paying from different currencies.
In our example, functional currency is IDR and we need to pay a supplier in
Thailand (so in THB) from a bank account in USD. Then is when the problem
shows up.

BTW, I tested and the problem is the same when doing a general payment /
receipt in these conditions, so I guess the problem is in the gltrans side.

I'll keep investigating, but really this is way too complicated for us to
fix.

Regards,
Ricard

2011/3/5 Tim Schofield <email address hidden>

> Hi Ricard, I am having trouble replicating this, are you sure your
> exchange rates are the correct way around, ie 1 unit of your functional
> currency = ? units of other currency?
>
> Sorry if that seems a silly question :-)
>
> Thanks
> Tim
>
> ** Changed in: web-erp
> Assignee: (unassigned) => Tim Schofield (tim-weberpafrica)
>
> ** Changed in: web-erp
> Status: New => Opinion
>
> ** Changed in: web-erp
> Status: Opinion => In Progress
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/719760
>
> Title:
> Error converting currencies Payment suppliers
>
> Status in webERP Open source web-based ERP:
> In Progress
>
> Bug description:
> Hi:
>
> Paying a supplier from Suppliers --> Enter a Payment to has an error
> converting the currencies if supplier has Currency A, paid from a bank
> account in Currency .
>
> After doing the tx, checked at Bank Reconciliation and the balance was a
> huge error number.
> Example was:
> Pay 225.000 THB from bank account in USD to supplier in THB (rate is aprox
> 30 THB/USD), so should be a deduction of 7.500 USD from bank account BUT The
> bank statement showed a balance of some - 67.500.000 USD :-(
>
> Some data is multiplied instead of being divided by the rate, I guess.
>
> Rgds,
> Ricard
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/web-erp/+bug/719760/+subscribe
>