Rajdip Das - Microsoft Dynamics AX | Previously known as Axapta

Workflow configuration error in Dynamics Ax: 401 Unauthorized

2011-01-04T11:16:00.001+05:30

If you are getting an error after installing Dynamics AX Workflow: “401 Unauthorized” after running Workflow infrastructure configuration wizard (Dynamics AX –> Administration –> Setup) at the first time installation of Dynamics Ax then you should go through the following steps…. It is mainly happening when database, AOS, Application and workflow servers are individual (especially workflow & AOS and Database server)

Check AOS Service is running under an active domain user (domain\username)
Workflow website and workflow application pool are having the same .NET Business Connector user name Identity (and of course, this should be an active domain user)
You added the workflow website (http://servername:portnumber/DynamicsAXWorkflow50 for example) to the trusted sites in Internet Options of AOS server
Run the following on the Workflow server:

After checking above points and then perform the following steps

Ø Start a command prompt.

Ø Locate and then change to the directory that contains the Adsutil.vbs file. (By default, this directory is C:\Inetpub\Adminscripts.)

Ø Type the following command, and then press ENTER:

cscript adsutil.vbs set w3svc/NTAuthenticationProviders “NTLM”

Ø To verify that the NtAuthenticationProviders metabase property is set to NTLM, type the following command, and then press ENTER:

cscript adsutil.vbs get w3svc/NTAuthenticationProviders

The output:

NTAuthenticationProviders       : (STRING) "NTLM"

After completing above procedure successfully then please take a restart of Ax and IIS service and then workflow infrastructure configuration wizard will work fine.

Sending mail from workflow submit or Approve or any status in Dynamics Ax

2010-12-15T10:50:00.000+05:30

During some period we are trying to send email from Ax while a workflow is submitted, approve or reject and etc. to the employee by using standard Ax procedure. But we did not achieve full our goal by using standard procedure. After few R&Ds we found that the standard Ax provides only can send a fixed email which is defined in E-mail template. Same mail has been sent to the user in case of workflow submit or approval or reject or anything. It is a standard template which is using in Ax.
Our requirement was different mail will go as per the workflow status. I found all the information are stored in the "Event Inbox" table. So I made a batch job class with necessary procedures and it is running into batch job after very little bit of customizations.

Customization:
1. One field is added into the "EventInbox" table: TMSendEmail (EDT: NoYesId)
It would indicate email is sent or not. Once email sent then it will ticked.
2. Created a class with extends "RunBaseBatch"
It prepares the email and send while batch occurrence in called

Procedure:
1. Set email id required employees those are tagged user in workflow
2. Check the email Notification field (under Approval & Task notification group)
Administrator -> User -> User Option -> Notification (Tab)

Operations:
1. Find the class xpo and import it. Change the necessaries as per your requirements.
2. Run the class -> a dialog will open -> Select Batch Process -> click Recurrence
3. Set no "No End Date" and set recurring pattern to Minute in "1" under count filed
4. Click Ok to back
5. Put a caption and select a batch group from the Batch Group field then press OK.
Class automatically fall into batch job and it will call 1 every minute. You can find the batch job under Basic -> Enquiries -> Batch Job.
Here while the batch is call called then run method of class would call and corresponding methods will be executed.

Sending of mail to the user is depends upon the workflow configuration. Body, Subject, users all are to be set into the configuration.

I made it in this way if anyone have any idea or comment or suggestions then please don’t forget to share with me.

Enable workflow in a Dynamics Ax webpart (EP)

2010-12-13T12:10:00.003+05:30

First create a new dynamics webpart in .net. Need to perform few steps to enable the workflow in the required webpart.

a. Register workflow control in webpart.

<%@ Register Assembly="Microsoft.Dynamics.Framework.Portal, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

Namespace="Microsoft.Dynamics.Framework.Portal.UI.WebControls.Workflow" TagPrefix="dynamics" %>

b. Add workflow control in webpart (place the code after datasource).

<dynamics:AxWorkflowActionBar ID="WorkflowActionBar" runat="server" DataSourceID="AxDataSource1" DataMember="{TableName}_Current" />

C. Under Editor, call the following namespace

using Microsoft.Dynamics.Framework.Portal.UI.WebControls.Workflow;

d. Create the following method for calling CanSubmitToWorkflow method by using Proxy.

void WorkflowActionBar_EvaluatingCanSubmitToWorkflow(object sender, EvaluatingCanSubmitToWorkflowEventArgs e)

{

Boolean canSubmit;

IAxaptaRecordAdapter record = e.DocumentRecord;

ApplicationProxy.TM_PolicyMaster policyMaster = new ApplicationProxy.PolicyMaster(this.AxSession.AxaptaAdapter, record);

canSubmit = (Boolean)policyMaster.canSubmitToWorkflow();

e.CanSubmitToWorkflow = canSubmit;

}

(Note: Here PolicyMaster the Ax Table and canSubmitToWorkflow method is under the table and it is defined in proxy also. It returns boolean)

e. Create or update the page init method in webpart editor with following code

void Page_Init(object sender, EventArgs e

{

this.WorkflowActionBar.EvaluatingCanSubmitToWorkflow += new EventHandler<EvaluatingCanSubmitToWorkflowEventArgs>(WorkflowActionBar_EvaluatingCanSubmitToWorkflow);

}

f. Create three WebActionMenuItems in DAX with EPWorkflowWorkItemActionManager class.

Set label: Web Approve, Web Reject and Web request to Change

Set Run On = Called from

g. Create another two WebActionMenuItems in DAX with your created Submit class.

Set label: Web Submit and Web Re-submit.

h. Modify Submit class for Submitting workflow.

DialogOk, init and reSubmit method

Figure 1: DialogOK() of submit class, write this code after menuIten calls. Here “EP_PolicySubmit” and “EP_PolicyReSubmit” are the WebActionMenuItem of EPWorkflowWorkItemActionManager.

Figure 2: Init() method of submit class: Add the highlighted line with your web policy submit menuItem name

Figure 3: ReSubmit method of submit class: Add the highlighted line with your web policy Re-Submit menuItem name

i.       Now set the webmenuItems in different places….
       a.       Web Submit: Workflow Template (Properties) -> submitToWorkflowWebMenuItem
         b.      Web Re-Submit: Workflow Approval (Properties) -> ReSubmitWebMenuItem
         c.       Web Approve: Workflow Approval ->Outcomes->Approve (Propeties) -> ActionWebMenuItem
        d.      Web Reject: Workflow Approval ->Outcomes->Reject (Propeties) -> ActionWebMenuItem
        e.      Web Req. to Change: Workflow Approval ->Outcomes-> RequestChange (Propeties) -> ActionWebMenuItem

And now workflow is ready for web. Please reset the IIS and Refresh AOD from EP before the submit of Workflow.

Microsoft Dynamics AX 6.0 (2011) New X++ Editor

2010-06-21T16:55:00.001+05:30

Good news for all DAX developers.... DAX 2011/6.0 has introduced new and interesting features in X++ editors. I have found a very helpful & interesting video regarding X++ editor in YouTube. Features are very nice and also very useful for the developer. I am sharing with you. Please click and see the bellow video....

..... :)

Installation Problem (Connectivity) of Dynamics Ax 2009 with Oracle 10g R2

2010-02-24T12:16:00.009+05:30

Few days earlier I was involving a problem of connectivity of Dynamics Ax 2009 with Oracle 10g database during installation. After lots of fights we've managed finally to get started up and running Axapta 2009. Recently I noticed many people are facing same kind of problem like me. It is not a complex procedure but some tricks over there. I found some tricks those I am publishing.

1. After completing Oracle 10g installation ensure Oracle services (Listner, database, Oracle service and SQL Plus) are running under local services

2. Open SQL Plus for checking Oracle is running successfully or not. ( Common error basically came as “Insufficient Shared Memory”)

If not running Oracle Plus then please hold a moment and then try to run Oracle SQL Plus again. (Cause after installing Oracle takes some times to initialize/configure the Oracle Shared Memory)

“Setup could not connect to the Database Server “DataSource = ****; Integrated Security = Yes” is the common barrier during installation of Ax with Oracle 10g.
This bellow mentioned process might be helpful to some extend for smooth installation.

Add AOS user (administrator) into Oracle 10g Administrative Assistance area and add also the “Domain Admins” if not present there. Here the path....

Here the area where you have to add user

Note: Another problem may happen AOS is not starting for the first time after building all the index files. If you face then nothing to worry, change the Dynamics Ax Server Service from NetworkService Account to Domain\Administrator Account and then start the service again and little while after service will show “Started”.

*** Apart form above procedure many procedures to be maintained during Oracle installation for Ax 2009. All the procedure are available in the Installation guide. Please read deeply the Installation guide of dynamics Ax with Oracle 10g (provided by Microsoft) before installing.

***I think above procedure is to avoid obstruction of installation but I may be wrong or right to some extend. Please leave me your comment or any information or missing information regarding this topic.

UTCDateTime field Query Range by Date in Dynamics Ax

2010-02-23T15:25:00.000+05:30

static void RAJ_UTCDateTimeQueryRange(Args _args)
{
Query q = new Query();
QueryRun qr;
QueryBuildDataSource qbds;
CustTable custTable;
Transdate tmpCreatedDate = 02\02\2010; // dd-mm-yyyy

;

qbds = q.addDataSource(tableNum(CustTable));
qbds.addRange(fieldNum(CustTable, CreatedDateTime)).value(date2StrUsr(tmpCreatedDate));

qr = new QueryRun(q);

while(qr.next())
{
custTable = qr.get(tableNum(CustTable));

info(strfmt("Account Num: %1, Name: %2", custTable.AccountNum, custTable.Name));
}
}

Conversion of UTCDateTime in Dynamics AX 2009

2010-02-09T13:13:00.001+05:30

Recently I have faced a problem of conversion from UTCDateTime variable. I searched everywhere blogs, msdn & finally got result.I am really thankfull for www.axaptapedia.com/UtcDateTime blog for the refference. This job is indicating converting from UTCDateTime to seperate variables as well as seperate variables to UTCDateTime variable.

public static void RAJ_UTCDateTimeConversion()
{
UTCDateTime dateTime;
date tmpDate;
TimeOfDay tmpTime;
CustTable cTable = CustTable::find("1101");
;

// Extracted date & Time from UTCDateTime datatype to individulal variable
dateTime = cTable.createdDateTime;

tmpDate = DateTimeUtil::date(dateTime);
tmpTime = DateTimeUtil::time(DateTimeUtil::applyTimeZoneOffset(dateTime, DateTimeUtil::getUserPreferredTimeZone()));

info(strfmt("Date: %1 and Time: %2.", tmpDate, time2str(tmpTime,1,2)));

// assign UTCDateTime varriable by using two individual field
dateTime = DateTimeUtil::newDateTime(12\05\2010, timeNow());
info(strfmt("UTCDateTime: %1.",dateTime));
}

Adding new Finance Dimension in Axapta 2009

2010-02-05T11:21:00.010+05:30

A wizard is available in Dynamics Ax 2009 for creating Finance Dimension. Its a very easy process. It is not a sequence of processes like 3.0. It is a wizard just write the Name & Label and then dimension creation has been completed. All internal processes are done by Axapta itself internally. Here some screenshots of creating a new dimension.

Fig 1: Path of Wizard

Fig 2: Input for Dimension
Place here Dimension Name, Dimension Caption.

Fig 3: Finish to complete Process

Note: Synchronize the database and restart the service after completing above procedure.
Finance Dimension up-gradation is depend upon license
Please do not try in Live application directly. Take a back up & implement in test environment at first.

"Like" with "AND" Operator through Query in Dynamics Ax

2010-02-01T19:15:00.004+05:30

static void RAJ_AndLikeOperator(Args _args)
{
Query query = new Query();
QueryRun queryRun;
InventTable inventTable;
;

query.addDataSource(tableNum(InventTable)).addRange(fieldNum(InventTable, ItemId)).value("100*, 110*, 120*");
queryRun = new QueryRun(query);
while(queryRun.next())
{
inventTable = queryRun.get(tableNum(InventTable));
info(inventTable.ItemId);
}
}

"Not Like and Like" Operator in Dynamics AX

2010-01-28T15:45:00.008+05:30

Use of "Not Like and Like" operator through Dynamics Ax Query.

static void RAJ_LikeNotLikeOperator(Args _args)
{
Query query = new Query();
QueryRun queryRun;
InventTable inventTable;
;

query.addDataSource(tableNum(InventTable)).addRange(fieldNum(InventTable, ItemId)).value("100*"); // Like operator
// query.addDataSource(tableNum(InventTable)).addRange(fieldNum(InventTable, ItemId)).value("!100*"); // Not Like Operator
queryRun = new QueryRun(query);
while(queryRun.next())
{
inventTable = queryRun.get(tableNum(InventTable));
info(inventTable.ItemId);
}
}

EDT Finds with String Length Value

2010-01-28T15:11:00.007+05:30

During X++ development I think finding a EDT with a specific String Size is a huge problem. Initially we are trying to find but after we create a new one EDT. For this reason .aod size is increasing day to day to some extend. I listed down a job which helps you to find out proper String EDT by giving our String Length value. A list will come into excel in your PC.

static void Raj_EDTfind(Args _args)
{
Dictionary dict;
DictType dictType;
TreeNode treeNode = TreeNode::findNode("Data Dictionary\\Extended Data Types\\ABCModelType");

#AviFiles
sysExcelApplication excel;
SysExcelWorkbooks books;
SysExcelWorkbook book;
SysExcelWorkSheets sheets;
SysExcelWorkSheet sheet;
com com;
Integer row = 2;

Dialog d = new Dialog("Input Box");
DialogField dfStrValue;
Integer tmpStringLen = 0;

SysOperationProgress progress = new SysOperationProgress();
;

// Dialog initialised and accept value and asign
dfStrValue = d.addField(typeId(Integer),"Enter EDT String Length");
if(!d.run())
return;

tmpStringLen = dfStrValue.value();

if(!tmpStringLen)
throw error("Plaese Enter Valid Number.");

// Excel Object initialisations
excel = sysExcelApplication::construct();
books = excel.workbooks();
book = books.add();
sheets = excel.worksheets();
sheet = sheets.itemFromNum(1);
com = sheet.comObject();

// Heading Initialisations
sheet.cells().item(2,1).value("EDT Name");
sheet.cells().item(2,5).value("Label");

// Progress Bar Initialisations
progress.setCaption("Generating Lines");
progress.setAnimation(#AviTransfer);
progress.setTotal(500);

// loop for searching EDTs
while(treeNode)
{
dict = new Dictionary();
dictType = dict.typeObject(dict.typeName2Id(treeNode.treeNodeName()));

if(dictType.stringLen() == tmpStringLen)
{
row++;
sheet.cells().item(row,1).value(treeNode.treeNodeName());
sheet.cells().item(row,5).value(dictType.label());

progress.setText(strfmt('Copying EDT %1.', treeNode.treeNodeName()));
progress.setCount(row);
}

treeNode = treeNode.AOTnextSibling();
}

sheet.cells().item(1,1).value(strfmt("Found EDT: %1.", row)); // Count & Print for Filtered EDT

box::info(strfmt("Total EDT Found: %1.", row), "Information");
excel.visible(true);
}

Simple code for retriving a Number from Number Sequence

2009-09-03T11:51:00.002+05:30

static void RAJ_retriveNumSeq(Args _args)
{
NumberSeq numberSeq;
str tmpNum;
;

numberSeq = numberSeq::newGetNumFromCode("Num_Seq_Code"); // place here num seq code
tmpNum = numberSeq.num();

info(tmpNum);
}

Excel Export from Axapta (through code)

2009-07-10T13:53:00.004+05:30

Excel import/export plays a very important role in DAX. This is a simple code of Excel Export. This job represents the creation of excel file along with customer data (two fields). :)

static void Raj_WriteIntoExcel(Args _args)
{
#AviFiles
sysExcelApplication excel;
SysExcelWorkbooks books;
SysExcelWorkbook book;
SysExcelWorkSheets sheets;
SysExcelWorkSheet sheet;
com com;
CustTable custTable;
Integer row = 1, totRecord;
SysOperationProgress progress = new SysOperationProgress();

;

select count(RecId) from custTable;
totRecord = custTable.RecId;

excel = sysExcelApplication::construct();
books = excel.workbooks();
book = books.add();
sheets = excel.worksheets();
sheet = sheets.itemFromNum(1);
com = sheet.comObject();

sheet.cells().item(1,1).value("Customer Id");
sheet.cells().item(1,2).value("Customer Name");

progress.setCaption("Exporting Customer");
progress.setAnimation(#AviTransfer);
progress.setTotal(totRecord);

while select custTable
{
row++;
sheet.cells().item(row,1).value(custTable.AccountNum);
sheet.cells().item(row,2).value(custTable.Name);
progress.setText(strfmt('Exporting Customer %1.', custTable.AccountNum));
progress.setCount(row,row);
}

excel.visible(true);
}

Code for Excel import by choosing file in Axapta

2009-07-04T14:51:00.007+05:30

This is a very useful code for importing excel into DAX table. Developer can add/modify their logics while importing excel into DAX table. This is a simple and compact code. Developers have to change this code as per their requirements.
Note: Here excel file will be 3 columns, 1. Vendor Code, 2. vendor Group and 3. vendor Currency. You can add or less fields in excel but same incorporation should be done in this job (bold area). While you incorporate this type of procedure then I recommend to all do this code into a class instead of job.

static void Raj_ExcelUploadByFile(Args _args)
{
#AviFiles
FilenameOpen filename;
dialogField dialogFilename;
Dialog dialog= new Dialog("Excel Upoad");
Container vendCont[];

int rowIdx;
Counter linesImported;
int lastRow;
boolean ok = true;
str c1,c2,c3;
str input;

SysExcelApplication application;
SysExcelWorkBooks workBooks;
SysExcelWorkSheets workSheets;
SysExcelWorkSheet workSheet;
SysExcelCells cells;
SysOperationProgress progress;

#define.CurrentVersion(1)
#localmacro.CurrentList
filename
#endmacro

#Excel
#define.Star('*')
#define.Space(' ')

// convert into str from excel cell value
str COMVariant2Str(COMVariant _cv, int _decimals = 0, int _characters = 0, int _separator1 = 0, int _separator2 = 0)
{
switch (_cv.variantType())
{
case (COMVariantType::VT_BSTR):
return _cv.bStr();

case (COMVariantType::VT_R4):
return num2str(_cv.float(),_characters,_decimals,_separator1,_separator2);

case (COMVariantType::VT_R8):
return num2str(_cv.double(),_characters,_decimals,_separator1,_separator2);

case (COMVariantType::VT_DECIMAL):
return num2str(_cv.decimal(),_characters,_decimals,_separator1,_separator2);

case (COMVariantType::VT_DATE):
return date2str(_cv.date(),123,2,1,2,1,4);

case (COMVariantType::VT_EMPTY):
return "";

default:
throw error(strfmt("@SYS26908", _cv.variantType()));
}
return "";
}

// Find last row from excel

int findLastRow(SysExcelWorkSheet _workSheet)
{
SysExcelRange range;
;

range = _workSheet.cells().range(#ExcelTotalRange);

try
{
// Finds the row where the first contents is found.
range = range.find(#Star, null, #xlFormulas, #xlWhole, #xlByRows, #xlPrevious);
}
catch (Exception::Error)
{
error("@SYS59926");
return 0;
}

if (range)
{
return range.row();
}
else
{
return 0;
}
}

;

dialogFilename = dialog.addField(typeId(FilenameOpen));
dialog.filenameLookupFilter(["@SYS28576",#XLS]);
dialog.filenameLookupTitle("Upload from Excel");
dialogFilename.value(filename);

if(!dialog.run())
return;

filename = dialogFilename.value();

ttsbegin;

application = SysExcelApplication::construct();
workBooks = application.workbooks();
workBooks.open(filename,0,true);

workSheets = workBooks.item(1).worksheets();
// this.importExcel("Sheet1");

input = "Sheet1";
workSheet = workSheets.itemFromName(input);
cells = workSheet.cells();
lastRow = findLastRow(workSheet);
rowIdx = 1;

progress = new SysOperationProgress();
progress.setCaption("Vendor Importing");
progress.setTotal(lastRow);
progress.setAnimation(#AviTransfer);
setprefix("Vendor Import");

while (rowIdx < lastRow)
{
rowIdx++;
setPrefix(strfmt("Excel Row: %1", rowIdx));

c1 = COMVariant2Str(cells.item(rowIdx,1).value()); //Vendor Account in excel asigning value into dax variable
c2 = COMVariant2Str(cells.item(rowIdx,2).value()); //vendor Group
c3 = COMVariant2Str(cells.item(rowIdx,3).value()); // vendor Currency

linesImported++;
vendCont[linesImported] = conins(vendCont[linesImported] , 1 ,c1, c2, c3); // records inserted into container

progress.setText("Importing " + c1);
progress.setCount(linesImported);
}

for(rowIdx = 1 ; rowIdx <= linesImported; rowIdx++) // for display
{
info(strfmt("Vendor Code: %1, Name: %2, Group: %3.", conpeek(vendCont[rowIdx], 1),conpeek(vendCont[rowIdx], 2), conpeek(vendCont[rowIdx], 3)));
}

application.quit();
application = null;

ttscommit;
}

How to display total number pages in a report like 5 of 100 in AX?

2009-03-17T13:52:00.000+05:30

Here 100 is the total pages of report and 5 indicating the current / active page of the report.

Its a very simple. In any section of report create two integer control.

For Page Number: go to propety of the a integer control and set DataMethod property with "Page".
For Total Number Pages: go to propety of the another integer control and set DataMethod property with "PagesTotal".

Run the report and see the effect.... :)

Form Run(Open) through code

2009-03-03T14:20:00.000+05:30

void clicked() // Button of a form it is optional
{
Args args;
FormRun formRun;
;
super(); // will be comment in case of MenuItemButton includes MenuItemName

args = new Args(formstr(FormName));

args.record(DataSourceTable); // as argument is optional
args.parm(Text); // Text Argument is optional

formRun = classFactory.FromRunClass(args);
formRun.init();
formRun.run();
formRun.wait();
formRun.detach();
table_ds.refresh(); // Refreshing parent table DataSourceTable
table_ds.executeQuery(); // Refreshing Parent DataSourceTable Query
}

Open table or browse from editor code

2009-03-03T13:26:00.000+05:30

Many times Developer needs to open the table or browse while coding. Developer has to go to AOT then search for that table. To ease of this situation by following code developer can easily open the table or browse from Editor windows itself.

It is applicable when you write code into an editor then select table Name (Not the buffer) and then right click -> script -> Rajdip, you will find your created menu here....

Copy paste the following methods in EditorScript Class of axapta
//------------------------

// FOR OPEN TABLE
void Rajdip_OpenTable(Editor e)
{

#AOT
TreeNode tr;
XInfo xInfo = new xInfo();
str selection;
;
selection= strltrim((strrtrim(Editorscripts::Raj_getSelectedText_n(e)))); // modified standard method getSelectedText
tr = TreeNode::findNode(#TablesPath + '\\'+selection);
if(tr)
tr.AOTnewWindow();
else
Throw error(strfmt("Table %1 not found",selection));

return;

}

// FOR BROWSING TABLE

void Rajdip_BrowseTable(Editor e)
{

#AOT
TreeNode tr;
TableId TableId;
XInfo xInfo = new xInfo();
str selection;
SysTableBrowser SysTableBrowser;
;
selection = strltrim((strrtrim(Editorscripts::Raj_getSelectedText_n(e)))); // modified standard method getSelectedText
tr = TreeNode::findNode(#TablesPath + '\\'+selection);
if(tr)
{
TableId = tablename2id(selection);
if(TableId)
new SysTableBrowser().run(tableID);
}
else
throw error(strfmt("Table %1 not found",selection));

return;

}

// FOR Selecting Text

static str Raj_getSelectedText_n(Editor e)
{
int i;
str text;
str line;
int startLine = e.selectionStartLine()+1;
int endLine = e.selectionEndLine()+1;
int startCol = e.selectionStartCol();
int endCol = e.selectionEndCol();

if (startLine == endLine && startCol == endCol)
{
e.firstLine();
while (e.moreLines())
{
text += e.getLine();
e.nextLine();
}
}
else
{
e.firstSelectedLine();
for (i = startLine; i <= endLine; i++)
{
line = e.getLine();
if (i == startLine && i == endLine)
{
line = substr(line, startcol, endCol-startCol);
}
else
if (i == endLine)
{
line = substr(line, 1, endCol-1);
}
else
if (i == startLine)
{
line = strrep(' ', startCol-1)+substr(line, startCol, strlen(line));
}

text += line;
e.nextSelectedLine();
}
}
return text;
}

[Note: You can also open Report, EDT, Base Enum, Form by using this function with a small change i.e.
tr = TreeNode::findNode(#TablesPath + '\\'+selection);
Bold word will be changed, please follow up the "Macro->AOT", & then replace the TablePath with "ClassesPath or FormsPath, etc.]

Show all the Forms Name into a StringEdit Control as a look up

2009-03-03T13:17:00.000+05:30

Set the EDT Property = "formName" under a StringControl property.

XML Export in Axapta [Simple Code]

2009-01-30T13:50:00.000+05:30

static void RAJ_XMLWrite(Args _args)
{
XMLDocument xmlDoc = XMLDocument::newBlank();
XMLNode rootNode;
XMLNode NodeEmpl, NodeName, NodeAddr;
XMLElement xmlElement;
XMLText xmlText;
CustTable custTable;
int i;
;
// Create first line containing version info
rootNode = xmlDoc.documentElement();
xmlElement = xmlDoc.createElement("CustTable");
rootNode = xmlDoc.appendChild(xmlElement);
while select custTable order by recId
{
// Create a node for the CustTable record
xmlElement = xmlDoc.createElement("Customer");
NodeEmpl = rootNode.appendChild(xmlElement);
// Create a node for the name
xmlElement = xmlDoc.createElement("CustomerId");
NodeName = NodeEmpl.appendChild(xmlElement);
xmlText = xmlDoc.createTextNode(custTable.AccountNum);
NodeName.appendChild(xmlText);
// Create a node for the Name
xmlElement = xmlDoc.createElement("CustName");
NodeAddr = NodeEmpl.appendChild(xmlElement);
xmlText = xmlDoc.createTextNode(custTable.Name);
NodeAddr.appendChild(xmlText);
i++;
print i;
}
// Save the file
xmldoc.save('e:\\CustTable_XML.xml');
}

Auto Posting of Ledger Journal in AX

2009-01-13T18:23:00.000+05:30

The tables used are LedgerJournalName, LedgerJournalTable, and LedgerJournalTrans.
The steps are:
• Create a journal table record {Table\LedgerJournalTable}
• Create lines for each transaction to be posted {Table\LedgerJournalTrans}.
• Post the journal. {Classes\LedgerJournalCheckPost}

Sample Code:

class Raj_LedgerJournal
{
LedgerJournalName ledgerJournalName;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans ledgerJournalTrans;
LedgerJournalCheckPost ledgerJournalCheckPost;
NumberSeq numberSeq;

LedgerJournalType journalType;

}

void JournalParameters()
{
str retStr;
;

retStr = this.PostingJournal("Cust_Daily","INR","900120",5000,"900110");
}

str PostingJournal(JournalNameId _JournalName, str _CurrencyCode, str _AccountNum, AmountMST _amount, str _offset)
{
#AviFiles
SysOperationProgress _progress;
str returnStr;
int i;
LineNum lineNum;
Amount amountMST;
;

amountMST = _amount;

/******** Progress Bar ********************************/

_progress = new SysOperationProgress();
_progress.setCaption("Posting");

_progress.setTotal(2);
_progress.setAnimation(#AviTransfer);

/******************** End Progress Bar ***********************/

/*********************** Creating Journal ************************/

ttsbegin;
select firstonly ledgerjournalName where ledgerJournalName.JournalName == _JournalName;
ledgerJournalTable.JournalName = LedgerJournalName.JournalName;
ledgerJournalTable.initFromLedgerJournalName();
// ledgerJournalTable.Name = "Rajdip Journal Description";
ledgerJournalTable.insert();

info(ledgerJournalTable.JournalNum);

/************************ End Creating Journal ****************************/

/************************* Creating Lines for Journal *************************/

numberSeq = NumberSeq::newGetVoucherFromCode(ledgerJournalName.VoucherSeries);
ledgerJournalTrans.voucher = numberSeq.voucher();

++lineNum;

ledgerJournalTrans.LineNum = lineNum;
ledgerJournalTrans.JournalNum = ledgerJournalTable.JournalNum;
ledgerJournalTrans.currencyCode = _CurrencyCode;
ledgerJournalTrans.ExchRate = Currency::exchRate(ledgerJournalTrans.currencyCode);
ledgerJournalTrans.AccountNum = _AccountNum;
ledgerJournalTrans.Dimension[1]= "Kolkata";
ledgerJournalTrans.AccountType = LedgerJournalACType::Ledger;

if(amountMST > 0)
ledgerJournalTrans.AmountCurDebit = amountMST;
else
ledgerJournalTrans.AmountCurCredit = -(amountMST);

ledgerJournalTrans.TransDate = today();
ledgerJOurnalTrans.Txt = 'Rajdip Das Ledger Post Demo';

ledgerJournalTrans.OffsetAccountType = LedgerJournalACType::Ledger;
ledgerJournalTrans.OffsetAccount = _offset;
ledgerJournalTrans.insert();
returnStr = ledgerJournalTable.JournalNum;

/************************* End Creating Lines for Journal *************************/

ledgerJournalCheckPost = ledgerJournalCheckPost::newLedgerJournalTable(ledgerJournalTable,NoYes::Yes);

_progress.setText(ledgerJournalTrans.voucher);

ledgerJournalCheckPost.run();
returnStr += ' please verify from AX.';
ttscommit;

return returnStr;
}

Static void main(Args a)
{
Raj_LedgerJournal ledgerJournal;
;

ledgerJournal = new Raj_LedgerJournal();

ledgerJournal.JournalParameters();
}

Brief Idea about Enterprise resource planning (ERP)

2008-11-17T13:22:00.000+05:30

Enterprise resource planning (ERP) systems attempt to integrate several data sources and processes of an organization into a unified system. A typical ERP system will use multiple components of computer software and hardware to achieve the integration. A key ingredient of most ERP systems is the use of a unified database to store data for the various system modules.
Some organizations — typically those with sufficient in-house IT skills to integrate multiple software products — choose to implement only portions of an ERP system and develop an external interface to other ERP or stand-alone systems for their other application needs.
The two key components of an ERP system are a common database and a modular software design. A common database is the system that allows every department of a company to store and retrieve information in real-time. Using a common database allows information to be more reliable, accessible, and easily shared. Furthermore, a modular software design is a variety of programs that can be added on an individual basis to improve the efficiency of the business. This improves the business by adding functionality, mixing and matching programs from different vendors, and allowing the company to choose which modules to implement. These modular software designs link into the common database, so that all of the information between the departments is accessible and real-time.

Best Practices of ERP

2008-11-17T13:21:00.001+05:30

Best Practices were also a benefit of implementing an ERP system. When implementing an ERP system, organizations essentially had to choose between customizing the software or modifying their business processes to the “Best Practice” function delivered in the vanilla version of the software.

Typically, the delivery of best practice applies more usefully to large organizations and especially where there is a compliance requirement such as IFRS, Sarbanes-Oxley or Basel II, or where the process is a commodity such as electronic funds transfer.
This is because the procedure of capturing and reporting legislative or commodity content can be readily codified within the ERP software, and then replicated with confidence across multiple businesses who have the same business requirement.

Where such a compliance or commodity requirement does not underpin the business process, it can be argued that determining and applying a Best Practice actually erodes competitive advantage by homogenizing the business as compared to everyone else in the industry sector.

Implementation of ERP

2008-11-17T13:20:00.001+05:30

Because of their wide scope of application within a business, ERP software systems are typically complex and usually impose significant changes on staff work practices.[citation needed] Implementing ERP software is typically not an “in-house” skill, so even smaller projects are more cost effective if specialist ERP implementation consultants are employed.[citation needed] The length of time to implement an ERP system depends on the size of the business, the scope of the change and willingness of the customer to take ownership for the project.[citation needed] A small project (e.g., a company of less than 100 staff) may be planned and delivered within 3-9 months; however, a large, multi-site or multi-country implementation may take years.[citation needed]

To implement ERP systems, companies often seek the help of an ERP vendor or of third-party consulting companies. These firms typically provide three areas of professional services: consulting, customization and support.

Data migration is one of the most important activities in determining the success of an ERP implementation. Since many decisions must be made before migration, a significant amount of planning must occur. Unfortunately, data migration is the last activity before the production phase of an ERP implementation, and therefore receives minimal attention due to time constraints.
The following are steps of a data migration strategy that can help with the success of an ERP implementation:

1. Identifying the data to be migrated
2. Determining the timing of data migration
3. Generating the data templates
4. Freezing the tools for data migration
5. Deciding on migration related setups
6. Deciding on data archiving

Configuration of ERP

2008-11-17T13:19:00.001+05:30

Configuring an ERP system is largely a matter of balancing the way you want the system to work with the way the system lets you work. Begin by deciding which modules to install, then adjust the system using configuration tables to achieve the best possible fit in working with your company’s processes.

Modules - Most systems are modular simply for the flexibility of implementing some functions but not others. Some common modules, such as finance and accounting are adopted by nearly all companies implementing enterprise systems; others however
such as human resource management are not needed by some companies and therefore not adopted. A service company for example will not likely need a module for manufacturing. Other times companies will not adopt a module because they already have their own proprietary system they believe to be superior. Generally speaking the greater number of modules selected, the greater the integration benefits, but also the increase in costs, risks and changes involved.

Configuration Tables – A configuration table enables a company to tailor a particular aspect of the system to the way it chooses to do business. For example, an organization can select the type of inventory accounting – FIFO or LIFO – it will employ or whether it wants to recognize revenue by geographical unit, product line, or distribution channel.

So what happens when the options the system allows just aren’t good enough? At this point a company has two choices, both of which are not ideal. It can re-write some of the enterprise system’s code, or it can continue to use an existing system and build interfaces between it and the new enterprise system. Both options will add time and cost to the implementation process.
Additionally they can dilute the system’s integration benefits. The more customized the system becomes the less possible seamless communication becomes between suppliers and customers.

Advantages of ERP

2008-11-17T13:17:00.001+05:30

In the absence of an ERP system, a large manufacturer may find itself with many software applications that do not talk to each other and do not effectively interface. Tasks that need to interface with one another may involve:

* design engineering (how to best make the product)
* order tracking from acceptance through fulfillment
* the revenue cycle from invoice through cash receipt
* managing interdependencies of complex Bill of Materials
* tracking the 3-way match between Purchase orders (what was ordered), Inventory receipts (what arrived), and Costing (what the vendor invoiced)
* the Accounting for all of these tasks, tracking the Revenue, Cost and Profit on a granular level.

Change how a product is made, in the engineering details, and that is how it will now be made. Effective dates can be used to control when the switch over will occur from an old version to the next one, both the date that some ingredients go into effect, and date that some are discontinued. Part of the change can include labeling to identify version numbers.

Some security features are included within an ERP system to protect against both outsider crime, such as industrial espionage, and insider crime, such as embezzlement. A data tampering scenario might involve a disgruntled employee intentionally modifying prices to below the breakeven point in order to attempt to take down the company, or other sabotage. ERP systems typically provide functionality for implementing internal controls to prevent actions of this kind. ERP vendors are also moving toward better integration with other kinds of information security tools.

Problems with ERP systems are mainly due to inadequate investment in ongoing training for involved personnel, including those implementing and testing changes, as well as a lack of corporate policy protecting the integrity of the data in the ERP systems and how it is used.

Disadvantages of an ERP

2008-11-17T13:15:00.001+05:30

Customization of the ERP software is limited.
Re-engineering of business processes to fit the “industry standard” prescribed by the ERP system may lead to a loss of competitive advantage.

* ERP systems can be very expensive leading to a new category of “ERP light” solutions
* ERPs are often seen as too rigid and too difficult to adapt to the specific workflow and business process of some companies—this is cited as one of the main causes of their failure.

* Many of the integrated links need high accuracy in other applications to work effectively. A company can achieve minimum standards, then over time “dirty data” will reduce the reliability of some applications.
* Once a system is established, switching costs are very high for any one of the partners (reducing flexibility and strategic control at the corporate level).
* The blurring of company boundaries can cause problems in accountability, lines of responsibility, and employee morale.
* Resistance in sharing sensitive internal information between departments can reduce the effectiveness of the software.
* Some large organizations may have multiple departments with separate, independent resources, missions, chains-of-command, etc, and consolidation into a single enterprise may yield limited benefits.
* The system may be too complex measured against the actual needs of the customer.

Microsoft Dynamics AX

2008-09-17T15:52:00.002+05:30

Microsoft Dynamics AX is a comprehensive business management solution for mid-sized and larger organizations that works like and with familiar Microsoft software to help your people improve productivity. Microsoft Dynamics AX is built to make it easy to do business across locations and countries by consolidating and standardizing processes, providing visibility across your organization, and help in simplifying compliance. With Microsoft Dynamics AX, you can be confident your business management solution is, and will continue to be, relevant to the needs of your people and the demands of your industry and business.