Posts

Import a .CSV file for Bank Reconciliation in Business Central

Image
Introduction: This blog will guide you in importing a .CSV file for Bank Reconciliation. Pre-requisites: Dynamics 365 Business Central Steps: Step 1:  Search for Data Exchange Definition in  Tell me/Search Icon and open it, Create a new Data Exchange Definition and enter the code and name. Step 2: In the new Data Exchange Definition add the following fields. File Type - Variable Text Type - Bank Statement Import Reading/Writing Xml Port - 1220 Ext Data Handling Codeunit - 1240 You can also add the number of Header lines that are present in .CSV file in the Header Lines field. I have one Header Line so I have put 1. Step 3: In the Line Definitions Tab, enter the Code and Number of Columns that are present in the .CSV file. I have 7 columns so I've put them accordingly. Step 4: In Column Definitions put Name of Columns according to your .CSV file and their Data type as well. Step 5: Now click the Field Mapping Action on Line D...
2 comments
Read more

How to retrieve a Sub-string from a String

Image
Problem Statement : We have a requirement where the client wants a part of String from Sales Order No. which is Code(Data type) and it is auto-generated from Number Series. The Sales Order No. value is "SO/123/789/456". The required Sub-string was: 123<Space>789. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: As per the requirement, we need to first retrieve Sub-strings "123" and "789" and this can be achieved using SELECTSTR( ) function. But SELECTSTR() only retrieves a Sub-string from a comma-separated String. And the Sales Order No. string is a slash-separated string. So firstly we need to convert this string to comma-separated string, which is achieved in the below-presented screen. CONVERTSTR(String, From Characters, To Characters)   In the above Screen, "SalesOrder No." is initialized in a text variable "SoNumber" and then is converted to a comma-sep...
Post a Comment
Read more

Update Sub-form (Sub-Page) from Main Page to apply Filters.

Image
Problem Statement : I have a requirement where I want to update the Subform(Part page) from the Main page, this Subpage(Subform) is linked to the Main page by SubpageLink Property. The Subpage is a List page and I want to filter this list by a field from Main Page. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: To solve the above Problem statement we have to make use of the Currpage.Update() function which shall update the Subpage.  As you can see in the below window a function is created Vendorfilter() on Subpage with the "vendor" parameter, in this function filter is added for the vendor on the part page and then CurrPage.Update() is used. This function will update the Subpage with the vendor.    Now, call this function on "OnValidate" trigger of the Main page field, here we have "Vendor" field on Main Page.     The calling of Function is as follows: CurrPage.<Subpage...
Post a Comment
Read more

How To: Setup Dockers

Image
Docker is an independent container platform that enables organizations to seamlessly build, share and run any application, anywhere from hybrid cloud to the edge. Docker provides the ability to package and run an application in a loosely isolated environment called a container. Introduction: In this blog, I will be attempting to provide information about how to setup Dockers on your System. Demonstration: The following steps shall help you to get Docker in place on your system. Steps: Visit the link- https://www.docker.com/products/docker-desktop, which will direct you to the Dockers website, after opening the link choose the “Download Desktop for Mac and Windows”. Now Create an Account for Docker or Login with credentials if you have an Account. After that go with “Download Docker desktop for Windows” and your download shall start soon. Install the downloaded “.exe” file and you are good to go with Dockers. Now look for “Docker Desktop is running” on your TaskBar...
Post a Comment
Read more