Method:Classic General Q&amp;Ahttp://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)some records in SaleOrderLine are gonehttp://forums.method.me/cs/forums/thread/28813.aspxThu, 10 Sep 2015 00:07:03 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:28813alexhuang0http://forums.method.me/cs/forums/thread/28813.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=28813<p>Hi,</p> <p>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.</p> <p>Here is what I did:</p> <p></p> <p>1. Create a new Sales Order</p> <p><span id="mce_6_start" style="overflow:hidden;"></span>2. In a loop of a <span id="mce_13_start" style="overflow:hidden;">grid (associated with a&nbsp;</span>customize table&nbsp;created in Method), it will create 23 SaleOrderLine item. Once a SalesOrderLine record is created, I&#39;ll save its RecordID to another table<span id="mce_0_start" style="overflow:hidden;"> (Table <span id="mce_1_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;"></span>My</span>Link<span id="mce_2_start" style="overflow:hidden;"><span id="mce_3_end" style="overflow:hidden;"></span></span><span id="mce_5_start" style="overflow:hidden;"></span>ed<span id="mce_4_start" style="overflow:hidden;"><span id="mce_5_end" style="overflow:hidden;"></span></span>Txn)</span>.</p> <p><span id="mce_6_end" style="overflow:hidden;"></span>3. After step 2, I checked&nbsp;<span id="mce_7_start" style="overflow:hidden;">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).</span></p> <p><span style="overflow:hidden;">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.&nbsp;<span id="mce_8_start" style="overflow:hidden;"></span></span></p> <p><span id="mce_10_start" style="overflow:hidden;">So far,<span id="mce_11_start" style="overflow:hidden;"></span> I met this error once (my client reported once.)&nbsp;</span>C<span id="mce_9_start" style="overflow:hidden;"></span>an you give some suggestion about how to debug these kind of error?<span id="mce_0_start" style="overflow:hidden;"></span><span id="mce_12_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;"></span><br /></span></p> <p><span style="overflow:hidden;">Thanks.</span></p> <p><span style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;">===== 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.<span id="mce_7_start" style="overflow:hidden;"></span><span id="mce_6_start" style="overflow:hidden;"></span> =====</span></span></p> <p><span style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;"></span></span></p> <table cellpadding="0" cellspacing="0"> <tr> <td colspan="2">Sales Order 1500827</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td align="right">1500827</td> <td class="xl65" align="right">9/9/2015 15:51</td> <td>Admin</td> <td>Latest</td> <td class="xl66" align="right">9/9/2015</td> <td>CONTAINER WEST SALES LTD.</td> <td></td> <td>90200 &middot; Sales Orders</td> <td>-SPLIT-</td> <td align="right">30600</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>TED WANG</td> <td>NO Sales Tax FOR DROP SELL TO OUT OF STATE</td> <td>25500 &middot; Sales Tax Payable</td> <td>90200 &middot; Sales Orders</td> <td align="right">0</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td align="right">1500827</td> <td class="xl65" align="right">9/9/2015 15:30</td> <td>Admin</td> <td>Prior</td> <td class="xl66" align="right">9/9/2015</td> <td>CONTAINER WEST SALES LTD.</td> <td></td> <td>90200 &middot; Sales Orders</td> <td>-SPLIT-</td> <td align="right">21600</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>TED WANG</td> <td>NO Sales Tax FOR DROP SELL TO OUT OF STATE</td> <td>25500 &middot; Sales Tax Payable</td> <td>90200 &middot; Sales Orders</td> <td align="right">0</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td align="right">1500827</td> <td class="xl65" align="right">9/9/2015 15:27</td> <td>Admin</td> <td>Prior</td> <td class="xl66" align="right">9/9/2015</td> <td>CONTAINER WEST SALES LTD.</td> <td></td> <td>90200 &middot; Sales Orders</td> <td>-SPLIT-</td> <td align="right">10800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>TED WANG</td> <td>NO Sales Tax FOR DROP SELL TO OUT OF STATE</td> <td>25500 &middot; Sales Tax Payable</td> <td>90200 &middot; Sales Orders</td> <td align="right">0</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td align="right">1500827</td> <td class="xl65" align="right">9/9/2015 15:25</td> <td>Admin</td> <td>Prior</td> <td class="xl66" align="right">9/9/2015</td> <td>CONTAINER WEST SALES LTD.</td> <td></td> <td>90200 &middot; Sales Orders</td> <td>-SPLIT-</td> <td align="right">9000</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>TED WANG</td> <td>NO Sales Tax FOR DROP SELL TO OUT OF STATE</td> <td>25500 &middot; Sales Tax Payable</td> <td>90200 &middot; Sales Orders</td> <td align="right">0</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td align="right">1500827</td> <td class="xl65" align="right">9/9/2015 15:24</td> <td>Admin</td> <td>Prior</td> <td class="xl66" align="right">9/9/2015</td> <td>CONTAINER WEST SALES LTD.</td> <td></td> <td>90200 &middot; Sales Orders</td> <td>-SPLIT-</td> <td align="right">5400</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>CONTAINER WEST SALES LTD.</td> <td>20&#39; GP NEW CONTAINER</td> <td>40000 &middot; Sales</td> <td>90200 &middot; Sales Orders</td> <td align="right">-1800</td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td>TED WANG</td> <td>NO Sales Tax FOR DROP SELL TO OUT OF STATE</td> <td>25500 &middot; Sales Tax Payable</td> <td>90200 &middot; Sales Orders</td> <td align="right">0</td> </tr> </table> <p><span style="overflow:hidden;"><span id="mce_5_start" style="overflow:hidden;">=====================</span><br /></span></p> <p><span style="overflow:hidden;">Alex<span id="mce_4_start" style="overflow:hidden;"></span><span id="mce_3_start" style="overflow:hidden;"></span></span></p>