Currently when you run a general ledger detail report, the way it lists the transactions, posted to accounts, is to list the account number on one line and then list all the transactions underneath that account number, that were posted to the account, on a line for each transaction. In order to use this data in excel, for sorting and pivot tables, I then have to copy and paste the account number to list in an additional column of the transaction. This is quite cumbersome, but the information is useless to analyze if I do not have the account number on the line with the rest of the details of the transaction. I would like for you to add a capability or option of having this information listed with the rest of the details of the transaction.
Been asking for years for this!
Attachments Open full size
Please do this! It takes me so much time to add account information to each line of the GL account report...
Attachments Open full size
Couldn't agree more! Been manipulating GL account reports for years now to get account number detail into each line item to use it in data tables.
Attachments Open full size
YES! I agree with this wholeheartedly. The GL Account reports are the best way to get balance sheet detail (better than a query), but the format is always clunky. I always feel the need to edit it before sending on to any other team-member or auditor, or before I can begin working with the data.
Attachments Open full size