Publications

Here is an example of X++ code to create a profit/loss inventory journal connected to a sales order delivery note.

Here is an example of X++ code to post the transfer order shipment with autoreceive and check that it was successful:

Here is an example of X++ code, which can be used to cancel existing transfer/sales order picks:

Here is an example of X++ code to post the transfer order picking list with a check that it was successful:

Cross-company indexes might be required to optimize cross-company oData queries. Or other cross-company X++ queries. By default, for company-specific tables (SaveDataPerCompany=Yes), DataAreaId is always included in the index at the…

Exchange rate operations: Convert to accounting currency: Convert to a different currency: Get accounting currency: Get reporting currency: Convert currency with a class instance: Get the exchange rate:

Often, due to a large number of fields in the table or an enormous amount of records, the standard SysTableBrowser is heavily lagging, especially on the DEV boxes. Also, when you are interested in only several field contents, it is not…

Add/overwrite SSRS print management design addOther vs addStandard. addOther - if populate (PrintMgmtReportFormat::populate()) is executed with standard code, it add a record to the PrintMgmtReportFormat table where System = Yes. Then, if…

Errors: Illegal splitting. Update has been cancelled. Full catch weight quantity requested was not processed. To resolve this issue, go to the order lines -> Stock -> Pick to pick sufficient amount to issue. Insufficient stock transactions…

Create a draft Pull request with linked work items from one branch to another. Open a new window and update next URL with your information: Copy and paste the JSON result to any service for converting "JSON to CSV" or Excel (e.g.…

I will show how to deal with most update conflict errors based on my case in standard application. Particular error from the case: Cannot edit a record in Inventory transactions (InventTrans). An update conflict occurred due to another…

try catch UpdateConflict / DuplicateKeyException template: Execution: Content of #OCCRetryCount marco:

Relevant menu items: Warehouse management / Setup / Location directives Warehouse management / Setup / Warehouse / Fixed locations / Product variant Warehouse management / Setup / Warehouse / Location stocking limits Warehouse management /…

If you need to debug something that will destroy your test data, that is not easy to recreate (i.e. posting a complex journal), then normal approach would be to take DB backup, and restore it after you finished debugging to debug…

Error: Results. The value "DataSourceName" is not found in the map. Usually happens when adding Name from DirPerson (DirPartyTable) data source joined to HcmWorker_Orderer data source on PurchPurchaseOrderHeaderV2Entity data entity or…

Error: SharePoint Site Address 'https://uksouth1-mediap.svc.ms/' is not valid clientRequestId: xxxx-xxxx-xxxx-xxxx-xxxxx. With a recent update to power automate, Microsoft seems to introduce a new validation, which blocks the creation of a…

Implementation of custom iframe control for D365 F&SCM with possibility to receive custom JavaScript messages from its content. For example, D365F&SCM needs to get some information from iframe when the user completes the process on the…

MD5 hashing + transformation to HEX format for the value to be JSON/XML compatible.

str string = 'some string'; // Convert String to System.IO.Stream System.Byte[] byteArray = System.Text.Encoding::get_UTF8().GetBytes(string); //System.Byte[] byteArray = System.Text.Encoding::get_ASCII().GetBytes(string);…

Can be used to deliver context parameters if it is not possible to do it via usual method parameters. Runnable job, which defines context: Execution infolog: Context class with required parameters/logic The class that consumes context:…