Sales Transactions with No Lines or Incorrect Totals in Microsoft Dynamics GP

On occasion, SOP transactions can be created that just don't add up. For example, the sum of the extended prices is not the same as the Order Total or all of the line items entered on the order have disappeared. This occurs infrequently and most people simply try to delete the transaction and re-enter it. This is awkward when document numbers or printouts have been given to the customer or when there are a lot of line items. 

Try this first. Run the Remove/Reconcile Utility process against the one sales transaction. Take the reconcile option only.  This will recalculate the order totals and frequently fixes SOP transactions. If this does not correct the transaction, perhaps the damage is greater than expected. Use the SQL Server Management Studio (2005) or Enterprise Manager (2000) to open the SOP10100 table. Locate the sales transaction in question by the document number and examine the data. If no customer number is listed, the order cannot be opened using Dynamics GP.  Enter an appropriate customer number, name, et cetera. This should allow the document to be opened in Dynamics GP and completed.