RE: SuiteAnalytics Connect – How to pull dropship/special order PO # from Sales Order or Item Fulfillment
Hi everyone,
I’m trying to figure out the join in my SQL query that will pull the CREATEPO or CREATEDPO field value for my SO with a dropshipped item. But in the Connect Browser there isn’t a column for that field. I tried using APPLIED TRANSACTION as well but maybe I’m using it wrong. Can someone provide me some guidance as I’m still learning this 🙂 Thank you!
Assuming you are using the Setup -> Records Catalog , the joins you are looking for are:
Hey there. Thanks for the help! I actually ended up changing my query to pull directly from the Item Fulfillment record since that was part of the base request. I was able to use {podoc} to pull in the internal ID of the associated PO and then used a workflow to copy the value into another line field where it can be pulled onto a report. 🙂
