Dynamics AX 2009 – Import Customer master,Vendor master and their Primary addresses

Shekhar Diptiman's space

The following illustration is for vendors. Similarly we can do for customers . Wherever needed I have mentioned what change would be required.To import vendors & customers in Microsoft Dynamics AX 2009, follow these steps:

1. In the Navigation Pane, click Administration>Periodic> Data export/import>Excel spreadsheets> Template Wizard.

2. In the Excel Template Wizard, follow the instructions to create a template for “VendTable”.  For customers the CustTable should be selected in the table selection step in the wizard.

When creating the template select the option to create a definition group in AX for this template.

Also select the ‘Create supporting table worksheet’. This will create the lookup values for selection in the template worksheet .

3. Ensure that the number sequence is setup for the address book Id in parameter for Global address book. Navigate to Basic>Setup>Global Address Boo

View original post 1,017 more words

Calling a form from Infolog in AX 2012

AXpedia

The SysInfoAction class provides the ability to add an action to the standard infolog. The user can then perform the action by clicking the infolog. The SysInfoAction class can be extended to perform custom actions e.g. opening a file using the default application.

Suppose my form to be open is Form2.

When I get an infolog like “This is demo of infolog”, one button should be visible on left side of clear button named as “Show” which appears in infolog.

Lets write a job showForm.

static void showForm()

{

    SysInfoAction_Formrun       infoAction = SysInfoAction_Formrun::newFormname(formStr(Form2));

    infoAction.parmDescription(“Show”);
    info(“This is demo of infolog”,””,infoAction);

}

run this job, infolog will appear with show button click on it and Form2 will get open.

🙂

View original post

How to Publish AX Reports for a specific AOS Instance

DAX Knowledge Pot

If you are running multiple instances of AX on a single environment, you have more than likely gone through the instructions as per this URL http://technet.microsoft.com/en-us/library/hh389760.aspx.

One of the steps identified in this URL talks about publishing reports using the following AX Powershell command: publish-axreports.

What isn’t perhaps obvious from the examples shown on the Deploy reports to the new Reporting Services Instance [AX 2012] page is – How do I publish reports for a specific AOS instance? (The examples shown is for the default instance)

 

When you look at the full syntax of the Publish-AxReports powershell command:

 

You will notice two optional parameters that are of interest, namely:

• ServicesAOSName
• ServicesAOSWSDLPort

 

These two parameters are used to “tell” the Publish-AXReports powershell command, which AOS to connect to when publishing reports.

The syntax used for these two parameters are as follow:

• ServicesAOSName

  This parameter contains the name…

View original post 89 more words

AX 2012 Installation SQL related error

Mono Out

Error Message:

Error text: [Microsoft][SQL Server Native Client 10.0][SQL Server]”FASTFIRSTROW” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.SQL error code: 321

Call stack:

(C)ClassesApplicationVersionfpkSlnIsvApplAll – line 20

(C)FormsSysAboutMethodsRun

OR

“Cannot select a record in Application Model (UtilElements). The SQL database has issued an error. SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]”FASTFIRSTROW” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.”

SQL statement: SELECT T1.NAME,T1.RECORDTYPE,T1.PARENTID,T1.UTILLEVEL,101090 FROM UTILELEMENTS T1 WHERE ((RECORDTYPE=?)

AND (NAME=?)) OPTION(FAST 20)

Solution:

Microsoft Dynamics AX 2012 Management Shell –

Axutil schema

Reference

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2709934#releasenote

View original post

Workflow Development Manual

Dynamics AX Workflow Wanderings

Two weeks ago now I reviewed the Installation and configuration document written by Sumit Loya for Microsoft Dynamics AX Workflow. As a followup, today I would like to mention one of the other useful sets of documentation that he has written. Namely “Workflows – Development – An easy to understand guide for creating new workflow templates in Microsoft Dynamics AX 2009”.

In this excellent document Sumit takes one through all the various artifacts and components that form a part of a Dynamics AX template, explaining why they exist and how you will be using them in your own customisations and/or creation of templates. He describes the various properties available for each component and their uses in a fair amount of depth (very handy if you’ve ever wondered what some of the more obscure properties do), providing examples as he goes.

The document also includes great sample code for the creation of…

View original post 77 more words

Dynamics AX2009 Workflow – Checklist

Shekhar Diptiman's space

 

I was going through the the workflow implementation with a client and could notice that there is a need of a check list for consultants users to configure the workflow and make it work . I have thought of the following points for the check list.

1. User options

a. Maintain the email address of the users .

b. Setup The parameters for receiving the notifications on the Notifications tab especially the two marked parameters for getting the notifications in client and or email.

 

2. Administration>Setup>Email parameters must be setup so that emails can be sent through AX.

3. Basic>Setup>Setting for workflow>settings for workflow to be used by the system to send workflow emails.

4. Configuration of the email template as identified in step 3 above. Basic>Setup>Email templates. FOr setting templates refer to the AX help file. Its a good source of information.

5.  Ensure that the batches…

View original post 162 more words

Workflow Installation Issues on 64bit Servers

Santosh Kumar Paruvella's Blog

This time when I am trying to install workflow, I have faced some issues, earlier no issues.

I want to share the same with my blog readers.

My System configuration: Windows 2008 R2 64 bit and IIS 7

I have already installed EP, for this EP, Sharepoint is running on 80 port number.

Default Web Site was in Stopped state, this was also on the same 80 port. I did not observe this and started the installation of Workflow for Dynamics Ax.

Installation is done with some warnings, I have ignored those warnings and tried to validate the URL from Ax client,  Basic  –> Setup –> Settings for workflow.

Then I have seen the following error

Error:     Error Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’.

The request failed with the error message  …….. <some HTML type string error>

Later I have observed, that

View original post 156 more words

AIF setup and installation in Dynamics Ax 2012

Dynamics Ax workshop

Hi – Today the post is about the AIF installation and setup . I found it really hard to configure when I tried to search the articles about it so Here you go. I think the whole configuration can be divided in two parts

1)Install the AIF component. Go to the installation setup of AX 2012 and run the setup.exe . From the Form select the option highlighted in the snap shot below

2)If the perquisite failed in the running the installation wizard above for the IIS web services and WCF, go the server manager and click Add Role for web server

3)Add role services by right clicking the webserver role and Check mark all the components except the FTP one. Make sure you got ASP.net checked.

4)For WCF installation, you need add feature for the web server . Click Add feature by right clicking the web server role and…

View original post 267 more words

Create Vendor by X++ code using AXVendTable

Tajwal's Blog

while i start integration between SAP E-procurement module and Dynamics AX 2009 i was trying to find standard way of Creating Vendor Details ,contact Person details, Item details  and PO  through  .Net BC to read data from SAP database and insert it into Dynamics AX database i could not find any code to help me the purpose of below post is to help those whom wants to create Vendor through code its not 100% complete code but it can give readers an idea.

static void CreateNewVendor(Args _args)

{
AxVendTable axVendTable;
AccountNum accountNum;
;
ttsbegin;
accountNum = NumberSeq::newGetNum(VendParameters::numRefVendAccount()).num();
info(accountnum);
axVendTable = new AxVendTable();
axvendTable.parmAccountNum(accountNum);
axVendTable.parmName(“Ms global tele comunications LLC”);
axVendTable.parmStreet(“Ms global tele comunications LLC Street Name”);
axVendTable.parmCurrency(CompanyInfo::find(false).CurrencyCode);
axVendTable.parmVendGroup(“10”);

axVendTable.parmLanguageId(CompanyInfo::find().LanguageId);
axVendTable.parmPartyType(DirPartyType::Organization);
axvendTable.parmAddress(“Detailed address line1”);
axVendTable.parmCountryRegionId(“AT”);
axVendTable.parmCity(“Abu dhabi city”);
axVendTable.parmPhone(“0093787693796”);
axVendTable.parmEmail(“contactname@companyname.com”);
axVendTable.parmURL(“www.companyname.com”);
// if(axVendTable.validateInput())
axVendTable.save();
ttscommit;
}

View original post

System does not support setup ‘continuous’ of number sequence

Tajwal's Blog

while i was working  on integration project to create Item code through .Net BC using VS 2008

i received below error from both client and .Net BC

NumberSeq Errpr .Net BC

Number Seq Error client

letter on resolved the problem by putting my code within the Transaction startement.

static void GetNewItemId(Args _args)
{

ItemId itemId;
;
ttsbegin;
itemId = NumberSeq::newGetNum(InventParameters::numRefItemId()).num();
ttscommit;
info(ItemId);
}

View original post