Re: [GNC] Exporting Data

2021-12-30 Thread Rogier F. van Vlissingen
Yes, that worked. Thinking back, I believe I did that originally when I did it the first time in v3.8. Now I wonder why it took me so long to figure it out again, but this is the way to go, one single opening split transaction and that makes it work, and if you mess up the difference will show up

[GNC] Help with Install Finance::Quote

2021-12-30 Thread kb1912 via gnucash-user
I have installed the finance::quote tool, but still get the "warning: Finance::quote not properly installed" message in the security editor screen, and everything is greyed out. Any tips? Thanks, Kiel Sent with [ProtonMail](https://protonmail.com/) Secure Email.

Re: [GNC] Exporting Data

2021-12-30 Thread Stephen M. Butler
I have never used the opening balances from the wizard.  I setup the COA and then enter one multi-split transaction to load all the balances as the first transaction in the file.  Looks like you would only have 8 splits (I have 30-50 in my initial transaction).  Since the transaction balances a

Re: [GNC] Exporting Data

2021-12-30 Thread Rogier F. van Vlissingen
in the 3.8 version I had: My Opening balances transaction on 1/1/20 was Debit Credit Assets: Current Assets Checking:$A Assets: Current Assets Advance/Loan:$B Equity: Opening Balances: $C Equity

Re: [GNC] Exporting Data

2021-12-30 Thread Adrien Monteleone
There is nothing special about opening balances. They are just regular transactions that the fresh start wizard makes for you. You should be able to edit those transactions just like any other. But I don't understand what the problem is. Even the Retained Earnings account would have an 'openin

Re: [GNC] Cannot select A/P Account to post Bill to

2021-12-30 Thread Mattia Rizzolo
On Thu, Dec 30, 2021 at 10:06:56PM +0100, Sebastian Naumann wrote: > And of course you're right. I had classified it as a "Liability", which, in > my opinion, might be setup a little confusing. Well, A/P is a type of liability anyway. And it should be under the bigger "Libility" parent account in

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread John Ralls
Maybe what you're missing is that Opening Balances accounts are created as placeholders by the Hierarchy Assistant. Before you can create the balancing transaction you must select the account on the Accounts page, click the Edit button in the toolbar, clear the Placeholder checkbox, and click OK

Re: [GNC] Cannot select A/P Account to post Bill to

2021-12-30 Thread Sebastian Naumann
Hi Mattia, thanks for the quick response. And of course you're right. I had classified it as a "Liability", which, in my opinion, might be setup a little confusing. Thanks a lot :) Am 12/30/21 um 9:38 PM schrieb Mattia Rizzolo: On Thu, Dec 30, 2021 at 05:59:47PM +0100, Sebastian Naumann wro

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread Rogier F. van Vlissingen
I am sitting here trying that, but in the setup, when you edit the accounts, it only allows posting of the entire account to "opening balances." I can't see a way to split it and put the appropriate amount in Retained Earnings. In the 3.8 version I was able to somehow correct the balances, I believ

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread Rogier F. van Vlissingen
It happens to be a loss. I seem to be missing something. For all the other accounts, I simply post to the account with the balancing transaction going to Opening Balances. But because of what I described, I get Opening Balances $x and Retained Earnings $0. Nothing I can think of gets the money fro

Re: [GNC] Cannot select A/P Account to post Bill to

2021-12-30 Thread Mattia Rizzolo
On Thu, Dec 30, 2021 at 05:59:47PM +0100, Sebastian Naumann wrote: > I wanted to test out GnuCash, including posting a bill. > > Unfortunately, I am unable to select an A/P Account to post the bill to. The > dropdown in the post modal is simply blank. > > If I try creating a new account via the "

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread Rogier F. van Vlissingen
Thanks, I do not get it. I can set up all the opening balances, except one retained earnings. To me retained earnings on 1/1/2020 is the accumulated position from prior years, I do not see how I can finagle that via what sub accounts. Evidently, when I set up the opening transaction, which is fairl

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread davidcousens49
Rogier When you transfer account to a new set of books, you would record the opening balances of the Asset and Liability accounts against the Opening balances entries in Equity. Asset entries will be a debit to the asset account and a credit to the opening balances account and Liabilities a cre

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread rmomxtx
David, All of my scheduled transactions are set to be created on or about the 1st of the month so the balances show what I can count on for the month. Works best for me. On occasion, when I get paid early, I would just post the income early, on the day it is received. It’s really just my Arm

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread rmomxtx
Thanks Gyle, What I was trying to communicate is that I already use the create in advance function. Works better for me to set all of my scheduled transactions to create up to 25 days or more in advance. They all post on or about the 1st. Except for a little inconvenience, I can’t think of a goo

[GNC] Cannot select A/P Account to post Bill to

2021-12-30 Thread Sebastian Naumann
Hi GnuCash Community, hopefully all are well. I wanted to test out GnuCash, including posting a bill. Unfortunately, I am unable to select an A/P Account to post the bill to. The dropdown in the post modal is simply blank. If I try creating a new account via the "NEW" button, everything work

Re: [GNC] Question on opening files

2021-12-30 Thread Gyle McCollam
He was referring to the Windows 10/11 icon. If you right-click on the gnucash icon, you should see 3 options: Gnucash, unpin from taskbar, and close all windows. Then, if you right-click on the Gnucash, the last option should be "properties". Left Click properties. In the Gnucash properties

Re: [GNC] Question on opening files

2021-12-30 Thread Charles Vincent
Thanks. Some files open without problems but some do not. Which properties are you referring to? In gnucash or generally ? Charles VINCENT Membre fondateur et ancien président du Conseil d'Administration Ecole Française de Battambang +33 6 7082 0475 (Mobile & WhattsApp) +855 12 635612 (Telegram)

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread Gyle McCollam
Rodger, Even though I agree with your initial premise that it would be good to be able to select a scheduled transaction and post it early without actually editing the scheduled transaction, I have found that the create in advance function works very well as an alternative. In my earlier email,

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread Robin Chattopadhyay
This was my thought also. If you don't want the scheduled transaction to be created in advance every month, then leave it set to zero. When you do want to create early, change the create-in-advance value to a large enough value that it will create today, run the scheduled transactions, and then ad

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread D. via gnucash-user
Roger, I still don't understand. If you set your scheduled transactions to be created 45 days in advance, then your January 1, 2022 transaction will be created in mid-November (with a date of 01-01-2022), and you can change its date directly in the register at any point after that. Why is th

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread rmomxtx
Thanks Steve, Kind of what I suspected. All my scheduled transactions are set to post on the 1st of the month regardless of the date posted. Not worth the trouble to do more than that for an occasional early payment. Yes, it would be a nice feature that isn't essential and probably not worth

Re: [GNC] Exporting Data

2021-12-30 Thread Rogier F. van Vlissingen
Hi, thanks sofar, I have tried literally everything along those lines, and nothing is doing it, and at this point it is all about ending with everything right, since I need to do 2021 urgently. My good luck is that this is about a business that was more or less dormant for a while, so, I can do th

Re: [GNC] 4.9 account set up of going business

2021-12-30 Thread Rogier F. van Vlissingen
Yeah, thanks. I am on mint, and it has version 3.8. I was able to do something like that in version 3.8. However, I had some problems with it, and moved to 4.9 now because of some other problems, but now I can't do this, and that sort of kills the fun. Let's see if someone comes up with a better s

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-30 Thread Liz
On Wed, 29 Dec 2021 13:00:30 + "Dr. David Kirkby" wrote: > If the invoice can not be deleted before posting, that would probably > mean it is unsuitable for use in the UK, as I believe invoice numbers > have to be created sequentially. One should *not* have invoice > numbers of 1, 2, 4, 7 et