Sales order financial dimension update using code

We can use below code to update financial dimensions defaultDimension field of sales order using x++ code

static void setDefualtDimensionSO(Args _args)

{

    DimensionAttribute                  dimensionAttribute;

    DimensionAttributeValue             dimensionAttributeValue;

    DimensionAttributeValueSetStorage   dimensionStorage;

    SalesTable                          salesTable;

    Counter               i;  

    ttsBegin;

    select forupdate salesTable

        where salesTable.RecId == 5637146827;

    

   dimensionStorage = DimensionAttributeValueSetStorage::find(salesTable.defaultDimension);  

   dimensionAttribute = DimensionAttribute::findByName('Handling');  

   dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute, 'BROK', true, true);  

   dimensionStorage.addItem(dimensionAttributeValue);  

   

    

    salesTable.defaultDimension = dimensionStorage.save();  

    salesTable.update();

    ttsCommit;

}

Error while execution the following sql:BULK INSERT

While upgrading data from 3.0 to 4.0, we need to use a tool AxDbUpgrade.exe, I was getting error while running the tool on bulk insert, the reason was that I was running the tool on the server where my AOS was installed, however the database was not able to access the local path of AOS, so I created a folder on my DB server and shared it and issue was resolved.

How to run AxBuild command in AX 2012

To start a AxBuild compile, you need to have CU7 update for Ax 2012 R2, make sure that you have axbuild.exe files in

C:\Program Files\Microsoft Dynamics AX\60\Server\bin

1. Open command prompt as an administrator

2. Go to AxBuild path C:\Program Files\Microsoft Dynamics AX\60\Server\bin

3. Run below command.

AxBuild.exe xppcompileall /aos=<AOS instance number> /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\6.0\Client\Bin"

System.Runtime.InteropServices.COMException (0x80070422): The service cannot be started

While installing Dynamics AX 2012 R2  debugger I was getting this error. I started windows update service the error was resolved.

Table 'TableName' used in report provider class should be a regular table.

This is because the RDP class extends the SRSReportDataProviderPreprocess class. to resolve this, you can do following steps:

1. Replace SRSReportDataProviderPreprocess with SRSReportDataProviderBase, but you will not be able to debug the report if it extends from SRSReportDataProviderBase.

2. Change properties of the report's tmp table CreatedBy and CreatetransactionId to 'yes', Also make the table as regular table.