Re: [GNC] SpamAssassin??

[Derek Atkins]

Just expect to lose any formatting or embedded images.

-derek
Sent using my mobile device. Please excuse any typos.
On October 22, 2021 9:19:09 PM David Carlson  
wrote:

Can I make a suggestion?

Sometimes,  when I want to post a rather complex statement to a text based 
medium I will compose the statement in a higher level editor, possibly 
Libre Office,  then copy and paste into the destination.


That should work where PDF's do not.

On Fri, Oct 22, 2021, 7:35 PM Derek Atkins  wrote:
Hi,

On Fri, October 22, 2021 6:17 pm, m.x. keating wrote:

When I attempt to send some questions contained in a .pdf attachment, I
get nailed by SpamAssassin, so I am trying here without the attachment
to see if that is the problem.


Yes, that's the problem.
Don't send a PDF to the list.
Just ask your questions.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


-derek

--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant

___
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] save as sqlite3 error

[Peter West]

FWIW, I just tried to save my postgresql-based data as sqlite3 and GnuCash 
crashed.

Peter
—
Peter West
p...@ehealth.id.au
“And why do you not judge for yourselves what is right?”

> On 23 Oct 2021, at 11:42 am, Geoff  wrote:
> 
> Looks like that approach could work, but I'm afraid I don't know enough about 
> the inner workings of GnuCash to advise you authoritatively.
> 
> Good luck!
> 
> 
> Regards
> 
> Geoff
> =
> 
> On 22/10/2021 11:52 pm, Public Address wrote:
>> Thanks, interesting that deleting the “NULL” text and leaving it empty 
>> allowed it to go through.
>> “but direct database manipulation may void your GnuCash warranty.”
>> I was thinking about direct upload to the postgres table (creating my own 
>> guid and checking for duplication) but that doesn’t sound like a good idea?
>> Sent from Mail > > for Windows
>> *From: *Geoff > >
>> *Sent: *20 October 2021 11:15
>> *To: *Public Address > >; David Carlson 
>> >
>> *Cc: *gnucash-user@gnucash.org  
>> >
>> *Subject: *Re: [GNC] save as sqlite3 error
>> That would do it - the schema prohibits NULLs.
>> I don't believe it is possible to import securities, it is not an option
>> on the Import menu.  Depending how many you have, you could consider:-
>> Learning to script AutoHotKey - https://www.autohotkey.com/ 
>>  > > - which is
>> excellent for automating Windows applications.
>> Or (big stretch) have a look at PieCash - the securities table is called
>> "commodities" -
>> https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py 
>> >  
>> >
>>  - but direct database manipulation may void your GnuCash warranty.
>> I reckon you will probably find it quicker to type them in yourself -
>> you can import price data from CSV once the securities themselves are
>> set up.
>> Hope this helps.
>> Regards
>> Geoff
>> =
>> On 20/10/2021 7:25 pm, Public Address wrote:
>> > 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: 

Re: [GNC] save as sqlite3 error

[Geoff]

Looks like that approach could work, but I'm afraid I don't know enough 
about the inner workings of GnuCash to advise you authoritatively.


Good luck!


Regards

Geoff
=

On 22/10/2021 11:52 pm, Public Address wrote:
Thanks, interesting that deleting the “NULL” text and leaving it empty 
allowed it to go through.


“but direct database manipulation may void your GnuCash warranty.”

I was thinking about direct upload to the postgres table (creating my 
own guid and checking for duplication) but that doesn’t sound like a 
good idea?


Sent from Mail  for Windows

*From: *Geoff 
*Sent: *20 October 2021 11:15
*To: *Public Address ; David 
Carlson 

*Cc: *gnucash-user@gnucash.org 
*Subject: *Re: [GNC] save as sqlite3 error

That would do it - the schema prohibits NULLs.

I don't believe it is possible to import securities, it is not an option
on the Import menu.  Depending how many you have, you could consider:-

Learning to script AutoHotKey - https://www.autohotkey.com/ 
 - which is

excellent for automating Windows applications.

Or (big stretch) have a look at PieCash - the securities table is called
"commodities" -
https://github.com/sdementen/piecash/blob/master/piecash/core/commodity.py 
 


- but direct database manipulation may void your GnuCash warranty.

I reckon you will probably find it quicker to type them in yourself -
you can import price data from CSV once the securities themselves are
set up.

Hope this helps.

Regards

Geoff
=



On 20/10/2021 7:25 pm, Public Address wrote:
 > 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  >  > 

Re: [GNC] SpamAssassin??

[David Carlson]

Can I make a suggestion?

Sometimes,  when I want to post a rather complex statement to a text based
medium I will compose the statement in a higher level editor, possibly
Libre Office,  then copy and paste into the destination.

That should work where PDF's do not.

On Fri, Oct 22, 2021, 7:35 PM Derek Atkins  wrote:

> Hi,
>
> On Fri, October 22, 2021 6:17 pm, m.x. keating wrote:
> > When I attempt to send some questions contained in a .pdf attachment, I
> > get nailed by SpamAssassin, so I am trying here without the attachment
> > to see if that is the problem.
>
> Yes, that's the problem.
> Don't send a PDF to the list.
> Just ask your questions.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> 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] SpamAssassin??

[Derek Atkins]

Hi,

On Fri, October 22, 2021 6:17 pm, m.x. keating wrote:
> When I attempt to send some questions contained in a .pdf attachment, I
> get nailed by SpamAssassin, so I am trying here without the attachment
> to see if that is the problem.

Yes, that's the problem.
Don't send a PDF to the list.
Just ask your questions.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] SpamAssassin??

[m.x. keating]

When I attempt to send some questions contained in a .pdf attachment, I 
get nailed by SpamAssassin, so I am trying here without the attachment 
to see if that is the problem.


___
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 Rizzolo]

Very well David,  I shall do as you suggest then!
Thank you!

On Fri, Oct 22, 2021 at 10:50 PM  wrote:
>
> Hi Mattia,
>
> I think you summay has captured the essentials. Whether you use a Liability or
> an Asset Acciunt to record the value of the stamps will not matter in practice
> but an asset account more correctly reflects the actual situation.
>
> My description is appropriate when your business is using an "accrual" 
> counting
> methodology. This primarily relates to the timing of the recording of income 
> and
> expenses. Some jurisdictions allow a "cash" accounting basis usually unde a
> specific turnover or income threshold where events are recorded at the time 
> the
> money actuallyexchanges hands.
>
> If you are passing the tax through to the customer, it is the customer who is
> actually paying the tax. You are in effect acting as an unpaid agent for the 
> tax
> office. You are receiving back from the customer the amount you paid for the 
> tax
> stamps so it is revenue and expense neutral. This is the primary reason it is
> not an expense for you.
>
> David Cousens
>
> On Fri, 2021-10-22 at 11:59 +0200, Mattia Rizzolo wrote:
> > Hi David, thank you for your insights!
> >
> > So, to highlight the differences between my thoughts and yours:
> >
> >  * prepaid stamps as an asset, not a negative liability
> >  * tax passed as-is to the customers are not actually expensed (since
> >the invoice would have as the "income account" to debit the
> >Assets:TaxStampsPrepaid or Liabilities:TaxPayableDeferred accounts
> >directly)
> >  * when not passing the tax stamp onto the customer, that would be my
> >expense, without any direct link to the actual invoice.
> >
> >
> > Is my understanding here correct?
> > Especially, from a formality point of view, is it really correct to *not*
> > expense the tax stamps I'm passing over to customers?
> >
> > -Mattia
> >
> > On Fri, Oct 22, 2021 at 12:26:18PM +1000, davidcousen...@gmail.com wrote:
> > > 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 

Re: [GNC] how to link an expense (a tax) to a invoice being issued

[davidcousens49]

Hi Mattia,

I think you summay has captured the essentials. Whether you use a Liability or
an Asset Acciunt to record the value of the stamps will not matter in practice
but an asset account more correctly reflects the actual situation.  

My description is appropriate when your business is using an "accrual" counting
methodology. This primarily relates to the timing of the recording of income and
expenses. Some jurisdictions allow a "cash" accounting basis usually unde a
specific turnover or income threshold where events are recorded at the time the
money actuallyexchanges hands.

If you are passing the tax through to the customer, it is the customer who is
actually paying the tax. You are in effect acting as an unpaid agent for the tax
office. You are receiving back from the customer the amount you paid for the tax
stamps so it is revenue and expense neutral. This is the primary reason it is
not an expense for you. 

David Cousens

On Fri, 2021-10-22 at 11:59 +0200, Mattia Rizzolo wrote:
> Hi David, thank you for your insights!
> 
> So, to highlight the differences between my thoughts and yours:
> 
>  * prepaid stamps as an asset, not a negative liability
>  * tax passed as-is to the customers are not actually expensed (since
>the invoice would have as the "income account" to debit the
>Assets:TaxStampsPrepaid or Liabilities:TaxPayableDeferred accounts
>directly)
>  * when not passing the tax stamp onto the customer, that would be my
>expense, without any direct link to the actual invoice.
> 
> 
> Is my understanding here correct?
> Especially, from a formality point of view, is it really correct to *not*
> expense the tax stamps I'm passing over to customers?
> 
> -Mattia
> 
> On Fri, Oct 22, 2021 at 12:26:18PM +1000, davidcousen...@gmail.com wrote:
> > 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 

Re: [GNC] how to link an expense (a tax) to a invoice being issued

[Mattia Rizzolo]

Hi David, thank you for your insights!

So, to highlight the differences between my thoughts and yours:

 * prepaid stamps as an asset, not a negative liability
 * tax passed as-is to the customers are not actually expensed (since
   the invoice would have as the "income account" to debit the
   Assets:TaxStampsPrepaid or Liabilities:TaxPayableDeferred accounts
   directly)
 * when not passing the tax stamp onto the customer, that would be my
   expense, without any direct link to the actual invoice.


Is my understanding here correct?
Especially, from a formality point of view, is it really correct to *not*
expense the tax stamps I'm passing over to customers?

-Mattia

On Fri, Oct 22, 2021 at 12:26:18PM +1000, davidcousen...@gmail.com wrote:
> 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 

Re: [GNC] save as sqlite3 error

[Public Address]

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.
>  >