Many thanks to you and Maf for your suggestions - I was able to fix the problem by setting the General/Add options summary to know what was wrong.
The offending invoice was issued to a new customer who started in Jan, so the corresponding Income account was created recently. When this new income account was added, it didn’t automatically get selected in the Report Options->Accounts tab. This was made evident by the add option summary setting, in which this account wasn’t listed. To Maf’s musings, yes, the account tree is quite nested, because this was done at a time of chaotic rollout of GST in India and I was trying to keep all possibilities open by way of reporting - hence the granularity. This is an extremely valuable report for my GST filings, so I am relieved that the taxes I have been paying are accurate. Cheers. > On 02-Feb-2020, at 4:44 PM, Christopher Lam <christopher....@gmail.com> wrote: > > Set General/Add options summary to 'always', and paste the headers. > > On Sun, 2 Feb 2020 at 10:36, <pobox.d...@outlook.in > <mailto:pobox.d...@outlook.in>> wrote: > Yes, there’s 1 split going to Income account. See screenshot link below. This > screenshot is from the IGST @ 18% account view. The account, > Assets:Business:Invoices, is my A/R account. > > https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te > <https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te> > > Thank you for making time to review this anomaly. > > Cheers. > >> On 02-Feb-2020, at 2:04 PM, Christopher Lam <christopher....@gmail.com >> <mailto:christopher....@gmail.com>> wrote: >> >> This report doesn't query the A/R register. It queries the Income account. >> Did you post it there? >> >> On Sun, 2 Feb 2020, 4:09 pm , <pobox.d...@outlook.in >> <mailto:pobox.d...@outlook.in>> wrote: >> Yes, the previous quarter ends on 31-DEC-2019. >> >> Perhaps I was misunderstood. Since I didn’t find the invoice showing up in >> the current quarter (Jan - Mar 2020), I ran the report for the previous >> quarter to check if it somehow shows up there. But it didn’t. In fact, I ran >> the report for the entire financial year thus far (1-APR-19 to 1-FEB-20) and >> that particular invoice doesn’t show up in any quarter or month. >> >> It happened once before about 2 years ago when an invoice was posted on 1st >> of the month, internally, it got recorded as 31st of the previous month in >> one of the splits and the report correctly didn’t show that particular >> invoice. But this was in the 2.6 series and I was able to edit the A/R >> register then, so I went in and changed the offending date to 1st and >> everything worked fine from then on. >> >> But in the current 3.x series, the A/R register edit feature is now >> disabled. However, all dates are stored correctly, so I am at a loss as to >> why it’s not showing on the report. >> >> I am not sure if the PNG attachments I sent earlier came through. If it >> didn’t, I am sharing the same via Google Drive links here. Hopefully this >> will work. >> >> https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y >> <https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y> >> https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p >> <https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p> >> >> Please let me know if you need any more information. >> >> Cheers. >> >> >>> On 02-Feb-2020, at 1:34 AM, Christopher Lam <christopher....@gmail.com >>> <mailto:christopher....@gmail.com>> wrote: >>> >>> Doesn't previous quarter end on 31/12/2019? >>> >>> On Sat, 1 Feb 2020, 10:58 pm , <pobox.d...@outlook.in >>> <mailto:pobox.d...@outlook.in>> wrote: >>> Hello, >>> >>> I am running 3.7 on Mac OS High Sierra 10.13.6. >>> >>> Something peculiar is happening with my datafile this month. >>> >>> See attached 2 screenshots - one from Find Invoice dialog for the date >>> range 1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement >>> report. >>> >>> There’s one invoice that’s not showing up in the Income & GST Statement >>> (i.e., invoice id = 000361). And I can’t find out why. >>> >>> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on >>> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it >>> still doesn’t show up on the report. >>> >>> When I run the Income & GST Statement report for the previous quarter, this >>> invoice isn’t there either. >>> >>> Can someone please help since my GST tax payment is due in the coming week? >>> >>> This invoice is no different from any other invoice in the period and I >>> have confirmed that it is still marked active. >>> >>> Cheers. >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user> >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists >>> <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.
