I 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?
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.
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.
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!