[GNC] Missing invoice on Income & GST Statement Report

[Maf. King]

It looks to me that you have a fairly complex tree of income accounts - 
possibly one per client?

are you sure that the final income account is of the correct type, and the GST 
report includes enough depth and is picking up that individual account?

0.02
Maf.



On Sunday, 2 February 2020 10:36:07 GMT 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>
> > 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.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542