Op maandag 26 maart 2018 02:29:12 CEST schreef John Ralls: > > On Mar 25, 2018, at 5:21 PM, Rick Copple <[email protected]> > > 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 [email protected] 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.
