Weighted average balances

nay_chi_soe_tun

I'm trying to set up a report in AX 3.0 to give me the weighted average balances of selected GL/creditor/debtor accounts on a given date (e.g. as at 31/12/07) within a date range (e.g. 1/7/07..31/12/07).

I've done a quick fix by doing it in Excel through Atlas however there are thousands of customers and the data retrieval is quite slow. The other option would be to have multiple smaller files but it is quite impractical. New account numbers are needing to be manually added to the files, and so on.

I have non-existent experience with AX reports and spending significant time navigating through AX tables. ](*,)

If there's anyone who has done this before, please help me out.