X++ and Excel: A Powerful Partnership

-

Introduction:

Excel has over 750 million users worldwide, making it one of the most popular software applications in the world.

According to recent studies, 89% of companies use Excel for daily operations, financial modeling, data analysis, and other tasks.

Excel is so integral to the financial world that many financial analysts and accountants refer to themselves as "Excel jockeys" or "Excel ninjas."

NASA used Excel in its operations for various calculations related to space missions.

Using Excel for manual data entry is much more easier for end users as it provides a familar interface and can be navigated much more quickly.
It can also be used for quick minor calculations and formulas.

References:

Details:

For businesses generating large volumes of data, it's essential to have an efficient system for users to input that data smoothly. 

Are you struggling to keep up with your rapidly growing data?

A study by Forrester Consulting shows that companies using Microsoft 365 tools like Excel, Word, Outlook, and PowerPoint see a 15-20% boost in employee productivity due to better collaboration and task management.

This article will surely inspire you to start using Excel for your organization's daily operations too!

Enabling the Developer Tab in Excel

To access advanced features like creating macros, using form controls, or accessing the XML commands in Excel, you'll need to enable the Developer tab. Here's how:

  1. Open Excel and click on the File tab.
  2. In the left-hand menu, select Options.
  3. In the Excel Options dialog, click on Customize Ribbon.
  4. Under the Main Tabs section, check the box next to Developer.
  5. Click OK to apply the changes, and you'll see the Developer tab appear in the Excel Ribbon.

In the Developer Tab, click on "Add Ins"


In the pop-up that follows, click on "Store" and search for "Microsoft Dynamics" and click on enter.
Once you get the results as described in the below screenshot, click on "Add."


Click on Continue.


Go to your Finance and Operations environment.
Go to System Administration -> Setup -> Office App Parameters.


Go to App Parameters and click on "Initialize app parameters"


Go to "Registered applets" and click on "Initialize applet registration"


Go to "Registered resources" and then click on "Initialize resource registration"


Then to test it out, we can go to the "All sales orders" list click on the "Office" icon at the top right and click on one of the "non-obsolete" options.


You can either download it on your own system or you can save it directly from this screen.


When you open the downloaded excel, after enabling editing, you'll get the following pop-up and data.


You can also use this Excel to create records in the system.


Open the downloaded excel sheet.


Click on "New".


Add the necessary fields in the newly created rows.


Once done, click on Publish.


And we can see back in D365 that we have added some new records in the system via Excel.

Conclusion:

In conclusion, I firmly believe that using Excel for manual data entry can significantly cut down on unnecessary tasks.
If you're looking to streamline your processes or maximize the potential of your ERP systems, don’t hesitate to get in touch!

Comments

Post a Comment

Popular posts from this blog

Using Notifications in Business Central via AL

-
Image
Introduction Notifications in Business Central are alerts that appears in the Notification bar based on User actions. Notifications stack up from top to bottom, lasting until the user dismisses them, including those from sub-pages.  Validation errors are prioritized and shown before other notifications. We can use this to alert the user regarding something without taking all the user's notification towards it, in the way messages or errors do. They also have the option to allow Users to make a corrective action by embedding the action button directly into the notification. Let's see how it works. Source Code Pre-requisites Business Central OnPrem/Cloud. References Notification - Business Central Docs Configuration Here, for an example, I've created one simple page which takes two inputs. 1. The message that is to be shown in the notification. 2. The message to be shown after the User clicks on the action embedded in the notification.     And I have two actions which I'l...
Read more

Actionable Error Messages in Business Central

-
Image
Introduction Error handling is an important concept in every technical field.  It helps programs deal with unexpected problems and mistakes smoothly.  It makes sure software works reliably and doesn't crash unexpectedly.  Error handling also helps developers find and fix issues quickly, making the software better for users. Plus, it gives users clear messages when something goes wrong, making their experience smoother. It shows that the team has considered the scenario and has measures in place for it indicating a well designed solution. Microsoft has an amazing document which lists the things to keep in mind for writing resilient code. In Business Central, we have try functions to handle errors and error function to show those errors to the Users.  In this blog, we'll learn how we can enhance the error messages so that the Users can resolve the errors themselves or at the very least we can point them towards where the error is. Pre-requisites Business Central OnPrem...
Read more

Configure Gmail SMTP service in Business Central without "Allow Less Secure" setting

-
Image
 Introduction Business Central has great email features like sending email, editing it with Rich Text, adding attachments, etc, but to send emails, you'll need to connect it with services like Outlook or Gmail. There is no outlook side configuration that is to be done if you are using Microsoft Outlook however if you are using Google's Gmail then there's a litte change that has happened on the configuration end. Starting May, 2022, Google has removed the "Allow Less Secure Apps" settings from the Google Accounts, which was essential is using Gmail to send emails from Business Central. However, to replace that we have "App Passwords" which we can use instead. Also, just something to keep in mind, Google is going to remove this from the "Google Workspace" accounts as well by Sept, 2024 so it would be wise for you to migrate your configurations to use app passwords. Reference 1.  How to Setup Email in Business Central 2.  Google Support - Less sec...
Read more