Aging report and general questions

has anyone done an Aging report for receivables? I have one in Crystal that is 95% correct but have some issues One problem is the Closed date. From Axapta it is the date the when the tranaction is fully settled. If no date then its still not fully settled I have transactions fully settled but with no date Also have some with a last settlement date after the closed date would think in time the last settlement date should equal the closed date when it is paid in full or debit/credit applied to force a 0 balance Axapta has it own aging report that I have discovered is wrong. Tried to figure out how it gets data but is very well buried. If you have an invoice 90 days late and get a partial payment , it will move it back to the current column instead of 90 days less the amount paid Axapta 3.0 SP1