Microsoft Dynamic Ax

Tuesday, 22 October 2019

D365 F & O + Dynamics Ax Get Dimension Attribute Value using X++ coding

1. Get Dimension values
public static String255 getDimensionValue(SalesLine     _salesLine,Name _attributeValue)
    {
        ProjTable ProjTable;
        DimensionAttributeValueSet         DimensionAttributeValueSet;
        DimensionAttributeValueSetItem     DimensionAttributeValueSetItem;
        DimensionAttributeValue            DimensionAttributeValue;
        DimensionAttribute                 DimensionAttribute;

        // To display value for ProjectId "10005" only
        select RecId from DimensionAttributeValueSet
                where DimensionAttributeValueSet.RecId == _salesLine.DefaultDimension
        join RecId, DisplayValue from DimensionAttributeValueSetItem
                where DimensionAttributeValueSetItem.DimensionAttributeValueSet == DimensionAttributeValueSet.RecId
        join RecId from DimensionAttributeValue
                where DimensionAttributeValue.RecId == DimensionAttributeValueSetItem.DimensionAttributeValue
        join RecId, Name from DimensionAttribute
                where DimensionAttribute.RecId == DimensionAttributeValue.DimensionAttribute
                && DimensionAttribute.Name == _attributeValue; //'Cost Center';

        return DimensionAttributeValueSetItem.DisplayValue;
    }

#D365 FO #X++ #Dynamics Ax

Monday, 20 October 2014

while Importting Ax 2012 r3 contoso data Error

while Importting Ax 2012 r3 contoso data Error

Unhandled Exception: System.NotSupportedException: The given path's format is no
t supported.
at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boo
lean needFullPath)
at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[
] str, Boolean needFullPath)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, AccessControlActions control, String[] pathListOrig, Boolean check
ForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFul
lPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess
access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
at System.IO.FileSystemEnumerableIterator`1..ctor(String path, String origina
lUserPath, String searchPattern, SearchOption searchOption, SearchResultHandler`
1 resultHandler, Boolean checkHost)
at System.IO.Directory.InternalGetFileDirectoryNames(String path, String user
PathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, S
earchOption searchOption, Boolean checkHost)
at System.IO.Directory.InternalGetFiles(String path, String searchPattern, Se
archOption searchOption)
at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetDifferentialTableNames(Datapor
tDatabase db, String directory) in e:\bt\110700\Source\DataPort\Dataport\Library
\SqlHelper.cs:line 721
at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 183
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82

solution : Give the read ,write and DB-owner access of database.

Tuesday, 14 October 2014

Dynamics Ax or D365 F & O SSRS Reports Error

Publish-AXReport : An error occurred : The network path was not found.
If User Account Control (UAC) is enabled on the machine, close the
application, right-click the application, and then click Run as administrator.
At line:1 char:1
+ Publish-AXReport -ReportName *
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (Microsoft.Dynam...erConfigura
tion:VerifyReportServerConfiguration) [Publish-AXReport], InvalidOperation
Exception
+ FullyQualifiedErrorId : An error occurred : The network path was not fou
nd.
If User Account Control (UAC) is enabled on the machine, close the applica
tion, right-click the application, and then click Run as administrator.,Mi
crosoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

Publish-AXReport : The deployment was aborted. You do not have privileges to
deploy to server: ignblr-pothuraj. For deployment, you must have
administrative rights to the SQL Server Reporting Services (SSRS) server.
Contact your administrator to deploy.
At line:1 char:1
+ Publish-AXReport -ReportName *
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : SecurityError: (Microsoft.Dynam...ReportsDeploye
r:ReportsDeployer) [Publish-AXReport], SecurityException
+ FullyQualifiedErrorId : The deployment was aborted. You do not have priv
ileges to deploy to server: ignblr-pothuraj. For deployment, you must have
administrative rights to the SQL Server Reporting Services (SSRS) server.
Contact your administrator to deploy.,Microsoft.Dynamics.AX.Framework.Man
agement.Reports.PublishReportCommand

Solution :

Remote Registry”-service is not enabled by default. After enabling and starting the service via Start -> Administrative Tools -> Services deployment of

AX 2012 default SRS reports was successful. I suggest changing Start type from Manually to Automatic.

Friday, 10 October 2014

commands for Compilation of Ax2012 R3

the Bellow commands for Compilation of Ax2012 R3

Open the command prompt Run as Administrator

C:\Program Files\Microsoft Dynamics AX\60\Server\DynamicsAXR3\bin\
axbuild.exe xppcompileall /s=01
/altbin="C:\Program Files (x86)\Microsoft Dynamics AX\6.0\Client\Bin"

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

above the installation of file path.

Cd axbuild.exe xppcompileall /s=01
/altbin="C:\Program Files (x86)\Microsoft Dynamics AX\6.0\Client\Bin"

Thursday, 9 October 2014

Date Range query(From date ...Todate ) on MS Dynamics Ax using x++ code

Query q;
QueryBuildDataSource qbd;
QueryBuildRange qbr,qbr1;

// ret = super();

q = new Query();
qbd = q.addDataSource(TableNum( RateLine));
qbr = qbd.addRange(FieldNum( RateLine, StartDate));
qbr1 = qbd.addRange(FieldNum( RateLine, InflationTypeID));
qbr1.value(InflationRate_Type.valueStr());
qbr.value(strfmt('"%1".."%2"',FromDate.dateValue(), editEndDateRange.dateValue()));
RateLine_ds.query(q);
RateLine_ds.executeQuery();

Tuesday, 7 October 2014

AX Performance Checklist

I did send earlier this month to go over performance checklist. Here is part 2 of it. Please read.

http://blogs.msdn.com/b/axsupport/archive/2014/09/08/ax-performance-troubleshooting-checklist-part-2.aspx

Wednesday, 24 September 2014

How to Import XML file Through X++ coding , SalesOrder XML file How to Import using X++ code

static void SalesOrderCreatandInvoice(Args _args)
{
RetailTransactionService RetailTransactionService;
str dc;

XmlDocument doc;
XmlNodeList data;
XmlElement nodeTable;
XmlElement nodeAccount;
XmlElement nodeName;
#define.filename(@'C:\Temp\CreateCustomerOrder.xml')
doc = XmlDocument::newFile(#filename);
doc.load(@'C:\Temp\CreateCustomerOrder.xml');
// dc = any2str(doc.lo);

RetailTransactionService::createCustomerOrder(doc.toString());
}

XML file:

Customer Order / SalesOrder file .

<AutoPickOrder>false</AutoPickOrder>

<OrderType>SalesOrder</OrderType>

<InventLocationId>BOSTON</InventLocationId>

<StoreId>BOSTON</StoreId>

<TerminalId>BOSTON-1</TerminalId>

<PrepaymentAmountOverridden>false</PrepaymentAmountOverridden>

<HasLoyaltyPayment>false</HasLoyaltyPayment>

<ChannelReferenceId>STONON-1300001</ChannelReferenceId>

<Email>marykay@contoso.com</Email>

<Items>

</Salespersons>

</Item>

</Salespersons>

</Item>

</Items>

</Payments>

</CustomerOrder>