Using Dimensions in Reporting for Dynamics NAV/365 Business Central

This post continues exploring the topic of Dimensions in Dynamics NAV (further, “NAV”) and Dynamics 365 Business Central (further, “D365BC”). Other posts have already discussed what Dimensions and Dimensions Values are; how to create; and assign them to Master Data and GL Accounts as well as how to block Dimension Combinations. This post focuses on how to use Dimensions in reporting in particular.

Bron : Encore Business
Lees meer…

Troubleshooting the Analysis by Dimensions Matrix in Dynamics NAV

A few months ago, I worked on a case where a client was having a problem with the analysis by dimensions matrix in Microsoft Dynamics NAV. It was a tricky problem (and quite hard to state in a descriptive manner), so I’ll demonstrate it using pictures.

If you are expecting an output that looks like this (the analysis by dimensions matrix shows the G/L accounts per month):

Bron : Encoreblog
Lees meer…

Test and fix dimensions before upgrading to NAV 2013

A coworker in Advania is working on a Business Intelligence solution called Advania Insight. He is working on the installation for a company that is running NAV. This company has data from Navigator since 1994.

One of the problem we saw was that some of the dimension codes used where not a standard dimension but for example a heading or a footer. This did not go to well through the analysis and we needed to fix this

Bron : Gunnar’s Blog
Lees meer…

How to include Dimensions in Conf. Package Table Fields while using Rapid Start Services in NAV2013

You must have seen my blog video “How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services” here.

You can see the Dimensions in Conf. Package tables fields but you cant see Dimensions as fields in Newly created package.

How to add the Dimensions in newly created package table fields?

Bron : Advanced Business Systems
Lees meer…