aging report with intervals

[former_member208987]

Hi,

i want to create an aging report by business partner balance with the folowing intervals of aging periode.

4 columns with 0-120 days 120-180 days 180-360 days and older then 360 days

Is there somebody who can help me set this up.

I,am not using SBO 8.8 and don't want to upgrade yet

Thanks

Mark

[Former Member]

Hi,

This feature is included in 8.8 as you can specify the date range.

Which version of SBO you are working on currently.

Regards,

Rakesh N

[former_member208987]

Hi,

i know that

But i want a query report.

customer is on 2007 and is not able to upgrade to 8.8 right now

Mark

[Former Member]

hi M. Hageman

the query is very long but i can tell you steps:

example : aging to 31/08/2010

- AP Invoice before 31/08/2010 that are still open

-AP Invoice reconciled after >31/08/2010 for AP Invoice created <= 31/08/2010

-AP Credit Memo before 31/08/2010 that are still open (It should be credit memo without base doc)

-Reconciliation for Credit memo without base doc created before 31/08/2010 but reconciled after 31/08/2010

-outgoing payment created before 31/08/2010 but have Open Balance <> 0

-Outgoing payment da reconcile trong thoi gian > 31/08/2010 ma duoc tao ra < = 31/08/2010

-Incoming payment of vendor created before 31/08/2010 and still open

-incoming payment created before <= 31/08/2010 but reconciled >31/08/2010

-journal entry befor 31/07/2010 that are still open

- journal entry befor 31/07/2010 But reconciled >31/07/2010

thanks,

H2