Is there any way to get a report showing amounts 'as entered'. That is,
are all foreign transactions converted by those rules in aggregate, or
is there a method for getting the actual converted amounts tallied? (for
example, the exchange rate might vary enough from the beginning of the
report
> On Nov 30, 2023, at 16:40, Derek Atkins wrote:
>
> Even more, the REPORTS only use #2, not #1, to figure out the "value" of
> an account in another currency.
Not exactly. Most reports have a Price Source option that allows you to select
how commodity prices and currency exchange rates are
Hi,
GnuCash stores the exchange rates in two ways:
1) In the transaction, it lets you record the exact conversion.
2) In the priceDB, it lets you input one price per day.
When you enter a transaction like #1, gnucash will automatically create a
pricedb entry for you. In other words, you do NOT
On Thu, 30 Nov 2023 at 20:50, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> As Derek noted, this is likely not a bug, but an issue with your pricedb
> in your main file.
>
> I too lost the plot, and forgot that those reports can target which
> price to use for such cases.
>
> Your
As Derek noted, this is likely not a bug, but an issue with your pricedb
in your main file.
I too lost the plot, and forgot that those reports can target which
price to use for such cases.
Your options then are to:
1. Play with the price target option
2. Edit, or delete the offending
First, yes, that warning is for when you try to delete the *Invoice*,
not the payment. (same for Bills with Vendors)
Second, as you may have noticed, inline images are not possible with
this list, you have to attach them separately. Because of that, if you
can, please give them some
In this data file there is a transaction that converts from 540 to 424.
It sounds like that is correct. My only guess as to the reporting is that
there are PriceDB entries in your real data file that are "incorrect" for
the actual transaction days. In the data file you posted, there is only a
On Thu, 30 Nov 2023 at 12:13, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Apparently so!
>
I have lost the plot I think.
I think there's a bug in the reporting.
Here's a demo account, with the GBP shown correctly for USD sales, but the
value of the USD sales is not given. I
Apparently so!
You can't delete the *invoice* but you can delete the payment.
I don't ever recall anything different and I've been using GnuCash for
10+ years.
Of course, you do get the confirmation for deleting the payment, but it
isn't an error.
Deleting the payment *should* 'unattach'
On Thu, 30 Nov 2023 at 09:18, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Once again - please remember to reply to the list...
>
OOps.
>
> It was several replies up the thread, but I was replying to your point
> about being able to delete payments for only some currencies.
Once again - please remember to reply to the list...
-
It was several replies up the thread, but I was replying to your point
about being able to delete payments for only some currencies. (though
you've now discovered that currency isn't a limitation)
Here was my posting:
Let's get
On Thu, 30 Nov 2023 at 03:48, Alan Hopkins wrote:
>Hello David
>We receive and pay for a multitude of currencies. This made life
>complicated for a small business so we decided to use a FX service - we
>use OFX because we managed to get to them in their early days and were
>
Hello David
We receive and pay for a multitude of currencies. This made life
complicated for a small business so we decided to use a FX service - we
use OFX because we managed to get to them in their early days and were
offered a special continuing deal.
However, there are quite
On Wed, 29 Nov 2023 at 23:35, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Since all of them are of type A/R and this isn't working with your
> current tree arrangement, I'd say you found a bug in the reports. You
> might want to file one and ask if you should separately file the
On 11/29/23 6:05 PM, David Kirkby wrote:
Is it possible, and so how, to move the A/R USD account directly under the
assets and not under the GBP account? When I set up accounts like that, the
P and trial balance agreed with each other.
On the Accounts tab, select that USD account and click the
On Wed, 29 Nov 2023 at 23:28, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> You can set your bank accounts nested however you want. GnuCash doesn't
> care as there is nothing special about such accounts.
>
> Gnucash *does* care about types Accounts Receivable and Accounts
>
Since all of them are of type A/R and this isn't working with your
current tree arrangement, I'd say you found a bug in the reports. You
might want to file one and ask if you should separately file the same
for the others.
When you do so, create and upload a test file with just enough
Receivables and Payables are not tied to each other. So there is no
concern with matching their respective set of currencies. (that is, you
don't need an HKD A/R account if you never receive funds in that
currency for an invoice.)
Regards,
Adrien
On 11/29/23 5:02 PM, David Kirkby wrote:
The
You can set your bank accounts nested however you want. GnuCash doesn't
care as there is nothing special about such accounts.
Gnucash *does* care about types Accounts Receivable and Accounts
Payable. (regardless of what you name them)
But exactly how these should be structured is still to be
On Wed, 29 Nov 2023 at 23:02, David Kirkby
wrote:
> But think about it, the fact one is supposed to set bank accounts that
> way, probably implies one needs to do the same with A/P and A/R.
>
> Dave.
>
I meant to say “thinking about it “ not “think about it “
>
>
>
>
>
On Wed, 29 Nov 2023 at 20:57, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Thanks. I saw that from the bug report.
>
> Please double-check all three of those and make sure they are of 'type'
> "Accounts Receivable".
>
> Regards,
> Adrien
Hi,
I checked and all are accounts
Thanks. I saw that from the bug report.
Please double-check all three of those and make sure they are of 'type'
"Accounts Receivable".
Regards,
Adrien
On 11/29/23 2:47 PM, David Kirkby wrote:
This is what I have. I changed the name of one account, adding "GBP" as you
suggested.
I found the screenshot in your Documentation bug report.
The question of a proper tree still stands, but at least I'm clear that
you *aren't* currently nested one level too deep. (be careful when
trying to transcribe your tree as it appeared you had an extra level in
there!)
Regards,
Adrien
On Wed, 29 Nov 2023 at 20:43, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> Relax, have some more beer. Read over my other replies. And perhaps
> those screenshots I suggested in the other response will clear things up
> for both of us. From what I can tell, you can likely just
On 11/29/23 10:39 AM, David Kirkby wrote:
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
If so, I'd rename it.
It is possible you don't even need it if that is your book currency.
Just stick with the original Assets:Accounts Receivable, but you should
On 11/28/23 3:55 PM, David Kirkby wrote:
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
David, I could be mistaken, but I think this is influencing your
reporting problem. (if the A/P side looks like what you posted below
concerning A/R)
Assets:A/R
On 11/28/23 3:42 PM, David Kirkby wrote:
Make a copy of your book and test out if one of these does the trick by
editing one bill and/or payment accordingly (you might be able to just
re-parent the account(s) though:
Assets:A/R
--Assets:A/R (GBP)
--Assets:A/R (USD)
--Assets:A/R (EUR)
I see
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> If so, I'd rename it.
>
> It is possible you don't even need it if that is your book currency.
> Just stick with the original Assets:Accounts Receivable, but you should
> verify that. (a single currency
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> David, I could be mistaken, but I think this is influencing your
> reporting problem. (if the A/P side looks like what you posted below
> concerning A/R)
>
> Assets:A/R
> --Assets:A/R (GBP)
> --Assets:A/R
Originally I sent this to just to Adrien by mistake. Now sending to the
list.
On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
> David, I could be mistaken, but I think this is influencing your
> reporting problem. (if the A/P side looks like what you
David, I could be mistaken, but I think this is influencing your
reporting problem. (if the A/P side looks like what you posted below
concerning A/R)
I'm hazarding a guess that:
Assets:Accounts Receivable:Accounts Receivable
is in GBP, though you have no indication in the name.
If so, I'd
I'm getting some crazy results things happening in my accounts, in that a
GBP amount of a transaction is not matching the USD amount.
I am wondering what I'm doing wrong. I have my accounts set up like this,
so the USD and EUR accounts are child accounts of the default (GBP)
account. Is that
32 matches
Mail list logo