D365 FO: Data Entity “onMappingEntityToDataSource” event

Requirement

In Microsoft Dynamics 365 finance and operations, client has an data entity for importing list of customer account into a table.During the time of importing of customer accounts using Data entity, client also want to capture & save values of few fields.

Continue reading D365 FO: Data Entity “onMappingEntityToDataSource” event

THE SUPPLIED SNAPSHOTPOINT IS ON AN INCORRECT SNAPSHOT [SOLVED] – D365 FO/Visual Studio Error/Visual Studio Crash

Issue

“THE SUPPLIED SNAPSHOTPOINT IS ON AN INCORRECT SNAPSHOT” error is coming. Visual studio is also crashing during the time of code editing and development of Microsoft Dynamics 365 finance and operations

Continue reading THE SUPPLIED SNAPSHOTPOINT IS ON AN INCORRECT SNAPSHOT [SOLVED] – D365 FO/Visual Studio Error/Visual Studio Crash

Power Apps Functions – Remove & RemoveIf

There are functions available for deleting or removing records from datasource or table in Microsoft Power Apps.

Remove Function – Use the Remove function to remove & delete a specific record or records from a data source in Microsoft Power Apps.

RemoveIf Function- Use the RemoveIf function to remove & delete a record or records based on a condition or a set of conditions in Microsoft Power Apps.

Continue reading Power Apps Functions – Remove & RemoveIf

Power Apps ForAll:Copy & Insert Records from One Datasource To Another Datasource

Requirement

Copying & Inserting Records from One Datasource To Another Datasource in Microsoft Power Apps using ForALL & PATCH

Scenario

We have 2 datasources or tables. First datasource “List” is excel & second datasource is a CDS entity “Contacts”. We want to insert or copy records from “List” to CDS entity “Contacts”

Continue reading Power Apps ForAll:Copy & Insert Records from One Datasource To Another Datasource

D365 FO & PowerAPPS – Lookup From Data entities

Requirement – Connecting Microsoft Power Apps to Data Entity of Microsoft Dynamics 365 for finance and operations. Then create a lookup from Data entity.

Continue reading D365 FO & PowerAPPS – Lookup From Data entities

D365 FO:JSON Creation & SERIALIZATION Using FormJsonSerializer & X++

Requirement

SON CREATION & SERIALIZATION USING FORMJSONSERIALIZER & X++ in Microsoft Dynamics 365 for finance and operations.

Format Of Output JSON String & Message

{"itemCategory":123456,"itemClassification":"A","itemCode":"ItemXYZ","itemGroup":"ItemGroup","itemname":"ItemXYZ Name","onDate":"/Date(1597363200000)/","Optimized":"Yes","site":"SiteCode"}
Continue reading D365 FO:JSON Creation & SERIALIZATION Using FormJsonSerializer & X++

D365 FO – Generate next Number sequence in X++ using NumberSeq Class

Requirement – D365 FO – GENERATE NEXT NUMBER SEQUENCE IN X++ USING NUMBERSEQ CLASS

Continue reading D365 FO – Generate next Number sequence in X++ using NumberSeq Class

D365 FO – Closing and adjustment using X++/InventAdj

Requirement – Closing and adjustment – Revaluation for moving average using X++

Sample Code –

static void Job258(Args _args)
{
    InventDataAdjSumUp  dataAdjSumUp;
    InventDimParm       inventDimParm;
    InventClosing       inventClosing;
    InventAdj_SumUp     inventAdj_SumUp;
    TmpFormLookUp       tmpTbl;
    AcxInventRevalueTable acxInventRevalueTable;
    boolean             adjustClosing;

    tmpTbl.clear();
    tmpTbl.initValue();
    tmpTbl.itemId =  itemId;
    tmpTbl.InventDimId = InventDimId;
    tmpTbl.qty = qty;
    tmpTbl.postedValue = postedValue;
    tmpTbl.adjustNow = adjustNow;
    tmpTbl.LineNo = LineNo;
    tmpTbl.insert();
    
    dataAdjSumUp  = InventDataAdjSumUp::newFromForm(tmpTbl);

    inventAdj_SumUp = InventAdj_SumUp::newSumUp(dataAdjSumUp.pack(),inventDimParm
        , today(), false
        // <GEERU>
        ,InventTransCurrency_RU::PrimaryCur
        // </GEERU>
    );

    inventAdj_SumUp.run();
}

D365 Fin & ops – add cross company in Odata URI & Odata webservice in C#

D you want to fetch records of all the companies of Microsoft Dynamics 365 finance and operations using cross-company in your Odata service application? Here is the trick:

Add below line in your C# program which is using AddQueryOption

d365.SalesOrderHeadersV2.AddQueryOption(“cross-company”, “true”)