BEGIN TRY
	BEGIN TRANSACTION
		USE DOD;
		---------------------------------------------------------------------------
		--They can't reconcile the order because the IsReconciled flag is Y.
		---------------------------------------------------------------------------

		DECLARE @MnfstID Int;

		SELECT @MnfstID = m.MnfstID
		FROM dbo.Manifest AS m WITH (NOLOCK)
		WHERE m.mnfstid = (
			SELECT mnfstid
			FROM OrderManifest AS om WITH (NOLOCK)
			WHERE om.Ordrnmbr = 503326
		);
                                    
		SELECT @MnfstID;
                        
		RETURN;

		---------------------------------------------------------------------------
		--Once you have the mnfstid value you can update the IsReconciled flag to N
		---------------------------------------------------------------------------

		UPDATE m
		SET m.IsReconciled = 'N'
		--Select m.*
		FROM dbo.Manifest AS m
		WHERE m.MnfstID = @MnfstID;

	--COMMIT
	ROLLBACK
END TRY

BEGIN CATCH
	ROLLBACK
END CATCH