openerp-expert-accounting team mailing list archive

[John Boyle <justbe.john@xxxxxxxxx>]

Hi folks,

Hoping someone has some insight on this. I've noticed the Aged Partner Balance report uses the reconcile date. Fine and dandy, except when payments use a date in the future. 
 e.g. if I process a supplier payment on May 30 and date it for June 1 - if I compare my Trial Balance with the Aged Partner Balance for May 30 Accounts Payable is off by the amount of those payments.

The reason seems fairly simple after digging through that report for longer than I'd care to admit - the Trial Balance will use the effective date on the journal item, thus taking the payment entries into account,  but the Aged Partner Balance will ignore the entries if the date is greater than May 30.

Anyone else run into this? Any solutions or suggestions?

Cheers,
John