QuickBooksHelpIntuit
Some Sales Orders or Estimates may be incorrectly marked as closed
by Intuit• Updated 3 months 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.
- Identify the affected transactions.
- Verify your company file's data integrity by going to File > Utilities > Verify Data.
- To identify the corrupted transactions, open QBWin.log.
- A typical Sales Order or Estimate in QBWin.log will look like the image below. Write down the doc# for every damaged transaction.
- Create a Custom Transaction Detail report to locate the damaged transaction in QuickBooks.
- From the Reports menu, select Custom Reports and choose Transaction Detail.
- On the Display tab, set the date range for the affected transactions.
- In the Columns section, select Trans #.
- Go to the Filters tab.
- Search for and select the Transaction Type filter, then click the drop-down menu to select your desired transaction type.
- Search for and select the Posting Status filter, then choose Non Posting.
- To generate the report, click OK.
- In the upper right, select the Sort By drop-down and choose Trans #.
- Repair the affected transactions.
- Find the doc# on the report.
- QuickZoom (double-click) on the transaction.
- 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.
- Repeat steps 1-3 for all damaged transactions.
- To make sure all damaged transactions are now fixed, verify your data again.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Create a sales orderby QuickBooks•Updated June 19, 2024
- Email or print multiple sales forms in QuickBooks Onlineby QuickBooks•110•Updated 2 days ago
- Release notes for QuickBooks Desktop 2024by QuickBooks•7•Updated 1 day ago
- Copy an estimate to a purchase order in QuickBooks Onlineby QuickBooks•21•Updated May 17, 2024