Thinking about moving to the Azure cloud

Thinking of moving to Azure? Five reasons why TES agree.

1. We can help you with migration. Azure allows users to migrate their complete solution to the cloud with ease. Saving you time, money and effort, Total Enterprise Solutions can assist you through this process. Or there is a step by step guide how to do it yourself here

2. Security is top of any organisations agenda following the implementation of the General Data Protection Act, and the continual threat of hacking or data leaks. Microsoft have a dedicated security team to ensure the highest levels of security is taking care of the Azure cloud. With the ability to back up your data in various locations around the globe, you can be sure your system is safe and secure backed up in another data center. View our infographic on the cloud here.

Microsoft are also investigating an eco-friendlier data centre in the sea. You can watch a video about this here:

3. We practice what we preach. We never store customer data, systems or our projects on hardware. It is all in the Azure cloud. This is due to its reliability. Your team can access their work any time of the day or night.

4. It’s so flexible. Buy the space you need now, and increase your requirement as you grow. If you have a sudden requirement for more space, Azure keeps track of your solution and will auto scale to ensure your requirements are always met.

For more information around Azure’s scalability click here.

5. From data to insight in seconds. Make educated decisions with your data exactly how you want to visualise it. Power BI and Azure are both tools Total Enterprise Solutions use to help you streamline, secure and run your organisation with to give you what you need when you need it.
Keep an eye on our blog to see Power BI webinars coming soon.

If you would like to discuss moving your organisation into the Azure Cloud and the benefits around this, please do not hesitate to contact us on

or call us on 0345 257 1173

Team Planning Performance Chart

Microsoft Dynamics 365 Business Central Resources

At Total Enterprise Solutions we build long term strategic relationships with our customers, to help them reach their organisations goals.

We have a unique and successful implementation methodology, with our approach we empower the user with product skills and knowledge so that they can maximise the return on investment from their finance system. 

There is so much information circulating the web it is difficult to know which information is reliable, or even where to get it.

In the lead up to our free webinar ‘Demystifying migration to Microsoft Dynamics 365 Business Central’ we have collated a dedicated resources section for Business Central.

But if you would like to discuss your requirements please do not hesitate to contact us.

Microsoft Dynamics NAV / 365 Business Central resources:

business central time line

The road map. With the ever changing world of technology, the roadmap reassures customers that Microsoft have clear, continual investment and development plans for Microsoft Dynamics 365 Business Central. Built following decades of experience perfecting NAV, Microsoft deploying the system in the cloud removed the lengthy processes of digital transformations as they ensure the customer, ultimately the end user will be at the forefront of all technological advancements, by quickly upgrading their system through the cloud. 

Want to read more? Click here.




Microsoft Dynamics 365 Business Central is here, the following is a high level summary of it’s capabilities ?


Manage your financials

Automate and secure your supply chain

Sell smarter and improve customer service

Keep projects on time and under budget

Optimise your operations

Protect your data and support GDPR compliance

Want to know more? Click here.


Microsoft have put together an introductory video, which you can watch here:

 Totally blended

It’s clear the Microsoft vision is to seamlessly integrate all the Microsoft suite which is done using Microsoft Dynamics 365, coupled with Business Central you can maximise the efficiency of the Microsoft stack in your organisation.  Joining together all of your organisation departments, reducing duplication of reports, time consuming data entry and perfectly blending and utilising your software.  Total Enterprise Solutions can assist your organisation in operating this function through training and empowerment of your users. Contact us to discuss further how we can help you.




Do you want to see Business Central in action?

Our technical director Chris Wilson will be presenting a webinar ‘Demystifying migration to Microsoft Dynamics 365 Business Central Friday the 29th of June at 14:00- 14:40 – register your free place here. 

Free webinar play online button vector illustration in Laptop notebook computer screen. Vector illustration


Benefits of Microsoft Dynamics NAV SaaS Solution.

Microsoft Dynamics NAV is Microsoft’s leading end to end Enterprise Resource Planning (ERP) system. Bringing together all aspects of your organisation into one common platform.

The latest release of NAV is Microsoft Dynamics 365 Business Central, and boasts an impressive offering, built from over twenty years of experience with the market leading ERP system. Industry specific enhancements ensure Business Central will meet all of your organisation’s needs.

Benefits of Microsoft Dynamics NAV Saas:

The Cloud solution offers any time, any place, any device availability. The complete online system Dynamics NAV, will be available to anyone with access to the internet. All information is accurate and operating in real time, meaning you can work anywhere, at any time on any mobile device.

Hosting on the Microsoft Azure servers allows users to take advantage of Microsoft’s high level protection from hacking or data leaks. This also eradicates the risk of storing important data on portable devices, that can be lost or stolen. Coupled with a Microsoft partner like TES who holds ISO 27001, you know your system is in safe hands.

Never pay for licenses you don’t use ever again. Licenses can easily be added, to grow as your organisation does. The ease of the cloud means your system is scaleable at the touch of a button.

The benefits of deployment into the cloud are clear, but what does Microsoft Dynamics 365 Business Central offer your organisation?

  • Control and insight over your finances
  • Purchase and sell items and materials
  • Pay and manage employees
  • Manage the billables generated by consultants
  • Effectively manage supply chains
  • Manage sales and inventory
  • Manage projects and the resources allocated to them
  • Gain clearer business insights through reporting functionalities
  • Extention facilities to enhance industry specific functionality
  • Full integration with the Microsoft Stack

Our Technical Director Chris Wilson will be demystifying the migration to Microsoft Dynamics 365 Business Central in our next webinar Friday 29th of June 2:00-2:40

You can register for this FREE here!

nonprofit word in wood type

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

Tax Payment

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.

Santa Claus working on laptop

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.

Happy New Year modern design flat online sending letter

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.

and on rthe

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.

Blog pic2.0

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.