SuiteAnalytics Connect – How to pull dropship/special order PO # from Sales Order or Item Fulfillment
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!