Rebuilding Customer Historical Ageing data with time buckets from CustTrans, and CustSettlement tables in Microsoft Dynamics AX 2009


I am currently builing an Account Receivables cube in SSAS by extracting data using SSIS from the CustTrans and CustSettlement tables of a Microsoft Dynamics AX 2009 installation.

I need to rebuild historical ageing information for the last 6 months for customers. For each date, I should be able to show the outstanding amounts and the age buckets.

I am finding it very difficult rebuilding history from the CustTrans and CustSettlement tables.

Thanks in advance.