Hi,
Dimensions in AX allow you to split the P&L pretty easily. But what do you do with the balance sheet and subledger level customer/vendor.
We thought of having default dimensions on customers & vendors and it works fine as the customer/vendor groups pick up the related GL control account with the dimension string on customers/vendors. However in events of customers/vendors used by multiple business unit constantly. We don't want the user to change dimensions on master files. Scenarios where transactions (invoice or purchase order lines) can belong to different financial dimension string and works fine with P&L accounts, however the other side will be the control accounts. These control accounts are posting as consolidated amounts of the invoice/purchase order and use the single default dimension string on the customer/vendor(ignoring the fact that there are multiple lines with different dimensions). We would have hoped that the control account would have got split as per the transactions (lines), so the dimension string and amounts will come from transactions and control account from customer/vendor groups.
Hoping anyone can shed some light.
*This post is locked for comments
Lally,
On Ax 2012 and higher there is an option in the GL parameters called Financial dimensions: Values used for summary accounts. If you have this set to Source document, it will use the financial dimensions from the HEADER of a source document (which typically defaults from the vendor, customer). If you switch that setting to Accounting distributions, your AR/AP ledger account will default from the financial dimensions from the accounting distributions of the document. This is how you can have your AR/AP split to follow the dimensions of your expense/revenue/asset account.
BUT.....you need to understand that this GL parameter is only used for documents that are source documents. This includes PO vendor invoices and the FTI for the vendor and customer side. It does NOT include any transactions you enter via the journals or the SO customer invoice.
Kristi
Hello lally,
Seems that I understood your question wrong. Would you mind posting some screenshots that illustrate an example that shows your issue in detail?
Many thanks and best regards,
Ludwig
It doesn't really make sense. It makes sense for GL accounts level only ,what about subledger level as it posts consolidaetd amount.
Hello lally,
Have you tried making use of the balanced financial Dimension Feature?
This should be able to generate you Balance Sheets by Business Units.
Please see:
technet.microsoft.com/.../jj729752.aspx
technet.microsoft.com/.../jj729758.aspx
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156