Balance Sheet using Dimension filters

Fred_Leary

We are creating a new Business Unit to support three other separately reporting Business Units. Within this new Business Unit we wish to create divisions using filters so that we can break out a division and link to it's offsetting Business Unit that it is supporting when desired.

For External Reporting we finish with four separately reporting Business Units; Balance Sheet, Income Statement, Financial Position.

For Internal Reporting though we would like to link the supporting companies division with it's offsetting Business Unit to get a truer look at the product line. Holds true on the Income Statement side, but we seem to be losing dimensional reporting when it comes to Accounts Payable and Cash...guessing we would have a similar problem with A/R but we are not using that module, too little activity. And without a working B/S we then also lose out on the Financial Position.

It appears that although we use multi-line and multi-dimensional reporting when keying A/P items, the invoices are simply posted as single-line/no dimension items into A/P. And I am guessing that the Cash posted against the Payment Journals is simply picking up the lack of dimensions listed with the A/P.

Do we possibly have a feature turned on/off that could correct this application?

ara3n

Nope this is how dimensions work and it is a limitation of Navision on balance sheet accounts.

And it will require major modification to solve this.
For example. If you are writing a check for 10 invoices from all the 3 companies, what dimension should the payment line have?