Posts

Showing posts from January, 2023

SysOperation MultiThreading in D365 X++

------------------------------------------------------------------------------------------------------------------------------ 1. PurchCalcTaxController  2. PurchCalcTaxHandler 3. PurchCalcTaxBatchController 4. PurchCalcTaxBatchContract 5. PurchCalcTaxContract [SysOperationJournaledParametersAttribute(true)] class 69PurchCalcTaxController extends SysOperationServiceController {     public static void main(Args _args)     {         69PurchCalcTaxController::construct().startOperation();     }     public static 69PurchCalcTaxController construct()     {         69PurchCalcTaxController controller = new 69PurchCalcTaxController(             classStr(69PurchCalcTax),             methodStr(69PurchCalcTax, run));         return controller;     }     /// <summary>     /// provides capti...

Excel Import into D365 using x++ code

 using System.IO; using OfficeOpenXml; using OfficeOpenXml.Style; using OfficeOpenXml.Table; using OfficeOpenXml.ExcelRange; using OfficeOpenXml.ExcelPackage; /// <summary> /// Customer invoice journal excel import /// </summary> class CustInvoiceJournalExcelImport  {     int currentRow              = 1;     int coloumn                 = 1;     ExcelWorksheets             worksheets;     ExcelWorksheet              worksheet;     OfficeOpenXml.ExcelRange    cells;     OfficeOpenXml.ExcelRange    cell;     #OCCRetryCount     CustInvoiceTable         CustInvoiceTable;     CustInvoiceLineImport    CustInvoiceLineImport;                 ...

Export Template into D365 through x++ code

 using System.IO; using OfficeOpenXml; using OfficeOpenXml.ExcelPackage; using OfficeOpenXml.ExcelRange; /// <summary> /// Contains buisness logic used in customer invoice journal template Export /// </summary> class CustInvoiceJourExportTemplate {         private const int InvoiceDate           = 1;     private const int BillingPeriodDate     = 2;     private const int Description           = 3;     private const int TCAccountId           = 4;     private const int BillingClassification = 5;     private const int BillingCode           = 6;     private const int AmountCurDebit        = 7;         private const int TotalAmount           = 8;     private const int ItemGSTG...