How to pull a UD table on a quote into an order

I have a UD table on our Quote entry that defines our quoted machine performance based on the customer’s specific products. When I create an order from a quote, I would like that UD table to be accessed and updateable on the Order entry screens. Is there even a reference/link to the quote number that was used to generate the order?
The keys on the UD table are Key1 = company, key2 = quote number, key3 = line item, key5=autogenerated sequence.

How do I reference (on the order) the specific lines from this UD table that were used on the quote that was used to generate the order?

Do you need multiple records for each quote line?

If not, go with UD fields on the QuotDtl table.

Yes, we need multiple records for each quote line. I have this configured already on the quote. Now I want to get this data to be shown on the order record.

If you make the order from the Quote (“Create Order” in Quote entry, or “Get Quote” in Order entry) each OrderDtl of the Order will contain the QuoteNum and the QuoteLine.

They even show on the Lines -> Detail tab on Order Entry

1 Like