Hello, I want to get the related PO from a SO but ...
# suitescripti
irurzo
12/09/2019, 2:30 PMHello, I want to get the related PO from a SO but I have no idea how to get it, for example, I can get the SO from an Item Fulfillment through the "Created From " field, but I have no idea how to get the PO on the SO that is under the Related Records -> Related Purchase Orders, the thing is I need to get some information from all this 3 records (IF, SO and PO), what Im doing right now is get the IF id, then lookup the fields that I need, then another lookuo for the SO but I got stuck with the PO. Any ideas?
b
battk
12/09/2019, 2:37 PMuse the applying transaction join
battk
12/09/2019, 2:39 PMdo a search on sales order, add a filter to limit the applying link type to the types of transactions you are interested in
battk
12/09/2019, 2:41 PMif you are doing drop shipments, you can also do a search on item fulfillments and use applied to transaction to get the related sales order and purchase orders
i
irurzo
12/09/2019, 3:06 PMAwesome, thanks @battk!!
p
PNJ
12/09/2019, 3:48 PMIf you start the search from the PO, you can go both ways SO<---PO--->IF
20 Views