Hello,

I am currently attempting to create a custom field that stores the Customer PO number (found on the customer order entity) for this quotation. As far as I’m aware, you can create a service quotation from a customer order or a work order. If I have the link for both of these, I can create this custom field, but currently, I don’t see a connection to do this. There is one entity called ServieQuotationConn which seems like exactly what I need, but out of the hundreds of service quotes we have, there is only one returned row in this SERVICE_QUOTATION_CONN view. I can attempt to pull the PO number from any customer orders that have the same order number as the service quote, but this doesn’t help with the work order created ones. Does anyone know where the information I need is stored?

Any and all help would be greatly appreciated.

Thanks,
Bryan