Thursday, August 07, 2014

Advanced Bank Reconciliation in Ax 2012 R2

Hi,

       In Microsoft Dynamics AX 2012 R2, we can import electronic bank statements and reconcile the imported bank statements with bank documents.

Microsoft whitepaper is available to download


Thanks & Regards
Naresh.D

Saturday, June 21, 2014

Information on Dynamics AX 2012 R2 Hardware Sizing

Information on Dynamics AX 2012 R2 Hardware Sizing

HI,
      I found this information on Dynamics AX Support blog and thought it might interest you.

Read more here about the hardware sizing guide for AX 2012 R2

http://blogs.msdn.com/b/axsupport/archive/2014/05/30/ms-dynamics-ax-2012-r2-hardware-sizing.aspx

Microsoft Dynamics AX Web Search tool

Microsoft Dynamics AX Web Search tool  is now available ...

Use the Microsoft Dynamics AX WebSearch tool to search for Microsoft Dynamics AX content.


DP.exe has stopped working with Ax 2012 R3

when importing Demo data with the help of Test Transfer tool you may  get the following error


DP has Stopped working.

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3

“Unhandled Exception: System.UnauthorizedAccessException: Access to the path ‘C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\DP Log.xml’ is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, I
nt32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions o
ptions, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolea
n useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Xml.XmlWriterSettings.CreateWriter(String outputFileName)
at System.Xml.Linq.XDocument.Save(String fileName, SaveOptions options)
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 182
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82

Solution : All programs-->cmd--> right click-->Run as Administrator  and execute the above command it will work.

To download demo data, check my previous post

D

Ax 2012 R3 demo data & Test data Transfer Tool download

The contoso demo data for Dynamics Ax 2012 R3 is different from previous version.we used .dat file to load demo data in previous versions. Demo data is available in .exe file.
i.e DynamicsAX2012R3DemoData.exe available in partner Resource.

 Download Ax 2012 R3 demo data


To import this demo data we need  Test Data transfer Tool is available on partner resource.
Go on following link

To import demo data we need to do the following steps.

Step 1:
  • Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.
Step1
  • The output folder will contain the files of following extension types:
  1. .OUT—– data file that contains metadata for AX transactional database
  2. .OutModel —- data file that contain metadata for AX model database
  3. .XML —- data file that contains AX table data.
Step 2:
 Run the Test Data Transfer Tool.Exe file to install the utility.
zb2
  • After successful installation, the folder will look like as shown below:
zb3
Step 3 :
  • Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)
zb4
  • On successful import a job will be created as shown below:
zb5
Step 4:
  • Run the job <MetadataXMLGenerator(usr)>, a  meta data file will be generated and the path will be displayed in the infolog as shown in the snapshot below:
zb6
Step 5:
Copy the metadata file from the above path and paste it in [lists] folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file.

Step 6 :
Stop MS Dynamics AX service.

Step 7 :
Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).

Step 8:
  • Run the following command:
Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3
C:\R3DemoData\DynamicsAXR3DemoData—— update the path (Demo Data extraced path)
DynamicsAXR3—— provide the actual database name.(Ax DB Name)
In case of 3 tier environment, you will get the following screen.





[Server] always looking for current machine.if DB in another server follow step 9. 
Step 9 : you need to install Test data transfer tool on SQL server and run DP command on same server. 
in case of standalone you will get the following screen.
zb7
If we enter ‘Y’, then following screen will open up describing the count for importing the table data and Error (if they come up)
zb8
  • The process may prolong depending upon machine configuration.
  • On successful import, Open AX client and data will show up.


Ax 2012 R3 installation components preview

Finally i downloaded AX 2012 R3 ISO and installed. here am adding preview of installation components.
you can find the ISO download link from my previous post 








Ax 2012 R3 ISO Download

The latest version of Dynamics AX - 2012 R3 has released.
The below  link will direct you to the ISO download for Dynamics AX 2012 R3. 
(Needs partner source access)







Monday, January 06, 2014

How to Take Application and DB backup in AX 2009

Applied on: 
Microsoft Dynamics® Ax 2009.
audience: 
This article is for Ax Technical persons & Administrators.



About this article: 
when  you created a new instance of AX2009 for testing purpose, you want to make it the same as the live server, so which files you have to copy from live server  and paste it in new Dev instance server.

This article Helps to know :

-->How to take Application Backup of ax 2009.
-->How to take Date Base  Backup.

Steps to Take Backup & Replace :

1)      Stop Dynamics AX Windows Service in newly created Test AX Server’s machine

2)      Copy entire Source Live AX Server’s Application-Folder located at 
       (Ex: C:\Program Files\Microsoft Dynamics AX\50\Application)
         To know where-about Source Live AX Server App-Folder location 
         Goto: Start Menu > Administrative Tools > Microsoft Dynamics AX 2009 Server Configuration
       See text in Application-File-Location in Tab:[Application Object Server ]

3)      Paste/Replace folders/files into the targeted new AX Test Server’s Application-Folder
       To know where-about Test AX Server App-Folder location
          Goto: Start Menu > Administrative Tools > Microsoft Dynamics AX 2009 Server Configuration
        See text in Application-File-Location in Tab:[Application Object Server ]

4)      Take Database Backup in Source Live AX Server’s SQL-Server

5)      Restore Database in targeted Test AX Server’s SQL-Server

6)      Start Dynamics AX Windows Service in newly created Test AX Server’s machine

Friday, January 03, 2014

How to open record directly from Info dialog in Microsoft Dynamics Ax 2009 / AX 2012

Applied on: 
Microsoft Dynamics® Ax 2009  & AX 2012 .

Target audience: 
This article is for Ax Technical persons.



About this article: 
Most of the time when we create / update / manipulate record, in general the record we display in an info log to inform end user. It’s easy for end user to open and see the record from info log dialog using a show button or by double click on the message.



This article Helps to know :

How to display Show button on info log dialog in Microsoft Dynamics® Ax 2009 /AX 2012.
Double click on info log message and open the record in Microsoft Dynamics® Ax 2009/
AX 2012.Pass record to the info method, display Show button on info log dialog and open the form with current record in Microsoft Dynamics® Ax 2009/AX 2012.Directly open record from info dialog / form in Microsoft Dynamics® Ax 2009/AX 2012. 


Below is job which shows a vendor Group in info log dialog and if you double click on the vendor Group  it will open the vendor Group detail form.