Use of FINDFIRST FINDLAST and FINDSET in BC D365: (1) For finding records in tables according to the filters and current key on tables in Business Central, use FINDFIRST, FINDLAST and FINDSET. (2) FINDFIRST is defined as finding the first record in the table according to the filter and current key. (3) FINDLAST is defined as …
SETRANGE and SETFILTER in Dynamics 365: (1) For applying filters on tables in Business Central, use “SETRANGE” and “SETFILTER”. (2) SETRANGE is defined as applying a simple filter on a table. (3) SETFILTER is defined as applying a filter that you specify. (4) The difference between SETRANGE and SETFILTER is that in SETFILTER, you can use …
Show Image or Picture in Report in D365 BC: For display image in RDLC report in D365 Business Central, following steps should be followed: (1) Field in the table must have datatype “blob”. (2) Set field property “SubType” = Bitmap. (3) Let’s open the company information table in design mode and check the nature of the …
CASE statement in D365 BC: (1) Definition- Case statements are typically used when you must choose between more than two different actions. (2) Syntax of “CASE” statement- case <Expression> of <Value set 1>: <Statement 1>; <Value set 2>: <Statement 2>; <Value set n>: <Statement n>; end; (3) Lets take an example, get name of the month from Date: (4) The <Expression> is evaluated, and the …
Skip Sales Order Document deletion in Business Central: (1) Sometimes businesses required Sales Order Document in a system when it is fully posted because inD365 BC sales order document auto delete when it is fully posted. (2) For doing this, call “OnBeforeDeleteAfterPosting” event for skip Sales order document to delete. Source Code in AL: codeunit 50001 …
Skip Purchase Order Document deletion in Business Central: (1) Sometime business required Purchase Order Document in system when it is fully posted because in D365 BC purchase order document auto delete when it is fully posted. (2) For doing this, call “OnBeforeDeleteAfterPosting” event for skip purchase order document to delete. Source Code in AL: codeunit 50001 …
Use FOR-TO loop statement in Microsoft D365: Definition of “FOR-TO”: Repeats the inner statement until a counter variable equals the maximum or minimum value specified. Syntax: “FOR-TO” statement- FOR <Control Variable> := <Start Number> TO <End Number> DO <Statement> Let’s take an example- Assign a value to the ARRAY variable according to the number of records …
Find Base Application Object in BC D365: Open Visual Studio and go to File>Open File as shown (let’s take an example to open Customer Table al)- After that select BC D365 setup folder, as shown- Open the folder and go to Applications>BasApp>Source and then copy the “Base Application Source” file and save it in a different …