Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

alirazazaidi

How to fetch un-Invoiced Delivery notes for sales order – D365 Finance and Operations

by

So here is another code snippet, that I develop after two hours of testing and understanding the D365 F&O that get all non invoiced , delivery notes or packingslip. I want to restrict the code to invoice against Delivery note, If no non posted delivery note exists, Code will not generate the invoice.

 public static str getUninvoicedPackingSlipsBySalesId(SalesId _salesId)
 {
     CustPackingSlipJour custPackingSlipJour;    // Packing slip journal
     InventTrans         inventTrans;            // Inventory transaction

     str packingSlipIds = "";
     container distinctPackingSlips;             // Container to store unique Packing Slip IDs
     int i = 0;

     // Fetch only un-invoiced Packing Slips based on Sales ID
     while select inventTrans
     where inventTrans.InvoiceId == ""
     
     join custPackingSlipJour
     where custPackingSlipJour.PackingSlipId == inventTrans.PackingSlipId
       && custPackingSlipJour.SalesId == _salesId
     {
         // Check if the Packing Slip ID is already in the container
         if (conFind(distinctPackingSlips, custPackingSlipJour.PackingSlipId) == 0)
         {
             distinctPackingSlips += custPackingSlipJour.PackingSlipId;  // Add to container if unique
                          
         }
     }

     return con2Str(distinctPackingSlips);  // Return the comma-separated string or empty if none found
 }

How to Import Data into D365 Finance and Operations

by

Hello friends, welcome to today’s video/blog post!

In this guide, we will walk through the process of loading data into Dynamics 365 Finance and Operations (D365 F&O). This step is typically performed twice:

  1. During initial environment configuration – before starting the User Acceptance Testing (UAT).
  2. Before going live – to ensure all required business data is in place.

Data Collection and Preparation

After analyzing business requirements, the Functional Consultant collects data from Business Users. There are two common approaches for preparing data:

  1. Business Users Provide Data in Excel
    • The business users share their data in Excel files.
    • The functional consultant then transforms it into the required D365 template for import.
  2. Predefined D365 Templates
    • The functional consultant exports predefined Excel templates from D365 F&O.
    • These templates are shared with business users for data entry.
    • Once completed, the business users upload the data into the system.
Excel Expertise is Essential

From my experience, strong Excel skills are crucial when handling data imports. You’ll often need to:

  • Remove duplicates.
  • Replace lookup values with valid data.
  • Ensure data is formatted correctly before uploading.

However, delays can occur due to confusion over responsibility. Business users may not provide data in the required format, while functional consultants may hesitate to modify it. This can result in delays of two weeks to a month in some cases.

Data Import Methods in D365

Microsoft provides two ways to import data into D365 Finance and Operations, both based on the D365 Data Entity Framework:

  1. Data Entity Framework – Used to import/export structured data.
  2. Excel Add-in – Allows direct data updates from Excel into D365.

Step-by-Step Guide to Import Data

In this walkthrough, we will use both methods to import data into D365 F&O.

Step 1: Exporting a Data Template
To get started, we first need to export a data template from D365. Here’s how:

  1. Navigate to the Dashboard.
  2. Click on Data Management.

Second way to go System administrator and there you can go Data Management
System Administration > Workspaces > Data management.

From Title Click and select Export

Create a new group and add vendor Info. and then click on Add entity

Search and select Vendors v2 in entity name and then select Excel in Target data format

Click on Export now

download excel by click on download excel file. Our excel template is ready.

We can remove unnessary fields from here and remove existing data and add new vendor information in excel sheet.

When excel sheet is prepared click again on Data management workspace on import Title

Create a new group with Vendor Import v2

click on add file and select Excel

and then search and select vendor V2 from form entity Name.

select the file and upload

Load and upload modified excel sheet and click on close button.

Before going to import go to vendor number sequence and set it manual and allow to a higher number.

And click on import

It is successful. If there are issue, then we try to resolve any validation issue. and try to import again.

![[Pasted image 20250223162113.png]]

Excel Addin

Using the Excel Add-in to Load Data into D365 F&O

Another efficient way to load data into D365 Finance and Operations (D365 F&O) is by using the Excel Add-in. This method allows users to import and update records directly from Excel, streamlining the data entry process.

Steps to Load Vendor Data Using the Excel Add-in

  1. Navigate to the Vendor List Page
    • Go to Accounts Payable > Vendors > All Vendors.
    • This page displays the list of all vendors in the system.
  2. Open the Excel Add-in
    • Click on the Microsoft Office icon in the top-right corner of the screen.
    • Select Vendor V2 under Open in Excel.

Work with the Excel Template

  • The system will download an excel file with all required fields.
  • Need to enable the Microsoft Dynamics Add-in if prompted.

Add new vendor and drag table boarder to new line save it
Publish the Data to D365

  • Once the data is entered, click the Publish button in the Excel Add-in.
  • The data will be validated and imported directly into D365 F&O.

click on publish

You can see the uploaded data into D365 F&O

How to convert utcdate time to ISO 8601 Formats D365 Finance and Operations

by

Hi friends, recently I got chance to write a code to convert Utc date time to iso 8601. I wrote following code snippet you can modify as per your need

public static str GetEPochTime(utcdatetime _DateTimeValue)
{
    utcDateTime utcDateTimeValue;
    str formattedDateTime;
  
    date datepart;
    int milliseconds;
    TimeOfDay _time;
    // _DateTimeValue = DateTimeUtil::applyTimeZoneOffset(_DateTimeValue, Timezone::GMTPLUS0300KUWAIT_RIYADH); // Adjust for specific timezone if needed
    int _year= DateTimeUtil::year(_DateTimeValue);
    int _day = DateTimeUtil::day(_DateTimeValue);
    int _Month = DateTimeUtil::month(_DateTimeValue);
    int _Hour = DateTimeUtil::hour(_DateTimeValue);
    int _second = DateTimeUtil::second(_DateTimeValue);
    int _minute = DateTimeUtil::minute(_DateTimeValue);
    int _timetomilliSecond = 0;
    var localTime =  new System.DateTime(_year, _Month, _day, _Hour, _minute, _second,_timetomilliSecond, System.DateTimeKind::Utc);
    localTime =System.TimeZoneInfo::ConvertTime(localTime,System.TimeZoneInfo::FindSystemTimeZoneById("Arabic Standard Time"));
    // Example UTC DateTime
    // utcDateTimeValue = _DateTimeValue;
    formattedDateTime = localTime.ToString("o");
    // formattedDateTime =DateTimeUtil::toStr(_DateTimeValue);
    formattedDateTime =strReplace(formattedDateTime,".0000000",".00+03:00");
    return formattedDateTime;

Sales order cancellation validation through event handler X++

by

Hi friends, small tip, I got chancel to add validation in Cancel functionality of D365 Finance and operations.Interestingly the menu button called the class. So I have to write the pre event handler for main method.

Following is the [[Code Snippet]]

public static void SalesCancelOrder_Pre_main(XppPrePostArgs _args)
    {
     

        Args args =_args.getArg("args");
        SalesTable salesTable = args.record();
        CustmTable _Response;

        select * from _Response where _Response.PrimaryKey == salesTable.SalesId && _Response.TransType == CustmTransType::SalesOrder;
         
        if (_Response.RecId !=0)
        {
           // validateEventArgs.parmValidateResult(false);
           Error("This sales order is integrationed with wms, Cancellation is not recommended, use the cancellation dailog for Cancel in wms.");
            if (Box::yesNo("Sales order is integrated with WMS, Do you really want to cancel it.", DialogButton::No) == DialogButton::No)
            {
                throw Exception::Error;
            }
        }

       
    }