Update the Cubes in dynamics AX 2012 using Visual Studio

Following steps will illustrate the way to update the analysis project cubes via visual studio framework.

1- Open the Microsoft Dynamics development AX client.
2- Click Tools > Business Intelligence (BI) tools > SQL Server Analysis Services project wizard.

3- On the Analysis Services project wizard page, click Next. 

4- On the Select an option page, click Update, and then click next.

5- On the Select an existing Analysis Services project page, Select Dynamics AX (or the other project you want to update) from the AOT, and then click next.

  

6- On the Verifying the SQL Server Analysis Service Project page, click Next.

7- On select perspectives Cubes and dimensions page, select all cubes, perspectives and dimension and click Next.

8- Then select all measure groups and click Next.

9- Then select Date dimension and click Next.

10- Select the language option English(United State) and click Next.

11- Checked the foreign currency option and click Next, as shown below.

12- On the Confirm changes page, click Next. 

13- On the Deployment option page, click Cancel as shown below. (Don’t deploy the project from here, we will use visual studio for this.)

14- Right click Dynamics AX analysis project and select edit to open it the project in Visual studio. (for this visual studio development tool must be installed in Ax).

15- When the Visual Studio get open, before doing anything make sure you are connected with the correct server and database. To confirm this Right Click Dynamics AX node and click properties option. See screenshot.

16- Now make sure that you are connected with correct database (or change it accordingly), for this double clicked on                  Data Sources -> Dynamics Database

17- Now the purchcube is ready to deploy and process. Right click on purchcube and select process option. The system may appear the below message, click Yes.

18- When you click “Yes” the system may again appear with the new message before overwriting the database. Click “Yes” to continue.

19- The final message will appear when the cube gets deployed, you will be required to click on “Run” option to process the cube.

          Hope this will be helpful.

Create purchase order and generate invoice in Dynamics AX.

To create new purchase order, you need to follow these steps.

1. click Accounts payable -> Purchase order -> All purchase orders

2. You will get the below screen, then click "Purchase order".

3. Now select Vendor account and set the site and warehouse location under storage dimension as shown below.

4. As you will click the "ok" button on previous form, you will be redirect to the next form to select the order Line. To add multiple line click "Add line" option under purchase order lines grid.

5. Once you have created the lines, you need to confirm the purchase order. For this you be required to click "Purchase" menu (on the top of the form) then you will find the "confirm" option in Generate group as shown below screenshot.

6. After purchase order confirmation, you will be required to create the product receipt. For this click on "Receive"  -> "Product receipt" option (from top of the form menu). After that you will get the below screen where you will be required to enter the "Product receipt" no. (you can enter the dummy no. for testing, here I have enter  4458) then click OK.

7. So far now the purchase order has been generated, now to create purchase invoice navigate to "Invoice" -> "Invoice" as shown below screenshot.

8. Finally you will be required to post that invoice click "Post" -> "post" (button). Make sure you check the print invoice checkbox to get the invoice report.

9. Finally, here is the invoice report of your purchase order.