Understanding that the field is accessible via saved search AFTER a PO is issued, we apply the value to the line field at the time of sales order creation where no PO has been created yet.
I'm trying to create a saved search that will pull SO's Pending Approval where line items have a name listed in the PO Vendor field above. Any attempt to access the name through the Purchase Order joins will fail, as previously mentioned there is no PO yet created.
The xml report the field existence, but I cannot figure out how to access it through any formula or join in the saved search options.
Is this field value accessible in this manner when applied prior to issuing the PO?
Note: this vendor name is not associated on the Item record. It is only listed on the line of the specific SO. We purchase from many different vendors and the same item may be procured from different vendors based on price and availability at any time.
I know similar questions have been asked, but I did not find any where the PO had yet to be issued.
Thanks.