Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 30, 2020
Question

Invoice only pulled some items from the sales order

  • January 30, 2020
  • 1 reply
  • 7 views

Hi All!

 

I've got a problem with one of our reports. We create an open order report every week to make sure we keep track of open orders/due dates. 

 

On our latest report, we show some open items that shouldn't be open. The sales order contains about 15 line items. Some have the same ship date and some have different ship dates. For this example, we shipped out 6 line items and invoiced. Sales order shows 4 items as invoiced and closed, but 2 of the items are still showing open. All items were invoiced the same way

**create invoice----->type customer name ------>select from open sales order -------->create invoice for selected items------>check item and fill out to invoice box**

 

I just don't understand how 4 items from the sales order show invoiced and closed, while the other 2 items show not invoiced and remain open. 

1 reply

AlexV
Level 10
January 30, 2020

Let's first make sure that the invoice has the correct quantity, joneill1186.

 

We can open the invoice so we can verify the invoiced quantity. Go to the Customers menu and select Customer Center. Go to the customer's profile and double-click on the transactions to open it. You can update the quantity in the Invoiced field, if needed.

 

If the invoice looks good but the report still show incorrect number, let's rebuild your company file. This process will check if this error is a result of a company data issue. Let's do the Verify Data first:

  1. Go to File menu and select Utilities.
  2. Choose Verify Data.
  3. Wait for it to load, and select OK.

Here's how to rebuild it:

  1. From File > Utilities > Rebuild Data.
  2. Follow the on-screen details in creating a  back-up file.
  3. Select OK when it's done.

Pull up the report again to see if the data is correct. Here are some of the articles I want to share about sales order:

Don't hesitate to reach out to us again. We'll be here to help. Wishing you all the best!