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 …
Use of RIGHT Function in SQL: (1) “Right” function is used to get a number of characters from a string that’s starting from right. (2) Let’s take an example to get a character from the Vendor Name as shown. (3) Select the database in the SQL server and click on the “New Query” button as shown. …