<@UN8UBEXK2> If you want to use a SuiteQL query, t...
# general
t
@Simon If you want to use a SuiteQL query, this might help get you started:
Copy code
SELECT
	Transaction.ID,
	Transaction.TranID AS ItemFullfillmentID,
	Transaction.TranDate AS FulfillmentDate,
	Transaction.Entity AS CustomerID,
	BUILTIN.DF( Transaction.Entity ) AS CustomerName,
	SalesOrder.TranID AS SalesOrderNumber,
	Transaction.OtherRefNum AS CustomerPONumber,
	BUILTIN.DF( Transaction.ShippingAddress ) AS ShipToAddress,	
	REPLACE( BUILTIN.DF( Transaction.Status ), 'Item Fulfillment : ', '' ) AS Status,
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
	( Transaction.Type = 'ItemShip' )
	AND ( Transaction.TranDate >= TO_DATE( '2021-09-01', 'YYYY-MM-DD' ) )
	AND ( Transaction.Void = 'F' )
s
SuiteQL is ALWAYS my first choice. I'll try it. Thanks a lot
👍 1