Local currency column in Transactions – Advanced Queries

1
  • Make main currency A, and foreign currency B
  • Make bank/cash account for each currency
  • Make two expenses as payment (e.x 100A electricity & 100B electricity make exchange rate something other than 1)
  • Make advanced query while on the payment tab
  • Tick (Group By) and select (Accounts)

What happens after this is: 200 Electricity
what should happen is: 100A 100B Electricity or (100+100*exch_rate)A Electricity

2

The business will only report such in the base currency as it should be. Your payments and receipts would either be in currency A or in Currency B and to Customers and Suppliers assigned to either currency A or B.

3

I’m not sure if you understood me correctly.

what the page reports is not in main currency. it just didn’t care about currency and summed them. so if you make 100 usd expense and 100 euro expense, it would show 200 alone. instead of converting euro to usd then summing them

image
image786×311 7.42 KB

image
image794×378 8.99 KB

in the summary, it adds them correctly (100usd + 100eur = 206usd)

image
image764×276 4.39 KB

But not in the grouped query

image
image1362×674 21.7 KB

4

I agree that this is a problem, in Custom Reports we have a separate field for AccountAmount which is used to get amounts in local currencies.

I believe that this is an important feature that should carry over to Advanced Queries especially on Transactions view.

If this field is present as a column, it should solve the issue.

I’m going to place this in ideas and I will change the title accordingly

5

My intention was that Amount column was meant to be in base currency. So that is now fixed in the latest version (24.12.2)

2 Likes
6

Sorry if i’m being impatient. I just installed the latest version 24.12.2.1965 it still has the problem. do you mean the next update?