Tuesday, October 22, 2024

Dimensions

 Financial Dimensions:-

 Create financial  Dimensions through code:-

 DimensionAttributeValueSetStorage   valueSetStorage= new DimensionAttributeValueSetStorage();

 DimensionAttribute      dimensionAttribute; 

DimensionAttributeValue dimensionAttributeValue;

 dimensionAttribute = dimensionAttribute::findByName("CostCenter"); 

dimensionAttributeValue =dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,"020",false,true);

 valueSetStorage.addItem(dimensionAttributeValue); 

this.DefaultDimension=valueSetStorage.save();


Thursday, October 17, 2024

Integrations by using On prime Azure Data Gateway

Scenario:-In this blog we see integrations with D365fo by On prime Data Gateway with Azure

Onpime Data gateway:- This is a concept where we can get a file or put a file in on premises environment(System) by Azure Logic apps or power automate(MS flows). 

Architecture:- 

Step1:-to install standard gate way click on link below

https://go.microsoft.com/fwlink/?LinkId=2116849&clcid=0x409

Step2:-Once you install choose the path where you need to install in your system

Step3:-Choose the email address you want use Data gate way

Step4:-Click on register new gate way 

Step5:-Now give username and recovery password

Step6:-On successful installation you can see message

Step7:-After that click on create a gateway in azure ass shown in below

Step8:-It will navigate to azure .click on create new in on premises gateways

Step9:-choose required recourses and create on premises gateways

Step10:-Create a logic app .Here sample chosen mail arrives. Then file added in a folder through on premises gateways

That's all we can start integrating with on-premises 

Thankyou!!

Note:-Don't worry that we haven't choose D365fo  the file generally gets from  F&O system or else by once we get a file  using logic app we implant data in F&O system by recurring or pacakageApi.




Importing Through Recurring integration scheduler for D365Fo

 Scenario:- In this blog we see sample import integration through recurring by using Recurring integration scheduler for D365 FO.

Step1:-Create a data project in D365fo and set recurring batch job as shown in figure

Step2:-Open Ris application click on Add job and choose import or export either recurring or package as shown in figure below  in my case I am going with recurring import

Step3:-In upload job overview give name of the job and next in upload job details choose data poject as shown in below

Step4:-Ste upload job recurrence and give connection details as shown in below

Step5:- Once you setup all details you can see job added 

Step6:-Drop the file in input folder

Step7:-Go to D365fo and check for new records


similarly you can do exporting as well and also importing and exporting through Package Api also


Thank you!!


Wednesday, October 16, 2024

Recurring Integrations Scheduler For D365 FO Installation and setup

Scenario :- In this blog we see how to install Recurring Integrations Scheduler(RIS) For D365 FO.

What is Recurring Integrations Scheduler For D365 FO?

Ans:- This is one of the procedures to achieve integrations with D365FO . 

Architecture :-


Installation:-

Step1:-I have downloaded this tool from GitHub link below

https://github.com/Microsoft/Recurring-Integrations-Scheduler/releases

Step2:-Once you download you can see file as shown in below

Step3:-After that click on the Package 

                    

Step4:-Click on the install and finish as shown in below


Step5:-This application can be seen on location as shown in below


Step6:-Click on with administrator as shown in below

Step7:-Once you open the application UI can be seen as below

Step9:-Once you click on the parameters you can see D365fo details;Azure;Datajobs information

This is installation and set up of Recurring integration scheduler for D365FO.

Import and export can bee seen in further blogs

Thank you

Reference :-https://github.com/Microsoft/Recurring-Integrations-Scheduler/wiki






Friday, October 4, 2024

Get lookup of All addresses by legal entity

Requirement: I had one Requirement where I wanted to filter the global addresses based on selected legal entity(Company). So by following below code we can get those addresses in lookup which are related to that specific legal entity.


[Form]

public class Form2 extends FormRun

{

    [Control("String")]

    class FormStringControl1

    {

        /// <summary>

        ///

        /// </summary>

        public void lookup()

        {

            Query query = new Query();

            QueryBuildDataSource queryBuildDataSource;

            QueryBuildRange queryBuildRange;

            CompanyInfo  companyInfo;

            OMInternalOrganization  oMInternalOrganization;

            DirOrganizationBase   dirOrganizationBase;

            DirPartyTable dirPartyTable;

            DirPartyLocation DirPartyLocation;

            LogisticsLocation   logisticsLocation;

            LogisticsPostalAddress  logisticsPostalAddress;


            companyInfo=CompanyInfo::findDataArea("USMF");


            select oMInternalOrganization where  oMInternalOrganization.RecId==companyInfo.RecId


                join dirOrganizationBase where dirOrganizationBase.RecId==oMInternalOrganization.RecId


                join  dirPartyTable    where dirPartyTable.RecId==dirOrganizationBase.RecId;



           

 

            SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(LogisticsPostalAddress), this);

 

            sysTableLookup.addLookupField(fieldNum(LogisticsPostalAddress, Address));

            queryBuildDataSource = query.addDataSource(tableNum(LogisticsPostalAddress));

            

            while select  DirPartyLocation where DirPartyLocation.Party==dirPartyTable.RecId


                join logisticsLocation where logisticsLocation.RecId==DirPartyLocation.Location


                join logisticsPostalAddress  where logisticsPostalAddress.Location==logisticsLocation.RecId

           

            {

          

               // Info(strFmt("%1",logisticsPostalAddress.Address));

 

                queryBuildRange = queryBuildDataSource.addRange(fieldNum(LogisticsPostalAddress, RecId));

                queryBuildRange.value(any2Str(logisticsPostalAddress.RecId));


            }

 

            sysTableLookup.parmQuery(query);

 

            sysTableLookup.performFormLookup();


        }


    }


}

Upload File from local system in a form

 Actions to be done at 3 stages  1) Create Fileupload item by right clicking on design as shown in image below 2)Change Properties especiall...