Monday, June 27, 2022

Business Central Learning Link for Begineers

 Hello Frieds

Use below link to start learn Business Central Development for begineer

https://theghl.in/Course/4039

Using AL in Microsoft Dynamics 365 Business Central

Reference Video/Code

Link

1

Using Git inside Visual Studio Code

View Video

2

How to Integrate Power BI Reports in Dynamics 365 Business Central

View Video

3

Connect Visual Studio Code to Business Central

View Video

4

Business Central - 2022 Release Wave 1 Plan

View Link

GitHub Link

Link

1

Github Repository - Lab Files

View Link

Examples/Analogies

Link

1

How to publish your Business Central App on AppSource

View Link

2

Dynamics 365 Business Central: Using the query as a data source for a page (Query.Open Method)

View Link

3

CheatSheet - Dynamics 365 Business Central

Download File

4

You'll get step by step process on how to connect your On- Premise Business Central to Power BI

Download File

Sandbox

Link

1

For MacBook - Procedure to connect RDO

Download File

2

For Windows - Procedure to connect RDP

Download File

Prestudy / Prerequisites videos

Link

1

Table Object

View Link

2

Table extension

View Link

3

Pages

View Link

4

Page Extension

View Link

5

Page customization

View Link

6

Reports

View Link

7

Designer- Business Central

View Link

8

Extensible Enums

View Link

9

Data Types and Methods in AL

View Link

10

Table, Table Fields, and Table Extension Properties

View Link

11

Page Types and Layouts in Business Central

View Link

12

Object Specifications and Limitations- Business Central

View Link

13

Working with Rapid Application Development

View Link

Video/PPT of Lab

Link

1

Labs

Download File

2

Labs_Updated(PDF Format)

Download File

Day wise Schedule

Link

1

Day Wise Schedule

Download File

Simulated Intership/Case Study

Link

1

Microsoft Learn - Customize Microsoft Dynamics 365 Business Central

View Link

2

Microsoft Learn - Interface with Microsoft Dynamics 365 Business Central

View Link

3

Microsoft Learn - Connect to the intelligent cloud with Dynamics 365 Business Central

View Link

4

Microsoft Learn - Set up Microsoft Dynamics 365 Business Central for reporting

View Link

5

Microsoft Learn - Configure Business Central for Excel and Power BI

View Link

6

Microsoft Learn - Develop using Power Apps and Power Automate for Dynamics 365 Business Central

View Link

7

Microsoft Learn - Learn about the data management foundation in Microsoft Dynamics 365 Business Central

View Link

8

Microsoft Learn - Discover the foundation of customizing Microsoft Dynamics 365 Business Central

View Link

9

Microsoft Learn - Change how documents look in Business Central

View Link

10

Microsoft Learn - Implement interfaces in Dynamics 365 Business Central

View Link

Error Logs

Link

1

Help File

Download File


Wednesday, June 22, 2022

Import Base 64 Stirng Data to Image Field in Business Central

Hello Friends

Below we use to import Base64 String data to Blob Field in record.

codeunit 50100 "Import Base 64"
{
    Permissions = tabledata 112 = RM;
    procedure UpdateInvoiceQRCode(InvoiceNo_iCod: Code[20]; DataBASE64_iTxt: Text)
    var
        Base64CU: Codeunit "Base64 Convert";
        VarOutStream: OutStream;
        SIH_lRec: Record "Sales Invoice Header";
    begin
        InvoiceNo_iCod := UpperCase(InvoiceNo_iCod);
        IF InvoiceNo_iCod = '' then
            Error('Enter Invoice No.');

        IF DataBASE64_iTxt = '' then
            Error('Enter Correct Base 64');

        SIH_lRec.GET(InvoiceNo_iCod);
        SIH_lRec.CalcFields("QR Code");
        SIH_lRec."QR Code".CreateOutStream(VarOutStream);
        Base64CU.FromBase64(DataBASE64_iTxt, VarOutStream);
        SIH_lRec.Modify();
    end;
}

Below code to used copy Media Image from One Record to Another Record in different company

var
                TenetMedia: Record "Tenant Media";
                TenantMediaSet: Record "Tenant Media Set";
                Media_InStream: InStream;
            begin

                If "VTK BOM Picture".Count <> 0 then begin
                    VTKProdBOMVersion.Reset();
                    VTKProdBOMVersion.ChangeCompany(SelectCompanyName);
                    VTKProdBOMVersion.SetRange("Production BOM No.",
"VTK Production BOM Version"."Production BOM No.");

                    VTKProdBOMVersion.SetRange("Version Code",
"VTK Production BOM Version"."Version Code");

                    IF VTKProdBOMVersion.FindFirst() THEN
                        for index := 1 to
"VTK Production BOM Version"."VTK BOM Picture".COUNT do begin

                            TenetMedia.GEt
("VTK Production BOM Version"."VTK BOM Picture".ITEM(index));

                            TenetMedia.CalcFields(Content);
                            IF TenetMedia.Content.HasValue Then begin
                                TenetMedia.Content.CreateInStream
(Media_InStream, TextEncoding::Windows);

                                VTKProdBOMVersion."VTK BOM Picture".ImportStream
(Media_InStream, TenetMedia.Description, TenetMedia."Mime Type");

                                VTKProdBOMVersion.Modify(true);
                            end;
                        End;              

                end;