You’re offline. This is a read only version of the page.
240
We have a project where we have a large number of companies (>120) that we are consolidating in AX 2012 and reporting on using Management Reporter. We are facing a challenge where some accounts occur naturally on the debit side of the balance sheet, but are sometimes credit and should be presented on the credit side of the balance sheet. under a differenct main account category.
For example we have some bank accounts that naturally occur on the debit side of the balance sheet, but some banks have a credit balance. The banks on the debit side of the Balance should be shown under the current assets, where the banks with a credit balance should be shown on the credit side under current liabilities. As some of these accounts may change from debit to credit on a regular basis we are looking to find a dynamic way to present the total balance on the debit or credit side determined by the total balance of an account at the end of the period. This can be further complicatd by the usage of a reporting tree where on some levels the balance may be debit and on a lower level may there may be a debit or a credit and the item should be shown on the correct spot at each level.
We have tried to set this up using MR, but are failing to find a way to present the items on the correct place in the balance sheet at each level. Has anybody faced a similar issue or konw a possible solution for this issue at hand?
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
