Коллеги, подскажите, в чем может быть ошибка?
https://yadi.sk/i/o2gwLZvSVeR6z

Выделил красным.

Как ссыль вставить без автозамены?

Проверял на тип и на уникальный идентификатор для обоих случаев, они равные. Взял по одной строке из ДвиженийССубконто:

Документ отражение
ТипСубконто 63b26cf0-fec3-4934-ae9e-83155956fd11
Ссылка 00000000-0000-0000-0000-000000000000

Документ Амортизация
ТипСубконто 63b26cf0-fec3-4934-ae9e-83155956fd11
Ссылка 00000000-0000-0000-0000-000000000000

ном.группа не заполнена

(3) В смысле?

Вверх

(0) ТИИ делал?

(6) На прошлой неделе в три захода.

(7) И что? Были ошибки? Исправил ли ты их?

Сделал вот такой запрос к базе:

exec sp_executesql N'SELECT
MIN(T1._Period),
MIN(T1._UseTotals),
MIN(T1._ActualPeriod),
MAX(T1._UseSplitter),
MIN(T1._MinPeriod)
FROM _AccRgOpt T1 WITH(NOLOCK)
WHERE T1._RegID = P1',N'P1 varbinary(8000)',0x37016F671FA3D34495B9C95579A03D8A

if object_id('tempdb..#tt1') is not null
  drop table #tt1

SELECT TOP 0 CAST(NULL AS NUMERIC(2,0)) _LineNo
INTO #tt1

create index [TMPIND_0] on [#tt1] (_LineNo)

INSERT INTO #tt1 (_LineNo) SELECT
99.0
WHERE 1=0
exec sp_executesql N'INSERT INTO #tt1 (_LineNo) VALUES(P1)',N'P1 numeric(2)',1
exec sp_executesql N'INSERT INTO #tt1 (_LineNo) VALUES(P1)',N'P1 numeric(2)',2
exec sp_executesql N'INSERT INTO #tt1 (_LineNo) VALUES(P1)',N'P1 numeric(2)',3

if object_id('tempdb..#tt2') is not null
  drop table #tt2

SELECT TOP 0 CAST(NULL AS BINARY(16)) _REFFIELDRRef
INTO #tt2


exec sp_executesql N'INSERT INTO #tt2 (_REFFIELDRRef) SELECT
T1._IDRRef
FROM _Acc17 T1 WITH(NOLOCK)
WHERE (T1._ParentIDRRef IN (P1))
UNION SELECT
T2._IDRRef
FROM _Acc17 T2 WITH(NOLOCK)
WHERE (T2._IDRRef IN (@P2))',N'P1 varbinary(16),@P2 varbinary(16)',0x8F0B05CF448F99884F7C6A35F938D496,0x8F0B05CF448F99884F7C6A35F938D496

INSERT INTO #tt2 (_REFFIELDRRef) SELECT
T1._IDRRef
FROM _Acc17 T1 WITH(NOLOCK)
INNER JOIN #tt2 T2 WITH(NOLOCK)
ON T1._ParentIDRRef = T2._REFFIELDRRef
LEFT OUTER JOIN #tt2 T3 WITH(NOLOCK)
ON T1._IDRRef = T3._REFFIELDRRef
WHERE T3._REFFIELDRRef IS NULL

SELECT
T1._IDRRef,
T2._Fld22461,
T2._TurnoverOnly
FROM _Acc17 T1 WITH(NOLOCK)
LEFT OUTER JOIN _Acc17_ExtDim22460 T2 WITH(NOLOCK)
INNER JOIN #tt1 T3 WITH(NOLOCK)
ON T3._LineNo = T2._LineNo
ON T2._Acc17_IDRRef = T1._IDRRef
WHERE ((T1._IDRRef IN
(SELECT
T4._REFFIELDRRef AS REFFIELDRRef
FROM #tt2 T4 WITH(NOLOCK))))
ORDER BY T1._IDRRef, T2._LineNo

if object_id('tempdb..#tt3') is not null
  drop table #tt3

SELECT TOP 0 CAST(NULL AS BINARY(16)) _IDRRef,
CAST(NULL AS BINARY(1)) _ED1,
CAST(NULL AS BINARY(1)) _ED2,
CAST(NULL AS BINARY(1)) _ED3,
CAST(NULL AS BINARY(1)) _RF1,
CAST(NULL AS BINARY(1)) _BRF1
INTO #tt3

create index [TMPIND_1] on [#tt3] (_IDRRef)

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef, _ED1, _ED2, _ED3, _RF1, _BRF1) SELECT
P1,
0x01,
0x01,
0x01,
0x01,
0x01
WHERE 1=0',N'P1 varbinary(16)',0x00000000000000000000000000000000

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0x8F0B05CF448F99884F7C6A35F938D496,0x01,0x01,0x01,0x01,0x00

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0x8F0B05CF448F99884F7C6A35F938D496,0x01,0x01,0x00,0x00,0x01

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xA48F2D56596C5CD54D3008C35DC90B6F,0x01,0x01,0x01,0x01,0x00

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xA48F2D56596C5CD54D3008C35DC90B6F,0x01,0x01,0x00,0x00,0x01

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xABF27DFE139AC96C4CF478F0C2443D76,0x01,0x01,0x01,0x01,0x00

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xABF27DFE139AC96C4CF478F0C2443D76,0x01,0x01,0x00,0x00,0x01

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xAD4C74AA426078824ADF88671B9584E8,0x01,0x01,0x01,0x01,0x01

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xB107DB9BA965649C40464EE543B068AA,0x01,0x01,0x01,0x01,0x00

exec sp_executesql N'INSERT INTO #tt3 (_IDRRef,_ED1,_ED2,_ED3,_RF1,_BRF1) VALUES(P1,@P2,@P3,@P4,@P5,@P6)',N'P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(1),@P4 varbinary(1),@P5 varbinary(1),@P6 varbinary(1)',0xB107DB9BA965649C40464EE543B068AA,0x01,0x01,0x00,0x00,0x01

if object_id('tempdb..#tt4') is not null
  drop table #tt4

SELECT TOP 0 CAST(NULL AS BINARY(16)) _IDRRef,
CAST(NULL AS NUMERIC(10,0)) _Cnt
INTO #tt4

INSERT INTO #tt4 (_IDRRef, _Cnt) SELECT
T1._IDRRef,
CAST(COUNT(T2._Acc17_IDRRef) AS NUMERIC(10))
FROM _Acc17 T1 WITH(NOLOCK)
LEFT OUTER JOIN _Acc17_ExtDim22460 T2 WITH(NOLOCK)
ON T2._Acc17_IDRRef = T1._IDRRef
WHERE (T1._IDRRef IN
(SELECT
T3._REFFIELDRRef AS REFFIELDRRef
FROM #tt2 T3 WITH(NOLOCK)))
GROUP BY T1._IDRRef

SELECT DISTINCT
T1._Cnt
FROM #tt4 T1 WITH(NOLOCK)

exec sp_executesql N'SELECT
P1,
T1.AccountRRef,
T1.AccountRRef,
T26._Code,
T1.Fld22552InitialBalanceDt_,
T1.Fld22552InitialBalanceCt_,
T1.Fld22552TurnoverDt_,
T1.Fld22552TurnoverCt_,
T1.Fld22552FinalBalanceDt_,
T1.Fld22552FinalBalanceCt_,
T1.Value1_TYPE,
T1.Value1_RTRef,
T1.Value1_RRRef,
T1.Value1_TYPE,
T1.Value1_RTRef,
T1.Value1_RRRef,
T1.Value2_TYPE,
T1.Value2_RTRef,
T1.Value2_RRRef,
T1.Value2_TYPE,
T1.Value2_RTRef,
T1.Value2_RRRef,
T1.Value3_TYPE,
T1.Value3_RTRef,
T1.Value3_RRRef,
T1.Value3_TYPE,
T1.Value3_RTRef,
T1.Value3_RRRef
FROM (SELECT
T2.AccountRRef AS AccountRRef,
T2.Value1_TYPE AS Value1_TYPE,
T2.Value1_RTRef AS Value1_RTRef,
T2.Value1_RRRef AS Value1_RRRef,
T2.Value2_TYPE AS Value2_TYPE,
T2.Value2_RTRef AS Value2_RTRef,
T2.Value2_RRRef AS Value2_RRRef,
T2.Value3_TYPE AS Value3_TYPE,
T2.Value3_RTRef AS Value3_RTRef,
T2.Value3_RRRef AS Value3_RRRef,
CASE WHEN CAST(SUM(T2.Fld22552TurnoverDt_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld22552TurnoverDt_) AS NUMERIC(33, 8)) END AS Fld22552TurnoverDt_,
CASE WHEN CAST(SUM(T2.Fld22552TurnoverCt_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld22552TurnoverCt_) AS NUMERIC(33, 8)) END AS Fld22552TurnoverCt_,
CASE WHEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 0.0 OR MAX(T25._Kind) = 2.0 AND CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) > 0.0 THEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) ELSE 0.0 END AS Fld22552InitialBalanceDt_,
CASE WHEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 1.0 OR MAX(T25._Kind) = 2.0 AND CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) < 0.0 THEN -CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) ELSE 0.0 END AS Fld22552InitialBalanceCt_,
CASE WHEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 0.0 OR MAX(T25._Kind) = 2.0 AND CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) > 0.0 THEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) ELSE 0.0 END AS Fld22552FinalBalanceDt_,
CASE WHEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 1.0 OR MAX(T25._Kind) = 2.0 AND CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) < 0.0 THEN -CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) ELSE 0.0 END AS Fld22552FinalBalanceCt_,
MAX(T25._Kind) AS AccKind_
FROM (SELECT
T3._AccountRRef AS AccountRRef,
T3._Value1_TYPE AS Value1_TYPE,
T3._Value1_RTRef AS Value1_RTRef,
T3._Value1_RRRef AS Value1_RRRef,
CASE WHEN CAST(NULL AS BINARY(1)) IN (0x01) THEN CAST(NULL AS BINARY(1)) END AS Value2_TYPE,
CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P2 END AS Value2_RTRef,
CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P3 END AS Value2_RRRef,
CASE WHEN CAST(NULL AS BINARY(1)) IN (0x01) THEN CAST(NULL AS BINARY(1)) END AS Value3_TYPE,
CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P4 END AS Value3_RTRef,
CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P5 END AS Value3_RRRef,
CASE WHEN T3._Period = @P6 THEN T3._Fld22552 ELSE 0.0 END AS Fld22552Balance_,
T3._Turnover22566 AS Fld22552FinalTurnover_,
T3._TurnoverDt22564 AS Fld22552TurnoverDt_,
T3._TurnoverCt22565 AS Fld22552TurnoverCt_
FROM _AccRgAT122573 T3 WITH(NOLOCK)
INNER JOIN #tt4 T4 WITH(NOLOCK)
ON T4._IDRRef = T3._AccountRRef AND T4._Cnt = @P7
WHERE ((T3._Fld22550RRef = @P8)) AND T3._Period >= @P9 AND T3._Period < P10 AND (T3._Fld22552 <> 0.0 OR T3._TurnoverDt22564 <> 0.0 OR T3._TurnoverCt22565 <> 0.0 OR T3._Turnover22566 <> 0.0)
UNION ALL SELECT
T5._AccountRRef AS AccountRRef,
T5._Value1_TYPE AS Value1_TYPE,
T5._Value1_RTRef AS Value1_RTRef,
T5._Value1_RRRef AS Value1_RRRef,
T5._Value2_TYPE AS Value2_TYPE,
T5._Value2_RTRef AS Value2_RTRef,
T5._Value2_RRRef AS Value2_RRRef,
T5._Value3_TYPE AS Value3_TYPE,
T5._Value3_RTRef AS Value3_RTRef,
T5._Value3_RRRef AS Value3_RRRef,
CASE WHEN T5._Period = P11 THEN T5._Fld22552 ELSE 0.0 END AS Fld22552Balance_,
T5._Turnover22566 AS Fld22552FinalTurnover_,
T5._TurnoverDt22564 AS Fld22552TurnoverDt_,
T5._TurnoverCt22565 AS Fld22552TurnoverCt_
FROM _AccRgAT322575 T5 WITH(NOLOCK)
INNER JOIN #tt4 T6 WITH(NOLOCK)
ON T6._IDRRef = T5._AccountRRef AND T6._Cnt = P12
WHERE ((T5._Fld22550RRef = P13)) AND T5._Period >= P14 AND T5._Period < P15 AND (T5._Fld22552 <> 0.0 OR T5._TurnoverDt22564 <> 0.0 OR T5._TurnoverCt22565 <> 0.0 OR T5._Turnover22566 <> 0.0)
UNION ALL SELECT
T7._AccountDtRRef AS AccountRRef,
CASE WHEN T8._ED1 = 0x01 THEN T10._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value1_TYPE,
CASE WHEN T8._ED1 = 0x01 THEN T10._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN P16 END END AS Value1_RTRef,
CASE WHEN T8._ED1 = 0x01 THEN T10._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN P17 END END AS Value1_RRRef,
CASE WHEN T8._ED2 = 0x01 THEN T12._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value2_TYPE,
CASE WHEN T8._ED2 = 0x01 THEN T12._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN P18 END END AS Value2_RTRef,
CASE WHEN T8._ED2 = 0x01 THEN T12._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN P19 END END AS Value2_RRRef,
CASE WHEN T8._ED3 = 0x01 THEN T14._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value3_TYPE,
CASE WHEN T8._ED3 = 0x01 THEN T14._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P20 END END AS Value3_RTRef,
CASE WHEN T8._ED3 = 0x01 THEN T14._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P21 END END AS Value3_RRRef,
CAST(0.0 AS NUMERIC(21, 2)) AS Fld22552Balance_,
CAST(CASE WHEN T8._BRF1 = 0x01 THEN T7._Fld22552 ELSE 0.0 END AS NUMERIC(21, 2)) AS Fld22552FinalTurnover_,
CAST(CASE WHEN T8._RF1 = 0x01 THEN T7._Fld22552 ELSE 0.0 END AS NUMERIC(21, 2)) AS Fld22552TurnoverDt_,
CAST(0.0 AS NUMERIC(21, 2)) AS Fld22552TurnoverCt_
FROM _AccRg22549 T7 WITH(NOLOCK)
INNER JOIN #tt3 T8 WITH(NOLOCK)
ON T8._IDRRef = T7._AccountDtRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T9 WITH(NOLOCK)
ON T9._Acc17_IDRRef = T7._AccountDtRRef AND T9._LineNo = @P22
LEFT OUTER JOIN _AccRgED22577 T10 WITH(NOLOCK)
ON T10._RecorderTRef = T7._RecorderTRef AND T10._RecorderRRef = T7._RecorderRRef AND T10._LineNo = T7._LineNo AND T10._Period = T7._Period AND T10._Correspond = 0.0 AND T10._KindRRef = T9._DimKindRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T11 WITH(NOLOCK)
ON T11._Acc17_IDRRef = T7._AccountDtRRef AND T11._LineNo = @P23
LEFT OUTER JOIN _AccRgED22577 T12 WITH(NOLOCK)
ON T12._RecorderTRef = T7._RecorderTRef AND T12._RecorderRRef = T7._RecorderRRef AND T12._LineNo = T7._LineNo AND T12._Period = T7._Period AND T12._Correspond = 0.0 AND T12._KindRRef = T11._DimKindRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T13 WITH(NOLOCK)
ON T13._Acc17_IDRRef = T7._AccountDtRRef AND T13._LineNo = @P24
LEFT OUTER JOIN _AccRgED22577 T14 WITH(NOLOCK)
ON T14._RecorderTRef = T7._RecorderTRef AND T14._RecorderRRef = T7._RecorderRRef AND T14._LineNo = T7._LineNo AND T14._Period = T7._Period AND T14._Correspond = 0.0 AND T14._KindRRef = T13._DimKindRRef
WHERE T7._Active = 0x01 AND ((T7._AccountDtRRef IN
(SELECT
T15._REFFIELDRRef AS REFFIELDRRef
FROM #tt2 T15 WITH(NOLOCK)))) AND ((T7._Fld22550RRef = @P25)) AND T7._Period >= @P26 AND T7._Period <= @P27
UNION ALL SELECT
T16._AccountCtRRef AS AccountRRef,
CASE WHEN T17._ED1 = 0x01 THEN T19._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value1_TYPE,
CASE WHEN T17._ED1 = 0x01 THEN T19._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P28 END END AS Value1_RTRef,
CASE WHEN T17._ED1 = 0x01 THEN T19._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P29 END END AS Value1_RRRef,
CASE WHEN T17._ED2 = 0x01 THEN T21._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value2_TYPE,
CASE WHEN T17._ED2 = 0x01 THEN T21._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P30 END END AS Value2_RTRef,
CASE WHEN T17._ED2 = 0x01 THEN T21._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P31 END END AS Value2_RRRef,
CASE WHEN T17._ED3 = 0x01 THEN T23._Value_TYPE ELSE CAST(NULL AS BINARY(1)) END AS Value3_TYPE,
CASE WHEN T17._ED3 = 0x01 THEN T23._Value_RTRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P32 END END AS Value3_RTRef,
CASE WHEN T17._ED3 = 0x01 THEN T23._Value_RRRef ELSE CASE WHEN CAST(NULL AS BINARY(1)) IS NOT NULL THEN @P33 END END AS Value3_RRRef,
CAST(0.0 AS NUMERIC(21, 2)) AS Fld22552Balance_,
CAST(CASE WHEN T17._BRF1 = 0x01 THEN -T16._Fld22552 ELSE 0.0 END AS NUMERIC(21, 2)) AS Fld22552FinalTurnover_,
CAST(0.0 AS NUMERIC(21, 2)) AS Fld22552TurnoverDt_,
CAST(CASE WHEN T17._RF1 = 0x01 THEN T16._Fld22552 ELSE 0.0 END AS NUMERIC(21, 2)) AS Fld22552TurnoverCt_
FROM _AccRg22549 T16 WITH(NOLOCK)
INNER JOIN #tt3 T17 WITH(NOLOCK)
ON T17._IDRRef = T16._AccountCtRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T18 WITH(NOLOCK)
ON T18._Acc17_IDRRef = T16._AccountCtRRef AND T18._LineNo = @P34
LEFT OUTER JOIN _AccRgED22577 T19 WITH(NOLOCK)
ON T19._RecorderTRef = T16._RecorderTRef AND T19._RecorderRRef = T16._RecorderRRef AND T19._LineNo = T16._LineNo AND T19._Period = T16._Period AND T19._Correspond = @P35 AND T19._KindRRef = T18._DimKindRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T20 WITH(NOLOCK)
ON T20._Acc17_IDRRef = T16._AccountCtRRef AND T20._LineNo = @P36
LEFT OUTER JOIN _AccRgED22577 T21 WITH(NOLOCK)
ON T21._RecorderTRef = T16._RecorderTRef AND T21._RecorderRRef = T16._RecorderRRef AND T21._LineNo = T16._LineNo AND T21._Period = T16._Period AND T21._Correspond = @P37 AND T21._KindRRef = T20._DimKindRRef
LEFT OUTER JOIN _Acc17_ExtDim22460 T22 WITH(NOLOCK)
ON T22._Acc17_IDRRef = T16._AccountCtRRef AND T22._LineNo = @P38
LEFT OUTER JOIN _AccRgED22577 T23 WITH(NOLOCK)
ON T23._RecorderTRef = T16._RecorderTRef AND T23._RecorderRRef = T16._RecorderRRef AND T23._LineNo = T16._LineNo AND T23._Period = T16._Period AND T23._Correspond = @P39 AND T23._KindRRef = T22._DimKindRRef
WHERE T16._Active = 0x01 AND ((T16._AccountCtRRef IN
(SELECT
T24._REFFIELDRRef AS REFFIELDRRef
FROM #tt2 T24 WITH(NOLOCK)))) AND ((T16._Fld22550RRef = @P40)) AND T16._Period >= @P41 AND T16._Period <= @P42) T2
INNER JOIN _Acc17 T25 WITH(NOLOCK)
ON T25._IDRRef = T2.AccountRRef
GROUP BY T2.AccountRRef,
T2.Value1_TYPE,
T2.Value1_RTRef,
T2.Value1_RRRef,
T2.Value2_TYPE,
T2.Value2_RTRef,
T2.Value2_RRRef,
T2.Value3_TYPE,
T2.Value3_RTRef,
T2.Value3_RRRef
HAVING (CASE WHEN CAST(SUM(T2.Fld22552TurnoverDt_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld22552TurnoverDt_) AS NUMERIC(33, 8)) END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld22552TurnoverCt_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 ELSE CAST(SUM(T2.Fld22552TurnoverCt_) AS NUMERIC(33, 8)) END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 0.0 OR MAX(T25._Kind) = @P43 AND CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) > 0.0 THEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) ELSE 0.0 END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = @P44 OR MAX(T25._Kind) = @P45 AND CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) < 0.0 THEN -CAST(SUM(T2.Fld22552Balance_) AS NUMERIC(33, 8)) ELSE 0.0 END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = 0.0 OR MAX(T25._Kind) = @P46 AND CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) > 0.0 THEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) ELSE 0.0 END) <> 0.0 OR (CASE WHEN CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) IS NULL THEN 0.0 WHEN MAX(T25._Kind) = @P47 OR MAX(T25._Kind) = @P48 AND CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) < 0.0 THEN -CAST(SUM(T2.Fld22552Balance_ + T2.Fld22552FinalTurnover_) AS NUMERIC(34, 8)) ELSE 0.0 END) <> 0.0) T1
LEFT OUTER JOIN _Acc17 T26 WITH(NOLOCK)
ON T1.AccountRRef = T26._IDRRef
WHERE (T1.Fld22552FinalBalanceDt_ <> 0.0) AND (T1.Fld22552FinalBalanceDt_ < @P49)',N'P1 nvarchar(4000),@P2 varbinary(4),@P3 varbinary(16),@P4 varbinary(4),@P5 varbinary(16),@P6 datetime2(3),@P7 numeric(10),@P8 varbinary(16),@P9 datetime2(3),P10 datetime2(3),P11 datetime2(3),P12 numeric(10),P13 varbinary(16),P14 datetime2(3),P15 datetime2(3),P16 varbinary(4),P17 varbinary(16),P18 varbinary(4),P19 varbinary(16),@P20 varbinary(4),@P21 varbinary(16),@P22 numeric(10),@P23 numeric(10),@P24 numeric(10),@P25 varbinary(16),@P26 datetime2(3),@P27 datetime2(3),@P28 varbinary(4),@P29 varbinary(16),@P30 varbinary(4),@P31 varbinary(16),@P32 varbinary(4),@P33 varbinary(16),@P34 numeric(10),@P35 numeric(10),@P36 numeric(10),@P37 numeric(10),@P38 numeric(10),@P39 numeric(10),@P40 varbinary(16),@P41 datetime2(3),@P42 datetime2(3),@P43 numeric(10),@P44 numeric(10),@P45 numeric(10),@P46 numeric(10),@P47 numeric(10),@P48 numeric(10),@P49 numeric(10)',N'Проверка',0x00000000,0x00000000000000000000000000000000,0x00000000,0x00000000000000000000000000000000,'4014-04-01 00:00:00',1,0x8BBE005056920EDD11DFD5342F9C9457,'4014-04-01 00:00:00','4014-06-01 00:00:00','4014-04-01 00:00:00',3,0x8BBE005056920EDD11DFD5342F9C9457,'4014-04-01 00:00:00','4014-06-01 00:00:00',0x00000000,0x00000000000000000000000000000000,0x00000000,0x00000000000000000000000000000000,0x00000000,0x00000000000000000000000000000000,1,2,3,0x8BBE005056920EDD11DFD5342F9C9457,'4014-06-01 00:00:00','4014-06-30 23:59:59',0x00000000,0x00000000000000000000000000000000,0x00000000,0x00000000000000000000000000000000,0x00000000,0x00000000000000000000000000000000,1,1,2,1,3,1,0x8BBE005056920EDD11DFD5342F9C9457,'4014-06-01 00:00:00','4014-06-30 23:59:59',2,1,2,2,1,2,1000000

И он выдал вот такую портянку (я поставил фильтр на значение остатка <> 0 и диапазон - одна строка из Отражения тянется, другая - из расчета себестоимости. Группировка из-за этой хрени не работает:

__https://yadi.sk/i/Y8CUq7Y_VfwFi

Поломался тип значения, в общем.

Как починить-то?

самое простое  перепровести попробовать документы эти

(11) Не помогло. Я даже руками перезаполнил все Субконто...

Вот такой вот косяк:

https://yadi.sk/i/CGt05JoRVieUq

Делаю запрос к ХозрасчетныйОстатки, поле Субконто2 получаю как  ТИПЗНАЧЕНИЯ(Субконто2) и там null. Для теста заменил в документе субконто на явное значение - появилась третья строка  с этим субконто, а сумма с null как была 561006,72 так и осталась.

Почему в итогах у типа субконто стоит null?

Вот так получается, если заполнить пустую номенклатурную группу - остаток с null не поменялся...

https://yadi.sk/i/piEG6X59Vifg6

ТИИ делал неделю назад. Попробую в копии запустить, так как рабочая занята.

ТИИ не помогло, так же все и осталось.

отраслевка?

пересчет итого делался?

*итого=итогов

(18) В копии сегодня сделал - не помогло. Создал копию документа "Отражение ЗП в регл учете" - такая же хрень.
Не, типовая УПП с допилами.