NAV 2016 to Create & Setup Account Schedules

Part 2 in this series about MS Dynamics NAV for Business Intelligence takes off from where Part 1 left, NAV 2016 for Business Intelligence – Part 1. The previous part had details on NAV being used to Analyze Actual Amounts and Budget Amounts. Part 2 deals with MS Dynamics Navision being used to Create and Setup Account Schedules.

Account Schedules are meant for arranging accounts listed in the chart of accounts in certain strategic ways that help provide information about those accounts. Multiple layouts can be setup to define information that has to be extracted from the chart of accounts. Account Schedules are primarily meant to provide a place for calculations which otherwise are not directly possible in the chart of accounts, calculations such as subtotals for groups of accounts which can then be included in new totals and also used in other totals.

Some of the advantages that come with creating Account Schedules, which your Microsoft Dynamics NAV Partner will explain to you in detail at the time of installing the Business Intelligence module, include calculating profit margins on such dimensions as departments or customer groups. Besides, general ledger entries and general ledger budget entries can also be filtered. Even two or more account schedules can be compared and so can column layouts be through formulas. Such comparisons will help:

1. Create customized financial reports

2. Create as many account schedules as needed, each with a unique name

3. Help set up various report layouts and print reports with the current figures

Given below are steps to Create New Account Schedules on MS Dynamics NAV.

1. Search -> enter Account Schedules -> choose related link

2. Account Schedule Names -> Home -> New -> Create New Account Schedule Name

3. Go to Name field -> Enter name that you wish your new account schedule to have

4. Fill Default Column Layout and Analysis View Name fields as appropriate

5. Home -> Process -> choose Edit Account Schedule to begin defining rows for the account schedule

Follow the steps given below to Setup Account Schedule Rows Manually on MS Dynamics Navision. Setting up Rows is the next automatic step once new account schedules have been created.

1. Search -> enter Account Schedule -> choose related link

2. Account Schedule -> select desired account schedule name in Name

3. Go to Account Schedule -> Fill in all the fields -> For help, click the field and Press F1

Given below are steps to Setup Account Schedule Columns Manually on NAV. After Rows, come Columns. They can either be setup manually or assigned a predefined layout to account schedule. Else, no information will display. It is important that all this be known before-hand, though your Microsoft Dynamics NAV Partner will guide you on this.

1. Search -> Account Schedules -> choose related link

2. Account Schedule -> Name -> select Account Schedule name -> OK

3. Actions -> General -> choose Edit Column Layout Setup

4. Fill up all fields in Column Layout -> For more information, select field and Press F1

Follow the steps given below to Assign Predefined Column Layouts to Account Schedules.

1. Search -> Account Schedules -> choose related link

2. Account Schedule Names -> Default Column Layout -> Fill in relevant account schedules

Now Change Column Layouts in Account Schedules.

1. Search -> Account Schedules -> choose related link

2. Name -> select relevant account schedule name

3. Home -> Process -> choose Edit Column Layout Setup

4. Name -> select desired column layout name -> OK

After this, Set Up Account Schedules with Overviews.

1. Search -> Account Schedule -> choose related link

2. Account Schedule -> Name -> select default account schedule name

3. Actions -> Functions -> Insert Accounts

4. Select all those accounts you want included in your statement -> OK

5. Navigate -> Account Schedule -> Overview

6. Dimension Filters FastTab -> Set Budget Filter to the Desired Filter Name

7. OK

Now Create Account Schedule Columns That Calculate Percentages.

1. Search -> Account Schedules -> choose related link

2. Account Schedule Names -> select account schedule

3. Home -> Process -> Edit Account Schedule -> This will set up an account schedule row which will help calculate the total on which the percentages will be based

4. Insert a line immediately above the first row for which you seek a percentage

5. Fill up fields. In Totaling Type -> enter Set Base for Percent

6. Actions -> Functions -> Edit Column Layout Setup

7. Column -> Formula -> enter formula for the amount for which a percentage has to be calculated

This pretty much sums up Part 2, which covered everything on How to create and Set up Account Schedules on NAV. Part 3 will be cover Setting Up and Publishing KPI Web Services based on these Account Schedules that have been created. Follow Up!