Fill Handle in Excel and Dynamics 365 Business Central

2024-06-26 17

Agenda of the Video▶️: How-To Use Fill Handle in the process of Data Import from Excel.
Fill Handle is a feature in Excel that Enables you to Auto-Complete a List in a Row/Column by simply dragging it using your mouse.
A basic understanding of Fill Handle in Excel could save you some time, and make you more productive.
✅Hint 1: This is just an Example to Show, How-to use Fill Handle (in Excel) for Data Modification or Updation in D365BC.
✅Hint 2: If You want to Changes in Dimension Values, you need to change it in the Dimensions Table of ERP System First, then it will work, and Global Dimension Code and 1st Shortcut Dimension (here, Department Dimension Values will be same.
Note: Test it in a Demo Company first, and after getting successful results, use it in Live