Re: [GNC] save as sqlite3 error
Thank you all. Someone last night pointed me to the trace file. I tried to
save as sqlite3, failed then closed down. The last lines are as follows:
* 17:59:21 ERROR gboolean qof_book_is_readonly(const QofBook*):
assertion 'book != NULL' failed
* 17:59:26 ERROR [error_handler()] DBI error: 19: NOT NULL
constraint failed: splits.memo
* 17:59:26 ERROR
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL INSERT
INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
17:57:12',46353,100,46353,100)
* 17:59:26 ERROR
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom)
VALUES('[xxx]','[xxy]','[xxz]',NULL,'','c','2021-01-24
17:57:12',46353,100,46353,100)
I am not sure how to look for transactions via the guid_tx, but I searched for
463.53. I was then shown a split transaction view of a transaction that was
put into the imbalance account. The description was “NULL” where the rectangle
is in the attached. Some of my other imbalance entries had this entry, some
did not. So I removed them all and now it writes.
I don't believe I put these “NULL”s in, I think gnucash did it so might be
something to look into.
Not sure if you saw my other question – can import securities (not the security
transactions) or can I only add them via the GUI?
Many Thanks
Sent from Mail for Windows
From: Geoff
Sent: 20 October 2021 04:29
To: David Carlson
Cc: Public Address;
gnucash-user@gnucash.org
Subject: Re: [GNC] save as sqlite3 error
Good pickup David - Thunderbird dropped the attachment, but I can see it
via Gmail {:--(
Not that it helps much PA, as John said, please check the trace file.
Geoff
=
On 20/10/2021 2:04 pm, David Carlson wrote:
> It is odd that PA's screenshot made it to my Gmail account in Windows OS
> when it did not get to Geoff's email client, or maybe it did but Geoff
> did not see it because for some reason there was an inline link as well
> as an attachment at the end. In either case I cannot comment on the
> sqlite issue as I have no experience with that. Did I see an email
> elsewhere suggesting that sometimes an incorrect version of some library
> program was incorrectly selected by the installation program?
>
> On Tue, Oct 19, 2021 at 8:16 PM Geoff > wrote:
>
> Hi PA
>
> I can't help you with this error except to say that I am running on the
> same build on Windows 10 and cannot reproduce your problem. BUT I do
> not have Trading Accounts switched on.
>
> I successfully saved a 35MB XML file to SQLite and can access that file
> in both GnuCash and the SQLite DB Browser. See attached screenshot.
>
> (Your screenshot didn't come through - try attaching instead of
> pasting).
>
> Have you tried debugging: https://wiki.gnucash.org/wiki/Logging
>
>
> Start gnucash.exe from the command line with the "--debug" switch. In
> my case, the log files are called gnucash.traceXX.log in
> ~\AppData\Local\Temp
>
> Being Windows, perhaps a reboot may help?
>
> Good luck.
>
> Regards
>
> Geoff
> =
>
> On 19/10/2021 6:27 pm, Public Address wrote:
> > Hi - In xml format
> >
> > Trying to save as sqlite3 getting error when file gets to 213kb.
> Plenty of room on disk. I have tried different drives, different
> filenames no luck.
> >
> > [cid:image001.png@01D7C4C2.F1FEDBF0]
> >
> >
> > Many thanks
> >
> > Windows 10
> > GNU 4.8
> > Build ID 4.8a+ (2021-09-28)
> > Finance::Quote 1.49
> >
> > Trading Accounts: on
> >
> > Sent from Mail > for Windows
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
> for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > ___
Re: [GNC] how to link an expense (a tax) to a invoice being issued
Mattia, When you purchase tax stamps in advance, they become a temporary asset of your business which you would expense at the time you attach then to an invoice.when you purchase the stamps you would credit your bank account by the amount of the purchase and debit an appropriate asset account (e.g. Asset:Current:TaxStampsPrepaid). If you don't pass the tax onto the customer it won't appear as a line item in the invoice and simply becomes an expense on your business. You would at the same time as you raise the invoice and attach the tax stamp create a transaction which credits the above asset account and debits an Expense:TaxPaid account. If you are passing it on to the customerthen create a secondline in the invoice, Add an appropriate description,set the Income account to Asset:Current:TaxStampsPrepaid and set the amount of the attached tax stamp. This will add the value of the tax stamp to the A/R account and credit Asset:Current:TaxStampsPrepaid On the other hand when you raise an electronic invoice and payment is deferred to a future date, then the tax component is a liability on your business which you would record inan account labelled something like Liabilities:TaxPayableDeferred. Again if your business is paying the tax and it is not being passed onto the customer then in parallel to raising the customer invoice you would create a separate transaction which credits Liabilities:TaxPayableDeferred and debits an expense account Expense:TaxPaid and there would be no line item in the invoice to the customer. If you are passing the tax onto the customer, then when you raise the invoice you add a second line for the tax , set the Income Account to your Liabilities:TaxPayableDeferred account and enter the amount of the tax payable in that line. This will create a credit to the Liabilities:TaxPayableDeferred account with a matching debit added to the sum of the other lines to the A/R account. Wehn your tax liability is paid your check account is credited by the total of the amount paid and the Liabilities:TaxPayableDeferred account is debited by the same amount. This is of course a generic treatment and may be altered by specific regulations and law which may apply in your jurisdiction. David Cousens On Fri, 2021-10-22 at 00:01 +0200, Mattia Rizzolo wrote: > Hi people! > > With the disclaimer that I'm keeping these books for myself, as I'm not > required by law to keep them at all, here I come ask you about this > specific tax. > > Also, this turned quite longer than I thought it would, actually while > writing my thoughts cleared quite a bit... :) Guess that's a kind of > "rubber duck debugging"! > For the quicker version go straight to below where I describe my case in > way more practical terms. > > > > Background: > When I issue an invoice I may (or may not) have to pay a 2€ duty stamp > and attach it to the invoice. That's an effect specific to the fact > that I produced a document, and I also need to attach such duty stamp > to credit notes, for example. > Now, if I do a paper invoice, I most likely already bought weeks/months > prior a stash of those duty stamps. Instead, if I'm doing an electronic > invoice, the payment for those stamp is deferred to the next quarter. > Furthermore, I may or may not (my choice) bill the customer for the > expense of this duty stamp. > > So I am a bit lost on how to properly account for this thing. To me is > an expense, that may or may not be charged back to the customer, but I > would also like to gather data on, like, how many invoices I'm issuing > that I am not billing the duty stamp on, so I wouldn't like to "hide" > them into some random expense/income account. > The different methods of actual payment of them (in advance or > postponed) surely doesn't help make it straightforward. > > Probably the hardest part is that I would really like to tie the expense > to each invoice. I have no clue if there even is a way to do that, but > it doesn't seem like there is one. Handling invoices through the > GnuCash invoice system makes it impossible to me to add random splits, > is there even a chance I could do this? > If not, guess I would be stuck creating a separate transaction manually > each time I issue an invoice. (in the below examples, I'm referring > specifically to the two splits that invoice Expenses:Tax:DutyStamps) and > simply "linking" that expense to the invoice by the memo field. > > > > > > To clarify and recap, here was my thinking: > > > 1. The accounts (simplified naming, I have a deeper tree): > Balance >Assets:Banks:Checking500.00 >Assets:Cash 50.00 >Assets:AR 0.- >Expenses:Tax:DutyStamps0.- >Income:Invoices0.- >Liabilities:Tax:DutyStamps:Pre 2.00- >Liabilities:Tax:DutyStamps:Post0.- > >I decided to separate the Pre and Post variant of duty stamps
Re: [GNC] Imbalance on Fixed Income Transaction
Thanks to Mattia and Steve (et all), Not only have I re-classified the FI1 and FI2 streams as "Assets", but since I didn't think "Current Assets" was quite a correct title, I created another asset category of "Recurring Assets" and moved FI1 and FI2 into that category. No more 'Imbalance'... And I have rescheduled recurring transactions for both of those assets. Does anyone see any kind of problem that might surface from that process ? Thanks -n- 73 Bruce KB6LWN ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Imbalance on Fixed Income Transaction
Thank you to Mattia and Steve, I have re-classified FI1 and FI2 as "Assets" rather than "Income", and it's beginning to make some logical sense to me (again). I've likely forgotten most of what I ever learned about bookkeeping, even knowing whether or not that is a hyphenated word... The General Account looks much better now. Couldn't figure out where the faucet was. In other words, I found out how to dump money IN, now all I have to do is find some to 'dump in'. Thanks for your input fellows... Got me thinking back on track... Btw, Steve.. 73 fm KB6LWN Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Imbalance on Fixed Income Transaction
Hi Bruce It is a formal requirement in double entry accounting theory that the sum of the debit entries/splits for a transaction should equal the sum of the credit entries or splits. Most transactions only have two splits but in the entry of transactions with more than two splits if you enter a transaction (pressing the enter key) GnuCash will assign any imbalance in these sums for the transaction to an imbalance account in the currency (and generate that account if it doees not exist. The purpose of this is to alert you that an unbalanced transaction has been entered and by how much it is unbalanced. Any non-zero balance in an Imbalance account is an indication that a transaction is in error or incomplete and unbalanced. The transaction entry to the Imbalance account enforces that formal accounting requirement for the transaction, even though it has been entered unbalanced. This can generally be fixed by viewing the transaction from any register but most usefully from the Imbalance account register and altering the destination account for the split from the Imbalance account to an appropriate account in your CoA. The transaction split to the Imbalance account will then disappear and its balance should return to 0. When entering transactions with more than two entries/splits if you use the tab key to get to a new line to enter the next split in the transaction, not the enter key, you should not encounter this problem. "Orphan" accounts perform a similar function when an account is deleted without reassigning all transaction splits to that account to another account before deleting the account. David Cousens On Thu, 2021-10-21 at 23:44 +0200, Bruce wrote: > Just setting up GnuCash 3.8b+(2019-12-29) for the first time > on an HP EliteDesk 800 G1 running LinuxMint v20.02 Cinnamon. > And yes, I've had Bookkeeping-101 in College, 40+ yrs ago. > And it was processed by an IBM 360 Mainframe. > > What I'm not understanding is the basics behind the "Imbalance" result. > I have set up all the top level accounts, and then added FI1 and FI2 (Fixed > Income 1&2) as subs below the 'Income' top level account. > > My two FI's come in at different times, one on the first of each month, the > other on the Second Wednesday, which I will eventually want to set up > recurring automatic transactions for those two sources (which I basically > already have figured out). > > After opening the register (ledger) for FI1 and entering a transaction for > that allotment, lets say $1000.00 and saving it, then opening the transaction > register for account FI2, and doing the same, for the same amount and saving > that... The main top level account page shows a total income of $2000.00, > which is correct and I understand, but directly above that is the "Imbalance- > USD" line, and if each transaction is once again opened each shows an > 'Imbalance' for the Transfer field in the amount of the transaction. > > I have reconciled both of these transactions basically meaning that I have > seen proof that the transaction occurred by statement or by funds-in-hand and > ticked the "R" box in the respective line, which changed to a "c", and is now > a "y". But the 'Imbalance' notice remains and the amount does not change. > > Once the transactions are reconciled, should not the imbalance go away ? > > I realize the answer to this is likely a simple one, > but it is alluding me at the moment, input appreciated. > > And lastly... Is it advisable to update to v4.8 under Mint ? > I notice that the doc page says it should be available through the 'Software > Center' on Ubuntu, but I just installed THIS version (3.8) from the Mint > 'Software Manager', and I'm limited to Cellular downloads at the moment, so > I'd rather not do the 800+MB FlatHub (which is v4.8). > > Bruce > (just another old retired Vet trying to keep his funds straight) > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Imbalance on Fixed Income Transaction
Hi Bruce! I believe you are missing something foundamental on how double-entry bookkeeping works. Every time you make a change to one account (in your case FI1 and FI2) there *need* to be another corresponding and opposite change to another. In your case, that's likely means some kind of checking account. If you write nothing there and just press return, GnuCash will automatically match whatever is not matched already to an "Imbalance" account, which collects all kind of splits that weren't properly assigned. More practically, you are using the "basic ledger" that means that you'll have to move on where "Imbalance-USD" is and change it to, say, Assets:Banks:Checking or somesuch, depending on where the money actually went. You should probably have a look at the manual at https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-accounting1.html to have a better idea on how that should work. Reconciling doesn't really help for that, since that really should only be used for things like checking if your account transactions match what your bank think it should be and is not going to re-assign splits to other accounts on its own. Hope to have been of help! On Thu, Oct 21, 2021 at 11:44:00PM +0200, Bruce wrote: > Just setting up GnuCash 3.8b+(2019-12-29) for the first time > on an HP EliteDesk 800 G1 running LinuxMint v20.02 Cinnamon. > And yes, I've had Bookkeeping-101 in College, 40+ yrs ago. > And it was processed by an IBM 360 Mainframe. > > What I'm not understanding is the basics behind the "Imbalance" result. > I have set up all the top level accounts, and then added FI1 and FI2 (Fixed > Income 1&2) as subs below the 'Income' top level account. > > My two FI's come in at different times, one on the first of each month, the > other on the Second Wednesday, which I will eventually want to set up > recurring automatic transactions for those two sources (which I basically > already have figured out). > > After opening the register (ledger) for FI1 and entering a transaction for > that allotment, lets say $1000.00 and saving it, then opening the transaction > register for account FI2, and doing the same, for the same amount and saving > that... The main top level account page shows a total income of $2000.00, > which is correct and I understand, but directly above that is the > "Imbalance-USD" line, and if each transaction is once again opened each shows > an 'Imbalance' for the Transfer field in the amount of the transaction. > > I have reconciled both of these transactions basically meaning that I have > seen proof that the transaction occurred by statement or by funds-in-hand and > ticked the "R" box in the respective line, which changed to a "c", and is now > a "y". But the 'Imbalance' notice remains and the amount does not change. > > Once the transactions are reconciled, should not the imbalance go away ? > > I realize the answer to this is likely a simple one, > but it is alluding me at the moment, input appreciated. > > And lastly... Is it advisable to update to v4.8 under Mint ? > I notice that the doc page says it should be available through the 'Software > Center' on Ubuntu, but I just installed THIS version (3.8) from the Mint > 'Software Manager', and I'm limited to Cellular downloads at the moment, so > I'd rather not do the 800+MB FlatHub (which is v4.8). > > Bruce > (just another old retired Vet trying to keep his funds straight) > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `- signature.asc Description: PGP signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] how to link an expense (a tax) to a invoice being issued
Hi people! With the disclaimer that I'm keeping these books for myself, as I'm not required by law to keep them at all, here I come ask you about this specific tax. Also, this turned quite longer than I thought it would, actually while writing my thoughts cleared quite a bit... :) Guess that's a kind of "rubber duck debugging"! For the quicker version go straight to below where I describe my case in way more practical terms. Background: When I issue an invoice I may (or may not) have to pay a 2€ duty stamp and attach it to the invoice. That's an effect specific to the fact that I produced a document, and I also need to attach such duty stamp to credit notes, for example. Now, if I do a paper invoice, I most likely already bought weeks/months prior a stash of those duty stamps. Instead, if I'm doing an electronic invoice, the payment for those stamp is deferred to the next quarter. Furthermore, I may or may not (my choice) bill the customer for the expense of this duty stamp. So I am a bit lost on how to properly account for this thing. To me is an expense, that may or may not be charged back to the customer, but I would also like to gather data on, like, how many invoices I'm issuing that I am not billing the duty stamp on, so I wouldn't like to "hide" them into some random expense/income account. The different methods of actual payment of them (in advance or postponed) surely doesn't help make it straightforward. Probably the hardest part is that I would really like to tie the expense to each invoice. I have no clue if there even is a way to do that, but it doesn't seem like there is one. Handling invoices through the GnuCash invoice system makes it impossible to me to add random splits, is there even a chance I could do this? If not, guess I would be stuck creating a separate transaction manually each time I issue an invoice. (in the below examples, I'm referring specifically to the two splits that invoice Expenses:Tax:DutyStamps) and simply "linking" that expense to the invoice by the memo field. To clarify and recap, here was my thinking: 1. The accounts (simplified naming, I have a deeper tree): Balance Assets:Banks:Checking500.00 Assets:Cash 50.00 Assets:AR 0.- Expenses:Tax:DutyStamps0.- Income:Invoices0.- Liabilities:Tax:DutyStamps:Pre 2.00- Liabilities:Tax:DutyStamps:Post0.- I decided to separate the Pre and Post variant of duty stamps since they are after all handled completely differently and stashing them in a single account would only create confusion later on IMHO. 2. When I buy "paper duty stamps" (that can only be bought in cash…): Debit Credit Balance Assets:Cash2.0048.00 Liabilities:Tax:DutyStamps:Pre 2.00 4.00- Here the Liabilities:Tax:DutyStamps:Pre represents a sort of prepaid expense, resulting in a credit for me, which is hence recorded as a negative liability. 3. When I issue an electronic invoice for which I am *not* charging the customer: Debit Credit Balance Expenses:Tax:DutyStamps2.002.00 Liabilities:Tax:DutyStamps:Post2.002.00 This is what I would love to have in my invoice posting transaction (the one that also bears A/R and Income), but that I fear my just simply not be possible. 4. When I issue an electronic invoice for which I am charging it back: Debit Credit Balance Expenses:Tax:DutyStamps2.004.00 Liabilities:Tax:DutyStamps:Post2.004.00 Assets:AR 2.002.00 ?? 2.00 To what should I match that AR? It ought to be some kind of Income, but I am not really sure, it's not really an income is it? It feels constrained to use Income:Invoices. I was half-thinking to match it against Expenses:Tax:DutyStamps (similarly to what one would do with credit card rebates), but GnuCash won't let me do that from within an invoice. Or am I looking at this from the wrong side and I should just get an Income:TaxCollection kind of account? 5. When I issue a paper invoice, not claiming back the duty stamp: Debit Credit Balance Expenses:Tax:DutyStamps2.006.00 Liabilities:Tax:DutyStamps:Pre 2.002.00- And there follows the rest of the invoice; like with case 3, beside this magic linking that I would love to have with these 2 splits and the actual invoice, I think nothing
[GNC] Imbalance on Fixed Income Transaction
Just setting up GnuCash 3.8b+(2019-12-29) for the first time on an HP EliteDesk 800 G1 running LinuxMint v20.02 Cinnamon. And yes, I've had Bookkeeping-101 in College, 40+ yrs ago. And it was processed by an IBM 360 Mainframe. What I'm not understanding is the basics behind the "Imbalance" result. I have set up all the top level accounts, and then added FI1 and FI2 (Fixed Income 1&2) as subs below the 'Income' top level account. My two FI's come in at different times, one on the first of each month, the other on the Second Wednesday, which I will eventually want to set up recurring automatic transactions for those two sources (which I basically already have figured out). After opening the register (ledger) for FI1 and entering a transaction for that allotment, lets say $1000.00 and saving it, then opening the transaction register for account FI2, and doing the same, for the same amount and saving that... The main top level account page shows a total income of $2000.00, which is correct and I understand, but directly above that is the "Imbalance-USD" line, and if each transaction is once again opened each shows an 'Imbalance' for the Transfer field in the amount of the transaction. I have reconciled both of these transactions basically meaning that I have seen proof that the transaction occurred by statement or by funds-in-hand and ticked the "R" box in the respective line, which changed to a "c", and is now a "y". But the 'Imbalance' notice remains and the amount does not change. Once the transactions are reconciled, should not the imbalance go away ? I realize the answer to this is likely a simple one, but it is alluding me at the moment, input appreciated. And lastly... Is it advisable to update to v4.8 under Mint ? I notice that the doc page says it should be available through the 'Software Center' on Ubuntu, but I just installed THIS version (3.8) from the Mint 'Software Manager', and I'm limited to Cellular downloads at the moment, so I'd rather not do the 800+MB FlatHub (which is v4.8). Bruce (just another old retired Vet trying to keep his funds straight) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
