# HOW TO USE SQL TO TROUBLESHOOT A GP SOP ORDER THAT DID NOT MOVE TO HISTORY WHEN IT WAS FULLY INVOICED – Microsoft Dynamics GP Community

- URL: https://dynamicaccounting.net/how-to-use-sql-to-troubleshoot-a-gp-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced-microsoft-dynamics-gp-community/
- Date: 2020-04-27
- Topics: Sales, Purchasing & Inventory, SQL & Data, Tips & Hidden Features
- Type: link to an external article
- Source: https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced

From the GP team comes info on troubleshooting a SOP order that didn’t move to history via SQL

There are two major reasons why an order did not move to history when it is transferred to an invoice. The first is that there is an amount remaining in several columns in the SOP10200. The second the…  
— Read on [community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced](https://community.dynamics.com/gp/b/dynamicsgp/posts/how-to-use-sql-to-troubleshoot-a-sop-order-that-did-not-move-to-history-when-it-was-fully-invoiced)