End of year reports question

[Des Dougan]

Derek,

Thanks for your reply.

On 15 Apr 2009, at 07:26, Derek Atkins wrote:

> Des Dougan <des at douganconsulting.com> writes:
>
>>>> I have a balance in both accounts according to the Balance Sheet.
>>>> I  found that if I check the "Show zero-balance items" in the
>>>> Ageing  Reports, then I get transactions displayed. However, the
>>>> totals do not  match those displayed in the Balance Sheet.
>>>
>>> To me that implies you hand-entered transactions into A/R or A/P.
>>> Did you do that?  Are you sure that ALL transactions into AR and AP
>>> were entered via Invoice/Bills and Process-Payment?   And ONLY via
>>> those methods?
>>
>> I'm pretty certain that is the case - I use the Business features for
>> creating bills and invoices constantly. I just took a look through
>> both registers. The only odd thing I see are several AP entries with
>> "Automatic Payment Forward" in the Memo field and "Auto Split" in the
>> Action field. The AR register, with "Show zero-balance items"  
>> checked,
>> shows the same balance as the Balance sheet.
>>
>> What does "Auto Payment Forward" mean? Is this caused by my error?
>
> The auto payment forward occurs when you have over payments.  This
> tends to occur when you pay invoices out-of-order.  There is still  
> some
> process by which you can get the system into a state where it cannot  
> fix
> itself.  The only way I know to get yourself out of it is to delete  
> all
> your payments and Auto Payment Forward transactions from your A/R
> account and then go re-apply all your Payments in chronological order.

Or use the backups... I went back a day or so, prior to my  
"corrections" and worked my way forward. I'm up to date again, with  
the two errors in my AP Register resolved.

>
>
>> And should I raise a bug for the zero-balance checkbox issue?
>
> I still don't understand this "issue"..  And it may be related to the
> above issue.

No, it's independent of the above. If you run either of the ageing  
reports, with "Previous Year End" as the date selection, the report  
does not show all outstanding bills/invoices unless the "Show zero- 
balance items" box is checked. This is not the case with "Today" as  
the date, where the expected behaviour is exhibited. The issue is  
reproducible.

Regards,

Des


>
>> Thanks,
>>
>> Des
>
> -derek
>
> -- 
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available

--

Des Dougan, Principal
Dougan Consulting Group Inc.

Office:		604-628-5434
Cell:   	604-866-2848
Email:  	des at DouganConsulting dot com

         www.DouganConsulting.com

Peace of Mind, One Computer at a Time.