General Ledger Detail Report

(0) Share

Report

Posted on by Community Member

I'm curious as to what others are using for financial backup reports by accounts. I want to be able to process financial statements using Management Reporter and run Detailed backup of the accounts in the same order as the Financial Statements. I'm currently using SSRS Detail Trial Balance and have added the Originating Master Name, Description and Reference fields. For efficiency, I have created a report for Balance Sheet asset accounts, liability accts, etc so the headers will print accordingly. The only idea I've come up with for sorting is to add an account user defined field for numbering in financial statement order. Has anyone else try to address these requirements and found a better way?

Thanks,

Debi

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

Part of the process depends on how the accounts are ordered in the MR reports. If you are following the normal grouping (Assets, Liabilities....etc) and the numerical by account number, you can link your report to the GL Account Number String table (GL00105) and sort first by type (from GL00100) then number or portion of the number.

If you have your accounts completely random ordered, you will need some type of ordering scheme. I would suggest using an Extender Table tied to the accounts that you could use to order the accounts on your report. Using this would allow you to upgrade GP with no re-coding of a customization.

Was this reply helpful? Yes No