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

Sales, Purchasing & Inventory SQL & Data Tips & Hidden Features

Archived post from 2020. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

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

Original article: 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