Open Sales Order by Customer

epurcell · ‎April 19, 2022

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!

epurcell · ‎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?

ZackE · ‎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!

epurcell · ‎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.

Candice C · ‎April 21, 2022

Good morning, @epurcell.

Thanks for coming back and clarifying what you needed help with. Let's work together so we can figure out why this sales orders are showing up as open when they are paid in the Open Sales Order report.

Trying some troubleshooting steps could help in this case. When using our Verify and Rebuild tool, it can eliminate any common glitches or errors that are occurring in your system. Here's how:

Verify Data:

Choose Window and then Close All.
Go to the File menu.
Hover over Utilities and select Verify Data.

Rebuild Data:

Go through steps 2-3 from above. Note: Instead of picking Verify, choose Rebuild Data.
Hit OK to backup your company file.
After the backup is done and you have saved it, the tool will start.
Tap OK when you get a message saying, "Rebuild has completed."

This should do the trick. If not, please come back and give us some additional information so we can determine the best solution for your business. Have a great day!

Topics

Training

Community

Resources

Open Sales Order by Customer