Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 19, 2022
Question

Open Sales Order by Customer

  • April 19, 2022
  • 4 replies
  • 9 views

Hello Community, 

 

I ran an Open Sales Order report to identify which customers still require invoicing. I am seeing some sales orders on this report which have already been paid in full. These sales orders have multiple progress invoices associated with them.   I can not figure out why they are showing up as unpaid/open.  

 

A few notes...

1. I checked the original sales order to be sure the all invoices are linked to the original SO. They are.

    * with that said, an additional charge for freight was added directly to an invoice after it was created. Does        this have an effect on the invoice when paid causing the SO to still show a balance? 

 

I have attached an example.  There were 2 invoices created from the original SO. Inv 3380 $10,259 was paid. The original amount of the invoice before adding the additional freight charge directly to the invoice $9.983. This is the amount that is showing as the open balance. 

 

Is there a better report I can run for Open sales orders? 

 

Thank you!

4 replies

epurcellAuthor
April 19, 2022

Also as a follow up, I have another SO for which a credit was used for a payment. That SO is also showing upas having an open balance although all payments/credits have been applied. Thoughts?

Moderator
April 19, 2022

Thanks for getting in touch with the Community, epurcell. I appreciate your screenshot and detailed information.

 

After reviewing all of our available reports for QuickBooks, the Open Sales Order report would be the best one to use to identify customers that require invoicing.

 

Additionally, you can work with an accounting professional to properly identify which report would work best for identifying this. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

I'll be here to help if there's any questions. Have a great day!

epurcellAuthor
April 21, 2022

Thank you but my question is not which report to run. I am asking why sales orders are showing up as open when they have been paid.