What is: the Inventory Status Of The Processes involved in Creating SalesOrder & PurchOrder in Ax 2012

Inventory Status of the SalesOrder:

1. Confirm         ==> OnOrder.
2. Picking List   ==> Reservation.
3. Packing Slip  ==> Deducted.
4. Invoice           ==> Sold.

Inventory Status of the PurchOrder:

1. Confirm / PurchOrder                     ==> OnOrder.

2. ReceiptList                                     ==> Registration.

3. Packing Slip / Product Receipt       ==> Received.

4. Invoice                                           ==> Purchase.

Proud To Be a DAX Developer :-)

What is: The Process For PurchaseOrder Creation, Class's & Table's Involved In the process in Ax 2012

PurchaseOrder Creation Process:

They are 4 Major Process Steps involved in the Creation Of Purchase Order:
1. Confirmation/PurchOrder.
2. Receipt List
3. Product Receipt
4. Invoice.

1. Confirmation : Class's & Tables That are related to Confirmation process are following:

               Tables  : VendPurchOrderJour , VendPurchOrderTrans.

               Class's : PurchFormLetter_PurchOrder.

2. ReceiptList  : Class's & Tables That are related to ReceiptList process are following:

            Tables  : VendReceiptListJour , VendReceiptListTrans.

            Class's : PurchFormLetter_ReceiptList.

3. PackingSlip : Class's & Tables That are related to PackingSlip process are following:

            Tables  : PackingSlipJour , PackingSlipTrans.

            Class's : PurchFormLetter_ProductReceipt.

4. Invoive : Class's & Tables That are related to Invoice process are following:

     Tables  : VendInvoiceJour , VendInvoiceTrans.

     Class's : PurchFormLetter_Invoice.

Proud To Be a DAX Developer :-)

What is: The Process For SalesOrder Creation, Class's & Table's Involved In the process in Ax 2012

SlaesOrder Creation Process:

They are 4 Major Process Steps involved in the Creation Of Sales Order:
1. Confirmation.
2. Picking List
3. Packing Slip
4. Invoice.

1. Confirmation : Class's & Tables That are related to Confirmation process are following:

               Tables  : CustConfJour , CustConfTrans.

                Class's : SalesFormLetter_Confirm.

2. PickingList : Class's & Tables That are related to PickingList process are following:

           Tables  : WMSPickingRout , WMSOrderTrans.

           Class's : SalesFormLetter_PickingList.

3. PackingSlip : Class's & Tables That are related to PackingSlip process are following:

            Tables  : CustPackingSlipJour , CustPackingSlipTrans.

            Class's : SalesFormLetter_PackingSlip.

4. Invoive : Class's & Tables That are related to Invoice process are following:

     Tables  : CustInvoiceJour , CustInvoiceTrans.

     Class's : SalesFormLetter_Invoice.

Proud To Be a DAX Developer :-)

How To: Create & Use AOT Maps In Ax2012

• Maps are also known as Table Maps/AOT Maps. Table Map is a element/object the makes possible to link/associate map fields with fields(same type with different names) in different tables.
• like, I have create a MAP with field (AccountNum) and Same field exist in CustTable and also in VendTable,so I can associate field in CustTable and in VendTable with Maps, so basically  Maps enables to access the fields with different name in different tables.

Procedure For Creating a AOT Map:

• I created a Map by navigating to AOT>Data Dictionary>Maps and right click and new and gave it name ‘MapTest’.

• I have created 4 fields under Fields node in Map (Best Practice drag and drop from EDT).

• Now the next thing I need to do is to associate the fields in map witch i created with the fields in different tables, let say I am taking two tables (CustTable and VendTable).

Notice that above, four fields that I have created in Maps also exist in CustTable as well as VendTable with different names.

• To associate fields, go to Mapping node, right click it and click New mapping and enter the table that you want to associate in Mapping Table field as following,

What Is: The Difference Between MapIterator and MapEnumerator In Ax 2012

Hi Friends, 

                

To day i would like to share info about MapIteratot and MapEnumerator, 1st thing to know is that in Ax 2012 "MAPS" are of two types,

1. X++ Maps:

                It can be used as a temp data store for the given scope of a process. This takes us less over head, and is much quicker than a TempTable. For Further reading.

2. AOT Maps:

                 A map can unify the access to similar columns and methods that are present in multiple tables. You associate a map field with a field in one or more tables. This enables you to use the same field name to access fields with different names in different tables. Methods on maps enable you to create or modify methods that act on the table fields that the map references

Difference is mentioned below:

MAP-ITERATOR:   The Mapiterator loops through the complete Map.

MAP-Enumerator: Map Enumerator class is like map iterator Class ,But allows the deletion of elements during enumeration where as mapiterator does not.

Proud To Be a DAX Developer :-)

SSRS Tip: Creating Multiple Data Regions In SSRS Reports

Hi Friends,

Today i'll demonstrate how to create multiple data regions/ groups in SSRS reports. A data region in simple definition is a subreport report that shares the parameters and datasets, and is present inside the report design itself. 

• This and the following procedure will help you understand how multiple data regions can be created in SSRS. The first of the two data regions will display the detailed customer transactions.

Note: 1. 1st we have to create a query using CustTrans and CustTable tables and with following fields as shown below.

           2. We are using "AutoDesign" report while creating reports.  

• Create a PktCustTransList query, which includes the CustTable and CustTrans tables. Remove the unwanted fields and retain only the fields that are shown in the following screenshot:

• Open Visual Studio and create a new Report Model Project named PktCustTransReport and create a dataset that refers to the PktCustTransList query.

• When selecting the fields in the query window, select all the fields and the name data method from CustTable.

How To: Create Related Field Fixed Relation In Ax 2012

Hi Friends,
Creating Relations in Ax 2012 is not that much difficult, today ll see how to do it in "3 Simple and Easy Steps" . Lets Start
Note: An Xpo for this example is provided at the end.

Step 1:

Create a BaseEnum  as AccTypeId , with elements as below 

            > Customer  - 0
            > Vendor      - 1

• Create a EDT as AccTypeEDT and in the propertie's you will find a property as EnumType:   Set it to : AccTypeID(Our BaseEnum)

Let say you have 3 tables as following:

1. AccTypeTable.

2. CustomerDetails.

3. VendorDetails.

Step 2:

• Now create  table  AccTypeTable with fields AccountNum(String), AccType(Enum), DepartmentBelongs(String).
Note: When Creating AccType Field create a enumType field and in the properties find ExtendedDataType and fill that with our AccTypeEDT witch we created in step 1.

How To: Use Date Effectiveness Feature in Ax 2012

• Date effectiveness is a new feature in Dynamics AX 2012 allowing developers to easily create date range fields.
•  Date ranges are used for defining record validity between the specified dates, for example, defining employee contract dates.
• This feature significantly reduces the amount of time that developers spend writing code and also provides a consistent approach to implement data range fields.

Note: > We will implement date range validation on the standard E-mail templates form.

          > This Example(Data, Tables, Forms etc etc) is given on the base of Contoso Domain

          > You ll also find an Xpo File To Download at the end of the example.

          > While importing into your AOT it ll ask for replacing the existing one, you can replace it with the new table and form. 

Procedure:

1. In the AOT, find the SysEmailTable table and change its property as shown below 

:

 

Property --> 

ValidTimeStateFieldType : Date

2. Notice the two new fields that are automatically added to the table :

3. Add the newly created ValidFrom and ValidTo fields to the existing emailIdIdx index

and change the properties shown in the following table:

4. The index should look similar to the following screenshot:

Microsoft Dynamics Ax Major Features of Next Release (RAINIER)

Feature's:

The next major release of Microsoft Dynamics AX is code named ’Rainier’. It is a new cloud optimized platform for deployments in private and public cloud as well as on-premises.

1. Cloud Based Solutions.
2. Platform independence - Browser enabled client's.
3. AD (Active Directory) Federation and more integration with Azure.
4. More investments on Visual Studio (Development Environment will be VS).
5. Application Development targeting any OS through Rainier.
6. No longer need to invest on Sharepoint hosting as Enterprise portal will be eliminated.
7. 3 key pillars - New client, Cloud Readiness, New Development Stack.

How To: Import & Export a Model In Dynamics AX 2012 Using Windows PowerShell Commands in Ax 2012

Exporting an .axmodel File (Windows PowerShell)

Procedure: 

1. Click On the Start menu -->point to All Programs
2. Point to Administrative Tools, & then click Microsoft Dynamics AX Management Shell.
3.  A Command Prompt will Appear After clicking Management Shell 
4. At the Windows PowerShell command prompt PS C:\>,
5. Type the following command, and then press ENTER.
   

Ax 2012 R2 Installation Setup Step By Step

Step By Step Procedure: 

Hello Friends,

Here we are have  24 Easy and Simple  Installation Wizard Overview on AX 2012 R2.

Note:  Make Sure The your P.C/ Laptop Is Connected to Internet.

1) Open the Setup Program/Setup Wizard.

 2) Click "Microsoft Dynamics AX Components" under Install.

 3) Click Next.

SSRS Tips: How To Get GrandTotal Using Autodesign in SSRS Report

Procedure:  3 Simple & Easy Step's

1. Open Property Window Of AutoDesign Node In Your Report.

2. Set The "GrandTotal" Property To "Yes".

3.That's it , It will Take care of the printing the total .

Proud To Be a DAX Developer  :-)