It is a long story, John. It has been discussed many times but today the aged balanced is not usable due to opening entries OpenERP strange way, partial payment management and reconcile date. But the main problem is the reconcile date which can be change if you unreconcile so it make impossible to print a aged balance at any date in the past.
We fixed this issue for an other report 'open invoices report' (one of the webkit financial reports) by adding the last_rec_date field. Unfortunately, I do not not have much time to explain further these days but this answer will help you. Please also note, that we can do such a dev but we estimate the workload at 5 days and we never found anyone to finance/contribute on this so far. Frederic Camptocamp *camptocamp* INNOVATIVE SOLUTIONS BY OPEN SOURCE EXPERTS *Frédéric Clementi* Project Manager Business Solutions +41 21 619 10 41 * * www.camptocamp.com 2013/6/6 John Boyle <[email protected]> > 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 > _______________________________________________ > Mailing list: https://launchpad.net/~openerp-expert-accounting > Post to : [email protected] > Unsubscribe : https://launchpad.net/~openerp-expert-accounting > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
