Make sure all items have price list entries.

I fixed the pricelist warnings but still have the exception with 0 errors in Session.Errors

I'd create a public variable and update it with the current item being used in any operation.  Add the variable to all error traps' output so you have your item reference.

I already log just about everything that I can. The  price list warnings were a red herring and have been dealt with. Obviously there is something wrong with deleting this and 2 other items because Sage is through an exception. I can't think of why it would do that and then not have anything in the Errors collection. A lot of items are being added and deleted in the process for this single order. These "bad" deletions also do not happen together.

The basic flow is:

1. Setup the Views
2. Do an Init on the Orders view
3. Set the ORDNUMBER
4. Set the key to 1
5. Do a Read
6. Process the Detail Items

Add Detail Item Processing:

1. If the item goes at the end of the list:
   1. Browse with a filter of LINETYPE = "1"
   2. Go to Bottom
2. If the items goes between to existing items:
   1. Browse with a filter of ITEM = "<ITEMNUMBER>"
   2. Fetch
   3. Read
3. Record Create
4. Set fields
5. Insert into the Details View

Delete Detail Item Processing:

1. Go to Top
2. Browse with a filter of ITEM = "<ITEMNUMBER>"
3. Read
4. Delete

After all of the Detail Items are processed, I do an Update on the Orders View.

This works for all of the orders that have been processed and it works for the majority of the items in this particular order

If you have shipped a single item, you cannot delete lines.

In addition to Jay's response I'll add: ALWAYS set your keys back to 0 before inserting/updating. Otherwise, you can get updates that 'kind of work' and misleading errors.  If you want to find a record based on the order number, set to key to 1, do the read and then set the key to 0. It won't change the record that you're looking at.

I will give it a try.

Just highly annoyed that there is no error in the session. Makes impossible to know what is going on especially when other inserts/delete work find

No change.

Question: I do an Init, set ORDNUMBER, set Order and then do a read. for the detail I do a GoTop, browse, then a Read and then the Delete. Do I need to do a Fetch in there somewhere?

I have an object that wraps around the order views so I use the following to navigate to an order.

public function ReadOrderNumber(aOrderNumber as string) as Boolean
    OEOrderHeader.Cancel
    OEOrderHeader.Order = 1
    OEOrderHeader.Fields("ORDNUMBER").PutWithoutVerification aOrderNumber
    ReadOrderNumber = OEOrderHeader.Read
    OEOrderHeader.Order = 0

end function

For the detail lines, I have a few functions. This one will use the key field and because I'm filling all of the keys of the index I can use .Read.

Public Function FindDetail_LineNo(aOrderLineNo As Long) As Boolean

    FindDetail_LineNo = False
    With OEOrderDetail
        .Order = 0
        .Fields("LINENUM").PutWithoutVerification (aOrderLineNo)

        If .Read Then
            FindDetail_LineNo = True
            LastOELineNumber = .Fields("LINENUM").value
        End If

    End With

End Function

And this version will search using the DETAILNUM field.  I could be more efficient and change the order to a better key but I didn't.  So this version uses browse/fetch.

Public Function FindDetail_DetailNum(aOrderLineDetailNum As Long) As Boolean

    FindDetail_DetailNum = False
    With OEOrderDetail
        .Fields("LINENUM").PutWithoutVerification -32000

        .Browse "DETAILNUM=" & aOrderLineDetailNum, True

        If .Fetch Then
            FindDetail_DetailNum = True
            LastOELineNumber = .Fields("LINENUM").value
        End If

    End With

End Function