Worksheet – Pardaan.com

Business Central Reservation Worksheet

A new interesting and useful functionality has been added relating to the creation of batch reservation in worksheets, via an allocation calculation. In practice it’s a functionality to automate and speed up the assignment of reservations for a lot of documents. The system for calculating possible…

12 October 2023

Dynamics NAV & BC Tips & tricks

Copy Data from Companies using Configuration Worksheet

In the earlier version of Business Central, the only way to copy data between companies was either to copy the company or upload the data through Configuration Packages or Rapid Start. Microsoft introduced Copy Data from Companies to copy data from specific tables in companies to…

7 April 2023

Dynamics NAV & BC Tips & tricks

Stock Procurement – Maximising the Benefits of the Planning Worksheet

The Dynamics 365 Business Central Planning Worksheet is a powerful tool that, with fine-tuning, will provide great benefit to your procurement team. It reviews the supply and demand, both actual (from existing documents) and expected (from a production forecast) to suggest replenishment orders. Bron : Fenwick…

16 November 2018

Data & Analysis

Combining Data From Multiple Worksheets In The Same Excel Workbook Using Power BI

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve…

17 July 2018

Dynamics NAV & BC Tips & tricks

Excel Multiple Worksheets Report Extended

In this Final Part I will add functions for formatting and to create real formulas in Excel with Dynamics NAV 2013 R2, in Part One I looked at the changes to the Excel Buffer, in Part Two I explored the code added in a new report…

28 July 2015

Dynamics NAV & BC Tips & tricks

Requisition Worksheets in Dynamics NAV 2013 R2

In this demonstration, we are going to look at how the Requisition Worksheet functions. This is a useful tool for requisition management in Dynamics NAV 2013 that can calculate and suggests a plan to create Purchase and Transfer Orders based on current Sales Orders and Inventory…

18 June 2015

Dynamics NAV & BC Tips & tricks

Creating Production Orders in Bulk Using the Microsoft Dynamics NAV Planning Worksheet

We have a couple of clients that have not yet gone live with the MRP (Planning Worksheet) functionality in Dynamics NAV. They determine the need for Production Orders outside of Dynamics NAV and then create the production orders one at a time in NAV. There are…

23 March 2015