Re: Problem with tax table under sqlite3

[Geert Janssens]

Op woensdag 28 maart 2018 02:25:21 CEST schreef Rick Copple:
> The only thing I can think of is that something "corrupted" the sales
> tax entry in the XML file so that when I converted it over to SQLite3,
> it stopped accumulating. Strange. But it apparently happened in my case.
> 
> Anyway, thanks for helping me with this. Glad I was able to figure it out!

Me too!

Geert


___
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: Problem with tax table under sqlite3

[Rick Copple]

On 03/27/2018 08:26 AM, Geert Janssens wrote:

I have tried to reproduce on 2.6.18 but I can't. I have started with an old
sqlite based book, created a new invoice in it with a tax table set and posted
the invoice. Looking in the AR register, the transaction does have have the
correct tax splits.

Can you share a minimal test file in which you have reproduced the issue ?


I've created a test file with the minimal data to create invoices. It 
all worked as expected. I created an
XML file and entered the sales tax in the table, then created a dummy 
invoice to make sure it was working. Then I saved the file. Right after 
that, I saved the file in SQLite3 format. Then created another dummy 
invoice. It created the sales tax in the liability account just fine. So 
I exited and restarted the program, and it still recorded the sales tax 
in the liability acct. as one would expect.


This caused me to suspect something was amiss with my file, and I 
postulated it was something in the XML's sales tax table file that 
wasn't being converted over to SQLite3 correctly, causing the problem. 
So I went into the XML file, and created a NEW sales tax item (I had 
only edited it in times past). I then saved it in the XML file, and then 
saved it again in the SQLite3 backend. Upon entering an invoice, it 
recorded the sales tax correctly. I exited and restarted the program, 
and entered another invoice, and it too recorded the sales tax 
correctly. So the issue has been resolved I can now use the SQLite3 
backend without having to mess with the sales tax table everytime.


The only thing I can think of is that something "corrupted" the sales 
tax entry in the XML file so that when I converted it over to SQLite3, 
it stopped accumulating. Strange. But it apparently happened in my case.


Anyway, thanks for helping me with this. Glad I was able to figure it out!

--
Rick Copple

___
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: Problem with tax table under sqlite3

[Rick Copple]

Sure, will do so when I get back home this evening. Thanks.

Rick Copple
⁣

On Mar 27, 2018, 8:26 AM, at 8:26 AM, Geert Janssens 
 wrote:
>Op maandag 26 maart 2018 02:29:12 CEST schreef John Ralls:
>> > On Mar 25, 2018, at 5:21 PM, Rick Copple
>
>> > wrote:
>> > 
>> > Thank you, John, for bearing with me.
>> > 
>> > On 03/25/2018 04:37 PM, John Ralls wrote:
>> >> Rick,
>> >> 
>> >> OK, I'll try again. You reported that when you post an invoice "it
>fails
>> >> to accumulate in the liability account" until you "edited the tax
>table
>> >> [and]... reposted that invoice. Then it showed up in the liability
>> >> account..."
>> >> 
>> >> Then you "went back in" (presumably having quit and restarted
>GnuCash)
>> >> and tried to post another invoice, only to have to edit the tax
>table
>> >> again to get to "accumulate".
>> >> 
>> >> I need you to break that down so that I understand exactly what
>happened
>> >> when and what is the problem. When posting an invoice without
>first
>> >> editing the tax table:
>> >> Is the sales tax liability account register open when you post the
>> >> invoice?
>> > 
>> > I've done it both ways, register open and closed. Same thing
>happens.
>> > 
>> >> Are you examining that register immediately after posting the
>invoice and
>> >> not seeing the invoice's transaction there?> 
>> > Yes.
>> > 
>> >> What about other accounts (e.g. Accounts Receivable) that the
>invoice
>> >> should have posted to? If the transaction is present in those
>other
>> >> accounts, does it include the tax split if you put it in split
>view?> 
>> > Yes, it posts to the A/R account, but without the sales tax split
>showing,
>> > despite it showing in the invoice itself.> 
>> >> If the tax liability register was open when you post the invoice,
>does
>> >> closing and reopening it change anything?> 
>> > No, it is either there or not.
>> > 
>> >> Otherwise, if the splits are all there after you post the invoice,
>do
>> >> some or all of them disappear when you quit and restart GnuCash?> 
>> > The splits are not there after I post an invoice unless, for that
>session
>> > since opening the program, I first edit the tax table to include
>the tax
>> > %. The strange thing is when I go to edit it, the name of the sales
>tax
>> > item in the left pane shows up, in my case "Marble Falls", but
>there is
>> > nothing in the right window UNTIL  I click on the name "Marble
>Falls",
>> > then the "Sales Tax Payable" account shows up in the right window
>(it
>> > does the same thing in the XML database, but it still calculates it
>> > correctly). It doesn't accumulate the sales tax into that
>> > register/account until I edit the entry on the right side (it shows
>8.25%
>> > as I had entered before), and then once I go in and edit the
>invoice that
>> > didn't post sales tax, unpost it, save the line by clicking through
>it,
>> > then reposting it.> 
>> >> You report all this for the Sqlite3 backend. Does it work
>correctly when
>> >> you do the same using the XML backend?> 
>> > Yes, it works as expected for the XML backend. It is only in the
>Sqlite3
>> > backend that I've had this happen. Note, I've not attempted using
>MySql
>> > or PostSql on this as it would require me stetting it up. I don't
>know if
>> > it would do the same  thing on those backends or not.
>> > 
>> > I've experimented with this some and can't seem to isolate why this
>is
>> > happening. If you can think of anything else I could try, let me
>know.
>> Thanks, now I understand what's happening.
>> 
>> What I don't understand is why the backend would make a difference.
>Geert
>> will be back on Tuesday and he's way more familiar with the business
>code.
>> Maybe he'll have an idea of what's going on.
>> 
>Unfortunately neither do I.
>
>I have tried to reproduce on 2.6.18 but I can't. I have started with an
>old 
>sqlite based book, created a new invoice in it with a tax table set and
>posted 
>the invoice. Looking in the AR register, the transaction does have have
>the 
>correct tax splits.
>
>Can you share a minimal test file in which you have reproduced the
>issue ?
>
>Geert
___
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: Problem with tax table under sqlite3

[Geert Janssens]

Op maandag 26 maart 2018 02:29:12 CEST schreef John Ralls:
> > On Mar 25, 2018, at 5:21 PM, Rick Copple 
> > wrote:
> > 
> > Thank you, John, for bearing with me.
> > 
> > On 03/25/2018 04:37 PM, John Ralls wrote:
> >> Rick,
> >> 
> >> OK, I'll try again. You reported that when you post an invoice "it fails
> >> to accumulate in the liability account" until you "edited the tax table
> >> [and]... reposted that invoice. Then it showed up in the liability
> >> account..."
> >> 
> >> Then you "went back in" (presumably having quit and restarted GnuCash)
> >> and tried to post another invoice, only to have to edit the tax table
> >> again to get to "accumulate".
> >> 
> >> I need you to break that down so that I understand exactly what happened
> >> when and what is the problem. When posting an invoice without first
> >> editing the tax table:
> >> Is the sales tax liability account register open when you post the
> >> invoice?
> > 
> > I've done it both ways, register open and closed. Same thing happens.
> > 
> >> Are you examining that register immediately after posting the invoice and
> >> not seeing the invoice's transaction there?> 
> > Yes.
> > 
> >> What about other accounts (e.g. Accounts Receivable) that the invoice
> >> should have posted to? If the transaction is present in those other
> >> accounts, does it include the tax split if you put it in split view?> 
> > Yes, it posts to the A/R account, but without the sales tax split showing,
> > despite it showing in the invoice itself.> 
> >> If the tax liability register was open when you post the invoice, does
> >> closing and reopening it change anything?> 
> > No, it is either there or not.
> > 
> >> Otherwise, if the splits are all there after you post the invoice, do
> >> some or all of them disappear when you quit and restart GnuCash?> 
> > The splits are not there after I post an invoice unless, for that session
> > since opening the program, I first edit the tax table to include the tax
> > %. The strange thing is when I go to edit it, the name of the sales tax
> > item in the left pane shows up, in my case "Marble Falls", but there is
> > nothing in the right window UNTIL  I click on the name "Marble Falls",
> > then the "Sales Tax Payable" account shows up in the right window (it
> > does the same thing in the XML database, but it still calculates it
> > correctly). It doesn't accumulate the sales tax into that
> > register/account until I edit the entry on the right side (it shows 8.25%
> > as I had entered before), and then once I go in and edit the invoice that
> > didn't post sales tax, unpost it, save the line by clicking through it,
> > then reposting it.> 
> >> You report all this for the Sqlite3 backend. Does it work correctly when
> >> you do the same using the XML backend?> 
> > Yes, it works as expected for the XML backend. It is only in the Sqlite3
> > backend that I've had this happen. Note, I've not attempted using MySql
> > or PostSql on this as it would require me stetting it up. I don't know if
> > it would do the same  thing on those backends or not.
> > 
> > I've experimented with this some and can't seem to isolate why this is
> > happening. If you can think of anything else I could try, let me know.
> Thanks, now I understand what's happening.
> 
> What I don't understand is why the backend would make a difference. Geert
> will be back on Tuesday and he's way more familiar with the business code.
> Maybe he'll have an idea of what's going on.
> 
Unfortunately neither do I.

I have tried to reproduce on 2.6.18 but I can't. I have started with an old 
sqlite based book, created a new invoice in it with a tax table set and posted 
the invoice. Looking in the AR register, the transaction does have have the 
correct tax splits.

Can you share a minimal test file in which you have reproduced the issue ?

Geert


___
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: Problem with tax table under sqlite3

[Rick Copple]

On 03/25/2018 07:29 PM, John Ralls wrote:

Thanks, now I understand what's happening.

What I don't understand is why the backend would make a difference. Geert will 
be back on Tuesday and he's way more familiar with the business code. Maybe 
he'll have an idea of what's going on.


Cool. I look forward to his analysis.

Rick Copple

___
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: Problem with tax table under sqlite3

[John Ralls]

> On Mar 25, 2018, at 5:21 PM, Rick Copple  
> wrote:
> 
> Thank you, John, for bearing with me.
> 
> On 03/25/2018 04:37 PM, John Ralls wrote:
>> Rick,
>> 
>> OK, I'll try again. You reported that when you post an invoice "it fails to 
>> accumulate in the liability account" until you "edited the tax table 
>> [and]... reposted that invoice. Then it showed up in the liability 
>> account..."
>> 
>> Then you "went back in" (presumably having quit and restarted GnuCash) and 
>> tried to post another invoice, only to have to edit the tax table again to 
>> get to "accumulate".
>> 
>> I need you to break that down so that I understand exactly what happened 
>> when and what is the problem.
>> When posting an invoice without first editing the tax table:
>> Is the sales tax liability account register open when you post the invoice?
> I've done it both ways, register open and closed. Same thing happens.
> 
>> Are you examining that register immediately after posting the invoice and 
>> not seeing the invoice's transaction there?
> 
> Yes.
> 
>> What about other accounts (e.g. Accounts Receivable) that the invoice should 
>> have posted to? If the transaction is present in those other accounts, does 
>> it include the tax split if you put it in split view?
> 
> Yes, it posts to the A/R account, but without the sales tax split showing, 
> despite it showing in the invoice itself.
> 
>> If the tax liability register was open when you post the invoice, does 
>> closing and reopening it change anything?
> 
> No, it is either there or not.
> 
>> 
>> Otherwise, if the splits are all there after you post the invoice, do some 
>> or all of them disappear when you quit and restart GnuCash?
> 
> The splits are not there after I post an invoice unless, for that session 
> since opening the program, I first edit the tax table to include the tax %. 
> The strange thing is when I go to edit it, the name of the sales tax item in 
> the left pane shows up, in my case "Marble Falls", but there is nothing in 
> the right window UNTIL  I click on the name "Marble Falls", then the "Sales 
> Tax Payable" account shows up in the right window (it does the same thing in 
> the XML database, but it still calculates it correctly). It doesn't 
> accumulate the sales tax into that register/account until I edit the entry on 
> the right side (it shows 8.25% as I had entered before), and then once I go 
> in and edit the invoice that didn't post sales tax, unpost it, save the line 
> by clicking through it, then reposting it.
> 
>> 
>> You report all this for the Sqlite3 backend. Does it work correctly when you 
>> do the same using the XML backend?
> 
> Yes, it works as expected for the XML backend. It is only in the Sqlite3 
> backend that I've had this happen. Note, I've not attempted using MySql or 
> PostSql on this as it would require me stetting it up. I don't know if it 
> would do the same  thing on those backends or not.
> 
> I've experimented with this some and can't seem to isolate why this is 
> happening. If you can think of anything else I could try, let me know.
> 

Thanks, now I understand what's happening.

What I don't understand is why the backend would make a difference. Geert will 
be back on Tuesday and he's way more familiar with the business code. Maybe 
he'll have an idea of what's going on.

Regards,
John Ralls


___
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: Problem with tax table under sqlite3

[Rick Copple]

Thank you, John, for bearing with me.

On 03/25/2018 04:37 PM, John Ralls wrote:

Rick,

OK, I'll try again. You reported that when you post an invoice "it fails to accumulate in the 
liability account" until you "edited the tax table [and]... reposted that invoice. Then 
it showed up in the liability account..."

Then you "went back in" (presumably having quit and restarted GnuCash) and tried to post 
another invoice, only to have to edit the tax table again to get to "accumulate".

I need you to break that down so that I understand exactly what happened when 
and what is the problem.
When posting an invoice without first editing the tax table:
Is the sales tax liability account register open when you post the invoice?

I've done it both ways, register open and closed. Same thing happens.


Are you examining that register immediately after posting the invoice and not 
seeing the invoice's transaction there?


Yes.


What about other accounts (e.g. Accounts Receivable) that the invoice should 
have posted to? If the transaction is present in those other accounts, does it 
include the tax split if you put it in split view?


Yes, it posts to the A/R account, but without the sales tax split 
showing, despite it showing in the invoice itself.



If the tax liability register was open when you post the invoice, does closing 
and reopening it change anything?


No, it is either there or not.



Otherwise, if the splits are all there after you post the invoice, do some or 
all of them disappear when you quit and restart GnuCash?


The splits are not there after I post an invoice unless, for that 
session since opening the program, I first edit the tax table to include 
the tax %. The strange thing is when I go to edit it, the name of the 
sales tax item in the left pane shows up, in my case "Marble Falls", but 
there is nothing in the right window UNTIL  I click on the name "Marble 
Falls", then the "Sales Tax Payable" account shows up in the right 
window (it does the same thing in the XML database, but it still 
calculates it correctly). It doesn't accumulate the sales tax into that 
register/account until I edit the entry on the right side (it shows 
8.25% as I had entered before), and then once I go in and edit the 
invoice that didn't post sales tax, unpost it, save the line by clicking 
through it, then reposting it.




You report all this for the Sqlite3 backend. Does it work correctly when you do 
the same using the XML backend?


Yes, it works as expected for the XML backend. It is only in the Sqlite3 
backend that I've had this happen. Note, I've not attempted using MySql 
or PostSql on this as it would require me stetting it up. I don't know 
if it would do the same  thing on those backends or not.


I've experimented with this some and can't seem to isolate why this is 
happening. If you can think of anything else I could try, let me know.


Thanks for your time.


Rick Copple

___
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: Problem with tax table under sqlite3

[John Ralls]

Rick,

OK, I'll try again. You reported that when you post an invoice "it fails to 
accumulate in the liability account" until you "edited the tax table [and]... 
reposted that invoice. Then it showed up in the liability account..."

Then you "went back in" (presumably having quit and restarted GnuCash) and 
tried to post another invoice, only to have to edit the tax table again to get 
to "accumulate".

I need you to break that down so that I understand exactly what happened when 
and what is the problem.
When posting an invoice without first editing the tax table:
Is the sales tax liability account register open when you post the invoice?
Are you examining that register immediately after posting the invoice and not 
seeing the invoice's transaction there?
What about other accounts (e.g. Accounts Receivable) that the invoice should 
have posted to? If the transaction is present in those other accounts, does it 
include the tax split if you put it in split view?
If the tax liability register was open when you post the invoice, does closing 
and reopening it change anything?

Otherwise, if the splits are all there after you post the invoice, do some or 
all of them disappear when you quit and restart GnuCash?

You report all this for the Sqlite3 backend. Does it work correctly when you do 
the same using the XML backend?

Regards,
John Ralls


> On Mar 25, 2018, at 1:24 PM, Rick Copple  
> wrote:
> 
> Sorry John, thought I did. I was on my cell phone and it quoted the whole 
> thing, but my answer to your question was at the top, which I've quoted below 
> now that I'm home and can respond via my computer. Sorry for any confusion. 
> Unless I completely misunderstood your question and you did see my answer, 
> which is always a possibility as well, in which case, you may need to clarify 
> what you were asking.
> 
> Rick Copple
> 
> On 03/25/2018 01:28 PM, John Ralls wrote:
>> Rick,
>> 
>> Please answer the question instead of repeating what you already reported.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Mar 25, 2018, at 10:43 AM, Rick Copple  
>>> wrote:
>>> 
>>> When I quit and restart the program, then it stops accumulating in the tax 
>>> liability acct.
>>> 
>>> Rick Copple
> 
> ___
> 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: Problem with tax table under sqlite3

[Rick Copple]

Sorry John, thought I did. I was on my cell phone and it quoted the 
whole thing, but my answer to your question was at the top, which I've 
quoted below now that I'm home and can respond via my computer. Sorry 
for any confusion. Unless I completely misunderstood your question and 
you did see my answer, which is always a possibility as well, in which 
case, you may need to clarify what you were asking.


Rick Copple

On 03/25/2018 01:28 PM, John Ralls wrote:

Rick,

Please answer the question instead of repeating what you already reported.

Regards,
John Ralls


On Mar 25, 2018, at 10:43 AM, Rick Copple  
wrote:

When I quit and restart the program, then it stops accumulating in the tax 
liability acct.

Rick Copple


___
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: Problem with tax table under sqlite3

[John Ralls]

Rick,

Please answer the question instead of repeating what you already reported.

Regards,
John Ralls

> On Mar 25, 2018, at 10:43 AM, Rick Copple  
> wrote:
> 
> When I quit and restart the program, then it stops accumulating in the tax 
> liability acct.
> 
> Rick Copple
> On Mar 25, 2018, at 9:36 AM, John Ralls  wrote:
> 
> 
>  On Mar 25, 2018, at 1:47 AM, Rick Copple  
> wrote:
>  
>  I decided to switch back to the sqlite db to see if it still did the same 
> thing as before: even though an invoice shows the breakdown of sales tax, it 
> fails to accumulate in the liability account. It did fail to do so on a test 
> invoice I had plugged in. So I edited the tax table, then went back and 
> reposted that invoice. It then showed up in the liability account and I 
> figured all was well.
>  
>  Not so fast. When I went in it today to put another invoice in, it again 
> failed to accumulate in the liability acct. I had to edit the sales tax table 
> again and repost the invoice to get the sales tax to accumulate.
>  
>  My question is, is this a known bug for ver. 2.6.12 running under Ubuntu? 
> I'm on 16.04.4 LTS.
>  
>  Or is there something else at play here that I'm unaware of?
>  
>  Thanks for your help.
> 
> I don’t see anything that looks similar in the bugs.
> 
> When you say that the new tax liability isn’t getting credited to the tax 
> account do you mean the register in the still-running GnuCash or do you mean 
> after quitting and restarting?
> 
> Regards,
> John Ralls
> 

___
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: Problem with tax table under sqlite3

[Rick Copple]

When I quit and restart the program, then it stops accumulating in the tax 
liability acct.

⁣Rick Copple

On Mar 25, 2018, 9:36 AM, at 9:36 AM, John Ralls  wrote:
>
>
>> On Mar 25, 2018, at 1:47 AM, Rick Copple
> wrote:
>> 
>> I decided to switch back to the sqlite db to see if it still did the
>same thing as before: even though an invoice shows the breakdown of
>sales tax, it fails to accumulate in the liability account. It did fail
>to do so on a test invoice I had plugged in. So I edited the tax table,
>then went back and reposted that invoice. It then showed up in the
>liability account and I figured all was well.
>> 
>> Not so fast. When I went in it today to put another invoice in, it
>again failed to accumulate in the liability acct. I had to edit the
>sales tax table again and repost the invoice to get the sales tax to
>accumulate.
>> 
>> My question is, is this a known bug for ver. 2.6.12 running under
>Ubuntu? I'm on 16.04.4 LTS.
>> 
>> Or is there something else at play here that I'm unaware of?
>> 
>> Thanks for your help.
>
>I don’t see anything that looks similar in the bugs.
>
>When you say that the new tax liability isn’t getting credited to the
>tax account do you mean the register in the still-running GnuCash or do
>you mean after quitting and restarting?
>
>Regards,
>John Ralls
___
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: Problem with tax table under sqlite3

[John Ralls]

> On Mar 25, 2018, at 1:47 AM, Rick Copple  
> wrote:
> 
> I decided to switch back to the sqlite db to see if it still did the same 
> thing as before: even though an invoice shows the breakdown of sales tax, it 
> fails to accumulate in the liability account. It did fail to do so on a test 
> invoice I had plugged in. So I edited the tax table, then went back and 
> reposted that invoice. It then showed up in the liability account and I 
> figured all was well.
> 
> Not so fast. When I went in it today to put another invoice in, it again 
> failed to accumulate in the liability acct. I had to edit the sales tax table 
> again and repost the invoice to get the sales tax to accumulate.
> 
> My question is, is this a known bug for ver. 2.6.12 running under Ubuntu? I'm 
> on 16.04.4 LTS.
> 
> Or is there something else at play here that I'm unaware of?
> 
> Thanks for your help.

I don’t see anything that looks similar in the bugs.

When you say that the new tax liability isn’t getting credited to the tax 
account do you mean the register in the still-running GnuCash or do you mean 
after quitting and restarting?

Regards,
John Ralls

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