[GNC] Missing invoice on Income & GST Statement Report

Christopher Lam christopher.lck at gmail.com
Sun Feb 2 06:14:11 EST 2020


Set General/Add options summary to 'always', and paste the headers.

On Sun, 2 Feb 2020 at 10:36, <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
>
> 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> 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=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>
>> wrote:
>>
>> Doesn't previous quarter end on 31/12/2019?
>>
>> On Sat, 1 Feb 2020, 10:58 pm , <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
>>> 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.
>>>
>>
>>
>


More information about the gnucash-user mailing list