Invoicing/billing in foreign currency.

Wouter van Marle wouter at squirrel-systems.com
Mon Aug 13 20:56:27 EDT 2007


>> When I post a bill in a foreign currency (Euro bill, my main currency 
>> is
>> HKD), it doesn't correctly display the amount in the Accounts Payable
>> account. This is a Euro denominated account by the way. All old bills
>> are still there and are correct. The transaction is there, just the
>> account is empty!
>
> Yes, you cannot do this.
>
>> This is a total show-stopper to me. And I can't downgrade to 1.8 
>> anymore
>> in this version of Mandriva due to obsolete gnome dependencies... that
>> version at least worked.
>
> 1.8 did this, too.  The business features are not multi-currency.

In 1.8 (.10 I think) I was using this function a lot. I at this moment 
HAVE bills and invoices in EUR, USD and HKD.

Posted of course in EUR, USD and HKD A/R resp. A/P accounts.

That's what I mean with "it worked". I've been using this function for 
several years now with dozens of bills, and save some workarounds it 
worked quite nicely. Now it doesn't work anymore. So please don't tell 
me 1.8 can't do what I did. It did, I was quite happy with it, and now 
I'm doing exactly the same with exactly the same data and it doesn't 
work anymore.

Existing, posted bills and invoices are there. With the correct 
amounts. And show up nicely and (afaict) correctly in the reports in 
2.x.

>> It's a complete show-stopper, this issue. NO idea what I'm doing 
>> wrong;
>> I changed the default currency for the vendor already, and for the 
>> rest
>> doing everything like I used to do in 1.8. Even unposting and 
>> reposting
>> a bill results in the amount being empty!
>
> What you're doing wrong is not using the same currency.  For every
> currency you do business you need an A/R account, an Income Account,
> and an Asset (Bank) account in that currency.

All this I have in place already, as said, it worked in 1.8 and I'm 
still using the same data (of course). So there's an obvious 
programming difference between 1.8 and 2.x here.

In 1.8, if I posted a bill of EUR 1000 in a HKD A/P account, it would 
end up as HKD 1000 in that account. Nasty, but manageable. I just had 
to make sure to post it in a EUR denominated A/P account. The counter 
account is of course also denominated in EUR.

In 2.x, if I post a bill of EUR 1000 in a EUR A/P account, against a 
EUR expenses account, then it shows up, but with empty amount! And 
that's the problem here. When posting a bill by the way it also often 
automatically adds a "payment forward" - a payment from the A/P to the 
same A/P account (I see two lines), with again empty totals.

Wouter.



More information about the gnucash-user mailing list