Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
The Payables Aging Report will tell you the *amount* that is outstanding, and to who, and with an aging time frame, as of the date of the report. Once you have the Payables Aging Report - you know who you owed money to as of that date and how much. To see which bills that entails, you have t

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Not so. Go back and read my replies again. You absolutely can get what you are looking for after the fact. Most accountants just want the total AP number. But if you need to provide it by Vendor, I've given you the steps to get that info. Regards, Adrien On 11/27/23 7:08 PM, David Kirkby wr

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports > Business > Payable Aging Regards, Adrien On 11/27/23 4:58 PM, David Kirkby wrote: [image: image.png] [image: image.png] __

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread David Kirkby
On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Neither of those is an Accounts Payable Aging Report. > > I'm not certain what the first one is. The second is a Transaction Report. > > Go to Reports > Business > Payable Aging > > Regards, > Adrien > If I

Re: [GNC] Setting up an account for stocks

2023-11-28 Thread Fred Bone
Please copy the list on replies. For one thing, this gives other people the chance to come in and help: you could have had further suggestions well before I got to see your message. On 28 November 2023 at 11:41, Max Hilbig said: > Hi Fred, > > Thanks for your response. > > My first email was

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
On 11/28/23 5:34 AM, David Kirkby wrote: On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports > Business > Payable

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-28 Thread Adrien Monteleone
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 re

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread David Kirkby
On Tue, 28 Nov 2023 at 15:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 11/28/23 5:34 AM, David Kirkby wrote: > > > > If I go to Reports > Business > Payable Aging, I just see > > > > > > > > *Payable Ageing - 28/11/2023A/Payable or A/Receivable accounts exist but > > have no

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Weird. Without that bill, do the vendors show but with everything as zero balances? If not, try Options > General > Show zero balance items. If that works and your balances are all zero as of the end of Feb '22, then your A/P as of that date was indeed zero. Any discrepancy otherwise *might*

[GNC] How do I add AP and AR for multiple currencies?

2023-11-28 Thread David Kirkby
Reading https://www.gnucash.org/docs/v5/C/gnucash-guide/currency_manual.html it describes how to set up *banks *for multiple currencies -Assets (USD) -Current Assets (USD) -US Bank (USD) -European Bank (EUR) -HK Bank (HKD) -Equity (USD) -Opening Balances (USD) -USD

Re: [GNC] How do I add AP and AR for multiple currencies?

2023-11-28 Thread Adrien Monteleone
As I noted in the other thread, you might not have to delete any transactions, just re-parent the account(s). In a worst case, you'd have to unpost and repost bills/invoices accordingly if you need to assign some to a different AR/AP account. (you can't delete bills or invoices, but you can de

Re: [GNC] How do I add AP and AR for multiple currencies?

2023-11-28 Thread David Kirkby
Well against my own advice, and submitted the lack of documentation as a bug. https://bugs.gnucash.org/show_bug.cgi?id=799146 I'm not going to say there's a bug in the reports, as the problem might be my errors. But without details on handling AR and AP in the documentation, errors are likely to

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-28 Thread David Kirkby
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 poste

[GNC] closing accounts

2023-11-28 Thread Elmar
How do you actually CLOSE but not delete an account, so that no new transactions can ever be posted to it, i.e. mark it as read only? GC keeps stuffing things automatched some way to the closed accounts.  How can I flag that account as unavailable? - elmar _

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-28 Thread David Kirkby
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 (U

Re: [GNC] closing accounts

2023-11-28 Thread Stan Brown (using GC 4.14)
Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2023-11-28 13:51, Elmar wrote: > How do you actually CLOSE but not delete an account, so that no new > transactions can ever be posted to it, i.e. mark it as read only? Yes, that's right. The GnuCash word for a read-only account is a Place

Re: [GNC] closing accounts

2023-11-28 Thread Murugan Muruganandam
mark the account as place holder, which will stop transactions to be entered Saludos Cordiales Murugan From: gnucash-user on behalf of Elmar Sent: Tuesday, November 28, 2023 6:51 PM To: gnucash-user@gnucash.org Subject: [GNC] closing accounts How do you

Re: [GNC] closing accounts

2023-11-28 Thread Elmar Schmeisser
Thank you! Perfect! On Tue, Nov 28, 2023, 5:25 PM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > mark the account as place holder, which will stop transactions to be > entered > > > > Saludos Cordiales > > > Murugan > -- > *From:* gnucash-user hotmail...

[GNC] Issues with missing gnc-fq-dump

2023-11-28 Thread Robin Haeusler via gnucash-user
g'day. trying to setup Gnucash on my Debian Linux system. Installed and working fine, but now need to start tracking crypto currency trading and earnings/losses. I have followed the manual, can get gnc-fq-update to work, but not gnc-fq-dump can't find it installed anywhere. I work with aud as

Re: [GNC] Issues with missing gnc-fq-dump

2023-11-28 Thread David H
>From the 5.0 release notes The Online Quotes facility has been completely rewritten and the old gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with finance-quote-wrapper. The functions performed by those programs may now be accomplished by passing commands to gnucash