Skip to main content

Posts

Showing posts with the label D365FO

🔎 How to Get Line-wise Other Charges Tax Amount in D365FO (IGST / CGST / SGST)

 In many D365FO implementations (especially India GST projects), we often need: Line-wise Other Charges Tax Amount Split into IGST, CGST, and SGST For Posted Customer Invoice Lines (CustInvoiceTrans) By default, D365FO stores: Invoice Lines → CustInvoiceTrans Charges → MarkupTrans Tax → TaxTrans To get accurate charges tax per invoice line, we must follow proper table relation hierarchy. 📌 Table Relationship Structure CustInvoiceTrans → MarkupTrans → TaxTrans Relationship Logic: MarkupTrans.TransTableId == tableNum(CustInvoiceTrans) MarkupTrans.TransRecId == CustInvoiceTrans.RecId TaxTrans.SourceTableId == tableNum(MarkupTrans) TaxTrans.SourceRecId == MarkupTrans.RecId This ensures we fetch only Charges Tax , not Item Tax. 🧠 Business Requirement For each invoice line, we need: IGST Amount CGST Amount SGST Amount Converted to positive value (if negative) 💻 X++ Code – Line Wise Charges Tax Calculation Cus...

🔄 Convert Available Inventory to Kilograms (KG) in X++ – D365 F&O

When working with raw materials in Dynamics 365 Finance & Operations (D365 F&O), it’s common to encounter situations where the inventory is stored in one unit (like Liters or Packs), but needs to be viewed or calculated in Kilograms (KG) for costing, reporting, or analysis. In this blog, we’ll walk through a practical X++ code snippet that demonstrates how to convert available inventory (AvailPhysical) into KG using D365’s standard Unit of Measure (UOM) conversion. 📌 Business Scenario Suppose you have a chemical item stored in Liters , but the production or costing team needs to see its available inventory in KG . You’ll need to: Fetch the item’s AvailPhysical from the InventSum table. Get the current unit of measure (UOM) for the item. Convert that quantity into KG , based on predefined unit conversion. 💻 X++ Code – Inventory Conversion to KG Here’s the code block that does exactly that: //******************** Avail Physical as per KG Unit conversion *...

Integrate API using X++ in D365FO

 Process of making a POST request in X++ using the WinHttp class step by step. 1. Setup Before making an HTTP request, ensure you have the necessary URL, headers, and payload data you want to send. 2. Create the HttpWebRequest Object You will first need to create an instance of HttpWebRequest by specifying the URL you want to send the POST request to. 3. Configure the Request Set the HTTP method to POST and configure any necessary headers and content type. Prepare the request body as a byte array. 4. Send the Request and Handle the Response Write the request body to the request stream, send the request, and read the response. Example Code Here’s a detailed step-by-step example in X++: static void PostRequestExample(Args _args) {     System.Net.HttpWebRequest request;     System.Net.HttpWebResponse response;     System.IO.Stream requestStream, responseStream;     System.IO.StreamReader reader;     System.Text.Encoding utf8;  ...

Customizing Date Lookup to Use the Persian Calendar in D365FO (X++)

Introduction Dynamics 365 Finance and Operations (D365FO) traditionally uses the Gregorian calendar for date selections. If your organization requires the Persian calendar, you can customize the default date picker form, SysDateLookUp, to accommodate this need. This blog provides a detailed guide on how to achieve this, including the creation of necessary classes and methods for date conversion. Step-by-Step Guide 1. Duplicate the SysDateLookUp Form To begin, you need to create a copy of the existing SysDateLookUp form, which will be customized to use the Persian calendar. Action : In the Application Object Tree (AOT), locate the SysDateLookUp form, right-click it, and select "Duplicate." Name the new form : PersianDateLookup 2. Configure the Persian Calendar Open the Form : Navigate to the AOT, find the duplicated PersianDateLookup form, and open it. Modify the Init Method : Open the init method of the PersianDateLookup form and set the calendar type to Persian. Use a util...

Configuring a Secure Connection to D365FO in OneBox

  Introduction In this guide, we will address how to eliminate the “Not secure” message that appears in the URL bar when connecting to Dynamics 365 for Finance and Operations (D365FO) in a local development environment known as OneBox. We will explore why this issue arises and provide a step-by-step solution to fix it. Understanding the Issue The problem originates from the site certificate not meeting the latest security standards. Google Chrome, starting from version 58, uses only the subjectAlternativeName extension, not the commonName , to validate the domain name against the site certificate. This change means that if the certificate does not comply with these standards, Chrome will flag it as invalid. Although Internet Explorer (IE) is less strict and may not show this warning, the issue is significant for Chrome users. More information can be found at this link: Google Chrome Security Support . Solution Steps Step 1: Generate a New Self-Signed Certificate To address this is...