Posts

number to text arabic

 [ExtensionOf(classStr(Global))] final static class Global_BI_KSA_EInvoice_D365Integration_Extension {     static TempStr numeralsToTxt_AR(real _num)     {        // real    numOfPennies = decround(frac(_num), 2);        int numOfPennies = real2int(decround(frac(_num) * 100, 0));         real    test         = abs(_num - frac(_num));         str     zero;         str     comma;         str     and;         str     cent;         int     numOfTenths;         str 20  ones[19], tenths[9], hundreds, thousands, millions, billions, trillions;         int64   temp;         str 200  returntxt;       ...

How to create a new design for a Sales Invoice report in D365FO

 https://denistrunin.com/xpptools-reportsalesinvoice/

Restore Production database to DEV environment in D365FO using Bacpac File

 https://www.linkedin.com/pulse/restore-production-database-dev-environment-d365fo-using-abbas-tfwbe

-Add Procurement Category Column in On-hand Inventory Screen

Image
we have tow options:  1- as display method 2- add new field to inventtable and update it in init() method of form before super()

Fix "The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server" while importing a D365FO .bacpac

 https://www.linkedin.com/pulse/fix-permission-kill-database-connection-supported-sql-silva-rossi-dzcaf

x++ query select from markuptransHistory table

     MarkupTransHistory _markupTransHistory;     Query query;     QueryRun queryRun;     QueryBuildDataSource queryBuildDataSource;     QueryBuildRange queryBuildRangeTableId,queryBuildRangeRecId;     select _purchLine     where  _purchLine.LineNumber == _vendPurchLineAllVersions.LineNumber  &&    _purchLine.PurchId == _vendPurchLineAllVersions.PurchId;     query = new Query();     query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime);     queryBuildDataSource = query.addDataSource(tableNum(markupTransHistory));     query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime);     queryBuildRangeTableId = queryBuildDataSource.addRange(fieldNum(markupTransHistory,TransTableId));     queryBuildRangeTableId.value(queryValue(_purchLine.TableId));     queryBuildRangeRecId = queryBuildD...