Dynamics Axapta Coverage and help materials or tutorials for developer using language x++

How to connect to a website from Axapta and Writing a web page information

noreply@blogger.com (Santosh Kumar singh) — Sat, 25 Feb 2012 06:47:00 PST

How to connect to a website from Axapta and Writing a web page information

str pg;
str NameofFile;
commaIO yourfile;
int Object1;
WinInet wi = new WinInet();
;
NameofFile = "C:\\test1.txt";
yourfile = new commaIO(NameofFile,"w");
Object1 = wi.internetOpenUrl('http://daynamicsaxaptatutorials.blogspot.in/');
if (Object1)
{
pg = wi.internetReadFile(Object1);
yourfile.write(pg);
}
wi.internetCloseObject1(Object1);
}

Connecting to External Database From Axapta by x++ code

noreply@blogger.com (Santosh Kumar singh) — Thu, 23 Feb 2012 11:36:00 PST

  Connecting to External Database From Axapta by x++ code.Following code works fine. I tried it.

CCADOConnection connection;
    CCADOCommand    Cmd;
    CCADORecordSet RS;
    CCADOFields     fields;
    Com             Coms;
    Str             Sql;
    Str             Provider    = "testServer";
    Str             DataBase    = "Testdb";
    Str             UserId      = "abc";
    Str             PWD         = "xyz";
    Str             ConnStr = strfmt("Provider=SqlOledb;server=" +
Provider + ";trusted_Connection=false;" +
                                        "Initial catalog=" + DataBase +
";user id=" + userid + ";password='" + PWD + "';");

    ;
    Sql = "Select * from InventTable where itemid="10001"";

    connection = new CCADOConnection();
    connection.open(ConnStr);

    Cmd = new CCADOCommand();
    Cmd.activeConnection(connection);
    Cmd.commandText(sql);

    RS = new CCADORecordSet();
    RS = Cmd.execute();
    Coms = RS.recordSet();

    while (!RS.EOF())
    {
        fields = RS.fields();
        info(strfmt("%1", fields.itemIdx(0).value()));

        Coms.moveNext();
    }

    connection.close();
    connection = null;

Calling Sql Stored procedure through axapta code

noreply@blogger.com (Santosh Kumar singh) — Sun, 12 Feb 2012 08:12:00 PST

Calling Sql Stored procedure through axapta code

    LogInProperty LogProp = new LogInProperty();
    OdbcConnection Con1;
    Statement stmt1;
    ResultSet rs;
    ;

    LogProp.setServer("SeverName");
    LogProp.setDatabase("DataBaseName");
    LogProp.setUsername("sa");
    LogProp.setPassword("123");

    try
    {
        Con1 = new OdbcConnection(LogProp);
    }
    catch
    {
        info("Check username/password.");
        return;
    }

    stmt1 = Con1.createStatement();
    rs = stmt1.executeQuery('EXEC [testSTRsp]');
    while (rs.next())
    {
        info(rs.getString(1));
    }

Hints for Workflow development for new modules in axapta

noreply@blogger.com (Santosh Kumar singh) — Fri, 10 Feb 2012 22:59:00 PST

Hints for Workflow development for new modules in axapta

creating workflows require creating / modifying following workflow artifacts:

Workflow Categories
Workflow Templates
Workflow Documents
Tasks
Approvals

Workflow Categories
To create new workflow categories follow the procedure below:
1. Open AOT
2. Expand the Workflow node
3. Right-click on the Workflow Category node and select New Workflow Category.
4. A new workflow category called WorkflowCategory1 will be created.
5. Right-click on the newly created workflow category and select Properties and set required properties.

Property
Description Name A unique name for the category
Label
A meaningful label for the category Ex: Purchase order Help Text Description about the category
Module
The module to which the category is applicable

Workflow Templates

Follow the procedure below to create a new workflow template:
1. Open the AOT
2. Expand the Workflow node
3. Right-click on the Workflow Templates node and select New Workflow Template
4. A new workflow template named WorkflowTemplate1 will be created
5. Right-click on the newly created workflow template and select Properties
6. Set the properties Name property to SalesApproval

Workflow Documents
Do the following:
Create a Query
1. Open the AOT
2. Right-click on the Query node and select New Query
3. Rename the query to PurchOrderDocument
4. Expand the Data Sources node in the newly created query
5. Right-click and select New Data Source
6.Next expand the salesable data source and right-click on the Data Sources node inside the salesable data source
7. Select New Data Source and set the Properties
8.Next expand the SalesLine data source and right-click on the Data Sources node inside the SalesLine data source

Task

Tasks are the most generic workflow elements. Tasks provide application specific behavior that you define in the AOT. Each task supports a single unit of work that is defined by one step. This means a workflow task can have only one step. A task does not have a fixed outcome. However, you can add any number of custom outcomes to the task, such as Completed or Skipped.
Each task must have at least one outcome of type Complete and an action menu item for the task work item button to display in the user interface.

This procedure describes how to create a new workflow task:
1. In the AOT, expand the Workflow node
2. Right-click the Tasks node and then select New Task. A new workflow task group displays under the Tasks node
3. Right-click the new workflow task and then click Properties
4. In the Properties sheet, set the properties as required

Approval

Workflow Approvals
Approvals are the specialized type of tasks. The main difference between tasks and approvals is that tasks can have only single step of work but approvals can have multiple steps and sub-workflows as well.
Approvals are specialized workflow elements designed to support approval scenarios. Approvals have a set of fixed outcomes that the workflow supports. These outcomes are as follows:
Approve - Outcome type Complete.
Reject - Outcome type Return to the originator of the workflow.
RequestChange - Outcome type
ChangeRequested from the originator or another person in the workflow process.
Deny - Outcome type Deny

This procedure describes how to create a new workflow approval:
1. In the AOT, expand the Workflow node
2. Right-click the Approvals node and then select New Approval. A new workflow approval group displays under the Approvals node
3. Right-click the new workflow approval and then click Properties
4. In the Properties sheet, set the properties as required

Add Dimensions array as range in axapta

noreply@blogger.com (Santosh Kumar singh) — Thu, 09 Feb 2012 09:56:00 PST

Add Dimensions array as range in axapta

QueryBuildDatasource qbds;
Query Q;
QueryRun QR;
;
Q=new Query();
qbds=Q.addDatasource(Tablenum(Table1));

qbds.addRange(fieldId2Ext(fieldnum(Table1,dimensionfield),1)).value('xyz')

QR=New QueryRun(Q);
While (Qr.next())
{
}

Programatically uploading image to document handling in axapta

noreply@blogger.com (Santosh Kumar singh) — Thu, 09 Feb 2012 09:29:00 PST

Programatically uploading image to document handling in axapta
This is good link to uploading image to document reference table of respective items automatically. I hope this link will help you to play with images in axapta tables.

http://dynamicsuser.net/forums/p/44260/223793.aspx

Set date range to datasource in report fetch method using Dynamics Ax

noreply@blogger.com (Santosh Kumar singh) — Thu, 09 Feb 2012 09:13:00 PST

Set date range to datasource in report fetch method using Dynamics Ax

querybuildrange qbr;

QueryRun qr = new queryrun(this.query());
;
qbr = qr.query().datasourcetable(tablenum(Inventtrans)).addrange(fieldnum(Inventtrans,DatePhysical));
qbr.value(queryrange(From_Date,To_Date));
element.send(Inventtrans);
element.send(Test_1);

How to send message alert to Online users in Axapta

noreply@blogger.com (Santosh Kumar singh) — Tue, 07 Feb 2012 11:35:00 PST

Create following job in AOT to send message alert to Online users in Axapta
static void sendMsgToOnlineUsers(Args _args)
{
Eventmsgbox msgbox;
EventmsgboxId msgboxId;
SysClientclientsessions1 clientsessions1;
;
while select clientsessions1
where clientsessions1.Status == clientsessions1tate::Running
{
msgboxId = Eventmsgbox::nextEventId();
msgbox.initValue();
msgbox.ShowPopup = NoYes::Yes;
msgbox.Subject = "Message aler";
msgbox.Message = "Message testing from ax application";
msgbox.SendEmail = false;
msgbox.UserId = clientsessions1.userId;
msgbox.msgboxId = msgboxId;
msgbox.AlertCreatedDateTime = DateTimeUtil::getSystemDateTime();
msgbox.insert();
}
}

validation for do not post the invoice without packing slip

noreply@blogger.com (sksingh1) — Wed, 01 Feb 2012 10:46:00 PST

Validation for do not post the invoice without packing slip

Below mentioned trick How to configure a AR parameter setting? so no body can not post the invoice without packing slip? mean they must create the packing slip and then system allow them to post the invoice?
You will have to setup the Inventory Model Group for the particular item.

Inventory management > Setup > Inventory > Inventory model groups
In the Setup tab under Physical update group, check 'Receiving requirements' checkbox.

How to call job to another job in axapta using x++ code

noreply@blogger.com (Santosh Kumar singh) — Sat, 21 Jan 2012 22:54:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to call job to another job in axapta using x++ code

1. Create simple job job_test and add it to action menu item in AOT.
2. Call job_test in other job using following code.

   Args                    args;
    ;

    args = new Args();
    args.name(identifierStr(Jobs_Test));
    new menuFunction(menuItemActionStr(Jobs_Test), MenuItemType::Action).run(args);

How to get current active company in Axapta

noreply@blogger.com (Santosh Kumar singh) — Sat, 21 Jan 2012 12:17:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to get current active company in Axapta

If you want to get name of current active company then curExt() is right method to get it just try following code in job

info(CurExt());

It will show you current active or selected company.

Simple Example of using tables in Query in axapta Reprts

noreply@blogger.com (Santosh Kumar singh) — Sat, 21 Jan 2012 11:31:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

Simple Example of using tables in Query in axapta Reprts
    Query q;
    QueryRun qr;
    QueryBuildDatasource qbds;
    QueryBuildRange qbr;
   InventTable inventtab;
    ;
    q = new Query();
    qbds = q.addDataSource(tablenum(InventTable));
    qbr = qbds.addRange(fieldNum(InventTable,Status));
    qbr.value(queryValue(NoYes::No));
    qr = new SysQueryRun(q);
    while(qr.next())
    {
    inventtab = qr.get(tableNum(InventTable));
    info(inventtab.Itemid);
    }

How to enable userid of axapta from sql query analyzer

noreply@blogger.com (Santosh Kumar singh) — Sat, 21 Jan 2012 11:17:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

select * from USERINFO where ID = 'userid'

update USERINFO set ENABLE = 1 where ID = 'userid'

update USERINFO set SID = 'write correct SID' where ID = 'userid'

Code to send email with attachment using dynamics axapta x++

noreply@blogger.com (Santosh Kumar singh) — Fri, 20 Jan 2012 11:08:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

Code to send email with attachment using dynamics axapta x++

void SendEMail()
{
    System.Net.Mail.MailMessage              Message;
    System.Net.Mail.Attachment              attachment;
    System.Net.Mail.AttachmentCollection    attachementCollection;
    System.Net.Mail.SmtpClient              smtpClient;
    System.Net.Mail.MailAddress             emailfrom;
    System.Net.Mail.MailAddress             emailto;
    str                                     messageBody ;
    str                                     Subject;
    str                                     SMTPServer;
    str                                     Filenm;
    FileIOPermission                        permission1;
    ;
    emailfrom = new System.Net.Mail.MailAddress("From@xyz.com","");
    mailAddressTo = new System.Net.Mail.MailAddress("To@abc.com","");
    messageBody = "This is test mail";
    Subject = "Subject";
    SMTPServer = SysEmailParameters::find(false).SMTPRelayServerName;
    mailMessage = new System.Net.Mail.MailMessage(emailfrom, mailAddressTo);
    mailmessage.set_Subject(Subject);
    mailmessage.set_Body(messageBody);
    attachementCollection = mailMessage.get_Attachments();
    Filenm = "C:\\sample.bmp";
    permission1= new FileIOPermission(Filenm,'w');
    permission1.assert();
    attachment = new System.Net.Mail.Attachment(Filenm);
    attachementCollection.Add(attachment);
    smtpClient = new System.Net.Mail.SmtpClient(SMTPServer);
    smtpClient.Send(mailmessage);
    CodeAccessPermission::revertAssert();
}

Add tables to query build datasource ,addlink,relation

noreply@blogger.com (Santosh Kumar singh) — Thu, 19 Jan 2012 23:37:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

Add tables to query build datasource ,addlink,relation

static void QBDSExample(Args _args)
{
    Query                   query;
    QueryBuildDatasource    datasource;
    ;
    query = new Query();
    // Add purchtable main datasource
    datasource = query.addDataSource(tableNum(purchtable));
    // Add child datasource "purchline"
    datasource = datasource.addDataSource(tableNum(purchline));
    // Set the join mode
    datasource.joinMode(JoinMode::InnerJoin);
     datasource.relations(false);
    datasource.addLink(fieldNum(purchtable, purchid),
        fieldNum(purchline, purchid));
    info(query.xml());
}

How to get all table ids from AOT using dynamics axapta x++ code

noreply@blogger.com (Santosh Kumar singh) — Thu, 19 Jan 2012 09:27:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to get all table ids from AOT using dynamics axapta x++ code.

//variable declaration
Dictionary dictionary1;
TableId tableId1;
;
// initialize object
dictionary1 = new Dictionary();

// set initial table id

tableId1 = dictionary.tableNext(0);

// start table id loop

while (tableId1)
{
info(int2str(tableId1));

tableId1 = dictionary1.tableNext(tableId1);
}
// end table id loop

Get record from table on the basis of field id in dynamics axapta x++

noreply@blogger.com (Santosh Kumar singh) — Thu, 19 Jan 2012 09:15:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way.

emplTable emplTable;
FieldId fieldId;
;

fieldId = fieldNum(emplTable, Emplid);

select emplTable;

info(emplTable.(fieldId));

select emplTable
where emplTable.(fieldId) == '1101';
info(emplTable.Name);

Print table data without declaring object variable of table in axapta x++

noreply@blogger.com (Santosh Kumar singh) — Thu, 19 Jan 2012 08:58:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to Print table data without declaring object variable of table

static void Job_GetDatawithouttableobject(Args _args)
{
   
    ;
 
    print (select Empltable).Name;
    pause;
}

Important blog link list of microsoft dynamics

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 11:21:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

MFP AX Blog
Microsoft Dynamics Website
Saelen Kenny AIF Blog
Santosh Paruvella AX Blog
AX Perf Blog
AxZap Technical Blog
MaheshTej AX Blog
SysDictCoder AX Blog
Dynamics AX Community
Dynamics AX Training
Kamalkannan AX Blog
AnithaSantosh AX Blog
Arijit Basu AX Blog
Dilip's AX Blog
AX Enterprise Portal Blog

axzaptech
ax-dynamics
doens
mafsarkhan
Ax Start
Vinay Singh
Vasanth Arivali
Ax Live
MS Press
SjakalAx
Issues concerning X++
Dynamics Care
Nikhil Pujar
Casper Kamal
axworld
SreeNathReddy
Kamal
Sonthosh
Zubair Ahmed
AXUG
Ax Tutorials
Ax World Blog
Ax WorkFlow
Ax Sukrut
Ax Patrik
INSTALLING HYPER-V MANAGER ON WINDOWS 7...
Ax Kranthi
MS TechNet
Ax Parthav
SumitLoya
Ax Community
Ax Tadka
Ax Training
Ax David Ferguson
Ax BRANDON GEORGE
Ax Coder
Ax David Pokluda
Ax Flemming
Ax Freak
Ax Palle Agermark
Ax Source
MSD World
Ax Daily
Ax Helper
Ax FAQ
Ax Rahul Sharma
Ax @ Yahoo Groups
Ax Fred Shen
Ax Yurii
AxaptaPedia
Ax SVEN JOCHIMSEN
Ax Harish Mohanbabu
Ax Overview
AX ENTERPRISE PORTAL TEAM BLOG
EP Solutions Monkey
AX EP Videos
AX MFP's BLog
Download Ax All Files
Ax Saveen Reddy
Upgrade Ax 3.0 to Ax 2009
EP Installation
Ax Info (Indusa)
Creating a new Number Sequence for an Existing Module
Axapta Key Features
NumberSeq(Axaptapedia)
Ax Kashperuk
SharePoint Installation
Download All (Ax,CRM,GP,SAP,Oracle,SQL,MSBI,MS Sure Step) PDFs
Ax Balbir Singh
Ax Code
Ax Recorded Webcasts
Microsoft Dynamics Tips
Ax Mohammed Rasheed
AX & SSRS Learning Roadmap
Dynamics AX Demo Videos
Channel9(Ax Videos)
Khwai(Download Ax Doc)
Dynamics Solution Finder
Ax-Blog
DeshPande
Expressions in query ranges
Ax-Greek

How to show current company lanugaue in message box in axapta

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 11:09:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to show current company lanugaue in message box in axapta

Public static void showLanguagecurrent()
{
info(infolog.language());
}

How to get day,month,year from your date variable using axapta x++

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 10:47:00 PST

Education and Entertainments Experience of knowledge Imortant Weblink collections

How to get day,month,year from your date variable using axapta x++
to Get day from date
dayOfMth(your date variable or date value)

to Get month from date
mthOfYr(your date variable or date value)

to Get year from date
year(your date variable or date value)

Create user defined mod method in axapta

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 10:41:00 PST

Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts

Create user defined mod method in axapta
There is no inbuilt function to get mod of two values to we can create our own function to get mod by following way.

real UserDefinedMod(real x, real y)
{
    ;
    return (x - ((trunc(x / y) * y)));
}

Count total number of records of query in axapta through code

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 10:36:00 PST

Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts

Count total number of records of query in axapta through code

to count record from first datasources write code in following manner.
SysQuery::countTotal(queryRun)

to count records from all attached table to query wrtie following code.
SysQuery::countLoops(queryRun)

Browse table through code in microsoft dynamics axapta x++

noreply@blogger.com (Santosh Kumar singh) — Wed, 18 Jan 2012 10:32:00 PST

Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts

Browse table through code in microsoft dynamics axapta x++

If you want to open table in axapta without touching table then you can open any table by only 2 line code which is below.

SysTableBrowser sysTableBrowser = new SysTableBrowser();
;

SysTableBrowser.run(tablenum(emplTable));

How to open executable file from dynamics axapta through code

noreply@blogger.com (Santosh Kumar singh) — Tue, 17 Jan 2012 11:43:00 PST

Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts

How to open executable file from dynamics axapta through code
If you want to open exe file from dyanmics axapta application then you can write following line in your form on any event where you want. just put following code with correct path of exe file.

WinAPI::shellExecute(path of the file);