Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI use Sales Orders in QB Manufacturing and am trying to create an on time delivery report. I need to pull in the Due Date from the Sales order form as well as the Ship date. In addition I need to pull in the Invoice date for the invoice that was generated from the sales order. I have determined that I cannot get what I need from custom QB reports. I have therefore resorted to using QB Advanced Reporting. The problem is that I can not find the field that holds the "Due Date" from the sales order form in the database. I thought that getting an answer to this question would be fairly simple by calling QB. I was on the phone for an hour and 20 mins and still don't have an answer. Does someone have a cross reference document showing the table/field name for all of the QB fields from the standard forms? If not, does anyone know the table/field name for the Sales Order Due Date field?
Open your invoice template and check the layout designer. Find the Due Date box. Is it active?
No it is not checked because I don't want to display it on my Invoice Screen or on my printed invoice. I think this is the Invoice Due Date and not the Sales Order Due Date anyway.
Hello, @Markteeth.
Let me guide you in generating and customizing the Sales Orders for All Customers report. This will allow you to view all of your sales orders recorded in QuickBooks.
Here's how:
Now, let's customize the Sales Orders for All Customers report to include the ship date on it. Here's how:
You can read through these articles to learn more about managing and customizing reports in QuickBooks:
Always feel free to swing by here if you have other questions. I'm just a few clicks away.
Thanks for trying but the "Ship Date" that you are pulling in is the Planned Ship Date. It is not the day that the order actually shipped. We do use this manually entered date as a target for shipment but I need to pull in the Invoice Date to see when the order was actually completed and shipped. I am trying to calculate on-time delivery.
Hello again, Markteeth. Thanks for keeping us updated.
Let's first customize the Invoice template to show the Sales Reports to use the Ship Date. Here's how:
Once done, try to run your Sales Reports, then follow the below steps:
To learn more about customizing reports, you can visit this article: Customize reports in QuickBooks Desktop.
If you have any other questions, let me know by leaving a comment below. I'm always here to help. Have a great day!
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.