Today I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files. Example of what we want to achieve To show the concept I made a very easy example, so let’s suppose we have the following customers with Location Codes: And…
DetailsI recently looked into a support incident where there were some problems when importing text data from an XML file into NAV. One of the problems was that in the xml file the string contained a lot of useless extra spaces. It looked somehow similar to this: So, in order to fix this, I created…
DetailsIn this post I described a way to deal with Extension Files Info in NAV AL (Business Central). Now I decided to create a small module that will help you manage the Extensions and Ids. Besides what I showed in the first post, I added to the module an extra feature: now you have the…
DetailsIn AL VS Code Extensions V2, if you try to create an extension and the ID or Name are already used, you get this error: Because we don’t have the extension id in the name of the file (I assume you don’t have it either), you can use the following Powershell script to check what…
DetailsIf you want to ensure the security of your accounts, an option is to use randomly generated passwords for each account together with a password manager tool (for example I use lastpass). In this way you will need to remember only one password (for the password manager account) and you can use very strong random…
Details
