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