الأحد، 4 أغسطس، 2013

Microsoft Dynamics AX 2009 - Free Tutorial 1 - (A Process Step-By-Step in Excel Format)



Microsoft Dynamics AX 2009 Tutorial 1 Process Step by Step in Excel Format.

This tutorial is a process step by step in excel format that can help consultants
and users to implement Microsoft Dynamics AX 2009 in a simple and fast way to
boost Microsoft ERP Projects implementations for "Financial Module".

The tutorial is a gathering work from Dynamics AX CAMP BLOG, it covers different solutions and topics that faced the founder of this work during his implementations in Egypt and Middle East.

Some tutorials contain Checklists, Application Process and Process Solutions.

The tutorials (Excel Process Steps):
  • AX 2009 Installation Checklist
  • Fixed Assets Addition
  • Budget – Application Process Steps.
  • Consolidation - Application Process Steps
  • Fill Utility - Application Process Steps
  • Advance Payment – Process Solution.
  • Accrued Checks – Process Solution.
  • Handling Custodies –
  • Year End Closing - Application Process Steps.
Download Now FREE..

This work is licensed under a Creative Commons
on a work at http://www.ahmedrafik.com/

الأربعاء، 24 يوليو، 2013

ERP Timeline (Open-Project)


ERP Timeline is the first Open-project developed by Dynamics AX CAMP User Group.

You can now list your name and become one of the team who developed the first ERP Timeline Project.

Just go to the link below and add your data ... and register your name in the TEAMWORK SHEET in the file.

https://docs.google.com/file/d/0BxqQL_n9ICdtV0loQXFJVVE5X0k/edit?usp=sharing

Only who have the link can access the file.
We will update the teamwork names every Month, Keep your name listed now.

Members who developed this sheet will get free access to courses from Pluralsight.


What you have to do to contribute in this work:

1- Download the Excel Sheet from the link above.
2- Edit your contribution and the necessary data.
3- Mention your name in the Teamwork Sheet.
3- Save your work in the document.
4- Send us the excel sheet after editing to rafik139 @ hotmail.com

This work is going to list the big events happened in ERP, specially with Microsoft Dynamics ERP Family through Information Technology development ...



الأحد، 23 يونيو، 2013

الخميس، 9 مايو، 2013

الأحد، 28 أبريل، 2013

Data Migration Framework within Microsoft Dynamics AX 2012




The Microsoft Dynamics AX 2012 Data Import/Export Framework is an extension that helps you export data and import it into Microsoft Dynamics AX. Examples of the data that you can import include master data, open stock, and balances.

Architecture of DMF:


Data Migration Framework architecture diagram 

PROCESSING 

Setup shared directory

An important first configuration is to provide Location of Shared Directory. Click Data Migration Framework->Setup->Data migration framework parameters. Provide the path to a shared directory and click Validate to let system verify the path. This directory will be used by DMF to put some files for internal use. User configuring the shared directory path must have Read/Write permission on the directory.



Setup source Data Format


Click on "Data Migration Framework" click on Setup->Source Data Formats->Click New to create new record to prepare Source Format 




Give Source Name e.g. CSV in Description column write Comma Separated File, inType column select File, then assign the additional details about the data source in right pane of Source Data Format Screen.

Fill following sections on right pane:

File Section

1. File format-provide file format here Delimited or Fixed Width, we will choose Delimited for our example
2. First Row Header check box- check this check box if first row is a header for remaining records
3. Row Delimiter-Select this if your file contains multiple rows. Here user can select "CR,LF,Semicolon {;},Colon {:},etc." we will select {CR}{LF} for our example. 

4. Column Delimiter-Select this if your file contains multiple columns to import, this is used to distinguish values between column, there are multiple options available to distinguish we will use Comma for our example.
5. Text Qualifier- Select this if your column type is string and you have to use Delimiter in data e.g. your Delimiter is Comma and you have to use it as data e.g. "2-A Ahmed Block, New Garden Town" here you have to write the comma in double quotes "," so that system don't consider it as Column Delimiter. For our example we will write as Text Qualifier.





Regional Settings


1. Code Page - Character encoding for the file, there are different options available select your desired one, for our example we will select Western European (Windows) 
2. Unicode - Select this if your file is using Unicode, we will not use this option for our example
3. Language Local - Select Language, we will use en-us for our example


Multiple value separator


1. Role Separator - This is used to display multiple values in a column e.g. if a customer have multiple email addresses. We will use semi column for our example.


Now General Settings are finished, screen should look like this

 Next important thing is Application related details, click on Application to do settings, following settings will be don here:

Dimensions 


Dimension Code - Select which financial dimensions you want to import, we will chooseDepartment;CostCenter;ExpensePurpose for our example.

Chart of Accounts Delimiter - Select this to specify in which format Dimensions will be available in file, we will use "-" it means we will enter data in following format Department-CostCenter-ExpensePurpose.

Name Sequence - Select what would be the default sequence for migration of party records i.e. First Name, Last Name or any of the combinations given in the list. We will use "First Middle Last" for our example.

The screen should look like below after above settings


Next step is to identify identities to import into AX 2012, now click on Setup->Target entities. A list of all entities will appear. User can create his own entity as well which will be discussed in another post, here we will go on with standard entities. Below is list of default entities available in system, which were discussed in the beginning of the post:



Create Processing Group


Next step is to create Processing Group. Processing Group is similar to Definition Groups in AX 2012. Go to Common->Processing Group. Click New give name & description, write "AR" in Name and "Accounts Receivable" in description column. PressSave and Entities button will be enabled.


Click on Entities button to select entities to import, click on New a blank line will appear, fill in following columns:

1. Entity Name - Select an entity name from the list to import, we will use Customer for our example
2. Source Data Format - Select the source file format to import, we will use our previously created file format, select CSV from drop down
3. Sample File Path - Give path of the file containing data.
You can see sample files which are shipped with the DMF at <your installation drive\Program Files\Microsoft Dynamics AX 2012 Data Migration Framework Client Components (Beta)\DemoFiles\Delimited\> folder.We will use "CustomerEntity_ContactInfo" file for our example. Now the screen should look like this:




Generate Source Mapping


Click on Generate Source Mapping on entities screen, system will verify the source file columns with staging table columns, if any error is present in the file, system will show the error. There is another section Modify Source Mapping, use this to modify mapping between the fields, user can remove an existing mapping and can create new mapping as well. To remove existing mapping right click on desired link and click Delete Selected Node. To create new link drag the desired field from source to target, it will create a link between the fields.

Preview Source Data

Click on Preview Source file on entities screen, system will display data in preview grid for user checking. See Preview section on above screen shot with data populated in grid. Close the screen and go back to processing group screen to process further.

Get Staging Data


Click on Common->Processing Group, select the previously created group click Get Staging Data, system will ask for JobID to create a Job for running Staging Dataroutine. Provide an appropriate ID, Description and click "OK". See screen shot below:

System will show another screen with job created in it, in that screen user can click onPreview to verify data again. Click on Run button to run the job to prepare staging data. A screen will appear where user can schedule a re-occurrence batch job to run the job and press OK to run the job instantly. see below screen shot of Staging Data Preparation main screen.




A success message will appear '6' Customer record(s) inserted in staging as I am importing 6 records in the file. See below screenshot.


View Execution History


 User can view execution history of staging data processing using Processing Groupscreen. Click on Common->Processing Group select the appropriate processing group and Click Execution History, a screen will appear showing all executed jobs. Select a job from the previously executed jobs to see execution details. A selection of JobID is also available for filtration of jobs as well. See below screen shot.


An important thing on this screen is, user can see Staging Data and even user can edit data before processing to Target. To view or edit the staging data, select the appropriate JobID and click View Staging Data. A screen will appear with all data copied from Source to Staging. See below screen shot.


On this screen user can edit and validate data before processing for Staging to Target. Do changes if required otherwise close the screen. Now user can copy data from staging to target. User can copy data from staging to target from Execution History or Processing Group screensClick on Copy Data to target button, system will ask for the job to run, select the your desired JobID and click OK. See below screenshot.

Another screen will appear from where user can run the job. Click on Run to startstaging to target data copy processSystem will again prompt for making a re-occurrence job, do the re-occurrence settings or click OK to process the job.


An information box will appear indicating Data written to target ('6' records created, '0' records updated) as I was importing 6 records, 6 is representing the number of records user is importing.

الخميس، 4 أبريل، 2013

Expert Author Award Certificate - Ezine Articles



I would like to share with you these news, I become now an Expert Author on Ezine Articles Directory.
We just published our first article in ERP field on Ezine Articles Directory, but we are going to publish more than 10 articles within 3 Months.

الجمعة، 29 مارس، 2013

Published Article: How ERP Help in President War Decision



In this article, i illustrate how ERP affect Politics directly, and this is not only my point of view, but also it is what happened in our real world, Just imagine the relationship between both and then read this article, and you will know How your imagination will take you away and thinking of this fact.
 You can read this article directly published on Ezine@articles.

الأحد، 10 مارس، 2013

Accrued Checks Scenarios in Dynamics AX 2009

Developing Solutions is the main issue to meet customer needs in Financial Module in Microsoft Dynamics AX, we develop this business scenarios according to our background business through Financial Module concern the Accrued Cheque within Microsoft Dynamics AX 2009 in a more simple steps.

Provided 2 Case Scenarios for the Accrued Check and how to deal with in Dynamics AX 2009.



الأربعاء، 13 فبراير، 2013

Consolidation Business Process within Dynamics AX 2009

Developing Solutions is the main issue to meet customer needs in Financial Module in Microsoft Dynamics AX, we develop this business scenarios according to our background business through Financial Module concern the consolidation processes within Microsoft Dynamics AX 2009 in a more simple steps.





الاثنين، 11 فبراير، 2013

The top 1% most viewed LinkedIn profiles for 2012!‏


Wow, it is a great news to share with you, and good recognition from LinkedIn.
I just received this message from Linkedin, I became one of the Most Viewed Linkedin Profiles for 2012.
They send me this email and also a Thank Letter.
Thanks for you all and keep updated with upcoming posts and news.


And last the Thanks Letter.