All our items have 1 Preferred Vendor assigned to them. Items are either special order or drop ship items.
When we create the sales vendor, the PO is created. The preferred vendor is automatically set on the PO and that is reflected in the SO line item under the PO Vendor column.
We have a business need to change the vendor and is accomplished by changing the vendor on the PO. When this is done the SO line item appropriately reflects the new vendor under the PO Vendor column.
We need to create a report where we need to present the line item PO vendor. How field do we access to retrieve this?
If we use Purchase Order : Preferred Vendor (Custom Column), we see blank
If we use Preferred Vendor (Custom Column), we get the preferred vendor from the Item record and not the transaction line item
Thanks in advance!
SALES ORDER SCREENSHOT
REPORT CRITERIA
REPORT RESULTS FIELDS
RESULTANT OUTPUT