Exploring The SalesSalesOrderservice AIF Document Service In Dynamics Ax 2012 R3

For my session for Integration with Dynamics Ax 2012. I have to consume SalesSalesOrderSerivce. In this article I am configure and consume Sales Order service and share c# code for calling a Sales service and consume.

Enable the methods and configure the inbound port. For this you have to go at following link and open AIf Inbound

Right click on AIF menu and create a New

set the Name there “ for example I create the port with Name “MySalesOrderService”.

Click on Service Operations add following one

Click on arrow button and add these method to service

Now click on Close button to close it.

Now click to check box to enable data policy button document. Click on it.

New screen open for all possible fields, Click on Element to sort the list, Enable following fields which are minimum required for Sales Order creation.

Now save it. From port screen enable logging and Click on activate, Wait it will take time to deploy the service on port.

Info log appear to tell that port is successfully active.

Now copy the WSDL url

Create a new Console application in Visual studio, I am more familiar with C# so I created a console application in C#.

Add new Service reference and set its name “SalesOrderService” and get methods from WSDL.

Now Click on Ok button.

Calling the Create Method.

 

var line = new SalesOrderService.AxdEntity_SalesLine()

{

ItemId = “D0001”,

SalesQty = 42,

SalesUnit = “ea”

};

var order = new SalesOrderService.AxdEntity_SalesTable()

{

CustAccount = “US-003”,

PurchOrderFormNum = “ffg”,

ReceiptDateRequested = DateTime.Now.Date,

SalesLine = new SalesOrderService.AxdEntity_SalesLine[] { line }

};

//   SalesOrderService. _salesOrder= new SalesOrderService.AxdSalesOrder();

var orderList = new SalesOrderService.AxdEntity_SalesTable[] { order };

var callContext = new SalesOrderService.CallContext() { Company = “USMF” };

SalesOrderService.SalesOrderServiceClient client = new SalesOrderService.SalesOrderServiceClient();

//   _salesOrder.SalesTable=orderList;

try

{

client.create(callContext, orderList);

//  client.create(callContext, orderList);

client.Close();

}

catch

{

client.Abort();

throw;

}

Read Method Code

try

{

SalesOrderService.KeyField keyField = new SalesOrderService.KeyField() { Field = “SalesId”, Value = “000767” };

// Create an entity key instance and put in the key field data

SalesOrderService.EntityKey entityKey = new SalesOrderService.EntityKey();

entityKey.KeyData = new SalesOrderService.KeyField[1] { keyField };

// Create an array of entity keys and put in the previously

SalesOrderService.EntityKey[] entityKeys = new SalesOrderService.EntityKey[1] { entityKey };

SalesOrderService.SalesOrderServiceClient _Client = new SalesOrderService.SalesOrderServiceClient();

SalesOrderService.CallContext _callContext = new SalesOrderService.CallContext();

_callContext.Company = “USMF”;

SalesOrderService.AxdEntity_SalesTable[] _SalesOrder= _Client.read(_callContext, entityKeys);

SalesOrderService.AxdEntity_SalesTable _SalesTable = _SalesOrder[0];

SalesOrderService.AxdEntity_SalesLine _SalesLineTable = _SalesTable.SalesLine[0];

Console.WriteLine(“Account Num : ” + _SalesTable.CustAccount.ToString());

Console.WriteLine(“Order date  : ” + _SalesTable.ReceiptDateRequested.ToString());

Console.WriteLine(“ItemId  : ” + _SalesLineTable.ItemId.ToString());

Console.WriteLine(“QTy  : ” + _SalesLineTable.SalesQty.ToString());

Console.WriteLine(“Sales Unit  : ” + _SalesLineTable.SalesUnit.ToString());

_Client.Close();

Console.ReadKey();

}

catch

{

//     client.Abort();

throw;

}

Update Method Call code

 

SalesOrderService.KeyField keyField = new SalesOrderService.KeyField() { Field = "SalesId", Value = "000756" };

// Create an entity key instance and put in the key field data

SalesOrderService.EntityKey entityKey = new SalesOrderService.EntityKey();

entityKey.KeyData = new SalesOrderService.KeyField[1] { keyField };

// Create an array of entity keys and put in the previously

SalesOrderService.EntityKey[] entityKeys = new SalesOrderService.EntityKey[1] { entityKey };

SalesOrderService.SalesOrderServiceClient _Client = new SalesOrderService.SalesOrderServiceClient();

SalesOrderService.CallContext _callContext = new SalesOrderService.CallContext();

_callContext.Company = “USMF”;

SalesOrderService.AxdEntity_SalesTable[] _SalesOrderList = _Client.read(_callContext, entityKeys);

SalesOrderService.AxdEntity_SalesTable _SalesOrderTable = _SalesOrderList.First();

SalesOrderService.AxdEntity_SalesLine SalesLine = _SalesOrderTable.SalesLine.First();

decimal salesQty = 50;

SalesLine.SalesQty = salesQty;

_Client.update(_callContext, entityKeys, _SalesOrderList);

Delete method code

 

SalesOrderService.KeyField keyField = new SalesOrderService.KeyField() { Field = "SalesId", Value = "000757" };

// Create an entity key instance and put in the key field data

SalesOrderService.EntityKey entityKey = new SalesOrderService.EntityKey();

entityKey.KeyData = new SalesOrderService.KeyField[1] { keyField };

// Create an array of entity keys and put in the previously

SalesOrderService.EntityKey[] entityKeys = new SalesOrderService.EntityKey[1] { entityKey };

SalesOrderService.SalesOrderServiceClient _Client = new SalesOrderService.SalesOrderServiceClient();

SalesOrderService.CallContext _callContext = new SalesOrderService.CallContext();

_callContext.Company = “USMF”;

_Client.delete(_callContext, entityKeys);

Trouble shooting AIF service.

There are many possible failure of sales service call, You can trouble shoot it from  System Administration section as

During writing code and I got many failures, All exceptions recorded here.