Παραθέτω την λυση για όποιον ενδιαφέρεται
Dim sql As String = "UPDATE SERIES SET SOISCONV = 0 WHERE SERIES = 11046"
Dim affected As Integer = s1Conn.ExecuteSQL(sql)
'MsgBox("Ενημερώθηκαν σειρές: " & affected)
'XSupport.CallFunction(s1Conn, "GENERAL", "RefreshMemoryTable", "SERIES")
Dim xTable = s1Conn.GetMemoryTable("SERIES", True)
NPurDocTable.Current("SERIES") = SafeInt(dtSalDoc(0)!SERIES) '11046 'CInt(SalDocTable.Current("SERIES"))
sql = "UPDATE SERIES SET SOISCONV = 1 WHERE SERIES = 11046"
affected = s1Conn.ExecuteSQL(sql)
xTable = s1Conn.GetMemoryTable("SERIES", True)