Why Not for Profit Organisations LOVE Microsoft Dynamics NAV / Business Central

TES have been working with the NFP Sector for over a decade. Microsoft Dynamics NAV, and the latest version of this, Business Central has stood the test of time as the NFP sectors choice of ERP system, but why?

Microsoft Dynamics NAV/Business Central is the heart beat of an organisation looking after all aspects of the business, bringing together all the data to a common platform.

A tight grasp on financial information and all income streams is vital to Non profit organisations, the ability to do this, in real time is one of the key pieces of functionality that NFP Finance Directors appreciate about NAV.  

What other functionality does NAV/Business Central offer?

Functionality includes –

  • Financial management accounting. Manage your cash, assets and banking
  • Partial VAT recovery reporting
  • Clear restricted and unrestricted cash figures
  • Budget holders have clear visibility of their data
  • Multi level budget approval
  • Sales and service. Manage your contact, sales opportunities and service contract.
  • Project management. Create estimates, track projects and manage capacity.
  •  Business intelligence and reporting. Get a holistic view of your business and make informed decisions.
  •  Support for international currencies. Compete globally using multiple currencies and languages.
  •   Flexible deployment. Deploy on-premises or in the cloud, whichever model best fits your organisation

NAV gives NFP organisations full control over their financials, accurately forecasting budgets, allocating funds, compliant reporting and total visibility.

Our TES Added value in this is our industry experience. We have expert knowledge of the NFP sector, producing our own in-house software to enhance and resolve specific pain points Finance Directors in some of the current industry leading charities and not for profits we work with. We have most likely come across any issues you are currently wrestling with and will offer a solution. 

Accurate budgets – Forecast budget for projects with tighter control over spend on events and campaigns. 

TES Added value – set controls so each member of staff can use their own budget, approve their spend on any mobile device. While continually having a real time view of the total budget and actual spend.

Effective Collaboration – All departments can work seamlessly together by sharing information. All Microsoft programs we know, and love integrate seamlessly with NAV with means you can hit the ground running with this ERP system.

Compliant Reporting – SOFA & SORP rules are fully adhered to with the systems export functionality.

 Increased Visibility – Common feedback we get from our users is how useful the 360-degree view of the business operation is. It allows a faster reaction to new opportunities, constant grasp on the budget and spend.

 If you’re feeling like you don’t have total control over your accounting and purchase processes, if you’re in the Not for Profit sector and you want to discuss streamlining your business processes contact us to discuss is Microsoft Dynamics NAV/Business Central is the right choice for your organisation.

Join the market leaders in Not for Profit using Microsoft Dynamics NAV and future proof your organisation.


Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is set to be released April the 2nd.

Digital transformations have been the hot topic of late, and with the ever-changing world of technology, success is in development and transformation. Success is being able to adapt and evolve with the ever-changing technology world. Microsoft continually enhance and develop their systems to ensure their users are always ahead of the competition.

The Microsoft Dynamics 365 suite’s latest release will be Microsoft Dynamics 365 Business Central, generally available April 2nd. Business Central offers organisations a single end to end solutions for managing finances, operations, sales and customer service, and an opportunity to easily upgrade from their entry-level accounting software and legacy ERP systems.

 Business Central integrates with other Microsoft cloud services, including Office 365 and can be customised or extended for specific industry needs with Power Apps, Microsoft Flow and Power BI.

 Dynamic 365 Business Central brings the full power of Dynamics NAV to the Cloud, with the option remaining to host on premise. The foundation of proven technologies that have served 160,000 customers and millions of users worldwide. As a single end-to-end application, Business Central offers:

·  Business without silos. Unify your business, and boost efficiency with automated tasks and workflows—all integrated within familiar Office tools like Outlook, Word, and Excel.

· Actionable insights. Achieve greater outcomes and gain a complete view of your business with connected data, business analytics, and guidance delivered by Microsoft’s leading intelligent technologies.

· Solutions built to evolve. Start quickly, grow at your own pace and adapt in real time with a flexible platform that makes it easy to extend Business Central based on your changing business needs.

Dynamics 365 Business Central will be generally available on April 2, 2018 in 14 countries – United States, Canada, United Kingdom, Denmark, Netherlands, Germany, Spain, Italy, France, Austria, Switzerland, Belgium, Sweden, and Finland.

Do even more with Dynamics 365 Business Central using pre-built applications, available through the AppSource marketplace, to easily and cost effectively extend your solution

Excited to learn more? Get in touch to see if Total Enterprise Solutions can help your organisation be more efficient with Microsoft Dynamics Business Central.

Dynamics 365, Business Edition, Microsoft Dynamics NAV

Microsoft Dynamics NAV, Microsoft Dynamics 365 for Finance & Operations, Business Edition – Making Tax Digital?

As Her Majesty’s Revenue and Customs (HMRC) service strive to become one of the most digitally advanced tax administrations in the world, tax going digital is a hot topic. HMRC want to make the tax system more effective, efficient, and easier for customers to comply with.

What does that mean for you? Making Tax Digital will be enforced in Phases.
Initially businesses in the UK will be required to start using the Making Tax Digital system in April 2019, but only to meet VAT obligations. This is going to be a trail and the UK government has said they will not extend this requirement of Making Tax Digital for business beyond VAT until the system has proven to work, and certainly not before April 2020. This is all aimed to make it easier for both businesses and individuals to stay on top of their tax related affairs.

How does Microsoft support Making Tax Digital?
Microsoft are working to ensure that the supported UK versions of Microsoft Dynamics 365 for Finance and Operations, Business edition, as stated in the Microsoft Lifecycle Policy, will comply with the Making Tax Digital initiative.
VAT reports are already supported electronically, and the technical requirements of the initiative are being discussed between Microsoft and HMRC. There are advisory groups set up to ensure that Microsoft functionally support Making Tax Digital before it takes effect for businesses.

Here are some FAQ’s:

If you want to know more about the foundations for Making Tax Digital, please see this page from the UK government.

Day 11 of our Christmas Calendar

Day 11 is one of our most useful tips customers use in NAV, creating VAT statement templates.

To create a VAT Statement Template, follow these steps.

On the Navigation Pane click:

  1. Departments > Administration > Application Setup > Financial Management > General > VAT Statement Templates.
  2. Click New.
  3. In the Name field, enter a unique name for the template.
  4. In the Description field, enter a short description for the template
  5. Example template below – VATGB

To assign a VAT Statement Name to a template, follow these steps

  1. On the VAT Statement Templates window, select the relevant template. (e.g. VATGB)
  2. On the Navigate tab of the ribbon, click Statement Names.
  3. Click New and in the Name field, enter a unique name for the statement. (e.g. Default)
  4. In the Description field, enter a short description for the statement. (e.g. Default Statement)

5. On the Home tab of the ribbon, click Edit VAT Statement

An example VAT Statement in design mode (Source Cronus UK Ltd)

If you require assistance developing your own VAT statement, please do not hesitate to contact us. We will be more than happy to provide you with the appropriate assistance.

 6. On the home tab of the ribbon, click Preview

An example VAT Statement in Preview mode

VAT Settlement

Periodically, the net VAT must be remitted to the tax authorities.

To calculate this amount, run the Calc. and Post VAT Settlement batch job.

The following list describes some specifics that are related to this batch job:

  • Calculates VAT settlement of open VAT entries in previous accounting periods.
  • Finds all the VAT entries in the VAT Entry window—for every VAT Posting Group combination that is included in the filters in the batch job.
  • Use it to start the posting process or to print a test report.
  • Run it as frequently as it is needed.

Running the Calc. and Post VAT Settlement Batch Job

To run the Calc. and Post VAT Settlement batch job, follow these steps.

  1. On the Navigation Pane, click Departments > Financial Management > Periodic Activities > VAT > Calc. and Post VAT Settlement.

  1. In the Starting Date and Ending Date fields, define the date range for the VAT entries to be settled.
  2. In the Posting Date field, define the posting date for the settlement.
  3. In the Document No. field, enter a unique number. This field is required to run the batch job.
  4. In the Settlement Account field, click the drop-down list and then select the G/L account that the net of the Purchase and Sales VAT entries are transferred to.
  5. In the Show VAT Entries check box:

Click to insert a check mark to display all VAT entries that are used to calculate each VAT Posting Group settlement amount.

Leave it unchecked to display only the total settlement for each VAT Posting Group.

  1. In the Post check box, when you print or preview the batch job, do the following:

Leave it unchecked to print a test report.

Click to insert a check mark to post the transfer to the VAT settlement account automatically. (NOTE – This setting will execute the process regardless of whether you Print or Preview the report. Only use this option where you are sure of your data)

  1. Click to insert a check mark in the Show Amounts in Add. Reporting Currency check box for report amounts to be shown in the additional reporting currency.
  2. On the VAT Posting Setup Fast Tab, filter on the VAT business or product posting groups to be included in the batch job, when it is needed.

VAT Settlement Posting Results

  • When you post the Calc. and Post VAT Settlement batch job, it closes open VAT entries and transfers purchase and sales VAT amounts to the VAT settlement account.
  • When VAT entries are closed, the Closed field on the VAT Entry is selected.
  • The entry number of the settlement entry that closed the VAT entry is automatically inserted in the Closed by Entry No. field. This occurs only when the amount must be transferred between G/L accounts.
  • When a VAT amount is transferred to a VAT settlement account, the account for purchase VAT is credited and the account for sales VAT is debited with the amount from the VAT statement period. The account for VAT settlement is credited with the net amount (or, if the purchase VAT amount is larger, it is debited).


After VAT entries are posted and their status is closed, they cannot be reopened. However, VAT reports can be created from these closed entries.

Here at TES we are passionate about the quality with which you use the tools available to you in your Dynamics Nav solution.

We would be more than happy to work with you to help you develop your VAT Statement and take advantage of the VAT Settlement processes to ensure you maximise your return on investment in Dynamics Nav by investing in adopting automated standard tools that you can then use consistently for months, quarters and years to come.

Import a Journal from Excel to Microsoft Dynamics NAV

On the third day of Christmas our NAV elves bring to you a ‘how to guide’ on importing a Journal from Excel to Microsoft Dynamics NAV.

In this quick how to guide, we illustrate how easy it is to import journal data from Excel into Dynamics NAV 2017.
The Microsoft documentation for this is helpful, but we thought we would show you the tips and tricks to getting this working right first time.
Note that in Microsoft Dynamics NAV 2018, this feature is further enriched as you will be able to edit the data straight in the Excel application.
If you’re executing this routine for the first time, consider creating a template from a Dynamics Nav 2017 journal batch. This will provide you with all the fields that you might require when profiling your batch for the Excel export / import process.
To profile a journal ‘right click’ on a column heading, and select ‘choose columns’ from the menu you’ve invoked and profile your journal by adding or removing columns to suit your needs.

• Once the required columns have been selected, use the CTRL+E shortcut key to export your journal to Excel.
• Alternatively, highlight all the rows in the journal, ‘right click’ and select ‘copy rows’ from the menu option (CTRL+SHIFT+C is the keyboard shortcut.). If you prefer this option, you will need to open Excel and paste the rows in to an Excel worksheet.

• You can populate Excel (also taking advantage of Excel tools like formulas) with data ready to be copied back into the Dynamics NAV 2017.

• To copy your data back into Dynamics Nav 2017, highlight the journal area in Excel and ‘Copy’ it by using for example the ‘CTRL+C’ keyboard function. Note that the description and column heading rows are omitted from the copy selection. (Rows 1 and 2 in the following screen image)

• Select a new row in your Journal batch in Dynamics NAV 2017, ‘right click’ and select the “Paste Rows” option. (Alternatively, use the CTRL+SHIFT+V keyboard shortcut.) Note that you can append to a journal batch which already has lines it. It doesn’t have to be an empty journal.

Tips and Tricks
• Mapping
o Making sure the columns in the worksheet match the columns in the Journal is key.
• Consistency
o Option fields (For example Account Type and Account Number) should always be entered in Excel as they appear in Dynamics Nav 2017. To see your options, use the relevant drop-down menu in Dynamics Nav 2017.
o Code fields, or fields which validate to a different table must also mirror what you have in Dynamics NAV 2017.
The above illustrates how you can paste a journal into Microsoft Dynamics NAV 2017.

If you would like further assistance or would like to see how this works in Microsoft Dynamics NAV 2018 please do not hesitate to contact us.

It’s here! Microsoft Dynamics NAV 2018

And on the first day of Christmas Microsoft gave to you, the new Microsoft Dynamics NAV 2018 update!

Click here for further information.

If you would like to discuss if upgrading to Microsoft Dynamics NAV 2018 is the right move for your organisation please do not hesitate to contact us.

Microsoft Dynamics NAV or Microsoft Dynamics GP

The familiar Microsoft software you know and love, but which to choose?

Following Directions 2018 and the strong roadmap for Microsoft Dynamics NAV, we have been contacted by many Microsoft Dynamics GP customers enquiring what the future looks like for them. When implementing Microsoft Dynamics NAV, Microsoft have a 10 year extended life cycle support policy. NAV 2017 already takes us to 2027 with guaranteed investment and support from Microsoft. NAV 2018 is being released in December 2017 by Microsoft, followed swiftly in 2018 by the release of Microsoft Dynamics 365 Tenerife the next release of NAV. The future looks bright for NAV.
We are finding more GP users comparing the strong roadmap of NAV to that of GP, leading them to engage in discussions with TES regarding migrating from GP to NAV. Microsoft enables Dynamics GP users to trade in their current GP licence value against a new NAV license, when combined with the TES migration tools from GP to NAV. This makes for a commercially attractive proposition to switch and take advantage of the wider NAV functionality and roadmap from Microsoft.

Microsoft Dynamics 365 Tenerife will be the latest release of NAV from Microsoft offering on premise, in the cloud or Saas deployment options. You can see our infographic on this here.

Over 2000 people met in Madrid in October from across the globe to witness the latest NAV developments at Directions EMEA 2017. A clear message was delivered by Microsoft around their investments in NAV and Office 365 to support digital transformation in organisations so that they can remain competitive in todays world. You can read more about Microsoft Dynamics Tenerife and Microsoft Dynamics 365 here.

Whilst there are many similarities between NAV and GP we wanted to highlight some of the variances that clients consider when switching from GP to NAV.

Essentially, they are both comprehensive ERP solutions with an array of powerful tools to enable you to manage your business’ finances, operations, human resources, projects, supply chain, and manufacturing processes. Both are Microsoft products, which mean that they work seamlessly with other Microsoft solutions and systems. It also means that they have a familiar, intuitive user interface that enables users to adopt it and learn it quickly.
Microsoft Dynamics NAV is well suited for both out of the box use and customised solutions, and ideal when you need to develop a specific functionality for your sector. It is easily scalable to support your growth used by organisations from 5 users to 1000’s of users, meeting the needs of your business now, tomorrow and in the future, due to the Microsoft long term commitment and investment.

Microsoft Dynamics GP whilst it is easy to implement, quick and easy doesn’t always support your long-term goals. It is an out of the box ERP solution with limited customisation, UK partner network and roadmap.

Some variances to consider

Financial management –
GP: Includes a range of functionality for financial management and fulfils your specific business needs with control and security
NAV: Complete functionality for financial management and a more flexible accounting plan that can trace financial transactions through account dimensions. We also offer a Total Approvals portal that enhances the NAV system for comprehensive budget management, including mobile approvals for budget holders.

Reporting –
GP: You can easily configure and run consolidated accounts.
NAV: With NAV you get a flexible reporting structure, which means you can deliver results in exactly the way your company requires.

Sales order processing –
GP: Includes ‘out-of-box’ features that enables automated sales order processing with customised Word templates which can be e-mailed to customers, and the ability to collect line item billing information for items not in stock.
NAV: Invoice for stock and non-stock items. Leverages the flexible reporting tool that helps to create invoices which are based on the company’s or customer requirements.

Payroll – 
GP: Payroll functionality is an ‘out of the box’ functionality in Dynamics GP.

NAV: Payroll functionality is available through an integrated third-party solution, such as sage payroll system.

Procurement –
GP: Equipped with material requirements planning functionality, GP makes possible procurement decisions and precise procurement adjustment according to specific requirements.
NAV: Comprehensive procurement functionality provides real-time access to order status, product specification, production plans, inventory, requisition management and purchase order authorisation.

Manufacturing –
GP: Sales forecasting, job costing, quality assurance, engineering change management and capacity requirement planning is all included in GP.
NAV: NAV improves performance from production, and your shop floor to the bottom line. By controlling different manufacturing areas ranging from order entry to delivery, leveraging tools specifically for production orders, supply and capacity, planning, agile and manufacturing, version management, demand forecasting machine centres, finite loading and production scheduling.

Inventory Management –
GP: Controls inventory by managing it on a site-by-site basis, reduces handling and increases accuracy for single and multisite warehouse operations, and ensures the right inventory is available to meet customer needs
NAV: Efficiently track inventory items with multiple characteristics in order to reduce the number of inventory items in the system.

Project Management –
GP: Time sheets, expense reports and resource control along with the billing functionality help you control project direction, cost and completion.
NAV: With support for budgeting and resource management NAV enables you to plan, manage and track projects by tracking expenses, predicting availability and planning capacity.

In conclusion both NAV and GP have their Pro’s and Con’s for customers depending on their requirements, however, when looking at the level of investment from Microsoft in NAV / Dynamics 365 “Tenerife” and the clear position it has within the Dynamics 365 / Office 365 family going forward a review of the migration options from GP to NAV should be well worth a small investment in time.
This is further emphasised when looking at the size of the NAV partner network and customer base within the UK and rest of world.

If you would like any further information regarding Microsoft Dynamics GP or NAV, please do not hesitate to contact us. 

You can also download a free Microsoft Dynamics NAV capability guide here.

Did you know in your average working life you will only be involved in one ERP system installation?

At Total Enterprise Solutions if it is your first installation, or you’re a seasoned pro, our experts are here to assist you in the knowledge and expertise to make your digital transformation as smooth and easy as possible.
Microsoft Dynamics NAV is a multi-language, multi- currency enterprise resource management solution that organisations worldwide use to manage their accounting and finances, supply chain and operations.
Working seamlessly with Outlook, Word, and Excel, Dynamics starts with what you need, and allows you to adapt as you grow. This is within the Microsoft Cloud, or on your servers – the choice is yours.

Microsoft annually reviews, and updates Dynamics NAV to ensure you are always equipped with the latest technology.

Many prestigious organisations are using Microsoft Dynamics NAV to reach their goals and objectives.

Want to simplify your organisation, but not sure where to start?

Our ACCA Accredited Financial Consultants will delve into your business, establish your needs and write an in-depth proposal, so what you’re getting is crystal clear.
Then commence the training of key users, our approach is designed to ensure that Key Users understand NAV functionality, prior to making design or configuration decisions. We run application training and design workshops, where the Key Users are experiencing standard setup.
System Configuration and customisation. A TES developer will develop any customisations as agreed and documented in the scoping analysis phase. All development is documented and can be used as part of the final training pack.

User Acceptance Testing

Another key stage of the delivery cycle, UAT is a planned period during which the business can fully test all areas of the system development and configuration in order to ensure that the software meets the initially identified requirements and will support the business in a live environment.

System Walk Through

The System Walkthrough can be considered as a trial go-live event, the purpose of which is to collectively evaluate the system delivery against defined success criteria, as well as ensuring that the business users are ready to go-live and that Dynamics NAV will support the business.

End User Training

Our suggested approach is that End User Training is run by the business’ Key Users – this helps to embed the system knowledge within the business and empowers the Key Users to become a point of contact for questions/issues as the system is embedded into the company. If required, however, TES can assist with End User Training, in part or in full. For example, the development of a training plan, the creation of training materials, right through to running training sessions across the End User base.

Go Live

We understand that project delivery does not stop on go-live day. TES will ensure an on-site presence on the day of your go-live, plus an agreed number of days thereafter. The project delivery team will work closely with the TES Service Desk to undertake a structured handover that ensures seamless ongoing support to the business.

We’re Live, what’s next? Welcome to the TES Community.

Now, your project manager will be replaced with a shiny new account manager, who will be in regular contact with you to ensure you are totally satisfied with our service.

A brake fix Service Desk 

Market leading self service support portal ServiceNow

Access to our complimentary webinar tutorials

Discounted bank days 

Invitation to our annual customer day to keep you in the loop with all things Microsoft Dynamics NAV.


At TES we build long term relationships with our customers. We are here to get the best out of your investment of Microsoft Dynamics NAV.


If you would like to discuss this further or have one of our ACCA Accredited Financial Consultants visit you please do not hesitate to contact us.












What Can Microsoft Dynamics NAV 2017 Offer Your Organisation?

Technology is ever changing. Microsoft Dynamics NAV is an innovative intelligent business solution that is constantly reviewed, and improved to ensure it is the market leader year after year.
With Dynamics NAV there is no need for dramatic digital transformations, as every year your NAV upgrade will ensure you stay up to the minute with the latest features and technological trends. Is it time to upgrade your Microsoft Dynaimics NAV system to 2017 ?

As we book our flights to Directions, we find ourselves looking back at the most notable improvements from NAV. From the introduction of the Role Tailored Client in 2009, NAV 2013 bringing us the Web Client, NAV 2015 bringing us the Tablet Client and NAV 2016 bringing us the Phone Client. Everyone at TES has their personal highlights from NAV, and we are excited to find out the latest innovation.

From simplifying manual tasks, to rapidly producing charts and graphs – everything you need to run your organisation, Dynamics NAV knows how to assist you.
With NAV you only pay for what you need, choose your applications you need now, and build on them as you grow. NAV offers the total business solution.

NAV 2017 is jam packed with new and exciting features that will add genuine business value to your organisations – if you would like more information you can read about this here: DynamicsNAV2017_CapabilityGuide_EN

If you would like to view the whitepapers feature comparison across all the versions click here.

If you would like any further information, or to discuss whether a NAV upgrade maybe right for your organisation, please do not hesitate to contact us.