D365 Development stuffs X++

It easy to create a model in D365 but not that easy to uninstall a model. It can be done however with the modelutil.exe file in K:\AosService\PackagesLocalDirectory\bin folder Syntax: modelutil.exe -delete -metadatastorepath="[Meta data file path]" -modelname="[Model name]" Example: modelutil.exe -delete -metadatastorepath="K:\AosService\PackagesLocalDirectory" -modelname="MyModel" You will be asked to confirm with y or n.

Sales orders in D365 can have holds, stopping their further processing. He is the data diagram over the tables. A select statement would look like this, showing all sales orders that have a certain hold code.         SalesTable salesTable;         MCRHoldCodeTrans holdCodeTrans;         MCRHoldCodeTable holdCodeTable;            while select  SalesId,                  from salesTable                                  join MCRHoldCode, InventRefId                     from holdCodeTrans                                         where    holdCodeTrans.InventRefId == salesTable.SalesId //Needs setup parameter                     &&       holdCodeTrans.MCRHoldCode == 'RX Item'                      {             info(strFmt( '%1 %2 %3 %4' , salesTable.SalesId , holdCodeTrans.MCRHoldCode));         } A more complex view including Retail Attributes on sales order lines, which was the actual task.         SalesTa

Recently I've dived into Retail. There will be some posts about retail and the problems I've faced with solutions. First off will be the Retail Attributes, they can be problematic here is a data base diagram illustrating a simplyfied view, assuming the value is of type text. And here is the select statement for listing all sales lines with their attributes.         SalesTable salesTable;         SalesLine salesLine;         RetailSalesTableInstanceValue instanceValue;         EcoResAttribute attribute;         EcoResAttributeValue attributeValue;         EcoResTextValue      textValue;     while select salesId                  from  salesLine             join SalesId                   from salesTable                 where salesTable.SalesId == salesLine.SalesId             join SalesId, RecID                 from instanceValue                 where    instanceValue.SalesId == salesLine.SalesId                 &&  

First post Hi, I am a developer, worked with Dynamics development since 2008. In this blog I will post solutions to problems I've faced that I have not found in any other forum, or blog. Better go get the information out there than have all to my self.