Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi, I'm trying to create a report for backorders that was unable to fill (NOT open backorders) for last quarter so I can see how much money I lost by not having enough inventory.
For example, a report that shows the unfulfilled line-items on sales orders that were closed rather than invoiced.
I know this is possible because I inadvertently came across a report that showed this in December when I was doing some year-end analysis and was shocked and appalled but how much money was left on the table due to insufficient inventory, but now for the life of me cannot find how I pulled that report.
Please note this is NOT a report showing open backorders (which are the only tutorials I was able to find thru search), but a report showing CLOSED backorders that were never shipped/invoiced.
I have quickbooks desktop.
Solved! Go to Solution.
Hi there, @gbody. I'm here to provide additional steps to show both open and closed backorders.
Here's how:
I'd suggest memorizing this report so you can access it in the future. You can also export the report to Excel. This way, it can be saved, stored, and transferred digitally if needed.
I'd be happy to help should you have any follow-up questions about customizing reports. Have a great day.
Welcome to the Community, @gbody.
I'll guide you on how to run a report for closed backorders. Let's start by running a report for Sales Orders. Then, filter the Transaction Type to Sales Order to show both open and closed transactions.
Here's how:
If necessary, you can also customize the report. This way, it'll only show the information that you need the most.
Just hit the Reply button if you have further questions in QuickBooks and in running reports. Stay safe!
Hi, thank you for your assistance.
However, following the instructions you provided only provides an itemized list of backorders that are still OPEN.
I also want to include a list of backordered items that were on CLOSED sales orders (meaning these items were ordered by the customer but never invoiced because out stock shortages).
I experimented with different filter settings but could not figure this out.
Thank you
Thanks for getting back to us here, @gbody.
I know a report you can use to see both open and closed transactions. You can run the Transaction Detail report instead, and filter the Transaction Type to Sales Order. Let me guide you how.
Learn more about customizing reports in this article: Customize customer, job, and sales reports in QuickBooks Desktop.
I've also added this link here in case you need help with other report tasks. It has our general report topics with articles.
Don't hesitate to comment below if you still have follow-up questions or concerns. I'm always here to help. Take care and have a great day ahead.
Thanks Sheila for looking into my question again.
I have followed your instructions, however the result shows nothing at all in the Report register - see screenshot below (we had a busy last quarter so it should be populated)
Hi there, @gbody. I'm here to provide additional steps to show both open and closed backorders.
Here's how:
I'd suggest memorizing this report so you can access it in the future. You can also export the report to Excel. This way, it can be saved, stored, and transferred digitally if needed.
I'd be happy to help should you have any follow-up questions about customizing reports. Have a great day.
Thank you, your assistance was very helpful and quick. That was the solution. I was then able to export to Excel and analyze.
I continue to have a challenge with system reflecting we have backorder qty when in all actuality we have -0- backorders. I can never utilize reorder points because of this.
Shows Backorder Qty 5 Avail Qty -5
but we have NO existing sales orders or back orders to fill.
Please help
[email address removed]
Hi there, kittybruns.
Can you tell us what report you're running for the backorder? Can you share more details or add a screenshot? We just want to make sure that we're giving you the right steps and information to resolve the issue.
Please reply to us again to share more details. We look forward to it.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here