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” eventIssue
“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 CrashThere 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 & RemoveIfRequirement
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 DatasourceRequirement – 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 entitiesRequirement
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"}Requirement – D365 FO – GENERATE NEXT NUMBER SEQUENCE IN X++ USING NUMBERSEQ CLASS
Continue reading D365 FO – Generate next Number sequence in X++ using NumberSeq ClassRequirement – 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();
}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”)