Dynamics Ax 2012

Product receipt against purchase order in Dynamics Ax 2012 R3

January 25, 2015 by alirazazaidi

In this post I am going to create a new Purchase order and receive inventory against Purchase Order.

My post against purchase order in Dynamics Ax 2012 are as follow.

http://tech.alirazazaidi.com/how-to-create-request-for-quotations-in-dynamics-ax-2012/

http://tech.alirazazaidi.com/how-to-register-request-for-quotation-response-in-dynamics-ax-2012-and-its-convert-purchase-order/

First of all we create a Purchase order with single line. For this we have to go

Accounts payable=>Area page=> Common=>Purchase order=> All purchase orders

Purchase order list page open as

Now from top strip click on Purchase Order and following new Purchase Order form open

Lets say we create Purchase order against 104 Vendor

Now from General fast tab select following settings. Set Purchase type: Purchase order

Site to 1 and warehouse 11 (Contoso data) and update delivery date to update to 4 then from now.

Click ok to create a purchase order

Now select Item “1000” and update its quantity to 100 items and let its price to default.

Now go to up top tab strip “Purchase” and click on confirm purchase order

Click on Ok button to confirm the purchase order.

Now select the purchase line and click on Inventory and then on on-hand to check to check its present inventory

Following on-hand detail page appears

For example, Now vendor send you required product with full quantity, and with invoice, you accept the Quantity and signed it that you received the quantity and invoice number enter in dynamics ax 2012

Now go to Receive tab strip and click on Product receipt.

Let see my I received the Product against Invoice number Invo-0001.

Click on ok.

Now again select the line and check its inventory you can see that inventory increased by 100 item.

Product entry successfully completed and Inventory successfully increased by 100 items.

Dynamics Ax 2012 R3 Cu8 demo data download link

January 25, 2015 by alirazazaidi

Demo data file for Dynamics Ax 2012 R3 CU8 is available for download. You can download it from following link

https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials

To log on here you must have partner source or customer source credentials.

Todo is help us to remember the reason why we commented the code in Dynamics Ax 2012

January 23, 2015 by alirazazaidi

Very interesting feature for developers in dynamics Ax 2012 comes from its legacy version is

//Todo: come back here

During development many times, we have to comment some code because it is unfinished or generate errors and we cannot generate CIL. Later we forget where were we set commented lines of code because AX has thousands of classes.

The best option is to put comment with keyword “todo:” and leave message there or wrote the reason why we commented the line below.

When we compile the code there will be message in compile output window.

unable to save method … Dynamics Ax 2012 R3

January 19, 2015 by alirazazaidi

I got error message ” Unable to save method init” during saving the form. While surprising it gives no error on compiling the code. I also found some errors on classes too, I solved it by following way, possible it helps,

Using AXBuild for fast compilation in Dynamics Ax 2012 R3

January 17, 2015 by alirazazaidi

We can compile with whole AOT in less time as compared to compilation in Mophix. From Dynamics Ax 2012 R2 cu7 and later a utility provided for this purpose. You can found AXBuild exe from this location.

X:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin

And compilation command is as follow.

axbuild.exe xppcompileall /s=01 /altbin=”C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin” /log:”C:\Temp”

Where s=01 is the AOS server Id

How to check Dynamics Ax 2012 form is in edit mode

January 16, 2015 by alirazazaidi

During development, I wrote code in clicked event of Button. But requirement is that code will works only if form is in edit mode. I used following code to check it

boolean _bool;

supper();

_bool= element.inViewMode();

if (_bool==boolean::true)
{
info (“true”);
}
else
{
info (“false”);
}

This method element.inViewMode() return true when form is view mode.

How to create a new module in dynamics Ax 2012

January 14, 2015 by alirazazaidi

Go to Data Dictionary in AOT. Expand it and under configuration create a new configuration key.

Suppose we are going to create Module name with CustomModule, so we create is configuration key with same name. If you have license key then enter it other wise left it blank. This approach with out licence key works for development but for production you have must have ISV license.

Now go to Menu and create a menu with Name “CustomModule”.

Expand it and copy other menu and paste in it, then remove all menu items, left empty, common, step up, reports and inquiries.

Now right click on CustomModule and from properties set and set it configuration key mentioned in above step

Now expand the menu and right click on main menu and add reference to Custom Module menu.

Now add one menu Item in newly created menu for example just open a empty form from menu Item.

Save it and close the client and restart the AOS.

When AOS is restart you find a new module click it and open it.

VendBankAccount and BankAccountTable address relation Dynamics Ax 2012

January 10, 2015 by alirazazaidi

We can get address for VendBankAccount table and BankAccountTable by following way.

VendBankAccount table has method which returns address VendBankAccount.addressing() ;

For BankAccountTable you can use following query to fetch its address, both table has similar releationship with logistic location table

BankAccountTable _BankAccount;

LogisticsPostalAddress _postalAddress;

LogisticsLocation _location;

while select * from _BankAccount

join * from _location

join _postalAddress

where _postalAddress.Location == _location.RecId

&& _BankAccount.Location == _location.RecId

{

info (_BankAccount.AccountID + ” address “+ _postalAddress.Address);

}

How to register Request for Quotation response in Dynamics Ax 2012 and its convert Purchase order

January 10, 2015 by alirazazaidi

In my previous post, we create and post a request for Quotation for two different vendors,

http://tech.alirazazaidi.com/how-to-create-request-for-quotations-in-dynamics-ax-2012/

In this post I am going to register the response sent by vendors against request for Quotation.

By clicking on Request for quotation replies. A list page open, if you saw last two lines are against our required RFQ. because we send it to two different vendors.

We are going to register the response from the “Lande Packaging Supplies”.

From top menu select copy Data to reply and click on Edit.

On click on edit detail page opens you can update the information according to replies.

For first Item, I have to update price from 50 to 40 , We assume that Vendor offer us with less price.

Save it and similarly register response for other vendor.

Now go to back to all request Quotation form. Select the Request for Quotation and found request of Quotation as follow

From top menu strip click on compare replies

Following form will open which shows the line header with amount.

If you saw Vendor account 1001 offers less prices then vendor 1002. I am going to accept that response and that will result in Purchase Order convert from Request for Quotation.

Select the line and click on accept button.

Purchase order successfully created against accepted response.

File load dialog in Dynamics Ax 2012

January 4, 2015 by alirazazaidi

Some times we have to load files into dynamics Ax. Following X++ code helps to load files in Dynamics AX.

Dialog _dialog;
DialogField _file;
;

//Prompt to import excel
_dialog = new Dialog(“Please select the file to load”);
_dialog.addText(“Select file:”);
_file = _dialog.addField(ExtendedTypeStr(“FilenameOpen”));

_dialog.run();

if (_dialog.closedOK())
{
info(_file.value() );
}

« Previous Page