Scripting

Sage 100 eWebServices QuestionWe are using SoapUI

  • 1.  Sage 100 eWebServices QuestionWe are using SoapUI

    Posted 11-29-2018 15:42
    Sage 100 eWebServices Question We are using SoapUI to try and submit an order to a test company in Sage 100. It appears the webservice is fully setup, we can get next sales order no, we can pull up current existing sales orders. When we go to create one though it keeps failing saying there are no lines for the order. We have checked for required fields etc..to make sure we were not missing something. This is the SOAP request <soapenv:Envelope xmlns:soapenv=""http://schemas.xmlsoap.org/soap/envelope/"" xmlns:ws=""http://mas90.sage.com/ws""> <soapenv:Header/> <soapenv:Body> <ws:CreateSalesOrder> <ws:logon> <ws:Password>XXXXXX</ws:Password> <ws:Username>XXXXXX</ws:Username> </ws:logon> <ws:companyCode>EDI</ws:companyCode> <ws:salesOrder> <ws:SalesOrderNo>0593175</ws:SalesOrderNo> <ws:ARDivisionNo>00</ws:ARDivisionNo> <ws:CustomerNo>PP0240</ws:CustomerNo> <ws:Lines> <ws:SalesOrderLine> <ws:ItemCode>OR-102258</ws:ItemCode> <ws:QuantityOrdered>6</ws:QuantityOrdered> </ws:SalesOrderLine> </ws:Lines> </ws:salesOrder> </ws:CreateSalesOrder> </soapenv:Body> </soapenv:Envelope> This is the response back we are getting back <s:Envelope xmlns:s=""http://schemas.xmlsoap.org/soap/envelope/""> <s:Body> <s:Fault> <faultcode xmlns:a=""http://mas90.sage.com/ws"">a:SO_NoLines</faultcode> <faultstring xml:lang=""en-US"">Could not write to SO_SalesOrder_Bus: This Order has no lines and has zero total amounts.</faultstring> <detail> <MasFault xmlns=""http://mas90.sage.com/ws"" xmlns:i=""http://www.w3.org/2001/XMLSchema-instance""> <ClassName>SO_SalesOrder_Bus</ClassName> <ErrorCode>SO_NoLines</ErrorCode> <ErrorMessage>This Order has no lines and has zero total amounts.</ErrorMessage> <MemberName>Write</MemberName> </MasFault> </detail> </s:Fault> </s:Body> </s:Envelope> Is there something wrong with the structure above? Anyone have any good ideas/pointers?