I am trying to replace a grid view in Quote Tracker - Related Sales Orders.
Can someone tell me what query is being used?
Just to provide a little background, I added a UD field called AltQuoteNum that I have on the Order Line. If you create an order from a Quote, you cannot change that reference quote number on the SO line, so I created an Alternate reference field that can be manually populated.
My order dashboards look at that alternate field and if it is greater than 0, then it show the details from that alternate quote.
But when you start from the Alternate Quote in Quote Tracker, the “Related Sales Orders” does not bring back results. So I am looking to update the link in the “Related Sales Order” query or copy and replace the query with one that also looks at the Alternate Quote Number.
Thanks in advance for your help.