Items on Sales Orders appear closed before invoicing

We are researching this issue. Please add any insight or additional information.

-If you would like to be notified of progress and/or resolution for this issue, click the Subscribe button at the lower right corner to subscribe to this discussion. You can also use RSS Feed.

*Note:

As a subscriber, you will receive email when a new post is entered on this discussion by other users or by Intuit. If you prefer not to subscribe, you can add this Web page to your Internet browser's Favorites list and check back periodically for updates.

It only seems to happen when you are entering 0 in the qty col. The quick fix is to go back to the sales order enter your initials in the body of the sales order and save. This lets you know who made the change and verify that it was done. The invoice will then kick back all the backorders to the sales order and correct the invoice. I know this sounds too easy but it works. Just remember not to send or print the invoice until you do this to the sales order. From this point it looks as though Quick Books picks everything up okay for reports and such.

Good News, We think we have found the cause to this problem. If you are using Unit of Measure or Group items Intuit has found a defect in our 2009 product. The defect causes items to close on a Sales Order that should not close and the user does not have the option to reopen the items. This only happens to Inventory Items that have Unit of Measure turned on or Group Items.

The other good news is that we have found a simple work around to reopen your closed items.

Go to the description field of the first blank line in the Sales Order that has items closed that should not be closed and enter three characters (***, 123, ---) any characters you choose. Save the sales order clicking yes to the warning about changes. The Sales Order and it will recalculate when you save it. When you reopen the Sales Order it will be correct. If you again partially Invoice from this Sales Order you will again have to return and add three characters to the description field of a NEW blank line.

If you find that Inventory and Sales Order reports are still incorrect you will need to run a rebuild of your company file in order to correct reports. This is done by The QuickBooks Admin Only and in Single User Mode. Go to File then Utilities, and then Rebuild Data and your reports will be corrected.

For screen shots and a more through explanation go to:

http://community.intuit.com/wi...

# 14 under Frequently Asked Questions

Intuit is aware if the problems this defect is causing our customers and we are working day and night to correct the software and implement a more permanent fix. We will post to the communities as soon as we implement this correction.

Intuit now has a patch for this problem.

Please update your file to the R6 patch, going forward your Sales Orders will partially invoice correctly and the sales order will correctly reflect what is on backorder. Inventory reports will now correctly reflect the items invoiced.

Previously created sales orders will need to be corrected and the file rebuilt for items to reflect correctly in an Inventory Report.

To find out if you have any previously inaccurate sales orders, run a Verify on your file after installing the patch (R6). Refer to KB article 1011460 for step by step instructions. http://support.quickbooks.intuit.com/Support/Pages/KnowledgeBaseArticle/1011460

Users will need to check the qbwin.log to find the transactions that have been affected. KB 1011461 will walk you through the steps of looking at the qbwin.log and finding any affected Sales Orders. http://support.quickbooks.intuit.com/Support/Pages/KnowledgeBaseArticle/1011461

When you have identified the erroneous sales orders you will need to correct them by adding three characters to the first blank line in the description field of the sales order ( Example: abc, ...,123) and save the sales order. After correcting all the transactions users will need to Rebuild their file to correct Inventory reports. Step by step instructions can be found in KB article 1011462 http://support.quickbooks.intuit.com/Support/Pages/KnowledgeBaseArticle/1011462

To look at screen shots and a more through explanation of the problem go to:

http://community.intuit.com/wi...

# 14 under Frequently Asked Questions.