New application feature for Microsoft Dynamics NAV 2015 – Totals and Invoice Discount Amounts displayed on Sales and Purchase Documents

A new welcome addition has been linked to Sales and Purchase documents within Dynamics NAV 2015 that displays the cumulative Total of the document and associated Discount. This applies to Quotations, Orders, Blanket Orders, Invoices, Credit Memos and Return Orders for both Receivables and Payables.

It is now possible to see at a glance the Totals for any such document and replaces the need to come out of the active page and refer back to the Statistics screen. When posting a Purchase Invoice it will be easy to see immediately any discrepancy in the VAT Amount.

The fields are placed on the document page below the Lines section.

Microsoft Dynamics NAV 2015

The functionality also extends to the equivalent Posted documents as seen here in an example of a Posted Purchase Invoice.

Microsoft Dynamics NAV 2015

You can also change the Invoice Discount Amount in the Total fields and this will adjust the Total. It will display the calculated Invoice Discount %. Similarly, this will be carried through to any posted document.

Microsoft Dynamics NAV 2015

Office 2013: Make sure it’s the Professional Plus version for PowerPivot

For Microsoft Dynamics NAV and CRM Reporting & Analysis

Microsoft Office 2013 is released and on the shelves. Be careful though – as to which version you buy – as Microsoft have introduced some restrictions designed to move users to better Office versions. The latest discovery is that more restrictive Office 2013 licensing affects the version at which you can install its PowerPivot business reporting tool.

Professional Plus for Powerpivot for Microsoft Dynamics NAV and CRM

Microsoft made PowerPivot, its easiest to use data-analytics reporting technology, available for use by anyone with any edition of Excel 2010 by installing the PowerPivot for Excel add-in. With Excel 2013, only those with the Office Professional Plus version of Office 2013 will have full access to Excel 2013's PowerPivot capabilities.

So if you are one of the many Microsoft Dynamics NAV or Dynamics CRM users that have used Excel for reporting on your sales or manufacturing data via an analysis services ‘cube’ you need to make sure you get at least the Professional Plus version of Microsoft Office 2013.

Microsoft Dynamics NAV & CRM go mobile!

Now on your iPhone, iPad, Android and Windows mobile devices.

Now that we are all used to consuming information on the move it’s frustrating when we cannot access key business systems such as Microsoft Dynamics NAV and Dynamics CRM.

The trouble is that the apps that have been available to date have only published very limited information – and almost all business needs include more than just simple standard fields.

Now finally there is a solution that allows you to enquire, and update, Microsoft Dynamics NAV and CRM from your iPad or iPhone, Android phone or tablet, Windows phone or Microsoft Surface – in fact any device you can think of except Blackberry (where the graphics are not strong enough).

Microsoft Dynamics CRM on the move with an app from Rescoe and Technology Management
It’s called Resco (simply search for it in your apps store and download it) and the good news is the standard client is free. There is some work to do at the server end before it can connect though. Resco make money by having chargeable, premium versions that first allow you to customise the screens and then, via .NET, change almost anything in the same way as you are used to doing
with Microsoft Dynamics NAV and CRM.

So the next time someone rings in to the office to ask for anything from a phone number to a customer balance or check if an item is in stock, tell them that if Resco was implemented they would be able to find it on their smartphone.

P.S. Microsoft do not have mobile apps on their roadmap except for a very simple iPad app for Dynamics CRM next year.

Public Perception will drive major food industry change

With our specialism in software for food manufacturers and distributors, in particular meat and dairy processors, I’ve watched the un-folding of the horse meat scandal over the last couple of months with more than a little interest. Whilst none of our clients have been implicated, our understanding of standard food industry practice means we are only too aware of how this could happen to some pretty reputable names.

food traceability with DynamicsFood

Put simply… while traceability is total within each organisation (from the time it arrives at goods inwards to the time it departs to the customer), you cannot track on a single system the entire supply chain from farm to fork. Unless, of course, you are the first and only processor in that supply chain. That does happen but frequently it does not.

So the fraud here was easier because the meat involved passed through multiple different traders and processors in multiple countries. If a major retailer wants to understand which animals are in a lasagne then, in the instance publicised, that would have meant queries into at least eight different company systems and more if any element of subcontracting was involved. Spread that across six countries and it’s no surprise that it took some time to unravel.

All of this is despite the big six UK food retailers insisting on 30 minute response times to traceability enquiries in their supply contracts. Sure you can do it for your organisation but about before the product or ingredients got to you?

So how can technology help tackle complete traceability not just for the industry but for the consumer? Having visited many food companies in the last few years I know that most in the UK are beyond question in this area but that’s no longer good enough. Food companies need to be able to prove total transparency to the consumer – and on demand!

How can this be achieved especially at a time when there is pressure on margins? Well electronic communication of information via systems like Dynamics Food (Microsoft Dynamics NAV plus SI Foodware) has to fill the gap here. Tier one food suppliers have to send electronic delivery notes called Advanced Shipping Notices (or ASN’s for short) which state not just what’s being delivered but what’s on which specific pallet or container. If you attempt to deliver to Sainsbury’s or Tesco, without having first sent your ASN, your delivery gets turned away.

ASN’s have got to be improved so that they also include traceability information that tracks the product(s) involved through every processing step, the farm it came from and the date it was slaughtered or picked. That’s going to mean those tier one manufacturers need ASN’s complete with batch trace information from all their suppliers as well. This is huge amounts of data that cannot be exchanged manually so extensions to the Electronic Data Interchange (EDI) standards such as EDIFACT have to be the way to go.

I guess the ultimate is that consumers can use a smartphone to read a QR code on a pack of meat in the supermarket that takes them to a website with the dates and time that every supplier touched the product right back to when and where the animal was born. Technology is capable of delivering this at little, if any, extra cost (after the initial investment). It will need industry-wide change but we believe the market will drive it.

And Dynamics Food from Technology Management will be ready when it does!