Extending NAV

Extending NAV to Better Manage Schedule Orders

One of my customers receives scheduled orders from his customers, either via email or EDI file transfer. The data consists of a forecast quantity for each Item going forward over the next few weeks or months. The quantity of a particular item/date on the schedule can change by any amount if it is way into the future, but only by small tolerance, or nothing at all as its date gets closer.

Historically this was managed on a spreadsheet outside NAV; with Sales Orders being keyed manually when the demand become firm.

Extending NAV to Better Manage Schedule Orders

Extending NAV

In order to improve this process we utilised the standard NAV Blanket Sales Order functionality, which has the advantage of being seen as forecast demand by the MPR engine (Planning Worksheet). However, instead of creating one Blanket Order per Customer, with lots of Item Lines, we created one Blanket Order per Item with separate lines for each forecast demend:

We added the Item details onto the header to make lifer easer.

We then created a new screen that listed Sales Blanket Order Lines from multiple Blanket Orders.

The screen has a new function that will create once sales Order per Customer for the currently filtered blanket Order Lines.

Time Saving Routines

In order to eliminate all that keying of data we built a routine that will import the EDI files into a holding table.

 

A button can then be pressed that validates the data provided in the EDI file to check the following:

  • Blanket Order for the Customer/Item exists.
  • A Blanket Order Line for that Item/Date already exists.
  • The system then highlights lines that are outside pre-set tolerances for new records, or quantity changes.

The user has the ability to automatically create/update Blanket Order Lines. Finally, the user has the ability to automatically create one sales order per customer call off week containing the lines from multiple blanket orders.

The Results

The development has saved the customer hours of effort in keying, and re-keying data. As well and improved data accuracy and enabled the use of MRP to take into account forecast demand.

What can we do for you?

If you want to discuss how we can use our experts with years of industry experience please contact us for more details.


D365 Business Central vs Sage 200: Comparing Sage 50 Upgrade Options

16 June 2025

Choosing the right ERP system when moving on from Sage 50 can shape how efficiently your business grows and adapts. If you want advanced features, greater flexibility and easier integration with familiar Microsoft tools, Microsoft Dynamics 365 Business Central is often the stronger option compared to Sage 200. As real-time data insight, automation and scalability are now necessities and not luxuries, your ERP upgrade decision is more important than ever.

​​Generative AI For Business: a Guide

09 June 2025

Generative AI continues to reshape how organisations operate and compete, delivering powerful tools that can drive efficiency and boost creativity. By using generative AI in your business, you can automate tasks, generate personalised customer service agents and unlock new insights to support better decision making.

The Most Useful Power BI Features

09 June 2025

Power BI continues to transform how organisations handle data by making complex analytics more accessible. By understanding the most useful Power BI features, you can create clearer reports, uncover valuable insights and improve decision-making within your business.

Scroll to top