Exporting to Excel – Microsoft Dynamics Nav Tip – Version 5 onwards

There are certain invalid characters that will not export to excel


: \ / ? * [ or ] 


If you have created a G/L, Customer, Vendor or Bank Account Name that includes one of the above characters then go into Ledger Entries and Export to Excel you will get an error relating to the Workbook Setting.


You will need to rename the G/L Name code and ensure it does not include one the above characters.


Entering Dates – Microsoft Dynamics Nav Tip

In a date field you can just type in t – this will bring up today’s date when you come off that field.

Please note that if you have changed your work date and you type t, today’s date will still appear.  (t uses the system date for the computer).  The shortcut for the work date is w.  To change the Work date you click on Tools, Work Date. 

You can also enter dates with or without separators.  There is no need to type in  '/' or '-'  between days/months/years.

For Example:

·         If you enter two digits, Navision reads this as the date; it will add the month and year of the work date.

·         If you enter four digits, Navision reads this as the day and the month, it will add the year of the work date.



Recurring Journals Tip – Microsoft Dynamics Nav Tip

In Recurring Journals if you have a line set up where there is no value to post this month and you attempt to post you will receive the following error:

Amount must not be 0 in Gen. Journal Line Journal Template Name = ‘RECURRING’, Journal Batch Name = (name of your journal batch), Line No = (Line No. where you have the zero amount)

To get round this you do not need to delete the line you can filter out the zero line as follows:

Under the Amount column apply a Field Filter (F7), enter a filter saying not equal to Zero <>0 then OK

This will allow you to post the journal, when posted the Posting Date of the line that was zero (that was filtered out) will not have moved onto the next month.  Just amend this manually.

VAT Changes in Microsoft Dynamics NAV

The changes to VAT announced yesterday have left us with the challenge to get your systems updated to reflect the new VAT rate of 15% from Monday while still allowing the processing of historic transactions at 17.5%. Unfortunately it’s not as simple as just creating a new VAT posting group, we need to run some routines to update g/l accounts / items / resources / item charges and open sales lines and purchase lines. We already have the required tools due to a recent  VAT rate change in Germany and we have already begun to test them on the UK versions of NAV. We will however need your assistance to test the process on your specific systems and in addition there will be some work for you to think about (for instance ALL part complete warehouse shipments and receipt documents linked to purchase lines or sales line have to be deleted prior to running the process!).


We are going to be doing some initial testing over the next day but need you to assist by getting an up to date copy of your system into  a test environment ready. Joy Hambridge will be managing the process this week, so if you have any specific queries please contact her (she won’t be on support during this process, so please respect this, as it’s an important issue for us all to get over).


I need you to think about when you will be able to switch over, as ideally we don’t want to be working all weekend, so if we can make a start on Friday it would be very much appreciated.

Using Intrastat: November’s NAV Knowledge Workshop

If you're struggling to use the Intrastat area of NAV, November's Knowledge Workshop is for you!

The free morning course for customers will cover:

  • Set up requirements

  • Running the process at period end

  • Howto use EC sales Reports

  • Purchase Acquisitions from the EU

To book your free places visit here.

Customise which blog posts you get from us…

Blog_screenshotNow you can choose which bits of news you receive from us.

Simply select the category of interest listed on the right hand column of the blog page and then click the link on the top right. This will ensure you only get the news from the news category that’s of interest to you.

Currently this doesn’t work with email subscriptions, but we’ll try and sort this out soon.

October NAV Knowledge Workshop – Bank Reconciliation

Technology Management’s October Microsoft Dynamics NAV (formerly Navision) knowledge workshop will be looking at Bank Reconciliations. Delegates will learn the best approach to find any differences when the Bank Account Card value is not agreeing with the General Ledger balance, hints on how to find and correct these differences and also how to input any entries shown on the Bank Statement into NAV via the Reconciliation screen.  We will advise on best practice to keep the Bank Account card and GL agreeing to the Bank Statement Balance.

The event runs on Thursday 23 October 2008, 9.30am – 12.30pm at Technology Management’s offices in Wolverhampton.

To book your place email mark.britton@tecman.co.uk

The NAV Knowledge Workshops run monthly and are free to all customers.

Dynamics NAV: Checking totals on your VAT Statement

You can run the Day Book VAT Entry Report to check totals in each box of your VAT Statement.

For version 4 and later – Financial Management, General Ledger, Reports, VAT Reporting, Day Book VAT Entry.For version 3 – General Ledger, Reports, Day Book VAT Entry

Box 1
VAT due on sales and other outputs (SALES VAT) You get this value if you run Day Book report with type SALE

Box 2
VAT due from you (but not paid) on acquisitions from other EU countries (PURCHASE REVERSE VAT) You get this value if you run Day Book report with type PURCHASE, VAT Calculation Type equal Reverse Charge VAT

Box 3: total VAT due (TOTAL VAT)

This is the sum of boxes 1 and 2. This is the amount of VAT you must pay or reclaim.

Box 4:
VAT reclaimable on your purchases (PURCHASE VAT incl. REVERSE) This is the VAT that you paid on your purchases. You should also include VAT you paid on imports. You can also think about this amount as a sum of "PURCHASE VAT" and "PURCHASE REVERSE VAT".

You get this value if you run Day Book report with type PURCHASE

Box 5:
VAT payable or reclaimable

This is the difference between boxes 3 and 4.

Run the Day Book report with type PURCHASE|SALE, "VAT Calculation Type" different from "Reverse Charge VAT"

Box 6:
  Total value of sales excl. VAT, incl. Row 8

You get this value if you run Day Book report with type SALE from the BASE Total

Box 7:
  Total value of purchases excl. VAT, incl. Row 9

You get this value if you run Day Book report with type PURCHASE from the BASE Total

Box 8:
  Total value of supplies excl. VAT to EU

Run the run Day Book report with type of SALE, VAT Calculation Type equal to Reverse Charge Vat

Box 9:
  Total value of acquisitions excl. VAT to EU

Run the run Day Book report with type of PURCHASE, VAT Calculation Type equal to Reverse Charge Vat from the BASE Total

August NAV Knowledge Workshop Announced

Technology Management’s August Microsoft Dynamics NAV (formerly Navision) workshop will be looking at VAT Settlement returns and Reconciliation to GL. Delegates will learn the best approach to find any differences when numbers aren’t balancing, plus hints and tips for producing a balanced return.

The NAV Knowledge Workshops run monthly and are free to all customers.

This month’s Workshop runs at Technology Management’s offices in Wolverhampton on Thursday 21 Augsust – 9.30am – 12.00 noon.

To book email mark.britton@tecman.co.uk

Running the adjust cost – item entries routine

What is it?

It’s a routine that checks that the inventory cost of a transaction going out of the system matches the inventory cost that went in.

For example –if you purchased an item in January, Sold it in February and then posted a purchase invoice for it in March (with a different cost), it would adjust the cost of sale to match the newly posted invoice cost.

When should I run it?

Firstly you should run the routine away from normal transactional hours, as it is quite a complex process and can cause record locking if you try to run during the day.

How often should I run it?

This really depends upon how accurate you need to keep your cost of sale information during the accounting period. As a minimum you should run it once per month, we generally recommend running it weekly.

Do I need to run it if I am using Standard Costing?

Yes – this is because you may still have stock with a different standard cost to current, especially if you have not re-valued your stock to match the standard cost.

How do I need to set up my posting dates?

You need to pay attention to getting your posting dates correct before you run this routine, as it will attempt to post into a prior period unless you set your posting date ranges correctly.

User Setup   

You need the allowable date range set for the person running the routine to be as wide as any potential adjustments. If you set this too narrow, you will receive an error saying to don’t have permission to post in that date range.

General Ledger Setup

This is the important one! The “Allow Posting From” field needs to be the first date you want any prior period changes to get posted to, so typically this is the first day of your current period. Anything after this date will get posted on the actual date of the change. If you are running the routine say in the first week of a month, but using it to finish off the previous accounting month, then you would set this field to the first day of the previous month, allowing it to adjust cost of sales for the previous month before you close it.

Remember to change the dates in your user setup back to the current period!