Skip to main content

Posts

X++ code to get cancelled sales lines Quantity details

By
  SalesLine salesLine; SalesId salesId = "SO-S3993939"; while select salesLine     where salesLine.SalesId      == salesId        && salesLine.SalesStatus  == SalesStatus::Canceled {     info(strFmt(         "SO:%1 Line:%2 Item:%3 Qty:%4",         salesLine.SalesId,         salesLine.LineNum,         salesLine.ItemId,         salesLine.SalesQty)); }
Post a Comment
Read more
Recent posts

X++ code to get Average cost price for Item as per selected date in ax 2012(Axapta)

By
  To Get X++ code to get Average cost price for Item as per selected date in ax 2012(Axapta) , you can try below code in job. 
Post a Comment
Read more

X++ code to get Transit Warehouse stock on hand

By
  Below X++ code to get Transit Warehouse stock on hand . You can try on Job and run. Thanks. InventSum inventSum;     InventDim inventDim;     InventDimParm inventDimParm;     InventLocation inventLocation;     Qty qtyPhysical, qtyOrdered, qtyAvailable;     WarehouseId transitWarehouseId = 'TRN0001'; // Replace with your transit warehouse ID     // Find the warehouse record     inventLocation = InventLocation::find(transitWarehouseId);     if (!inventLocation)     {         info(strFmt("Warehouse %1 not found.", transitWarehouseId));         return;     }     // Build dimension parameters     inventDimParm.initFromInventDim(InventDim::find(inventLocation.InventLocationId));     // Query InventSum for stock in the transit warehouse     while select inventSum         join inventDim...
Post a Comment
Read more

D365 F&O Build Versions List

By
  Application Version Build Number Release Date 10.0.38 10.0.1725 Oct 2023 10.0.39 10.0.1787 Jan 2024 10.0.40 10.0.1841 Apr 2024 10.0.41 10.0.1900 Jul 2024 10.0.42 10.0.1955 Oct 2024 10.0.43 10.0.2010 Jan 2025 10.0.44 10.0.2065 Apr 2025 10.0.45 10.0.2120 Jul 2025 10.0.46 10.0.2175 Oct 2025 10.0.47 10.0.2230 Jan 2026
Post a Comment
Read more

D365fno certification list

By
  Renewal frequency: Most certifications require renewal every 12 months through Microsoft Learn. Recent updates: MB-920 (ERP Fundamentals) retired Dec 31, 2025 . MB-310 (Finance) updated Sept 20, 2024 . MB-330 & MB-335 (SCM) updated July 12, 2024 . MB-500 (Developer) remains active Exam Code Certification Name Focus Area Level MB-920 Microsoft Dynamics 365 Fundamentals (ERP) Core ERP concepts, Finance & Operations basics Beginner MB-310 Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate Finance processes, reporting, accounting Intermediate MB-330 Microsoft Certified: Dynamics 365 Supply Chain Management Functional Consultant Associate SCM processes, inventory, logistics Intermediate MB-335 Microsoft Certified: Dynamics 365 Supply Chain Management Functional Consultant Expert Advanced SCM consulting, optimization Expert MB-500 Microsoft Certified: Dynamics 365 Finance and Operations Apps Developer Associate Development, customization, extensions Int...
Post a Comment
Read more

Power bi integration steps in d365fno

By
Integrating Power BI with Microsoft Dynamics 365 Finance and Operations (D365 F&O) can enhance your analytics capabilities by allowing you to create powerful dashboards and data visualizations directly from your D365 F&O data. Below are the steps to integrate Power BI with D365 F&O: Step-by-Step Guide to Integrate Power BI with D365 F&O 1. Service Principal Registration (Optional) If you want to access data securely and manage permissions for Power BI, it's recommended to create a Service Principal in Azure Active Directory.Go to Azure Portal: Navigate to the Azure portal ( https://portal.azure.com/ ). Register an Application:Go to "Azure Active Directory" > "App registrations" > "New registration". Give your application a name and select an account type that meets your needs. Register the application. Create a Client Secret: In the app's "Certificates & secrets" tab, create a new client secret and note it down....
Post a Comment
Read more