Financial dimension based on transaction type / posting type (cross-module)
Transaction-based financial dimension:
There was an easy-to-implement possibility to largely improve GL reporting and analysis capabilities by extending the ledger integration by financial dimensions.
In several setups, a posting integration is defined by ledger account defined i...
Dimension Segments to be displayed in separate columns
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 B...
Ledger settlement -> remaining accounting amount automatically posted to exchange rate/loss account
Currently it is not possible to settle two transactions (General ledger -> periodic -> Ledger settlement) when the transactions amount (for example €) is net-zero and the accounting currency (for example USD) isn't zero. First transaction: +€100 = +$111 Second transaction:. -€100 = ...
In the release notes for 2023 Wave 2, you'll find entries to support the calculation of gains/losses in both the accounting and reporting currency when doing ledger settlement. The reporting currency functionality will be delivered first, and then the accounting currency after that.
direct view of main account postings
When looking for an GL-account, for example in General ledger > accounts > main accounts there is no possibility in Operations furthermore to directly have a look on the postings. Instead a time consuming trial balance has to be run (for all accounts) before the account can be selected t...
Thank you for the feedback. This feature will be delivered with the 10.0.16 build. We have added the buttons Transactions and Accounting source explorer to the Main account page to quickly access the transactions for a single main account.
Intercompany transactions recognation with dimension not just with main account
Customers Group structure includes many companies e.g. 20 companies in one or many countries. Intercompany transactions need main account at least for IC accounts receivables/payables, sales, purchases. In this scenario with current standard functionalities customer would need to setup many inter...
Thank you for the feedback! We will consider this for future releases. Kristi, Microsoft PM
Ability to put default financial dimensions on the grid control
I would be great to have the ability to show and edit and filter the financial dimensions on the grid. This will help clients to easily identified the dimensions of the records across the system. Before AX2012 we have ability to put financial dimensions on the grid, without any modification. T...
Ledger settlement - allow partial settlement
Today it is only possible to settle transactions that equal zero, and my suggestion is to make it possible to perform partial settlements. For instance, you have a voucher that is accrued over a period of 6 months, January to June. It would be great to settle monthly, so that the report at any g...
The ability to partially ledger settle has been added to the 10.0.42 release. In addition, as part of the same feature we added support for automatic ledger settlement when the AR/AP settlement happens.
Improving data populations in Accounting Source Explorer (ASE) Report and Voucher transactions Report
We’ve found a number of inconsistencies in data population when running an accounting source explorer report and voucher transaction report, so would appreciate your support in getting these fixed by Microsoft. We have identified:- • The ‘document field’ is not being populated consistently even ...
All changes planned are currently in place for the Accounting source explorer. Some consistency of the document number cannot be achieved for transactions that originate from journal entries. Vendor invoice, free text invoice, etc... are correct. Future versions of the product will continue to enhance the reporting aspects of posted transactions.
Fixed dimensions overridden from import Excel AddIn
When setting up fixed dimensions for one account and import from Excel AddIn has different values for the dimensions, the journal lines show the values from the Excel file whereas the postings go to the default dimensions. This is the intended design as of now. The request is to import the main a...
Thank you for the feedback! We will consider this for future releases. Kristi, Microsoft PM
Improve ledger settlement - Settlement in transactional currency
The advanced settlement function for General ledger allows to settle transactions based on accounting currency. This design has a couple of disadvantages when it comes to settlement of sales and payment transaction in another currency than accounting currency. Preconditions. Accounting currency ...
With the introduction of the GL parameter "Enable post currency realized gain/loss for ledger settlements", the matching functionality was changed to match on the transaction currency. This was required in order to determine if a gain or loss should be posted.
The feature was originally introduced on 10.0.38 in Feature management, but was later moved to a GL parameter.
Administrator
We will be starting research and development on a new 'Accounting rules engine' which will meet this requirement. Think of it as bringing together all the posting profiles into a single location + adding support for more criteria and dimensions. For example, you could define accounting rules differently for customer invoices vs customer credits.
We'll update the Idea when we have more clarity on which release it will come in, but it's tentative for 2025 Wave 2. Please watch the release wave documents and What's new documents also for more details.