[GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
Hello, Gnucash 4.11 Windows 10 Having struggled once again with the extremely unreliable aspects of the Lots Manager, I am resigned to the fact that, while an admirable endeavor in concept, the Lots Manager is more trouble than it is worth, and leads to books that cannot be considered accurat

Re: [GNC] gnucash in tandem with SuiteCRM or other CRMs

2022-12-04 Thread david whiting
I don't use a CRM with Gnucash, but you might be able to achieve what you need - it depends on what you mean exactly by "keeping customer contacts/accounts up to date". Do you mean: 1. Adding customers to the CRM, 2. Importing them into gnucash so that you have the same customers in your

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David Carlson
David, IIRC for databases that have never had the lots functionality enabled, it remains disabled. This leads to the hope that it would be possible to disable it, but that may or may not work. At least, in my case I never enabled it outside of one dedicated test case and it seems to remain dis

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
David, Lots get activated on an account by account basis; in any given account, you open the View Lots window and either create/assign lots manually or "Scrub" an account to have GnuCash automatically assign your shares to lots. Over the years, I've opted to implement the lots on a substantial

[GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Scott Traurig
Hi all: New user questions follow, I'm afraid... I have no trouble following the directions in the wiki for migrating from Quicken. I made the QIF file, imported it into GnuCash, and watched it very unhelpfully create 100 different accounts. The instructions do mentions this, and it's ability to

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Fross, Michael
Hi Scott, This took some getting used to when I moved from Quicken 7 years or so ago. The categories become accounts. This is required for double entry accounting and makes sense. When you pay your electric bill, money moves from checking to the electric company. GNUCash has to show money movi

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Ken Pyzik
Scott -- Forgive me if I misinterpreted your request -- but if I am reading it correctly, what you describing is not in line with the way GNU-Cash works. You see GNU-cash works as a double-entry (two-sided) accounting system. What that means is that for every transaction - there must be an op

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Ken Farley
This is a common concern whenever someone (including me) is migrating to Gnucash. As is noted elsewhere, it's a conceptual change based on Quicken Category => Gnucash Account. What I realized when I converted years and years of data over is just how terrible I was at maintaining some sort of co

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Scott Traurig
I do understand double-entry accounting and that it is the GnuCash paradigm. What I didn't understand is that on the import GnuCash did create the requisite checking account, plus all the expense accounts. I did not see the checking account as it was lost in a sea of expense accounts. Now that I'

Re: [GNC] Stock spinoff

2022-12-04 Thread john
Companies used to send shareholders a letter stating the relative valuations of the spun off and original shares, but the last couple of spinoffs I've had they instead posted it on the original company's website and I had to Google for it. In some cases you might have to find the SEC filing for

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Keld Sorensen
An easy way to "move" many entries is to *delete* the offending account and let GnuCash move it to another account. Say you have utilities:water as an account but also utilities:Watercompany. Then you simply delete one and ask GnuCash to move all transactions to the other. All in one fell swoop.

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Fred Bone
On 04 December 2022 at 11:54, Scott Traurig said: > I do understand double-entry accounting and that it is the GnuCash > paradigm. > > What I didn't understand is that on the import GnuCash did create the > requisite checking account, plus all the expense accounts. I did not see > the checking ac

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Scott Traurig
Nope, sorry, you gents did not understand my question. I don't have any unwanted accounts. Indeed, all of my categories in Quicken were well thought out and organized, and well replicated as separate expense accounts in GnuCash via the import process. But with some 100 different, well organized a

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread Adrien Monteleone
If I understand correctly, the AR & AP accounts use them to track links between payments and bills/invoices. If you don't use the Business Features, then those two shouldn't be an issue. I'm not so sure simply using View Lots is how they are activated for an account. Some accounts have none an

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread David Carlson
Scott, If I understand correctly, what you expected was a chart of accounts with one asset account for checking and all other accounts lumped under expenses. Maybe one account for income. You should be able to get to that result with an import from Quicken but it may take some or perhaps a lot

[GNC] Is there a way to change font and font size (Windows 10 and 11)?

2022-12-04 Thread Scott Traurig
I found this wiki entry: https://wiki.gnucash.org/wiki/GTK3 And I found this directory: C:\Users\my-user-name\AppData\Local\gtk-3.0 I created the settings.ini file as shown in the wiki and set the new font definition. But no changes are evident when I restart GnuCash. Is there any way to do th

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Scott Traurig
That was the politest "No, you are stuck doing it manually" response I've ever seen ;-) Thanks, Scott On Sun, Dec 4, 2022 at 1:25 PM David Carlson wrote: > Scott, > > If I understand correctly, what you expected was a chart of accounts with > one asset account for checking and all other accoun

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Adrien Monteleone
Let's get this cleared up: You're telling us that *all* of your expense accounts are *not* under the top-level 'Expenses' account but exist as each their own top-level account? (but maybe of 'type' Expense) If so, that sounds like an error (I'll hazard, user) in the import. The easiest thing

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread David Carlson
What you need to do is start a new file and position those expenses correctly under the the top expense level during the import process. That is not really very hard with a couple of expendable tries to see how it works. On Sun, Dec 4, 2022, 12:17 PM Scott Traurig wrote: > Nope, sorry, you ge

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread Scott Traurig
So I did the import wrong. Crap. Too late, I already gutted it out and manually rearranged it all! Thanks, Scott >> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
Adrien, I don't know anything about the business features. My statement regarding lot activation wasn't clear; you must open the Lot Manager *AND* create lots-- either manually, or by using the scrub feature. ⁣David T. ​ On Dec 4, 2022, 9:22 PM, at 9:22 PM, Adrien Monteleone wrote: >If I u

Re: [GNC] Is there a way to change font and font size (Windows 10 and 11)?

2022-12-04 Thread David H
Scott, The following works for me on Win10 and is in C:\Users\\AppData\Roaming\GnuCash\gtk-3.0.css . I assume you're using Gnucash 4.12 ??? Cheers David H. /* This is an example GTK CSS file that can be used with Gnucash. Simply copy this file to the location specified below according

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread David Cousens
Scott You can edit the accounts and in the dialoguechange the account type to Expense and the parent to the top level expenses account.Unfortunately its a one at a time operation David Cousens On Sun, 2022-12-04 at 13:39 -0500, Scott Traurig wrote: > So I did the import wrong. Crap. Too late, I

[GNC] searching for inventory tags -- bind keys -- best ways

2022-12-04 Thread John Griessen
I buy and sell things, tracking the cost of goods sold, and each item or quantity of identical items gets an alphanumeric tag Like CCB, CCD, CCD, etc. After I make a sale with an invoice I sometimes do several more sales, then expense cost of goods sold for all of them. I put the inventory tag

Re: [GNC] Is there a way to change font and font size (Windows 10 and 11)?

2022-12-04 Thread Scott Traurig
This worked, David, thank you. Scott On Sun, Dec 4, 2022 at 2:35 PM David H wrote: > Scott, > > The following works for me on Win10 and is in C:\Users\ name>\AppData\Roaming\GnuCash\gtk-3.0.css . > > I assume you're using Gnucash 4.12 ??? > > Cheers David H. > > /* This is an example GTK C

[GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
GnuCash 4.12 on Windows 10 Pro. I was rearranging the sizes of the columns in one of the account ledgers and now both the Transfer and Reconcile ("R") column labels are gone. No amount of rearranging or double clicking of columns is bringing those labels back. This is affecting ALL accounts. I

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
Adding to this: I installed on another Windows machine and the account (.gnucash) file is 100% fine. The missing column labels are not missing on the new machine. So somewhere on my main PC resides a file or registry entry that is NOT removed by Windows uninstall that is causing the problem in a p

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread David H
You have shrunk those columns down to nothing and very carefully need to drag right to open them up again - happens now and then. First you need to remember where they are, difficult to see but they may be a little wider than the other column markers? Or you could just delete the prefs for that f

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Stan Brown
On 2022-12-04 13:06, Scott Traurig wrote: > GnuCash 4.12 on Windows 10 Pro. > > I was rearranging the sizes of the columns in one of the account > ledgers and now both the Transfer and Reconcile ("R") column labels > are gone. As you might expect, yours is a Frequently Asked Question. You'll w

Re: [GNC] [GNC-dev] Missing column header labels after resizing columns (Windows 10, GC version 4.12)

2022-12-04 Thread john
That's a user-list question. I've changed the CC for your convenience. The file you're looking for is the book's metadata file, see https://wiki.gnucash.org/wiki/Metadata_File. It stores among other things window sizes and column widths for registers. Regards, John Ralls > On Dec 4, 2022, at

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
Stan, That FAQ entry looked promising, but it does not solve the problem. There are no entries in the .gcm file showing zero width to edit. Worse, uninstalling GnuCash and deleting the entire C:\Users\my user name\AppData\Roaming\GnuCash directory, including all .gcm files such that they would be

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread David H
There are also settings in the Registry ? Cheers David H. On Mon, 5 Dec 2022, 10:00 am Scott Traurig, wrote: > Stan, > > That FAQ entry looked promising, but it does not solve the problem. There > are no entries in the .gcm file showing zero width to edit. > > Worse, uninstalling GnuCash and de

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
Can you point me to them? Thanks, Scott On Sun, Dec 4, 2022 at 7:11 PM David H wrote: > There are also settings in the Registry ? > > Cheers David H. > > On Mon, 5 Dec 2022, 10:00 am Scott Traurig, > wrote: > >> Stan, >> >> That FAQ entry looked promising, but it does not solve the problem.

[GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread Steve Thompson
Hi all and forgive me if this has been asked and answered before. I'm trying to get used to this particular list server and how it functions and my search didn't seem to return what I thought it should. I was trying to migrate from Linux (Suse Leap 15.3) to Windows 11. I'm being forced into t

Re: [GNC] Stock spinoff

2022-12-04 Thread Fred Tydeman
The company says that they will post an IRS Form 8937 later this week with the information. On Sat, Dec 3, 2022 at 6:48 PM Geoff wrote: > Hi Fred > > First up you need more details on this transaction to determine the > exact nature of the spin-off, the valuations, and whether ABC treated it > a

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Glenn Fowler
Hi, did you look in the "books" folder? C:\Users\\AppData\Roaming\GnuCash\books Each book will have it's own .gcm file In it, the columns will be something like this: date_width=177 num_width=74 reconcile_width=239 balance_width=140 transfer_width=318 debit_width=140 credit_width=140 On Sun, D

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
That approach failed, Glenn. Please read my email chain and you'll see that. On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote: > Hi, did you look in the "books" folder? > > C:\Users\\AppData\Roaming\GnuCash\books > > Each book will have it's own .gcm file > > In it, the columns will be something

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread Ken Farley
I'm using Gnucash on MacOS and under the menu there is File->Export which has options to export: Account Tree to CSV Transactions to CSV Active Register to CSV Accounts But to be honest, if you want to migrate to another system, you could look here: https://lists.gnucash.org/docs/C/gnuca

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread David H
Home after a bus ride and now able to take a look. Glenn is correct, that is indeed where the preferences for GnuCash are in Win 10 Pro - it's in the C:\Users\AppData\Roaming\GnuCash\books folder and is called whatever you saved your file as eg x.gnucash.gcm. Deleting or renaming the file in

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread Glenn Fowler
Hi Steve, The data file is cross platform. You can simply copy it to a USB and put it in your new computer and it will work. From: gnucash-user on behalf of Steve Thompson Sent: Sunday, December 4, 2022 8:24 PM To: gnucash-user@gnucash.org Subject: [GNC] Why d

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Glenn Fowler
Sorry for the confusion, my reply went out before the POP3 timer pulled down new messages. Have you tried Help -> About ? There are now filepath links there in the latest version but I'm not sure if it changes if your paths are not the default. On Sun, Dec 4, 2022 at 8:44 PM Scott Traurig wrote:

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread David H
All you need to do is copy your data file to another machine so you don't need an export function just Ctrl/Cmd-C Ctrl/Cmd-V. I quite happily copy/sync Data file / Saved Reports/ Preferences between MacOS, Win 10 Pro, Win 11, Ubuntu. See the wiki entry re migrating to another pc for more detail

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread David H
Steve you might want to read https://wiki.gnucash.org/wiki/Backup ... Cheers David H. On Mon, 5 Dec 2022 at 12:19, David H wrote: > All you need to do is copy your data file to another machine so you don't > need an export function just Ctrl/Cmd-C Ctrl/Cmd-V. I quite happily > copy/sync Data

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread David H
Sorry, looks like that's a left click on the separator, right click tends to display the context menu :-) Cheers David H. On Mon, 5 Dec 2022 at 12:13, David H wrote: > Home after a bus ride and now able to take a look. Glenn is correct, that > is indeed where the preferences for GnuCash are i

Re: [GNC] Colum headers missing on all accounts

2022-12-04 Thread Scott Traurig
Respectfully, some of you are not reading my emails ;-) ;-) The .gcm file is not, repeat not, the problem in this case. This is a new bug that is not covered by the FAQ. Proof: I was just able to solve the problem a few minutes ago by deleting the registry information under HKEY_CURRENT_USER/soft

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-04 Thread Michael or Penny Novack
But, to the question, now that we have covered the problem that brought me to this question: Why doesn't GnuCash have an export functions so that one can more easily migrate from one computer system to another? Because the DATA is not dependent on the computer. This is NOT different from ot

Re: [GNC] searching for inventory tags -- bind keys -- best ways

2022-12-04 Thread Adrien Monteleone
I would absolutely *not* edit directly in AR. (I'm surprised they are even editable) If you want to change them, you need to unpost the invoice, edit, then repost. Any changes you make otherwise might cause havoc. If you do not 'consolidate splits on posting' (that's a per invoice or book-w