We are working on modifying the Open Purchase Orders Report and want to be able to pull some line-level information from the associated Sales Order into the report. There are two important fields that we want to include from the item line that generated the PO: Priority and Promise Date
If we add the Created From as a result on the search, we get the Sales Order #—great.
(However, if we add the Applied To Transaction as a result, we get nothing—why? Are they not the same in this case?)
Since the PO was created at the line level of the Sales Order, is there not a way to retrieve that information? I have tried using Formula fields (such as {createdfrom.cust_col_priority} and {appliedtotransaction.cust_col_priority}, etc. but to no avail.
Is there a way to get to the line-level information so that the Priority and Promise Date fields can be shown in the search? (The native report operates at the PO level, so we're always "looking up" to the SO. The report does not start at the SO level.)