Author: ERP Consultors
Install Code Blocks for C Language on Windows: (1) In this blog we will see the installation of “Codeblocks” in windows for C language. Open the URL (https://www.codeblocks.org/downloads/binaries/) and click the marked links, as shown. (2) After that new URL open and click on the “Download” button, as shown. (3) After the download is complete. Go …
Restore and Change in Pages by using Personalize in BC D365: (1) In BC D365, there is a feature “Personalize” in which the user can change, adjust, hide & show the fields on the Page as per his requirement. (2) For this, open the page and make the changes via Personalize feature, lets take an example, …
Check Changes in Pages via Personalize Feature in BC D365: (1) In BC D365, there is a feature “Personalize” in which the user can change, adjust, hide and show the fields in Page as per his requirement. In BC D365 Microsoft provides a list in which you can see the list of the Personalized Pages with …
Sales Register Report in D365 BC: (1) In this blog we will do the development of the “Sales Register” or “Sales Summary” report in D365 BC. (2) For developing Sales Register Report: Use Dataitem: Sales Invoice Header and Sales Cr. Memo Header as shown. Header Part: Variable Initialize: Body Part of Sales Invoice: Body Part of …
Purchase Order Report in D365 BC: (1) Development of New report already explained in the previous blog. In this blog, we will develop a new “Purchase Order Report”. Follow the below screenshot and develop a report for the client. The report includes- No. of Copies and Document No. filter. (2) RDLC Format for designing. (3) After …
Use of SUBSTRING Function in SQL: (1) “SUBSTRING” function is used to extract characters from the string with defined length and position. (2) Let’s take an example to extract the first two characters from Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) …
Use of REVERSE Function in SQL: (1) “REVERSE” function is used for reversing the string. (2) Let’s take an example of reversing the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens as shown. (5) After doing …
Use of REPLACE Function in SQL: (1) “REPLACE” function is used to replace characters within the string. (2) Let’s take an example to replace ‘A’ with ‘T’ in Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query editor opens …
Use of LOWER Function in SQL: (1) “LOWER” function is used for converting text in lower case. (2) Let’s take an example to convert the text of Vendor Name into the Lower case as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new …
Use of UPPER Function in SQL: (1) “UPPER” function is used for converting text in upper case. (2) Let’s take an example to convert the text of Vendor Name into Upper case as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. (4) After that new query …
