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.