QuickBooks HelpQuickBooksHelpIntuit

Some Sales Orders or Estimates may be incorrectly marked as closed

SOLVEDby QuickBooksUpdated over 1 year ago

Corrupted transaction data may be causing the following error when working in QuickBooks Desktop:

Problem: Some Sales Orders or Estimates may be incorrectly marked as closed or display incorrect invoiced quantities.

To troubleshoot this error, you need to locate and repair the damaged transactions.

  1. Identify the affected transactions.
    1. Verify your company file's data integrity by going to File > Utilities > Verify Data.
    2. To identify the corrupted transactions, open QBWin.log.
    3. A typical Sales Order or Estimate in QBWin.log  will look like the image below. Write down the doc# for every damaged transaction.User-added image
  2. Create a Custom Transaction Detail report to locate the damaged transaction in QuickBooks.
    1. From the Reports menu, select Custom Reports and choose Transaction Detail.
    2. On the Display tab, set the date range for the affected transactions.
    3. In the Columns section, select Trans #.
    4. Go to the Filters tab.
    5. Search for and select the Transaction Type filter, then click the drop-down menu to select your desired transaction type.
    6. Search for and select the Posting Status filter, then choose Non Posting.
    7. To generate the report, click OK.
    8. In the upper right, select the Sort By drop-down and choose Trans #.
  3. Repair the affected transactions.
    1. Find the doc# on the report.
    2. QuickZoom (double-click) on the transaction.
    3. Follow these steps to repair the transaction.
      Tip! Adding a period to a field in a transaction and saving it is usually sufficient to repair the transaction. If that doesn't work, try each of the repair solutions until you find one that works in your situation.
  4. Repeat steps 1-3 for all damaged transactions.
  5. To make sure all damaged transactions are now fixed, verify your data again.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Desktop AccountantQuickBooks Desktop PremierQuickBooks Desktop ProQuickBooks Enterprise QuickBooks Enterprise AccountantQuickBooks Enterprise Diamond

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this