Why Build Community?
Posted: June 18, 2013 Filed under: Uncategorized | Tags: community, Dynamics, manuals, Microsoft, NAV, training, user group 1 CommentBack when I first recommended Microsoft Dynamics NAV to my company as an ERP solution, I was a lone voice in my universe. I had run the whole gauntlet of the request for proposal, partner screening, requirements planning, and final selection, and ultimately I was the person in charge and therefore responsible for where our company ended up because of my choice.
The first few years of using Microsoft Dynamics NAV were a little rough and I did many of the following things to solve problems:
- Spent hours on the internet searching for terms that might get me some results. Many of the searches ended up in programming and development forums that would show me the code behind what was happening, but wouldn’t help me, as an end user, figure out what steps I should take.
- Read the manuals I had gotten from my partner. I spend hours going through the manuals I had been given and trying to piece together how I could do more advanced tasks by cobbling together the simple examples I had.
- Brainstormed with my boss and my staff. We had quite a few long conversations about how to get things done. Some of these conversations actually solved the problem, many of them ended up with needing to go back to the manuals, or the internet, or to our partner.
- Just tried it in the live system to see if I could figure it out. Sometimes this was successful and sometimes it created more problems than where I had started. I was an inexperienced end user who didn’t even know having a test system was possible. When pressed, I took the risk (in small steps) to see if I could get it figured out.
- Called our partner for help. When all of the above failed, I would reach out to our partner for assistance and pay them to help us out.
What an incredible waste of time! I had spent hours and hours of time trying to solve simple problems. Why? Because I thought I was alone. Because I thought I was the only person who could solve what we had. Because I hadn’t built a network.
Eventually, I got smarter. I started to ask our partner, “Surely you have other customers who have this same problem. What do they do?”, and in return I got silence and an invoice for services. I went back to the internet and looked again, and this time, I learned about user groups and began to look for a user group for Microsoft Dynamics NAV, and I found one! I started small, lurking in webinars and listening and learning and applying all the things I learned back at the office.
Since then, I’ve gotten the opportunity to regularly attend the annual user group conference, and have built a robust network with other NAV users. While I do still go to the internet for answers, I know where to go and where not to go to get my answers. I know where to get the right manuals for what I really need. I don’t mess things up in my live system because I have an effective test system. I still pay my partner for help, but I get to pay them for things that really make a difference in improving things at my company instead of paying them to help with things I should be able to do myself. Most importantly, I have a whole network of Controllers and CFOs and other professionals from other companies who I can email or call to help solve a problem.
I’m no longer a lone voice, but a single voice in an entire chorus of knowledgeable NAV users who are making a difference at their companies because we’ve all chosen to build a community together.
If you haven’t found your community yet, find it here at www.navug.com .
nChannel lists Dynamics NAV Financials as a top Microsoft Dynamics NAV Blog
Posted: April 30, 2013 Filed under: Uncategorized | Tags: Account Schedules, budgets, Dynamics, financial reporting, Microsoft, NAV 1 Comment
nChannel gave Dynamics NAV Financials a really nice mention in their recent listing of top Microsoft Dynamics NAV blogs.
Here’s a blurb from the article:
About the Blog: Kerry uses her extensive experience in Dynamics NAV to give readers an in-depth look at account schedules, financial reporting, dimensions, budgets and more. Readers can also follow the blog on Facebook, follow Kerry on Twitter and subscribe via email in order to receive notifications of new posts (the blog is updated often, with some days generating multiple posts).
For the full article, listing twelve other really fantastic NAV blogs and communities, click here!
Blogiversary Top 20 (#1) Account Schedules Formulas Page
Posted: April 29, 2013 Filed under: Uncategorized | Tags: account schedule formulas, Account Schedules, cheat sheet, comparison date formula, comparison period formula, Dynamics, Microsoft, NAV, tips and tricks Leave a comment
We’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
The most viewed blog entry in the Dynamics NAV Financials first year isn’t an entry at all, but an entire page! Check out the Account Schedules Formulas Page found here to see what 15 people a week come to the blog to use.
I developed this page in response to a question I would get in my classes on account schedules. “Do you have a cheat sheet for all the formulas you can use in Account Schedules?” I’ve shied away from this in the past, because it’s a complex question. You’ve got to take into account comparison period versus comparison date, column type used, use of filters, and like all Microsoft products, there is often more than one way to accomplish the same result. But I think I’ve got us a start. To my knowledge, there are bits and pieces of this out there, but this is the most comprehensive guide to account schedule formulas that I know of.
If you know of more, please submit them here. As long as I can test it to prove it works in the way described, and it’s different enough from already listed formulas, I’ll add it to the list and make sure to put a shout out to the contributor on the blog.
I believe the power of community is an amazing thing. We continually make each other better by sharing information. I’m looking forward to seeing what our amazing NAV community can accomplish!
Blogiversary Top 20 (#3) Basic column layout options for NAV Account Schedules
Posted: April 25, 2013 Filed under: Uncategorized | Tags: Account Schedules, balance at date, Classic Client, column layout, comparison date formula, comparison period formula, financial statement, fiscal year, general ledger, NAV, net change, RTC Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
Column layouts in NAV account schedules are what you build to add more flexibility to your financial statements. You can have an unlimited number of column layouts to match together with your already existing row setups. In general, most basic row setups contain general ledger numbers and column layouts contain dates. As an example, when I produce my income statement, I will have one row setup that reflects a summarized income statement and at least four different column layouts that reflect different configurations of month to date, year to date, comparisons against budget, and twelve month trended views.
Just like with row setups, there are many available options in the column layouts. This large variety of options can sometimes be overwhelming to the new account schedule user. I’ll show you which columns to choose in the column layouts for account schedules as a beginning point, and go through some simple explanations of how they are used.
Fields to start with:
Column No. – The column number is completely optional, but highly recommended. This simple element of the column layout will eventually be one of the key features of your account schedule, allowing you to calculate and organize with ease.
Column Header – This is where you’ll define, in words, what you’re showing in each column of your report. Keep it short; there is a 30 character limit.
Column Type: Net Change, Balance at Date, or Formula – There are actually seven options to choose from here, but I recommend that you limit yourself to these three when you’re just getting started. The key here is knowing what type of accounts you’re reporting on. If you’re using income statement accounts (Revenue/Expense), then you need to use net change. If you’re using balance sheet accounts (Assets/Liabilities), then you need to use Balance at Date. Formula allows you to perform calculations in a column.
Ledger Entry Type – This column will allow you to define what type of ledger entries you will show. This is where you can choose actual general ledger entries or budgeted general ledger entries.
Formula – If you’ve chosen Formula as the Column Type, this is where you’ll put the formula.
Comparison Period Formula – This column allows you to define date formulas that are used to calculate the amounts shown. I generally recommend that beginning account schedule users start out using the comparison period formula field instead of the comparison date formula field. The comparison period formula field references the accounting periods set up in the fiscal year, so this option seems the most consistent, and is especially necessary for companies that may not follow a calendar fiscal year. Common data labels used in this field are CP for current period or -1CP for previous period and FY for fiscal year or -1FY for prior year.
Shown below are both the design view and the user view of a column layout for a summarized income statement showing year to date and prior year to date information in the columns to demonstrate the use of these six basic options in an account schedule.
Role Tailored Client
Classic Client
For more information on row setups, please see these posts: Basic row setup options for NAV Account Schedules and Complete row setup options for NAV account schedules.
If you’re just beginning to use account schedules, see Getting started with a new account schedule.
Blogiversary Top 20 (#4) Maximize your Microsoft Dynamics NAV 2009 Classic screen space with user level configuration options
Posted: April 24, 2013 Filed under: Uncategorized | Tags: Classic Client, glued column, increase header, NAV, RTC, user level configuration Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
One of the first things I do when I get a new person started using NAV is to show them how to customize their screens using different NAV options available at the user level. The NAV defaults start us off with white space in weird places, columns we may not necessarily use, and headers we can’t read. These are all possible to fix easily at the user level, and I’ll share my six tricks with you today.
Today we’re just going to cover the Microsoft Dynamics NAV 2009 Classic client. The Role Tailored Client, with its updated look and feel, is significantly different and Microsoft has done a great job of addressing many of these small challenges with the new client.
- Change the size of the main navigation pane. You can do this by hovering on the vertical blue separator bar until you get a double-sided arrow, and then move your pane to the left or right.
- Get rid of unwanted menu options. If you’re not using the Jobs or Service Menus, right-click on that item and choose hide. You can always add something back to the menu by right clicking and choosing show.
- Increase your header size. Every screen starts out with the header line as one line tall. This means that you can’t read most of the information in your headers. Hover at the bottom of the blank grey box at the top left of the lines area until you get a double ended arrow, then click and pull down to see more lines within the header.
- Check your row height. Depending on your preference, you might prefer rows taller or shorter than what is the default. Choose any grey separator bar on the left side of the lines area between two rows and move it up for shorter or down for taller. Your adjustment will be equally sized for all rows.
- Change your columns. Make sure to show only the things you need. There are almost always more options available with the default than what you will use in day-to-day transactions. If you have a coworker in a similar role, it may be best to check to see what they use regularly when you’re just getting started. Hide anything you don’t need just by using right-click and hide. Just like with the menu options, you can right-click and show if you want to put something back on your screen.
- Make the glued column smaller. In NAV 2009 Classic, on every screen, one column is always designated as the “glued” column. This column is generally the Description column. You’ll know which one this is when you try to resize it to a smaller size and get the error, “You resized the glued column Description, which then expanded automatically to fill otherwise empty space”. This can get frustrating for new users, because it seems there is not a solution. There are two recommendations that I have to get past this.
- Place your mouse to the right of the glued column separator, and move from right to left until you get a double-headed arrow. Left click, hold, and aggressively move to the left, farther than where you want to end up. This will make your glued column narrower, but only if you have a bunch of columns off to the right already.
- Another way to accomplish this is to add a column that you don’t need to the right and make it really really wide, so that it creates visual white space on the right hand portion of your screen.
Before
After
Blogiversary Top 20 (#5) PowerPivot to the People
Posted: April 23, 2013 Filed under: Uncategorized | Tags: BI, Excel, Microsoft, NAV, Office2013, PowerPivot Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
As a Controller at a small to medium-sized business, I struggle with the big BI question: do I invest in a business intelligence package or do I do it myself?
When I first became aware of PowerPivot, a free Excel add-on that became available with Microsoft Office 2010, I was excited and also a little relieved. While the emergence of PowerPivot didn’t completely solve my dilemma, it sure gave me some significant options for more data accessibility. I didn’t have to depend on my partner or an IT employee with special skills to build me a dataport from NAV, or to piece together an SQL query, or to build a cube I could apply queries to. Because I have PowerPivot, suddenly I can be Super-Controller; accessing tables directly in my NAV database, pulling ginormous amounts of data into a single spreadsheet, and manipulating the data with lightning speed into familiar Excel pivot tables, all without asking for help. 
So, when I read in a recent article from MSDynamicsWorld.com that New Office 2013 Licensing May Put PowerPivot, Power View Out of Reach for Some Microsoft Dynamics Users, I was actually pretty alarmed and then pretty upset. How dare Microsoft give us this shiny new Christmas dream and then snatch it away like some kind of horrible data-reneging Grinch!
I went looking for a few more answers about exactly what was going on, and what I found out was that Microsoft has actually taken PowerPivot out of most versions of Office 2013. This is a big deal because it was previously available in all versions of Office 2010, so Microsoft is actually removing functionality. PowerPivot is only available in Office 2013 if you get Office Pro Plus through volume licensing or through Office 365 subscriptions. Basically, this means PowerPivot is not available in any retail Office 2013 packages, so therefore, is only reachable by companies who have enough purchasing power to utilize volume licensing packages. So, a tool that was designed, in my opinion, to give BI power directly to the people by making it simple enough for financial folks to pull their own data, has now been restricted to only business class licensing. If you’re looking for some interesting theories as to why this might be, read Hey, Who Moved My (PowerPivot 2013) Cheese?
Mr. Excel himself (Bill Jelen), the uberist Excel geek of them all, has some great stuff to say about PowerPivot, including “PowerPivot is the best new feature to hit Excel in 20 years” and a few other things here including a great short video explaining why we should care. I just said in a recent NAVUG Ask the Experts Finance webinar only two weeks ago that as a financial professional who uses NAV, learning to use PowerPivot should be the most important skill finance people should learn in the next year.
Microsoft has missed a huge opportunity to finally settle a score in the BI arena for small to medium businesses by making this move. There has always been the argument that using Excel spreadsheets is a risky proposition for financial professionals. You can really create some big problems for yourself if you are not careful in how you manage your spreadsheets. Some companies even go so far as to outlaw them and attempt to go spreadsheet free. Companies who sell BI packages lean on this pretty hard, trying to remove spreadsheets from the list of available choices.
I say this risk is greatly offset by the benefit of being able to use a tool that can pull, in a safe way, massive amounts of data that can be manipulated by the typical Excel end-user quickly and efficiently. For me, the benefit PowerPivot brings to my company tips the scale on sinking money into a BI solution, and keeps me firmly in the DIY BI camp, with Excel as my primary tool. Making PowerPivot available in all new versions of Excel seals the deal and makes BI in Excel a revolution of equality, ensuring equilateral Excel adoption in the business world.
I’m glad to see so many people bringing forward a call to action to bring PowerPivot back to all versions of Office, not just Pro Plus and Office365 subscriptions. I’m adding my voice, and will continue to ask Microsoft to bring PowerPivot to the people!
Blogiversary Top 20 (#6) Getting started with a new account schedule
Posted: April 22, 2013 Filed under: Uncategorized | Tags: Account Schedules, Classic Client, NAV, RTC Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy
If you are just getting started with account schedules, you need some basic information to get going. This post will show you where to find account schedules in NAV, how to create a new one, and how to name them. We’ll cover both the role-tailored client (RTC) as well as the classic client.
Where can you find them?
If you’re using NAV with the RTC, choose Departments, then General Ledger from the Financial Management menu, then choose the Account Schedules link under the Reports and Analysis and Analysis & Reporting menus.
If you’re using NAV 2009 and prior versions with the classic client, choose Financial Management=>General Ledger=>Analysis & Reporting=>Account Schedules.
How do you create a new account schedule?
In the RTC, creating a new account schedule is made easy with the New button located on the action pane. If you’re a keyboard shortcuts person, you can use Ctrl-N, or if you prefer to use menu options, go to Actions=>New.
In the classic client, use F3 to create a new record for the account schedule, or select New from the Edit menu.
How do you name a new account schedule?
Once you’ve created a new report using the RTC, you’ve got 10 characters available for the Name field, and 80 characters available for the Description field.
The classic client has the same parameters.
Both clients will allow you to use any combination of numbers, letters, or special characters.
Keep in mind, that regardless of whether you are using RTC or the classic client, the names you use for the description field will be the default names used when you print account schedules directly out of NAV.
Blogiversary Top 20 (#7) 15 days of NAV dimensions
Posted: April 19, 2013 Filed under: Uncategorized | Tags: Account Schedules, Convergence, CustomerSource, dimensions, Dynamics, NAV, NAV 2013, tips and tricks Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
March Madness may mean basketball for some folks, but for me it means Convergence! Getting a chance to participate as a speaker at Microsoft Dynamics Convergence is a great opportunity to meet new NAV users I haven’t met before. I’m always looking to expand my network of knowledgeable professionals, and one of the ways I do that is by sharing information.
I’m lucky enough to be giving a concurrent session this year called Tips & Tricks for Working with Dimensions in Microsoft Dynamics NAV and I thought I would put together a series for the blog on the same topic to get the information out to a wider audience. For the next 15 days, there will be a brand new post on one of these dimension topics. Enjoy!
Day 1 4 questions to ask when deciding how to use NAV dimensions in your business
Day 2 5 reasons you need to use NAV dimensions
Day 3 The finance professional’s perspective on NAV dimensions
Day 4 Why finance and IT need to work in partnership on a NAV dimension strategy
Day 5 Viewing NAV dimensions on postings: where can you see them?
Day 6 NAV default dimensions and value postings applied to master data
Day 7 NAV default dimensions and value postings on the chart of accounts
Day 8 NAV dimension combinations for additional accuracy
Day 9 NAV dimension priorities
Day 10 Resolving NAV dimension errors
Day 11 NAV dimensions in account schedules
Day 12 NAV dimensions in budgets and consolidations
Day 13 Communicating to IT about NAV dimensions and NAV2013 dimension sets
Day 14 Add NAV dimensions as your business changes
Day 15 Learning more about dimensions from Microsoft Dynamics Customer Source
BONUS View Convergence 2013 session on Microsoft Dynamics NAV dimensions here
This posting is one of the Top 20 Most Viewed in the last year! Follow this link to see the entire list.
Blogiversary Top 20 (#9) Where can I learn more about NAV analysis reports and analysis by dimensions?
Posted: April 17, 2013 Filed under: Uncategorized | Tags: analysis by dimensions, Analysis Reports, CustomerSource, export to excel, general ledger, item ledger entries, NAV, pivot table, query tool, reporting tool Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
Analysis reports and analysis by dimensions are the native reporting options that extend NAV reporting to the item ledger entries generated from the sales, purchasing, and inventory areas of the application. I find that many users don’t know that this reporting option exists and think it is one of the more underutilized areas by NAV financial users.
These reporting options can be found on the general ledger, sales & marketing, purchasing, and inventory menus.
The main advantage this reporting tool has over account schedules is that it reaches a further level of detail that just isn’t recorded on the general ledger. Being able to get to quantity information at the item or location level in addition to the dollar values posted makes these tools great as a way to get operational reporting.
What is the difference between the two?
Analysis by dimensions is a query tool. The key to using this tool effectively is to use aggressive filtering, especially if you have a large number of items. It can be a very quick way to get information about what may be going on with a single or small group of items. You can also export to Excel and it shows up in a pivot table.
Analysis Reports allow you to configure and save row setups and column layouts for later use, which makes it a reporting tool. These reports work a lot like account schedules, with some added features to accommodate the additional data you can reach because you’re reporting against the item ledger entry tables instead of the general ledger.
A few hints on analysis reports and analysis by dimensions:
- Skip the analysis report on the general ledger menu and use accounts schedules; you’re not going to get any added value here.
- When posting sales or purchase orders, you must be fully utilizing the sub module, i.e. do not allow any posting of lines to general ledger accounts on the sales or purchase order documents. Any posting that goes “around” these modules will cause your analysis report to show a lower number than what is on your general ledger. Avoid the argument of reporting credibility by understanding this, and either being able to explain the variance, or prevent it from happening altogether.
- Know that analysis reports will not automatically update if you add new items. You’ll need to go in and do this manually to each report every time you add new items.
For those of you who are looking for more resources on Analysis by Dimension and Analysis Views, reference the documents below, found on Customer Source:
Documentation => User Guides => Overview of Training Manuals and Hands-On Labs for Microsoft Dynamics NAV 2009
- Trade in Microsoft Dynamics NAV 2009 – Chapter 9
- Business Intelligence for Information Workers in Microsoft Dynamics NAV 2009 – Chapter 5
Documentation => User Guides => Overview of Training Manuals for Microsoft Dynamics NAV 5.0
- Trade in Microsoft Dynamics NAV 5.0 – Chapter 10
- Business Intelligence for Information Workers in Microsoft Dynamics NAV 5.0 – Chapter 6
Blogiversary Top 20 (#11) Complete row setup options for NAV account schedules
Posted: April 15, 2013 Filed under: Uncategorized | Tags: Account Schedules, balance at date, Classic Client, column layout, dimensions, Excel, export to excel, financial statement, general ledger, NAV, net change, posting accounts, row setup, RTC, set base for percent, setup options, show opposite sign, totaling type, trial balance Leave a commentWe’re celebrating our one year blogiversary by reposting the Top 20 Most Viewed in the last year, as determined by you, our readers! Follow this link to see the entire list. Enjoy!
About a month ago, I published a post called Basic row setup options for NAV account schedules. This is a great place to look if you’re just getting started. However, if you’re looking for what else you can do with Microsoft Dynamics NAV account schedules, then this is where you want to be. This post will go through each and every field available on the account schedule row setup and talk about the available options. The functionality of these fields are exactly the same between the Classic and Role Tailored Clients. The only difference is in how they look on the screen and how you navigate between screens. Take a look at the pictures below to find the look you’re familiar with, but then keep reading for the explanations of what these fields will do in your financial reporting.
Role Tailored Client
This is a view of what I recommend you start with for basic row setup options.
This is a view of all available row setup options.
Classic Client
This is a view of what I recommend you start with for basic row setup options.
This is a view of all available row setup options.
Row setup options – apply to both clients
Row No. is completely optional, but highly recommended. This simple element of the row setup will eventually be one of the key features of your account schedule, allowing you to calculate and organize with ease.
Description is the one place you have to communicate, in words, what you’re showing on each line of your report.
Totaling Type: 6 options to choose from
- Posting Accounts pull data from your accounts designated as posting accounts on the G/L Account Card Account Type field.
- Total Accounts pull data from your accounts designated as a total or as an end-total on the G/L Account Card Account Type field.
- Formula allows you to calculate a basic formula on this row.
- Underline places a single underline .
- Double Underline places a double underline.
- NOTE: This nifty addition showed up with NAV 2009 R2. If you are NAV 2009 SP1 or earlier, this won’t be available to you.
- Both of the underline functions are there to give folks who print account schedules directly out of NAV some formatting options. If you’re exporting to Excel you’ve got some better format options to work with than these.
- Set Base for Percent allows you to designate which row from your row setup will be used as the beginning point for a section to be included in a percent of total calculation. This feature showed up in version 5.0 and must be used together with a formula on another row to designate the end point of the section as well as some setup in the column layout. It’s a little fussy in the setup and inelegant in execution, but is still effective to get those vital comparative percentages onto your account schedules.
Totaling will be which general ledger accounts you want to pull or what formula you want to calculate, depending on what you selected in totaling type.
Row Type: 3 options to choose from
- Net Change should be used, generally, if you’re reporting on income statement accounts (revenue/expense).
- Balance at Date should be used, generally, if you’re reporting on balance sheet accounts (assets/liabilities).
- Beginning Balance will be sparingly used, but you’ll want this for your statement of cash flows at some point.
Amount Type gives you three options: Net Amount, Debit Amount and Credit Amount. You’re going to use Net Amount almost all the time, but I suppose if you were getting very granular in your account schedules and perhaps using them for detailed reconciling reports, this might be useful. If I’m getting down to this level of transactional detail, I’m usually going to the chart of accounts instead of account schedules.
Formatting Fields: Bold, Italic, and Underline These basic formatting fields are there to allow you to emphasize some of the rows of your account schedules. When you select these options on any row, the whole row is effected. You are not able to effect a single “cell” for formatting. What’s the difference between underline here and underline found in the Totaling Type options? You can get a more snug fit on your underline using this option since it appears in the same row of your data instead of in a row if its own.
New Page inserts a page break. This is commonly used when separating the pages of the balance sheet showing assets on the first page and liabilities and equity on the second page. I have also seen it used when folks build multi page account schedules.
Show Opposite Sign is the option you can select to change revenue credit balances or expense debit balances to the opposite sign for the purposes of presenting this data in a more non-finance friendly manner. No salesperson wants to see sales presented with a negative sign; use this to change that credit to a positive number on your reporting.
Show allows you to designate if a row will show (the default) or be hidden on the printed account schedule only. You can click this box as much as you want, but your rows will still show on-screen or when you export to Excel. If you print directly out of account schedules, this feature will work very well for you.
Dimension Totaling is the last option available and you might have noticed that I didn’t show them on pictures above. This is because they are unique for just about every user, and depending on your analysis view setup, may even be different from schedule to schedule. You can use just one, or you can use all four of the available dimension totaling fields, in whatever combination you like. These fields act very much like the Totaling field because this is where you will tell NAV what Dimensions you want shown and totaled from your general ledger accounts.
Dynamics NAV Financials 