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!

Add Comment
1 Answers

Assuming you are using the Setup -> Records Catalog , the joins you are looking for are:

“Related Transaction Line Link – Next”   NextTransactionLineLink
“Related Transaction Line Link – Previous”   PreviousTransactionLineLink

Intermediate Answered on August 11, 2022.

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. 🙂

on August 15, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.