AijazMahar

Create Sales Quotation using X++ Code in Ax2012

2012-02-05T09:34:00.000-08:00

static void CreateSalesQuotation(Args _args)
{
AxSalesQuotationTable AxSalesQttable;
AxSalesQuotationLine AxSalesQtline;
SalesQuotationLine SalesQuotationLine;
salesQuotationTable salesQuotationTable;
CustTable custTable;
SalesQty salesQty;
;
salesQty = 2;
AxSalesQttable = new AxSalesQuotationTable();
AxSalesQttable.parmCustAccount('C-20');
AxSalesQttable.parmCurrencyCode('USD');
AxSalesQttable.save();
AxSalesQtline = new AxSalesQuotationLine();//::construct(smmQuotationLine);

AxSalesQtline.axSalesQuotationTable(AxSalesQttable);

AxSalesQtline.parmQuotationId(AxSalesQttable.parmQuotationId());
AxSalesQtline.axSalesQuotationTable(AxSalesQttable);
AxSalesQtline.parmItemId('1000');

AxSalesQtline.parmSalesQty(salesQty);

AxSalesQtline.parmInventDimId('00001005_069');
//AxSalesQtline.par

AxSalesQtline.parmcurrencyCode('USD');
AxSalesQtline.save();
}

A call to the Microsoft Dynamics AX SRSFrameworkService service failed. No connection could be made because the target machine actively refused it

2012-01-25T22:05:00.000-08:00

I am facing that problem but the help of following link. I have solved that problem
http://community.dynamics.com/product/ax/f/33/t/68553.aspx

with the help of above link i have register the following both services

SRSFrameworkService

SSASFrameworkService

and also auto deploy the following services

BIServices

UserSessionService

Selecting and Updating Records from an External Database

2011-12-15T06:12:00.000-08:00

I have read article from some useful links.
http://daxguy.blogspot.com/2006/11/updating-external-database-using-x.html
http://www.artofcreation.be/2010/06/21/executing-direct-sql-statements/
http://alexvoy.blogspot.com/2008/11/connection-from-ax-to-external-database.html
http://atomicax.com/content/selecting-and-updating-records-external-database

How add financial dimension on forms inside Ax2012

2011-11-01T06:51:00.000-07:00

1. Perform

a) Open AOT>>Data Dictionary>>Extended Data Types type/select DimensionDefault and drag it in table which will be used further as a datasource in form where you have to show the Dimensions. Do Remember that you have to drag it in table not at DataSource.

b) Open Table in the Data, Dictionary which will be used as a Datasource, and create a realtion with table DimensionAttributeValueSet .

c) Right Click the Relations. Select ‘New Realation’. Select properties. Set name as DimensionAttributeValueSet, Table as DimensionAttributeValueSet.

d) Right Click the this newly created Relation DimensionAttributeValueSet, select New>>Normal.

e) Set the properties of Normal Realtion as: Field=TheFieldwhichwillsaveDimensionNumberInYourTable

Source EDT= DimensionDefault

Related Field=RecId

2. Verify that the table that will hold the foreign key to the DimensionAttributeValueSet table is a

data source on the form(the one on which you have to show dimensions).

3. Create a tab that will contain the financial dimensions control. This control is often the only

data shown on the tab because the number of financial dimensions can be large.

4. set properties of Tab as under

a) Set the Name metadata of the tab to TabFinancialDimensions.

b) Set the AutoDeclaration metadata of the tab to Yes.

c) Set the Caption metadata of the tab to @SYS101181 (Financial dimensions).

d) Set the NeedPermission metadata of the tab to Manual.

e) Set the HideIfEmpty metadata of the tab to No.

5. Override the pageActivated method on the new tab

public void pageActivated()

{

dimDefaultingController.pageActivated();

super();

}

6. Override the following methods on the form.

class declaration

public class FormRun extends ObjectRun

{

DimensionDefaultingController dimDefaultingController;

}

init (for the form):

public void init()

{

super();

dimDefaultingController=DimensionDefaultingController::constructInTabWithValues(

true,

this,

tabFinancialDimensions,

"@SYS138487");

dimDefaultingController.parmAttributeValueSetDataSource(myTable_ds,

fieldstr(myTable, DefaultingDimension));

}

7. Override the following methods on the form data source

public int active()

{

int ret;

ret = super();

dimDefaultingController.activated();

return ret;

}

public void write()

{

dimDefaultingController.writing();

super();

}

public void delete()

{

super();

dimDefaultingController.deleted();

}

what´s difference between Kernel version and Application

2011-09-19T03:16:00.000-07:00

The Dynamics AX Kernel is the component executing the X++ Application code. So the Kernel version is the version of the executable (Client, Server, Business Connectors) while the Application version is the version of the Dynamics AX “Business Logic” - the X++ Application code, Forms, Repots – everything in the AOT.
You can check the current Application version in the Dynamics AX Client going to "Help - About Microsoft Dynamics AX".

Sample union query from AX 2009

2011-07-11T12:23:00.000-07:00

Queries build with the Query classes now supports unions, meaning that you can combine the result from several tables into one result set. The results you want to combine from the different tables must be structured the same way for all tables.

You could for example create a query combining CustTable and VendTable. This would be particularly useful if you need to present for example a lookup form showing both customers and vendors in the same grid. In earlier version you’d have to push customer and vendor data to a temporary table before being able to present the combined data in one grid.

Here is an example on how to build and use a union query from X++:

static void union(Args _args)
{
Query query;
QueryBuildDataSource qbdsCustTable;
QueryBuildDataSource qbdsVendTable;
QueryRun queryRun;
CustTable custVendTable;
Map mapTableBranches = new Map(types::Integer, typeId2Type(typeId(TableId)));
SysDictTable dictTable;
;

// The map is used to match the UnionBranchID with a table id
mapTableBranches.insert(1, tableNum(CustTable));
mapTableBranches.insert(2, tableNum(VendTable));

query = new Query();
query.queryType(QueryType::Union);

qbdsCustTable = query.addDataSource(tableNum(CustTable));
qbdsCustTable.unionType(UnionType::UnionAll); // Include duplicate records
qbdsCustTable.fields().dynamic(false);
qbdsCustTable.fields().clearFieldList();
qbdsCustTable.fields().addField(fieldNum(CustTable, AccountNum));
qbdsCustTable.fields().addField(fieldNum(CustTable, Name));

qbdsVendTable = query.addDataSource(tableNum(Vendtable));
qbdsVendTable.unionType(UnionType::UnionAll); // Include duplicate records
qbdsVendTable.fields().dynamic(false);
qbdsVendTable.fields().clearFieldList();
qbdsVendTable.fields().addField(fieldNum(VendTable, AccountNum));
qbdsVendTable.fields().addField(fieldNum(VendTable, Name));

queryRun = new QueryRun(query);
queryRun.prompt();

while (queryRun.next())
{
custVendTable = queryRun.getNo(1);
dictTable = SysDictTable::newTableId(mapTableBranches.lookup(custVendTable.unionAllBranchId));

info (strFmt("%1 %2 (%3)", custVendTable.AccountNum,
custVendTable.Name,
dictTable.name()));
}
}

Microsoft Dynamics AX 2012 - System Architecture Overview

2011-06-26T02:53:00.000-07:00

Microsoft Dynamics AX 2012 - System Architecture Overview link
http://dynamics-ax.blogspot.com/2011/05/microsoft-dynamics-ax-2012-system.html

Tip for deploying SSRS report AX2009

2011-06-26T00:38:00.000-07:00

Following link will be help full for deploying SSRS report in AX2009.
http://dynamics-ax.blogspot.com/2011/01/expert-ssrs-with-ax-tip-from-michael.html

Who Modified Ax2009 Object?

2011-05-17T05:46:00.000-07:00

Following code will help you that who have modified object last time with date. Copy code and paste it in job.

static void UserWhoModifiedObjectLastDateandTime(Args _args)

{

UtilIdElements tblUtilIdElements;

;

while select tblUtilIdElements

where (tblUtilIdElements.utilLevel == UtilEntryLevel::USR && tblUtilIdElements.recordType == UtilElementType::Form && tblUtilIdElements.name == "SalesTable")

{

info(strfmt("%1",tblUtilIdElements.modifiedBy + " " + datetime2str(tblUtilIdElements.modifiedDateTime)));

}

How to check if your variable suit the conditions given in query range

2011-04-05T10:32:00.000-07:00

Use inRange methods from Global class

static boolean inRange(str _rangeValue, anytype _value)

Example:

{

str _rangeValue;

str _value ;

boolean result;

;

_rangeValue = ‘200..500’;

_value = ‘300’;

result = Global::inRange (_rangeValue , _value);

}

The result variable will be equal to true

How to set focus when first time opening form in axpta

2011-04-05T10:30:00.000-07:00

Override method firstField on a form, and call after super method setFocus of a control which should focused after form is opened. Example:

public void firstField(int _flags=1)

{

;

super(_flags);

MyControlName.setFocus();

}

How dynamically change data source field properties?

2011-04-05T10:14:00.001-07:00

myTable_ds.object( fieldNum( myTable, myField ) ).visible( false );
myTable_ds.object( fieldNum( myTable, myField ) ).allowEdit( false );

How to override lookup in Ax2009?

2011-04-05T10:08:00.000-07:00

Write following method on form level

void SummaryProjectLookup(FormControl ctrl)

{

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(ProjTable),ctrl);

Query query = New Query();

QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(ProjTable));

QueryBuildRange queryBuildRange;

;

sysTableLookup.addLookupfield(fieldNum(ProjTable, ProjId));

sysTableLookup.addLookupfield(fieldNum(ProjTable, Name));

sysTableLookup.addLookupfield(fieldNum(ProjTable, Status));

queryBuildRange = queryBuildDataSource.addRange(fieldNum(ProjTable, Type));

queryBuildRange.value(queryValue(ProjType::DEL_Summary));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

*******************************************************************

public void lookup()

{

element.SummaryProjectLookup(this);

}

How can I extract the hour, minute and seconds from AX2009 time?

2011-03-29T06:34:00.000-07:00

static void time(Args _args)

{

TimeIn _TimeIn;

int hourInt, minuteInt , SecondInt;

str s;

;

_TimeIn = str2time('5:45');

s = time2str(_TimeIn,0,0);

info(strfmt("%1",s));

hourInt= str2int(substr(s,0,2));

info(strfmt("%1" ,hourInt));

minuteInt= str2int(substr(s,4,2));

info(strfmt("%1" ,minuteInt));

SecondInt= str2int(substr(s,7,2));

info(strfmt("%1" ,SecondInt));

}

How to get current language of AX2009?

2011-03-27T04:34:00.000-07:00

using following code

info( infolog.language());

How to refresh data source Table level method?

2011-03-27T02:08:00.000-07:00

object Table1_ds;

;

Table1_ds = Table1.dataSource();

if(Table1_ds )

{

Table1.dataSource().refresh();

}

How to refresh parent form data Source against child form button clicked

2011-03-20T04:10:00.000-07:00

On Parent form data source write a method “refreshDatasource “

Step:1

void refreshDatasource ()

{

;

ParentTable_ds.research(true);

}

Step: 2

On child form click button write following code

Void Clicked

{

element.args().Caller().refreshDatasource();

}

Steps to Create Number Sequence on form using Table Level Methods in Microsoft Dynamics Ax2009

2011-03-20T02:59:00.000-07:00

I will describe these steps with example in this example I have two Tables “Table1” and “Parameter Table” OR NumberSequenceReferenceone extend data type “Test” and “form1”.

Step1: Add one field in Table 1

Filed1 using extend data type Test

Write two methods on Table 1

Let suppose name are numberSeqFormHandleFiled1(Parameter1,Parameter2) and

formMethodDataSourceCreate(Parameter1,Parameter2)

Step 2: Write one method on Parameter Table OR NumberSequenceReference

numRefFiled1()

Detail code of all methods

static client server NumberSequenceReference numRefFiled1 ()

{;

return NumberSeqReference::findReference(typeId2ExtendedTypeId(typeid(Test)));

}