Inventory dimension identification not specified - Creating Sales Order - AIF

(0) Share

Report

Posted on by Community Member

Hello all,

I am creating sales order using AIF. I faced many issues which were solved with your help and assistance in one of my other forum post.

Currently I am facing following exception/error in Exception section System Administration -> Periodic -> Service and Application Integration Framework -> Exceptions

I even tried using different (multiple) InventDimId from INVENTDIM table (for SalesLine table) but still getting the same issue.

Here is the code I am using (Screenshot)

7774.error.jpg

Please, if anyone can help?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Please give details of exception you are getting. Also try to assign inventdim ID in the following way .

inventDim = salesLine.inventDim();
inventDim.InventSiteId = "01";

if you have warehouse and other inventory dimensions then you should specify those

e.g inventDim.InventLocationId = "99";

salesLine.setInventDimIdFromInventDim(inventDim);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When I used

inventDim = salesLine.inventDim();

I got the compiler error

Non-invocable member "inventDim" cannot be used like a method.

Moreover setInventDimIdFromInventDim method is not available for salesLine.

I am using MS Dynamics AX 2012.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report
try this for invent dim creation but you didn't tell in your post what exception you are getting.

AxdEntity_InventDim inventDim = new AxdEntity_InventDim(); inventDim.InventSiteId = "1"; inventDim.InventLocationId = "2"; salesLine.InventDim = new AxdEntity_InventDim[1] { inventDim }; salesTable.SalesLine = new AxdEntity_SalesLine[1] { salesLine }; salesOrder.SalesTable = new AxdEntity_SalesTable[1] { salesTable };

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the detailed reply.

I tried this but now I am getting following 2 exceptions

Error found when validating record.

Update has been canceled.

Here is screenshot of my exception window. (I am ignoring Warnings at the moment and focusing on errors only).

None of these warning or error was there before using your code. Also I made sure that I am using correct SiteId and LocationId from InventDim table. I even tried using inventDim.InventDimId="XXXXXXX"; but same warninngs and errors.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report
Ok .Look at below code and see what you are missing. This code works. not sure what you are doing wrong.

SalesOrderServiceClient proxy = new SalesOrderServiceClient(); AxdEntityKey_LogisticsPostalAddress addressKey; CallContext _callContext = new CallContext(); _callContext.Company = "comp1"; AxdSalesOrder salesOrder = new AxdSalesOrder(); AxdEntity_SalesTable salesTable = new AxdEntity_SalesTable(); salesTable.CurrencyCode = "USD"; salesTable.CustAccount = "US01"; salesTable.DeliveryDate = Convert.ToDateTime("8/14/2016"); salesTable.ReceiptDateRequested = Convert.ToDateTime("8/14/2016"); salesTable.Payment = "Net1"; salesTable.PurchOrderFormNum = "PO"; AxdEntity_SalesLine salesLine = new AxdEntity_SalesLine(); salesLine.ItemId = "item1"; salesLine.SalesQty = 1; salesLine.SalesUnit = "ea"; AxdEntity_InventDim inventDim = new AxdEntity_InventDim(); inventDim.InventSiteId = "1"; inventDim.InventLocationId = "2"; salesLine.InventDim = new AxdEntity_InventDim[1] { inventDim }; salesTable.SalesLine = new AxdEntity_SalesLine[1] { salesLine }; salesOrder.SalesTable = new AxdEntity_SalesTable[1] { salesTable }; EntityKey[] returnedSalesOrderEntityKey = proxy.create(_callContext, salesOrder); EntityKey returnedSalesOrder = (EntityKey)returnedSalesOrderEntityKey.GetValue(0); Console.WriteLine("The sales order created has a Sales ID of " + returnedSalesOrder.KeyData[0].Value); Console.ReadLine();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I am using your code, just have replaced

Company with my company

CustAccount to one of my customer account.

Delivery Date and Receipt Date Requested to a future date

Payment to a record of my system (N30)

InventDimID, Location ID and Site id for InventDim to an existing record of my database.

ItemID to an actual ID

But still I am getting above errors and warnings. What can be a work around. How can I troubleshoot. How can I know that which field was not validated which caused Update cancel.

Here is my code

SalesOrderServiceClient proxy = new SalesOrderServiceClient(); //AxdEntityKey_LogisticsPostalAddress addressKey; CallContext _callContext = new CallContext(); _callContext.Company = "ART"; AxdSalesOrder salesOrder = new AxdSalesOrder(); AxdEntity_SalesTable salesTable = new AxdEntity_SalesTable(); salesTable.CurrencyCode = "USD"; salesTable.CustAccount = "11224"; salesTable.DeliveryDate = Convert.ToDateTime("10/12/2017"); salesTable.ReceiptDateRequested = Convert.ToDateTime("10/14/2017"); salesTable.Payment = "N30"; salesTable.InventLocationId = "10"; salesTable.InventSiteId= "1"; salesTable.PurchOrderFormNum = "A875891"; AxdEntity_SalesLine salesLine = new AxdEntity_SalesLine(); salesLine.ItemId = "PF201292"; salesLine.SalesQty = 1; salesLine.SalesUnit = "EA"; salesLine.InventDimId = "ART00000001"; AxdEntity_InventDim inventDim = new AxdEntity_InventDim(); inventDim.InventSiteId = "1"; inventDim.InventLocationId = "10"; inventDim.InventDimId = "ART00000001"; salesLine.InventDim = new AxdEntity_InventDim[1] { inventDim }; salesTable.SalesLine = new AxdEntity_SalesLine[1] { salesLine }; salesOrder.SalesTable = new AxdEntity_SalesTable[1] { salesTable }; EntityKey[] returnedSalesOrderEntityKey = proxy.create(_callContext, salesOrder); EntityKey returnedSalesOrder = (EntityKey)returnedSalesOrderEntityKey.GetValue(0); lblOutput.Text = "The sales order created has a Sales ID of " + returnedSalesOrder.KeyData[0].Value;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Exceptions I am getting ar

1. Error found when validating record.
2. Update has been canceled.

Screenshot

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Before providing Invent Dim I was getting Inventory dimension identification not specified exception.

Screenshot

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

try to debug it

msdn.microsoft.com/.../jj710372.aspx

https://community.dynamics.com/ax/b/dynamicsaxsolutions/archive/2015/11/25/debug-from-visual-studio-x-code-running-on-the-server-ax-2012

Was this reply helpful? Yes No
source258147 1,025 on at

Like (0)

Report
Could you please explain from where you got this class

AxdSalesOrder salesOrder = new AxdSalesOrder();

Was this reply helpful? Yes No