Have you tried running the AM270? I included the form help but that sounds like what you are looking for.
Run Account Balance Report (AM270) to reconcile general ledger account transactions that were posted to the General Ledger by company and account number. This report includes the posting date, asset, tag, transaction type, and transaction amount. You can run this report for non-posting books as well. More Information • You can report on any book that has the Depr Hist (Depreciation History) set to Y (Yes) on Book (AM00.1) or Books (AM00.2). • If you select D (Detail) in the Totals field, the report lists all the transactions, a beginning and end balance for each account as well as the detail of each addition, adjustment, transfer, and disposal transaction posted to the account. |