AR Rolling or movement reporting

Has anyone ever written or created a detailed AR rolling / movement report by customer account to represent the entire AR sub ledger that ties back to the GL movement? we have a request from our auditors to provide this information.

Currently we are using open item and do not print statments for all customers. We find the AR294 report lacking in this area.

Any recommendations on which canned Lawson reports may be move useful than creating out own report?