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 <geert.gnuc...@kobaltwit.be> wrote: >Op maandag 26 maart 2018 02:29:12 CEST schreef John Ralls: >> > On Mar 25, 2018, at 5:21 PM, Rick Copple ><r...@copplecleaningservice.com> >> > 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.