business accounts receivable report problems

[John Ralls]

On Jan 2, 2014, at 5:56 PM, Marc Evans <marc at softwarehackery.com> wrote:

> 
> 
> On 1/2/14, 8:44 PM, John Ralls wrote:
>> 
>> On Jan 2, 2014, at 5:21 PM, Marc Evans <marc at softwarehackery.com> wrote:
>> 
>>> 
>>> 
>>> On 1/2/14, 8:07 PM, John Ralls wrote:
>>>> 
>>>> On Jan 2, 2014, at 4:23 PM, Marc Evans <marc at softwarehackery.com> wrote:
>>>> 
>>>>> Hello,
>>>>> 
>>>>> I am running gnucash-2.6.0 on OSX 10.9.1, installed via the DMG from the
>>>>> gnucash site.
>>>>> 
>>>>> When running Reports > Business > Receivable Aging the reports that
>>>>> results shows the wrongs figures, such that many items that should be
>>>>> zero at not. When I click on a problem figure trying to figure out
>>>>> details of why, a new tab is shown specific to the customer, showing
>>>>> that same problem figure in the Total Due, but zeros in both the credits
>>>>> and debits columns. If I then:
>>>>> 
>>>>> 1) Select Report Options
>>>>> 2) Select From > Start of previous year
>>>>> 3) Select From > Start of accounting period
>>>>> 4) Select Apply
>>>>> 
>>>>> The result is a proper customer report with all zeros.
>>>>> 
>>>>> Am I somehow not properly using the system or is this a bug?
>>>>> 
>>>> 
>>>> To make sure that I understand, you are changing the start of the
>>>> report period to "start of previous year" and then changing it
>>>> back to "start of accounting period", so there's no actual change
>>>> to the options. Is that correct?
>>> 
>>> Yes. Effectively tricking the program into allowing me to select Apply
>>> without making any changes.
>>> 
>>>> What happens if you do that immediately rather than following
>>>> one of the problem links? How about if you click on the "Reload"
>>>> button in the toolbar?
>>> 
>>> If I go directly to the customer report all figures are zero, which is
>>> what I would expect.
>>> 
>>> Selecting Reload when viewing the receivable aging report results in no
>>> change.
>>> 
>>>> Where are the "problem figures" coming from? An earlier accounting
>>>> period?
>>> 
>>> I have not been able to figure that out. My customers are invoiced and
>>> pay the same amount repeatedly, so the figures aren't particularly
>>> unique. I was hoping to be able to figure that out using the customer
>>> specific report, but no such luck. Any suggestions?
>>> 
>>> Thanks for the response!
>> 
>> Make a fake accounting file and create a few invoices with unique numbers,
>> or copy your existing file and change one customer's numbers so that they're
>> unique over a 2 year period; increasing powers of 2 would make it easy to
>> recognize multiple invoices getting summed. 
> 
> I just tried looking at a different set of books which are experiencing
> the same issue. I am including a screen shot of what I am seeing. In
> that screen shot, the Current and 0-30 days column is correct. The Total
> in line 1 is clearly wrong. The figure on line 3 is wrong too.
> 
> When I clink on the Total in line 1 I get an error (attached too). When
> I click on the Total in line 3 I get a report with all zeros.
> 
> I will experiment more as you are suggesting, but wanted to pass these
> along in case there is anything helpful.




Please remember to CC the list on all replies: Use "Reply All".

Interesting. The odd balancing line 1 suggests that there might be a stray
A/R or asset account in the accounts list. Can you check that?

Regards,
John Ralls