Category Archives: AX 2012

Pharmatec: Integrated Functions and Improved Operations Through Dynamics AX 2012

The chemical/pharmaceutical industry has some typical challenges that it looks to be addressed especially when in the midst of choosing a technology and software solution. Some key pain areas include management of production particularly with respect to ingredient potency and formulae; as well as expiry and quality control. Depending on the extent and business of the company, integrated, real time information and secondary solutions towards relationship management (such as secondary sales, customers, vendors, etc.) all form key parts of the challenge within this industry.

We have solved these challenges for one of our pharmaceutical clients, Pharmatec Pakistan Private Limited. Our vertical solution caters to their multitude of challenges and focuses on bringing key benefits that Dynamics AX 2012 inherently has to offer.

Read through our case study here:

Pharmatec-Pakistan-Private-Limited-Casestudy_0

Reports stuck on Queued / Cancellation in Management Reporter 2012

Hello everyone. So recently I was quizzed as to why my reports generated in MR 2012 where being stuck on queued for a very long time with no progress at all.

Report stuck

So here’s a useful tip if you ever bogged down as to why the reports you generate in Report Designer (MR 2012) gets stuck on cancellation or queued status. You just need to start / restart the Management Reporter 2012 Process Service Properties. Navigate to Services (Start Menu > Run > Service.msc) and find the following service MR2012ProcessService.

Start service

In our case, the service was stopped and needed to be start. Right click the service and select the Start / Restart option. Once the service has started, the reports will start to generate and will no longer be stuck in Queued status.

Service starting

 

So this was pretty simple solution that had me bogged down for quite some time. Hopefully this will help out some people.

Catch Weight Functionality for Receiving of Goods in Microsoft Dynamics AX 2012

Many industries receive raw material in a different packaging unit, while payment may be made in a different unit. This post will help you understand how to receive product in different packaging using Catch Weight. Let’s take an example of cotton in Textile Industry, Cotton is received in unit “Bales” and normally companies need to pay the vendor after weighing in Kilograms. This weight may be different in each case because the Bale has a catch weight. Users face great difficulties while receiving goods because in AX 2012 we can give only one Unit of Conversion against single item. Lets have a look on how to resolve this:

First of all go to Product Information Management –> Common –> Released Product then click on New

Do not forget to mark CW Product Check Box while creating new Product

CW

Then click OK button and you can see the New Product in Product Information Management

 

New Item

Define unit of conversion of Product; remember that we have taken Inventory and Purchasing unit “KG”

Unit of Conversion

UOC

After setting unit of conversion go to the Product and edit that then go to Manage Inventory tab and select catch weight unit as Bales

Edit Prduct

and add minimum and maximum quantity to be received. Note that minimum and maximum quantity will be the quantity to be received in Kilograms not bales

Setups have been done. Now, we need to receive the same Product for this follow the below navigation

Go to Procurement & Sourcing –> Common –> Purchase Orders –> All Purchase Orders then click on New PO

PO

Select vendor and click Okay

Then select the Product on Purchase order lines

PO Lines

After taking Product and its quantities click on Update Line tab and select Registration

Update Line

This will be done after confirmation of Purchase order and before Receiving of Goods but at this stage user must know the actual weight of the Product which user is going to receive.

Now click on Auto create

Auto Create

After clicking on Auto Create checkbox, the total quantity of that Product will copy in Register now

Now user can register the actual weight of the goods received. Let’s say we have set the conversion from Bales to Kilograms 150 kg but at the time of receiving when Product was measured on weighing bridge user came to know that actual conversion is 1 Bale = 200 kilograms then here user will register the quantity with actual weight even batch number wise

Batch Wise registeration

But registration is only based on minimum and maximum quantities setup on Catch Weight you can see in the above screen shot that setup conversion was 150 kilogram but registration has been done with 200 kilograms conversion

After this go to the Product Receipt for receiving the Product

Product Receipt 1

Enter Product Receipt number

Product Receipt 2

In above Posting Product Receipt screen you can see on lines The CW quantity remains same but conversion factor has been changed from 150 kg conversion to registered 200 kg conversion

Now click Ok for receipt.

Now you can check “On Hand” inventory will show the inventory of received product

On Hand

You can see the receiving of goods in different batches with actual weight of the Product received.

Hope this post will help to solve the Catch Weight receiving issues that you may have.

 

Mix and Match Discounts in Dynamics AX 2012

Retail generally has a large amount of discount scenarios of each of which must be catered to through Dynamics AX 2012. One of our customers was looking to apply some discounts that needed to be mapped in the system as well. I have mentioned a scenario that I faced and the solutions I came up with this

Scenario:

Case 1:  Buy 1 item 000004 and get 1 item 000016 free throughout the year. And these items can sell separately too with their respective prices

Case 2: 10% discounts to all products in spring season.

(In spring season both discount cases need to be apply)

Solutions:

Case 1 Buy one Item 000004 and get item 000016 free

Step 1: Go to Retail > Common > pricing and discounts

D-1

Step 2 Create New Discount

Step 3: In price/ Discount Tab go to Line Spec

D-2

Step 4: In lines; I have selected the item 000004 with 0.00% Discount and for item 000016 I have mentioned 100% discount as this item is going to be free with the item 000004 ( this will be apply through out the year)

D-4

But problem occurs when the we have spring discount (CASE 2) also Applying In item 000004 and 000016 so what I did is; in item 000004 I have mention discount 10% in lines, if I don’t mention 10% discount over here then Case 2 will be not apply for 10% discount on item 000004 while 000016 Item has been taken at 100% discount as it is going to be free with 000004 item

 

D-4

Step 6 : Change the Status

D-5

 

CASE 2: Get 10% discount on all products in Spring Season

Step1: Go to Retail > Common > pricing and discounts > Discounts

D-6

Step 2: Create New Discount

Step 3: Select Retail Price Group and in Concurrency select Compounded from Top Down list

D-7

Step 3: Select Discount 10%

D-8

Step 4: Select Validation period

D-9

Step 5: In lines select products which you want to apply 10% discount

D-10

Step 6: Change the Status

D-11

Now run the discount JOB and Check POS Applying both discounts in spring season

 

Exploring Drill-down SSRS Reports in Dynamics Ax 2012 R3

Drill drown reports in Dynamics Ax 2012 R3 are very vasy. For this purpose, I have to create a new AOT/Static Query AOT. This query is a join between CustTable and SalesTable. I created an Inner Join so only those Customer were selected who have associated Sales Orders. Consider following steps to create a new report:
Create a new Query with Name “DyWorldCustSales”
Drop or add Data Source with CustTable
6-21-2014 9-02-30 PM

Right click on Fields and add following fields from Customer table.

CustomerFileds

Expand Data Source inside Custtable, Add or Create DataSource with SalesTable and fields

SalesOrder

Right Click on  SalesTables Data Source and set its join properties as follows:

DataSetProperties

Expand Relationship node of SalesTable_1

Add following relationship:

Relations

Set it properties as follows:

RelationshipDetail

Now, create a new report In existing or New DataModel Report in Visual Studio project:

NewReport Project

Add New report with DyCustSalesOrderList

Add Dataset with Name DSCustomer and Point to Query which we created in above steps:

PointToQueryQueryDataSet

Now drag and drop the dataset on designer to create a designer

And Update, rename it to  DyCustSalesOrderList

Set DataTable’s Propeties visible to set false

DataTable

Add a List and set its name to CustList

Create two groups, one for CustomerGroup and second for AccountNum:

Groups

Now drop the fields from dataset which you want to display on report

Fields

Right click on CustList and set Data Navigation Style to DrillDown from properties window

DrillDownProperties

Now right click add report to aot and then deploy to Report Server

When you run the report,  from meu Item you will find following

CustomerGroupClick

Click on Customer group this will open:

reportCustomerLevel

Click on Customer account it will drill down report on Detail level:

Details

This post was originally published on http://tech.alirazazaidi.com/exploring-drill-down-ssrs-reports-in-dynamics-ax-2012-r3/

Ali Raza Zaidi is MVP, one of the only 6 people qualified from Pakistan! He is our top notch technical consultants and works in the capacity of Advisory Software Engineer for Dynamics AX 2012 in Systems Limited.

original article

Exploring Drill through Reports in Dynamics Ax 2012 R3.

Creating basic drill through reports in Dynamics Ax 2012 R3 is really simple. Consider following scenario where we have to show the list of customer and their sales Orders in particular legal Entity.  In this report when User clicks on customer account, a new report opens, which contains list of all possible sales Orders. For this purpose I created two Static/AOT queries. First for Customer, and second for Sales Order. Customer Query:

  • Create a new AOT query with Name DyWorldCustomerList.
  • In DataSource add CustTable table.
  • In fields dynamic to true.

CustListTable Similarly, Create another Query “DyWorldSalesTable” for SalesTable. With Name DyWorldSalesTable   SalesTable Now Open Visual studio and create a new Dynamics AX Report Project   Report Project Add a new report with name

  • DynamicCustomerList

Add New dataset with Name

  • DynamicCustomerList set its properties as follow

CustomerDataSet

  • Select Following fields
    •   AccountNum
    •    CustGroup
    •    Party
  •  Drag this DSCustomerList data set on Report Designer to create an AutoDesign.
  • Change the AutoDesign1 properties as follow

o   Name to DesignCustomerList

o   LayoutStyle to ReportLayoutStyleTemplate

 ReportDesinger2

 Now create another report inside same Dynamics Ax Model Project, this report will be called from customer Report SalesOrderReport Create and DataSet with DSSaleOrder with query  “DyWorldSalesTable” SalesOrderDataSet Drag this dataset on Report Designer and update newly Designer as follow. SalesOrderDesignerProperties     Now open the parameter Section of report and add new parameter as “CustId” of string type CustIdParameter Now expand report designer and expand Table and add filter with following Properties NewParameter Set following Properties of filter o   From  Expression select “=Fields!CustAccount.Value” o   Name= Customer o   Operator =Equals o   Value “=Parameters!CustId.Value” Properties   Save the report.   Now Open the first report “DynamicCustomerList”. And expend the reports design, “DSCustomerListTable” and then Data and select AccountNum. Right click on AccountNum and select “Report Drill Through Action” AddDrillThrough   Now Double click and Select the report designer which will open against the click on field ActionProperties Select SalesOrderReport and its Desinger form dialog ReportSelectionSalesOrderList It will create number of parameters, all belonging to  DynamicSalesOrderList Report as follows: DrillThroughParameters   Delete all parameters except AX_CompanyName and CustId. If any other parameter remains, you definitely got following error when you called Sales Order report form drill through option.

“The Microsoft Dynamic AX parameter ID should be a RECID. The exception is System.FormatException: Input string was not in a correct format.”

AfterDeleteParameters   Please Select following Values for these Properties AX_CompanyName Select its value “=Parameters!AX_CompanyName.Value CompanyNameValue Please select the following value for CustId as “=Field!AccountNum.Value” SaleIdValue Now saves the reports and right click on Report Project to Add to AOT and then deploy on Report Server   AOT and Deploy Now Go to AOT, and refresh the Select the Visual Studio Model Project and SSRS reports into Dynamics Ax project so it will easy to edit or locate easily Menu2 Now create a Menu Item of Display type and set its following Properties Menu Now run the report as follow   CusttomerList As click on first Customer “CNMF-000001” To its salesOrderList , The second report successfully open as follow SaleOrderList   This post has been excerpted from http://tech.alirazazaidi.com/exploring-drill-through-reports-in-dynamics-ax-2012-r3/ Ali Raza Zaidi is MVP, one of the only 6 people qualified from Pakistan! He is our top notch technical consultants and works in the capacity of Advisory Software Engineer for Dynamics AX 2012 in Systems Limited.

#TipADay: Credit Note Functionality On POS in Dynamics AX 2012

Here is little tip how Credit note functionality works on Microsoft Dynamics Ax 2012 POS

Following are the few steps required to apply credit note in AX 2012

Step 1: Go to Retail > Setups > Payment Method

CN -1

Step 2: Create method of payment for Credit note and associate appropriate Posting account in it

Issue Create Note

Step 3: Now go to POS Select Return transaction

CN-2

Step: 4 Click Issue Credit Note

C-3

Credit Note will be issued and transaction will be done

Step 5: Now we can check if credit note has been issued or not

Go to Retail > Inquires > Credit Memo

new 1

Apply Credit Note:

Step 1: Enter Sales Transaction and then Select the payment option; that is pay with Credit Note

C-5

Step 2: Select settle balance with cash or settle with new transactions

In this example I have chosen Settle balance with cash

CN-6

 

Step 3: Enter the credit note Number

CN-7

Step 4: Now we can check if Credit note has been applied or not

Go to Retail > Inquires > Credit Memo

new 2

You will notice that applied check box is now marked.

#TipADay: Copying Data Between Companies using Excel Add-in

Hello everyone

Here is little tip on how to migrate data through Excel Add-In  . Through Excel Add-in you have the option of selecting what instance, partition, and company that you want to upload and publish to.

Let us work on how we can use the Excel Add-In to copy data between entities.

I have not loaded all of my base data, so we will use our main company as the template to load the data.

1

From the Dynamics AX tool, select the Options button and select your base company from where the data will be copied

To create a linked worksheet within Excel, select the Dynamics AX bar, and then from the drop down menu of the Add data button, click on the Add Tables option

2

This will open up a table selection dialog box. Then select the table that you want to add in sheet

3

You will initially have no records showing. To view all of the data that is in the company, select the Refresh button

4

Now change the Legal Entity that will be used just by selecting it from the drop down list.

6

Then we will save the data from  original company for reference. This will make it easier to cut and paste the data back into the new company. So we just select all of the original table, and then copy it.

7

Now that we have the template data saved we can continue on. Return back to the linked table, and then select the Refresh All option there is no data in the other company then the linked table will be blank.

8

And  now you can see in the below image, there is no data in the other company so linked table will be blank. Select the template data that you saved and then paste it into the linked table.

23

Now from the Publish menu, select the Publish All option

10

Now you can check the Publishing Status ,Your data will be copied from one company to another.

Try this tip, Copy a lot of the base data from another existing company, and  save your time

Enjoy Reading!

AX2012 R3- How to Import Contoso Data using Test Data Transfer Tool (Beta)

Pre-requisites:

1-      Download the test data transfer tool from the below mentioned link.

https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465
2-      Download demo data for AX2012 R3 from partner source site.

Steps: 

  • Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.

zb1

  • 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.
  •  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

  • Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)

zb4

  • On successful import a job will be created as shown below:

zb5

  • 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

  • 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.
  • Stop MS Dynamics AX service.
  • Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).
  • Run the following command:

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

C:\R3DemoData\DynamicsAXR3DemoData—— update the path accordingly

DynamicsAXR3—— provide the actual database name.

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.

zb9

#TipADay: Day 2: Importing Data to Microsoft Dynamics AX 2012 using Excel Add-in

Excel is a great spreadsheet tool and the AX 2012 Add in is even more wonderful. It allows to publish information/data back to Dynamics AX 2012 without any changes in AX 2012  configuration.  In this functioned example, I will show how you can use the Dynamics AX Excel Add-In to update your data. 

Before we start working on Microsoft Excel, we need to make sure that we have the Dynamics AX Excel Add- in installed. If you open up Excel and there is a Dynamics AX tab, then you are fine. If not, you will need to install it.

Lets try and import Chart of Accounts in Dynamics AX 2012. To do that, follow these simple steps:

Step 1: Go to Dynamics AX Excel Tab in the Excel

E1

Step 2: Select Add Data > Add table

e2

Step 3: Select Main Account Table

e-3

Step 4: Drag important columns that you want to update

e-4

Step 5: Enter your data in the fields

e-5

Step 6: Select Publish to import the records in AX

e-6

It will also create a new sheet called Dynamics AX Status which will show you how many records were updated, and also any errors –if they occurred.

Step 6: If we return back to Dynamics AX, then we will see the data  has been uploaded.

e-7

Hope this little tip helps you. Leave me your feedback and comments!