Web Services DeleteLines

Question

Hello. I'm looking for advice on using the DeleteLines method in web services to delete sales order lines as part of an application that moves open SO lines. (It creates lines on a new or current sales order, then deletes them from the source order.) 
 I can get DeleteLines to delete a single line, but I can't get it do delete multiple lines at once. 
 This works fine: 
 Dim tLineKey(0) As String tLineKey(0) = "1" r = ws.deleteLines(cc, "ZSOH", pk, "SOH4~NBLIG", tLineKey) 
 
 This causes a webservice error: 
 Dim tLineKey(1) As String tLineKey(0) = "1" tLineKey(1) = "2" r = ws.deleteLines(cc, "ZSOH", pk, "SOH4~NBLIG", tLineKey) 
 
 The server says: ErrNum=[8] ErrLine=[0] ErrPgm=[] ErrTyp=[1] ErrMess=[ARGUMENT10(1) : Index Incorrect] The server says: **Exception** - Class[CCommException] ErrNum=[8] ErrLine=[0] ErrPgm=[] ErrTyp=[1] ErrMess=[ARGUMENT10(1) : Index Incorrect] 
 
 The "Line Keys" is a string array, so I'd expect it to take more than one value at a time. Or I'm totally wrong and there's a better way to go about this. 
 Thanks

Delamater · Answer

Yes, the key parameter, your third parameter is an array of keys. However, does the sales order have multiple lines for which to delete? Your code doesn't perform a read on the ZSOH object to discover the number of lines before attempting to delete. I can appreciate that's likely because you wanted to keep the example short here, but I wonder, if you perform a read first, which you can do using the web services tester, then check the max of the line numbers, then build those line numbers in your tLineKey what would happen? 
 
Also consider, perhaps the line number key is not monotonically increasing.

Barak · Answer

Hi
you can't delete more than one line at one time using this method.
as far I understand the reason is that once you delete a line (LIN) the object has changed the rows are resorted.
for example if you have 5 lines and you delete line #3 then now LIN #5 become LIN #4 and LIN #4 bcome LIN# 3. (1 and 2 does not change in this case).
X3 web service delete each line in a loop and the LINs get resorted).
so if you have more then one line to delete , you have to read after each delete to get the right LIN.

another approche to delete more than 1 line is to read the SOH object and then recreate the XML by deleteing from it the lines you want to delete,( and reordering by yourself the LIN NUM ,) and then use the Modify method with the new XML
remember that LIN NUM must be 1,2,3,4... no gaps as these correspond to the nolign grid variable.
(the SOPLIN in the table can have gaps. i.e : 1000, 2000, 4000 etc..)

hope that helps
Barak

Sage X3

Web Services DeleteLines

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING