查询总账科目与库存账不符

示例代码

DECLARE @Act nvarchar(15)
DECLARE @Date datetime
DECLARE @int int
SELECT @int = 1
FROM jdt1 t9
WHERE t9.Account = '[%0]'
	AND t9.Refdate = '[%1]'SET @Act = '[%0]'SET @Date = '[%1]'
SELECT t1.TransType AS 财务账交易类型, t1.CreatedBy AS 财务账交易单据号, t1.transvalue AS 财务账交易金额, t0.TransType AS 库存账交易类型, t0.CreatedBy AS 库存账单据号
	, t0.transvalue AS 库存账交易金额
	, isnull(t1.transvalue, 0) - isnull(t0.transvalue, 0) AS 差额
FROM (
	SELECT TransType, CreatedBy, SUM(TransValue) AS transvalue, InvntAct
	FROM OIVL
		INNER JOIN IVL1 ON OIVL.TransSeq = IVL1.TransSeq
	WHERE TransValue <> 0
		AND InvntAct = @Act
		AND DocDate <= @Date
	GROUP BY TransType, CreatedBy, InvntAct
) t0
	FULL JOIN (
		SELECT TransType, CreatedBy, SUM(Debit - Credit) AS transvalue
			, Account
		FROM JDT1
		WHERE Account = @Act
			AND Debit - Credit <> 0
			AND RefDate <= @Date
		GROUP BY TransType, CreatedBy, Account
	) t1
	ON t0.TransType = t1.TransType
		AND t0.CreatedBy = t1.CreatedBy
WHERE isnull(t0.transvalue, 0) <> isnull(t1.transvalue, 0)