Thursday, 13 March 2014

How to: Delete Companies NAV 2013 R2

How to: Delete Companies NAV 2013 R2


Firstly; we recommend that you make a backup before you delete the company. This can be stored as a read only file and even zipped in order to save space.
In addition to this, before deleting the Company, it is very important that you ensure you are the only user who has access to the company.
To make sure that you are the only user who has access to the company
1.       In the Microsoft Dynamics NAV Development Environment, on the File menu, choose Database, and then choose Alter.




2.       Choose the Options tab, select the Single User check box, and then choose the OK button.


To delete a company in Microsoft Dynamics NAV Windows client
1.       In the Microsoft Dynamics NAV Windows client, open a different company.
2.       In the Search box, enter Companies, and then choose the related link.
3.       In the Companies window, choose the company that you want to delete, and then, on the Home tab, in the Manage group, choose Delete.


4.       Confirm that you want to delete the company (CRONUS UK 2).


NB: This deletes the company, this action cannot be undone.

How to: Create a New Company NAV 2013 R2

How to: Create a Company NAV 2013 R2


To create a company in Microsoft Dynamics NAV Windows client or Microsoft Dynamics NAV Web client
1.       In Microsoft Dynamics NAV, in the Search box, enter Companies, and then choose the related link.

2.       On the Home tab, in the Manage group, choose Edit List.

You can create a new company, or you can create a copy of an existing company. When you create a new company, data is not included.
When you create a copy, the business data is copied to the new company.
a.      To create a new company, choose an empty row, and then, in the Company Name field, enter the name of the new company.

The company name can have a maximum of 30 characters. If the database collation is case-sensitive, you can have one company called COMPANY and another called Company. However, is the database is case-insensitive, you cannot create companies with names that differ only by case.


b.      To create a copy of an existing company, choose a company, and then, on the Home tab, in the New group, choose Copy.

Then, in the Copy Company window, in the Company Name field, enter the name of the new company.

Choose the OK button to create the company.

When you create the company name, remember that it will be written at the top of various reports. Therefore, write it exactly as you want it to appear.

You can create as many companies as your license allows for.

Wednesday, 5 March 2014

NAV 2013 R2 Creating Cash Flow Forecasts

Setting up a Cash Flow Forecast Card

To calculate a cash of your company on January 31st 2015; firstly you will need to set the work date to 31/01/15.

  • Select Set Work Date

  • Set the work date in the window that opens

The next step is to create a new Cash Flow Forecast Card
  • On the navigation pane click Departments > Financial Management > Cash Flow > Cash Flow Forecasts
  • Click New to create a new Cash Flow Forecast Card

For the purposes of this example we are going to setup a cash flow forecast for the period 31/01/15 to 28/02/15. The example will include neutral payments, consider discounts and cash flow payment terms.


Once the necessary values have been entered NAV will be able to calculate your expected cash flow for this period.

There are a number of possible options when setting up the Cash Flow Forecast Card and the above example is simply one combination of the options available. Full details of the various fields are as follows:

  • Consider Discount - Select the check box to have the cash discounts assigned in entries and documents that will be reflected in the liquidity calculation.
  • Consider Pmt. Disc. Tol. Date - Select the check box to have the program factor in the payment discount tolerance date when you calculate the flow date. You can only select this option if you decide to take the discount into consideration.
  • Consider Pmt. Tol. Amount - Select the check box to use the payment tolerance amounts from the posted customer and vendor ledger entries.
  • Consider CF Payment Terms - In addition to the standard payment terms of customers and vendors, you can specify your own methods of payment for the cash from forecast. If you want to use these in the cash flow calculation, select this field.
  • Show in Chart on Role Center - Select the check box to have this Cash Flow Forecast promoted on the Role Center Cash Flow Chart.
  • G/L Budget From & G/L Budget To - Enter the starting and ending date from which you want to use the budget values from the general ledger in the cash flow forecast.
  • Manual Payments From & Manual Payments To - Enter a starting and ending date from which neutral expenses will be included in the Cash Flow Forecast.





Tuesday, 4 March 2014

NAV 2013 R2 Cash Flow Setup

Cash Flows

Understanding cash inflows and outflows is the key to running a successful business. You can use cash flow to easily create a short-term forecast that predicts how and when you expect money to be received and paid out by your business.

Cash Flow Setup 

The program uses a function to automatically calculate the current cash flow of the company. To make sure that the relevant information in the cash flow forecast appears in the correct accounts, you must use the Cash Flow Setup page. You use this page to establish which accounts must be used for the entries in the sales, purchases, service, and fixed assets areas.

To access the Cash Flow Setup:

  • On the navigation pane, click Departments
  • click Financial Management > Cash Flow > Cash Flow Setup

General FastTab
  • Receivables CF Account No. - Enter the number of the cash flow account in which the values for open receivables will be registered. The program uses open customer ledger entries to calculate open receivables.
  • Payables CF Account No. - Open payables are registered in this cash flow account. The program uses open vendor ledger entries to calculate the open payables.
  • Sales Order CF Account No. - All open sales orders are registered in this cash flows account. The program uses all  sales orders that are not yet fully invoiced to calculate the order volume.
  • Service CF Account No. - All open service order item lines are registered in the cash flow account. For this calculation, the program uses all service orders that are not yet invoiced.
  • Purch. Order CF Account No. - Enter the number of the cash flow account in which open purchase orders will be registered. The purchase order volume originates from all purchase orders that are not yet fully invoiced.
  • FA Budget CF Account No. - Enter the number of the cash flow account in which the acquisition costs of the budgeted fixed assets will be registered.
  • FA Sales CF Account no. - Enter the number of the cash flow account in which the proceeds from the planned fixed assets sales are registered.
Number FastTab
  • Cash Flow Forecast No. Series - Select the number series  that the program uses to number cash flow forecasts.
Finally select OK to close the Cash Flow Setup page.



Friday, 28 February 2014

Navision 2013 R2 Upload a Licence

Upload a Licence to Navision 

To upload a licence to NAV; it will be necessary to open the Development Environment as this action will not be possible within the Role Tailored view.

Upload the licence by selecting: Tools > Licence Information.


At this point you will be presented with a window displaying the current licence being used by Navision (in the case of new setups, this will be a Cronus licence). From this window please select Upload and select the necessary licence from your files.





NAV 2013 R2 Import Objects

Import New Objects

It is not possible to import objects to NAV 2013 R2 through the role tailored view, as such, it is necessary to open the Development version of R2 before uploading modifications to the system.

Open the development environment; click Tools > Object Designer. When open it will then be possible to import objects to R2.




Do this by selecting File > Import while the Object Designer is open. 


Selecting Import will enable the appropriate objects.fob file to be imported into Navision. The user will be prompted to either Merge or Replace All new objects. With very few exceptions Replace All should be the option chosen as it will overwrite previous versions of the object and avoid conflict between the new and previous code.

After selecting all Replace All and OK the objects will be imported to Navision.

Compile The Objects

After importing the objects.fob to Navision, in the Object Designer select the button All on the left-hand side of the window. Then highlight all of the objects and press F11 to compile all of the objects.

How to Create a User in NAV 2013 R2

Set Up User and User Rights

NAV allows companies to limit users to only view information that pertains directly to their job role. There are a variety of different permissions that a user may be granted dependent on the type of tasks that they will be carrying out on a day-to-day basis. Administrators can specify what authorised users are allowed to do within the database:

  • Read data
  • Insert data
  • Modify data
  • Delete data
  • Execute data
Procedure: Set Up a New User Card

When users log on to the database, they can perform tasks in accordance with the permissions that they have been allocated.

To set up a new user go to the Navigation Page > click Departments > Administration > IT Administration > General > Users.



Once you have reached this page (pictured above) select Users and the click on New, alternatively press Ctrl + N to create a New User.

Now you are in the User Card (below) select the ellipses (...) on the fast tab Windows Authentication, this will open the Select User or Group window. In this window type the domain of your user, in this case metaphorix, and the user name (taken from their windows login). 

The next step is to find the user by selecting Check Names > OK. This will auto-populate the User Card with necessary information to create a user. At this point it is possible to submit additional information to the user card such as a date on which the users permissions will expire and the user's password (assuming database logins are used rather than windows authentication).  


Complete the stage by entering the user's permission level in the bottom left-hand corner, in this case SUPER, and click OK.

The user "danielw" has now been added to Navision 2013 R2.