[GNC] Missing invoice on Income & GST Statement Report

[pobox.deva at outlook.in]

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.lck at gmail.com> wrote:
> 
> Set General/Add options summary to 'always', and paste the headers.
> 
> On Sun, 2 Feb 2020 at 10:36, <pobox.deva at outlook.in <mailto:pobox.deva at 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.lck at gmail.com <mailto:christopher.lck at 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.deva at outlook.in <mailto:pobox.deva at 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.lck at gmail.com <mailto:christopher.lck at gmail.com>> wrote:
>>> 
>>> Doesn't previous quarter end on 31/12/2019?
>>> 
>>> On Sat, 1 Feb 2020, 10:58 pm , <pobox.deva at outlook.in <mailto:pobox.deva at 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 at gnucash.org <mailto:gnucash-user at 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.
>> 
>