In Dynamics 365 for Finance and Operations, Trial Balance (General Journal > Inquiries and reports > Trial balance) is displayed with Main accounts and Dimension segments in separate columns. This is enabled by the parameter "Display segments in separate columns". Hence, when the Trial Balance is exported to excel, all segments are exported into separate columns in Excel too.
Similar functionality is also required in all other places where we view financial transactions viz. Voucher transactions (General Journal > Inquiries and reports > Voucher transactions).
Currently, when Voucher transactions (posted data) are exported into excel, segments and main account is combined into a single column, and hence not understandable which segment value belongs to which Segment.
Comments
Very helpfully and essentiell
Category: General Ledger
Is very helpful particularly analyse data in excel or use in BI report.
Category: General Ledger
Absolutely essential!
Category: General Ledger
Yes, this functionality is very much required, as this will ease during the Data management, Excel Add-ins and Reports which are dependent on financial dimensions.
The best example is:
We have a customer who is running their operations in more than 30 countries and 10 are having the same chart of accounts and the 7 are having their own and the remaining entities are having their own chart of accounts. For all these 30 legal entities have around 50 custom financial dimensions excluding the entity backed dimensions. So, while configuring the financial dimensions for integration of applications requires to add all the financial dimensions as this configuration is not legal entity specific. Hence this will be huge difficult process during importing the Master such as Customer, Bank etc. and general journal or any other transaction through data management and or Excel-Addin as we don't have the option configure to display each financial dimension as a separate column in the data template configuration (which essential can be configured for each legal entity, but currently tedious process).
Hope Microsoft can provide more dynamic approach to resolve the issue.
Category: General Ledger
Provide dimension description as separate column with the search capabilities.
Category: General Ledger
One million percent agree with this! It is painful in many areas when trying to analyse data when it is one string.
Also as per previous poster this is definitely required in budgeting module also, the current setup creates many frustrating issues when uploading
Category: General Ledger
The same is also required for Budgeting > Inquiries and reports > Basic budgeting > Actual vs. budget
Category: General Ledger
The same is also required in General Ledger > Inquiries & Reports > Accounting Source Explorer
Category: General Ledger