does anyone know how to pull in fulfillments for a...
# generalm
Michael Casey
09/20/2023, 6:54 PMdoes anyone know how to pull in fulfillments for a sales order based on the sales order id? Im trying to use SuiteScripts and for the life of me I can't link them to eachother with any of the default fields.
b
battk
09/20/2023, 8:01 PMwhat does your attempts look like
m
Michael Casey
09/20/2023, 8:23 PMvar mySearch = search.create({
type: search.Type.ITEM_FULFILLMENT,
columns: ["internalid", "tranid", "statusref", "status"],
filters: ["createdFrom", "is", orderId],
});
Michael Casey
09/20/2023, 8:23 PMSorry was in a meeting
b
battk
09/20/2023, 8:45 PMlooks like it should work
battk
09/20/2023, 8:45 PMif it doesnt, then orderId is likely not an internal id
m
Michael Casey
09/20/2023, 8:53 PMyeah. i think maybe createdFrom is not used anymore? It comes back blank.
Michael Casey
09/20/2023, 9:48 PMconst q =
"SELECT Transaction.id " +
"FROM Transaction " +
"INNER JOIN TransactionLine ON TransactionLine.Transaction = Transaction.ID AND TransactionLine.MainLine = 'T' " +
"INNER JOIN Transaction AS SalesOrder ON SalesOrder.ID = TransactionLine.CreatedFrom " +
"WHERE SalesOrder.id =" +
orderId +
" AND Transaction.Type = 'ItemShip'";
Michael Casey
09/20/2023, 9:49 PMthis works but holy cow theres got to be a better way!
b
Boban Dragojlovic
09/21/2023, 2:22 PMMichael - your saved search will work, but you can't use the "is" operator on the "createdFrom" field. You must use the "anyof" operator
✅ 1
Boban Dragojlovic
09/21/2023, 2:27 PMand here is a simpler query that will just return the item fulfillment IDs:
Boban Dragojlovic
09/21/2023, 2:27 PM"SELECT T.ID FROM Transasction T JOIN TransactionLine TL ON T.id = TL.transaction AND TL.mainline = 'T' WHERE TL.createdfrom = " + orderId
✅ 1
m
Michael Casey
09/21/2023, 7:11 PM@Boban Dragojlovic Very appreciated!
3 Views