This walkthrough includes tasks for the following role:

• Sales Manager (Kevin)
  

This walkthrough is based on the assumption that you have some prior knowledge of financial management and accounting in general.

Important
This walkthrough is intended to be used with the worldwide (W1) version of the CRONUS International Ltd. demo database. You will need to adapt it for use with your country/region-specific version of the demo database.

Before you can perform the steps in this walkthrough, you must do the following:

• Install the CRONUS International Ltd. demo database. (If you have changed the data in the demo database, you should restore the database with the original demonstration data.)
  
• Save the additional sample data in the attached Microsoft Office Excel spreadsheet for import during the walkthrough.
  

To save the additional sample data for import

1. In the navigation pane, click the Departments button, and then click Financial Management. On the Financial Management page, click Administration, and then click Dimensions.

2. In the Dimensions window, select the line with the SALES CAMPAIGN dimension. Click Related Information, click Dimension, and then click Dimension Values.

   Note that a summer and winter dimension value has already been set up for the Sales Campaign dimension.

3. To set up a new value, click New. On the new line, in the Code field, enter NOT KNOWN. In the Name field enter Not known.

4. Close the window.

5. In the Dimensions window, select the AREA dimension, and click Related Information, click Dimension, and then click Dimension Values to open the Dimension Values window.

   Note how the subsets of a dimension value are indented. This hierarchical structure resembles the structure of the chart of accounts.

6. Close the Dimension Values window and the Dimensions window.

1. Click the Departments button, click Financial Management, click General Ledger, and then click Chart of Accounts.

2. Select the lines with the Sales of Retail accounts (6105..6195).

3. Click Related Information, click Account, click Dimensions, and then click Dimensions-Multiple. The Default Dimensions-Multiple window appears.

   As an alternative to manually entering dimension information, you can set up default dimensions to ensure that transactions related to, for example, the sales campaign are denoted. The Dimensions-Multiple functionality allows you to specify how a particular group of accounts will use dimensions and dimension values. When one of these accounts is used, dimensions and dimension values will automatically be suggested, for example on a journal line.

   You can also enter default information for customers, vendors, and items.

   Default dimensions can be changed on a transaction-by-transaction basis.

4. Click New to insert a line and fill in the following fields.

   Field	Value
   Dimension Code	SALESCAMPAIGN
   Dimension Value Code	SUMMER
   Value Posting	Code Mandatory

5. Close the Default Dimensions-Multiple window.

1. Click the Departments button, and then click Financial Management. On the Financial Management page, click Administration, and then click Dimension Combinations.

2. Click the SALESCAMPAIGN/CUSTOMER GROUP cell, and then select Limited. Click OK.

3. Right-click in the cell, and then click DrillDown. The Dimension Value Combinations window appears.

4. Scroll down and click the SUMMER/INSTITUTION cell and select Blocked. Click OK.

5. Close all windows except the main application window.

1. Click the Departments button, and then click Financial Management. On the Financial Management page, click Administration, and then click Default Dimension Priorities.

2. In the Source Code field, select the SALES source code.

   The Customer and Item table have already been assigned priority 1 and 2, respectively.

3. Click a blank line to add a new default dimension priority. Fill in the fields with the following values.

   Field	Value
   Table ID	413
   Table Name	IC Partner
   Priority	3

4. Close the Default Dimension Priorities window.

1. Click the Departments button, click Financial Management, click General Ledger, and then click G/L Budgets.

2. On the G/L Budgets page, click New to create a new G/L budget name.

3. Fill in a line in the G/L Budget Names window with the following values.

   Field	Value
   Name	CAMPAIGN
   Description	2009/2010 Campaign Summer Budget
   Budget Dimension 1 Code	SALESCAMPAIGN
   Budget Dimension 2 Code	AREA
   Budget Dimension 3 Code	BUSINESS GROUP

4. Select the new line, and then click Edit Budget.

After you have defined specific budget dimensions in the G/L Budget Names window, they are available on the Filters FastTab in the Budget window.

1. In the Budget window, on the Filters FastTab, fill out the filter fields to specify which dimensions to use. Fill in the fields with the following values.

   Field	Value
   G/L Account Filter	6105..6195
   Salescampaign Filter	SUMMER
   Area Filter	10..55

2. On the General FastTab, in the View by field, enter Week.

3. Click Actions, click Functions, and then click Import from Excel.

4. In the Workbook File Name field, click the AssistButton.

   Note
   If you have not already allowed the server to run Microsoft Common Dialog Control on your client, you will receive a message requesting permission to run the dialog control. Allow the dialog control to run. The server will then open the dialog box that you will use to browse for the file on your client computer, in order to upload the file to the server.

5. Browse to the CRONUS International Ltd. Budget.xls file that you saved earlier. Select the Excel file and click Open.

6. Fill in the remaining fields in the Import Budget from Excel window.

   Field	Value
   Worksheet Name	Budget
   Budget Name	CAMPAIGN
   Option	Replace Entries
   Description	Imported from Excel

7. Click OK. In the messages that follow, click Yes and then click OK.

8. In the matrix, click the amount in a cell to show the entries that make up the amount.

9. Close the G/L Budget Entries window.

   You can create budgets on various dimensions using the Show as Lines or Show as Columns field on the General FastTab.

10. To view the campaign budget per area, in the Budget window, in the Show as Lines field, enter AREA.

11. Close the Budget window and the G/L Budget Names window.

1. To create a new sales invoice, click the Departments button, click Sales & Marketing, clickOrder Processing, and then click Sales Invoices. Click New to create a new invoice. Press ENTER to use a number from the number series.

2. In the Sell-to Customer No. Field, enter 10000.

   Note that when you fill in the Sell-to Customer No. field, a range of information is immediately entered on the invoice. This information includes dimensions relevant for this customer.

3. To see the dimensions that are now assigned to the invoice, click Related Information, click Invoice, and then click Dimensions.

4. Close the Document Dimensions window.

   Because this sales invoice relates to a sales campaign, you can set up shortcut dimensions in the Sales Invoice window to easily enter dimension information on the transactions that relate to the sales campaign. Some of the shortcut dimension fields are not shown on the sales invoice lines, so you will add them in the next step.

5. Click a sales line, right-click, and then click Choose Columns. Add the following fields to the line: Customergroup Code, Area Code, Businessgroup Code, and Salescampaign Code.

6. Fill in a sales invoice line with the following values.

   Field	Value
   Type	Item
   No.	70001
   Description	Base
   Location	BLUE
   Quantity	1
   Unit of Measure	PCS
   Unit Price	40,30
   Customer Group	MEDIUM
   Area	30
   Salescampaign	SUMMER

1. To see all of the dimensions on the line, click Actions on the Lines FastTab, click Line, and then click Dimensions.

   Now the Document Dimensions window displays dimensions and dimension values related to the specific sales line.

2. Close the Document Dimensions window.

3. Click Post to post the invoice, and then click Yes.

   When you post the invoice, entries will be posted to all related accounts, such as customer accounts, item accounts, VAT accounts, and general ledger accounts.

1. Click the Departments button, click Sales & Marketing, click Sales, and then click Customers.

2. In the Customers list, select customer 10000, click Related Information, click Customer, and then click Ledger Entries. The Customer Ledger Entries window appears.

3. In the Customer Ledger Entries window, scroll to the bottom of the window and select Document No. 103022.

4. To see the dimensions assigned to the customer ledger entry, click Related Information, click Entry, and then click Dimensions.

5. Close the Ledger Entry Dimensions window.

1. Click Navigate. The Navigate window appears.

   In the Navigate window, you can get an overview of all entries for the sales invoice. All entries made when posting the invoice are displayed, for example, general ledger entries and VAT entries.

2. Select the Posted Sales Invoice line and click Show. The Posted Sales Invoice window appears.

   Note that it is possible to reprint the posted sales invoice.

1. In the Posted Sales Invoice window, click Related Information, click Invoice, and then click Statistics. The Sales Invoice Statistics window appears.

   Here you can see all entry details. You can view, for example, profit, invoice discounts, and VAT amounts for the posted sales invoice.

2. Close all windows except the main application window.

1. Click the Departments button, click Financial Management, click Reports and Analysis, and then click Analysis by Dimensions.

   You can have as many analysis views as you want, using highly specific filtering criteria such as general ledger accounts, and up to four analysis view dimensions.

2. Select the CAMPAIGN analysis view, click Actions, and then click Edit.

3. On the analysis view card, on the Dimensions FastTab, ensure that the analysis view is set up with the same analysis dimensions as the budget, that is: SALESCAMPAIGN, AREA, and BUSINESSGROUP.

   Within each dimension, you can specify a filter on dimension values.

4. Click Related Information, click Analysis, and then click Filter. The Analysis View Filter window appears. Fill in the window with the following values.

   Dimension Code	Dimension Value Filter
   AREA	10..55
   SALESCAMPAIGN	SUMMER

5. Close the Analysis View Filter window and return to the analysis view card.

6. On the General FastTab, in the G/L Account Filter field, enter 6105..6195.

7. Accept the message that appears.

   You can also include budgets in an analysis view. There are four budget dimensions and four analysis view dimensions available, so you can always create an analysis view that can be compared with your budgets.

8. On the General FastTab, click to insert a check mark in the Include Budgets field.

   After the analysis view has been set up or changed, an update batch job must be run to gather general ledger entries posted since the last update. You can also click the Update on Posting check box to specify that the analysis view will be updated each time an entry is posted. However, this may affect performance.

9. Click Update to update the analysis view and accept the message that follows.

10. Close the Analysis View Card window.

1. In the Analysis ViewsList, select the CAMPAIGN analysis view, and then click Edit Analysis View. The Analysis by Dimensions window appears.

   The amounts in the Analysis by Dimensions Matrix window represent all general ledger entries with the criteria specified for the selected analysis view. The amounts can then be filtered further by entering information in the filter fields.

   You can use the Show as Lines/Columns fields to view the same amounts by dimension values, rather than the traditional G/L Account/Period combination.

2. On the Filters FastTab, some fields are already filled in. Add the following filters.

   Field	Value
   Date Filter	12-01-09..03-01-10
   Budget Filter	CAMPAIGN

3. On the Matrix Options FastTab, in the View by field, select Month.

   Analysis views can be compared with budget amounts in a number of ways, including variance percentage.

4. On the Options FastTab, in the Show field, click the AssisButton to view the different options. For this exercise, select Budgeted Amounts.

   Note that there is also a field where you can select the option to Show Amounts in Add. Reporting Currency.

5. Click Show Matrix to see the results.

1. Close the matrix window and change the contents of the Show field to Actual Amounts.

2. Click Show Matrix and then click Related Information, click Actions, and then click Export to Excel.

   Excel opens and the analysis is automatically exported.

3. Close Excel without saving the document and then close all windows except the main application window.

1. Click the Departments button, click Financial Management, click Reports and Analysis, and then click Account Schedules. The Account Schedule Names window opens.

   In this window, if the Analysis View Name field for an account schedule contains the name of an analysis view, the account schedule will be based only on general ledger data that has been gathered in the analysis view, that is, analysis view entries.

   Note that the CAMPAIGN account schedule is based on the CAMPAIGN Analysis View. In this example, you want to create an account schedule that is based on the CAMPAIGN analysis view.

2. Select the CAMPAIGN account schedule and click Edit Account Schedule in the Action Pane to show the Campaign Analysis account schedule.

   In the Account Schedule window, row names are defined by the person who creates the report and amounts can be taken from specific general ledger accounts, groups of general ledger accounts, or based on formulas. When the account schedule uses analysis view entries, both general ledger accounts and dimension values are used for totalling.

   An account schedule can either be printed immediately or viewed.

3. To view the account schedule overview, click Overview.

   In the Acc. Schedule Overview window, you will apply a date filter as you did in the analysis by dimension.

4. To add the filter pane to the window, click Customize , and then click Customize This Page. Select the Show Filter pane field, and then click OK.

5. Fill in the Date Filter field as you did in the analysis by dimension: 12-01-09..03-01-10 and then press ENTER.

6. Click Show Matrix to view the account schedule overview.

   Note
   Using the online version enables you to drill-down from all figures to see which entries comprise the total.

7. Click the amount in any of the amount fields to view the drill-down functionality.

1. In the Acc. Schedule Overview Matrix window, click Actions, click Functions, and then click Export to Excel.

2. In the Option field, select Create Workbook and then click OK.

   The account schedule overview can be represented visually using graphs and charts in Excel. Note that when you use this function for the first time, Microsoft Dynamics NAV will create and open a workbook in Excel. Subsequently, when exporting the same account schedule, you can select the relevant workbook and Microsoft Dynamics NAV will automatically update all Excel cells, graphs, and charts.

3. Close Excel and close all windows except the main application window.

1. Click the Departments button, click Financial Management, click Analysis and Reporting, and then click Dimensions - Total.

2. In the Dimensions - Total window, in the Analysis View Code field, enter CAMPAIGN.

3. In the Include Dimensions field, you can specify which dimension information should be included in the report.

   Click the AssistButton next to the Include Dimensions field to open the Dimension Selection window.

4. Click Actions, and then click Edit List to make the window editable. In the Level column, on the line with AREA, enter Level 2.

5. In the Level column, on the line with G/L Account, enter Level 1. Close the window.

6. Fill in the remaining fields in the Dimensions - Total window.

   Field	Value
   Column Layout Name	BUDGANALYSIS
   Date Filter	12-01-09..03-01-10
   G/L Budget Name	CAMPAIGN

7. Click Preview to preview the report.