Solved

Service Quotation origin/Service Quotation connection information location?

  • 15 January 2024
  • 1 reply
  • 20 views

Userlevel 5
Badge +15

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

icon

Best answer by bdoucette 15 January 2024, 15:24

View original

1 reply

Userlevel 5
Badge +15

Just found the answer to this, It seems that using the ServiceQuotationUtil entity with the SRV_QUOTATION_SERVICES view gives access to the origin/connection of the service quotation.

Reply