Method Community

Hi,

I encountered an issue that some SaleOrderLine records are gone for no reason, and I can not find any audit log that delete thos item either in Method or QuickBooks log.

Here is what I did:

1. Create a new Sales Order

2. In a loop of a grid (associated with a customize table created in Method), it will create 23 SaleOrderLine item. Once a SalesOrderLine record is created, I'll save its RecordID to another table (Table MyLinkedTxn).

3. After step 2, I checked MyLinkedTxn and can find all 23 RecordID of SaleOrderLine. However, I can not find some records in SalesOrderLine table. In my case, I expect to see records of SalesOrderLine which RecordID are from 3168 to 3190 (total 23 records.) but I can not find those records which RecordID are from (3180 to 3185).

It seems that either those records are removed for some reasons, or it failed to create those SalesOrderLine but still returned their RecordID and reports no error. 

So far, I met this error once (my client reported once.) Can you give some suggestion about how to debug these kind of error?

Thanks.

===== here is the audit trail log from QuickBooks regarding this sales order, seems that there are only 17 salesorderline are created and sent to QuickBooks. =====

=====================

Alex