Does anyone know how to tell if a purchase order i...
# suiteqlc
Cory Weiner
03/11/2022, 3:23 PMDoes anyone know how to tell if a purchase order is a “Special Order” or “Drop Ship” order in suiteql?
c
Clay Roper
03/12/2022, 1:24 AM Copy code
SELECT
dropship,
specialorder
FROM transactionline
WHERE createdpo = {poInternalId}🙌 1
Clay Roper
03/12/2022, 1:25 AMWill return null if it's neither
c
Cory Weiner
03/12/2022, 1:41 AMThank you man that is exactly what I needed
c
Clay Roper
03/13/2022, 10:38 PMGreat to hear! 😄
3 Views