Steps to upgrade or apply service update On-Premise environment in D365FO

To install Custom package on-premise environment

AXUpdateInstaller.exe devinstall

--------------------------------------------------------------------------------------------------

To install Service update package

Step 1: Download the service update package from LCS

Step 2: Right click and Unblock the package

Step 3: Extract to some folder like C:/Temp 

Step 4: go-to - C:/Temp/"Serive Update extracted folder"/RetailServer/Scripts

Step 5: search file "DropAllRetailChannelDbObjects.sql" and click edit on notepad, copy all code

Step 6: Open SQL and New query on AXDB -> paste the code and Execute

Step 7: go-to - C:/Temp/"Serive Update extracted folder"/DefaultTopologyData.XML(Open in notepad)

Step 8: search in notepad (LocalHost) and replace with PC name

Step 9: Paste the list of devTools list by executing AXUpdateInstaller.exe list(Inside CMD under same folder). Example below: -  

<Machine>

      <Name>TESTDEV001</Name>

      <ServiceModelList>

        <string>AOSService</string>

        <string>DevToolsService</string>

<string>ALMService</string>

<string>BIService</string>

<string>DIXFService</string>

<string>MROneBox</string>

<string>PayrollTaxModule</string>

<string>PerfSDK</string>

<string>ReportingService</string>

<string>RetailCloudPos</string>

<string>RetailHQConfiguration</string>

<string>RetailSDK</string>

<string>RetailSelfService</string>

<string>RetailServer</string>

<string>RetailStorefront</string>

      </ServiceModelList>

    </Machine>

Step 10: open CMD as admin and navigate to extracted folder. i.e. C:/Temp/"Serive Update extracted folder"

Step 11: Execute below commands: -  

AXUpdateInstaller.exe list

AXUpdateInstaller.exe generate -runbookid="Dev-runbook22082022-1" -topologyfile="DefaultTopologyData.xml" -servicemodelfile="DefaultServiceModelData.xml" -runbookfile="Dev-runbook22082022-1.xml"

AXUpdateInstaller.exe import -runbookfile="Dev-runbook22082022-1.xml"

AXUpdateInstaller.exe execute -runbookid="Dev-runbook22082022-1"

--------------------------------------------------------------------------------------------------

To re-run step: - 

AXUpdateInstaller.exe execute -runbookid="Dev-runbook22082022-1" -rerunstep=60

To mark step has completed: - 

AXUpdateInstaller.exe execute -runbookid="Dev-runbook22082022-1" -setstepcomplete=60

--------------------------------------------------------------------------------------------------

Additional Basic Troubleshooting solutions: - 

Unable to find Dynamics 365 Finance and operations extension: -

Solution - Check for service: - CNG Key Isolation

to install - C:\Temp\FinanceAndOperations_10.0.1265.20_Application\DevToolsService\Scripts

Microsoft.Dynamics.Framework.Tools.Installer.vsix

Any Step failed: - 

solution - Right click on extracted folder - Uncheck Read only option.

Enable developer mode of Retail POS in d365 how to check label text id of each button on CPOS in d365

 open cpos on edge

f12

setting

enable javascript source maps true

console

Commerce.Helpers.DeveloperModeHelper.setDeveloperMode(true);

Update Modern POS to latest version in D365fo

 

Refer below link : - 

Configure, install, and activate Modern POS (MPOS) - Commerce | Dynamics 365 | Microsoft Docs

Device activation of a customized Modern POS - Commerce | Dynamics 365 | Microsoft Docs

Click check for package update

To update peripheral : - 

Refer below link - https://www.youtube.com/watch?v=ZSdH57w02oc

Export Import Model in D365fo

CMD as admin

go to path-

 C:\AOSService\PackagesLocalDirectory\bin

Export - 

ModelUtil.exe -export -metadatastorepath=K:\AosService\PackagesLocalDirectory -modelname=CustomModel -outputpath=C:\Temp

Import-

ModelUtil.exe -import -metadatastorepath=C:\AOSService\PackagesLocalDirectory -file="C:\Temp\Custom Seperate Models\CustomModel.axmodel"

Each model might contains Resources folder which contains DLLs. Need to import seperately.

synchronize DB

Build the model

Enable/ Disable or Hide/ Show new, edit, delete button on form in D365fo

 This is posts shows that how to enable disable or show hide system defined button on Form

FormCommandButtonControl attachButton; public void init() { #SysSystemDefinedButtons

//(This Macro contains all system defined buttons to be used on forms and you can play with

// and you play with all system defined buttons like command button, grid controls etc. super(); attachButton= this.control(this.controlId(#SystemDefinedAttachButton)) as FormCommandButtonControl; attachButton.visible(false); }

  public void init()
    {
        this.form().design().showNewButton(0);
        this.form().design().showDeleteButton(0);
        super();

    }

[ExtensionOf(FormStr(InventBatch))]
public final class P_InventBatchForm_Extension
{
    void run()
    {
        next run();
        inventBatch_ds.allowCreate(false); // Disable System Defined NEW Button
      }

}

ref: - System-defined buttons - Finance & Operations | Dynamics 365 | Microsoft Docs

Enter data from new line in SSRS and Formula in D365fo

 =Format(Fields!QuotationDate.Value, "MMM-dd yyyy") & Microsoft.VisualBasic.Constants.vbcrlf & Microsoft.VisualBasic.Constants.vbcrlf & Fields!CustomerName.Value & Microsoft.VisualBasic.Constants.vbcrlf & Fields!CustomerAddress.Value

 =Format(Fields!QuotationDate.Value, "MMM-dd yyyy") & vbcrlf & vbcrlf & Fields!CustomerName.Value & vbcrlf & Fields!CustomerAddress.Value

=Fields!PurchOrderDocNum.Value & vbcrlf & Format(Now(),"dd/MM/yyyy")

=IIF(Fields!CompLabelPrice.Value = "0.00",Nothing, Format(Fields!CompLabelPrice.Value, "#,0.00;(#,0.00)")) & " /-"

--------------------------------------------------------------------------------------------------------

To Get user specific date time on report

-

=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "d", Parameters!AX_RenderingCulture.Value) & vbCrLf & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "t", Parameters!AX_RenderingCulture.Value)

--------------------------------------------------------------------------------------------------------

Print every word with new line

=Replace(Fields!Text2.Value," ", System.Environment.NewLine)

--------------------------------------------------------------------------------------------------------

Print Page number on SSRS in D365 FO

Visual studio expression to print page number on every pages of report

 ="Page "&Globals!PageNumber &" of "&Globals!TotalPages