I was given a list of Inventory Count transactions, and using SQL I'm trying to get the Inventory Adjustment records that were created by those Inventory Counts. The Inventory Adjustment record has a _created_from_id_ field like I would expect, but when I query the transactions table for that transaction_id, it returns nothing. Are Inventory Count records located on a different table other than transactions?

@Andrew Cohen This might help. It returns any adjustments that were made as a result of an inventory count.

SELECT
	NTLL.NextDoc AS AdjID,
	BUILTIN.DF( NTLL.NextDoc ) AS AdjTranID,
	TransactionLine.Item,
	BUILTIN.DF( TransactionLine.Item ) AS ItemName,
	TransactionLine.Quantity
FROM
	NextTransactionLineLink AS NTLL
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = NextDoc )
		AND ( TransactionLine.MainLine = 'F' )
WHERE 
	-- This is the ID of the Inventory Count record.
	( NTLL.PreviousDoc = 999999 )

Hi @tdietrich thanks for the help but the table "NextTransactionLineLink" doesn't seem to be a native NS table I'm able to query.