45
I created the Purchase Order Header by SOAP, It created successfully but when I created the Purchase Order Line. I have received the following exception.
"The field No. of table Purchase Line contains a value (1100) that cannot be found in the related table (Standard Text)."
I also change the Item No but nothing happens. where 1100 is the Item No.
*This post is locked for comments
I was adding a GL Account. but now the issue has been solved because we also have to give the TypeSpecified = True; for adding the type. Thanks for the help.
we are talking about this line
poLine1.Type = POServiceReference.Type.G_L_Account;
it should be Item
Hi,
Currently type is GL Account. It must be item then mention the item no.
Here is my code as you can see my provided fields but I am unable to create a PO with Lines or insert(update) into the existing PO.
BasicHttpBinding binding = new BasicHttpBinding();
binding.Security.Mode = BasicHttpSecurityMode.TransportCredentialOnly;
binding.Security.Transport.ClientCredentialType = HttpClientCredentialType.Ntlm;
POServiceReference.PO_PortClient portClient = new POServiceReference.PO_PortClient(binding,new EndpointAddress(POurl));
POServiceReference.PO po = new POServiceReference.PO();
var PurOrd = portClient.Read("46185");
po.Buy_from_Vendor_No = "156";
po.Vendor_Invoice_No = "Test 2";
po.Buy_from_Vendor_Name = "Test 2";
po.Document_Date = DateTime.Now;
po.Posting_Date = DateTime.Now;
POServiceReference.Purchase_Order_Line[] ArrayPOLines = new POServiceReference.Purchase_Order_Line[1];
POServiceReference.Purchase_Order_Line poLine1 = new POServiceReference.Purchase_Order_Line();
poLine1.Type = POServiceReference.Type.G_L_Account;
poLine1.No = "65030";
poLine1.Quantity = 20;
poLine1.Direct_Unit_Cost = 100;
ArrayPOLines[0] = poLine1;
po.PurchLines = ArrayPOLines;
portClient.Create(ref po);
Hi,
Please mention the item in type field in that line. and then mention item no. in no. field.
you need to set type field to Item before setting No field.
#1
André Arnaud de Cal...
292,492
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
