Hello.
When I try to change ExtDimension in account I got this error:
| Code |
|---|
Microsoft SQL Server Native Client 11.0: Cannot insert value NULL in to column '_Fld1013RRef', table 'XXXX.dbo._AccRgAT0343'. |
The query which leads to this:
| Code |
|---|
exec sp_executesql N'INSERT INTO dbo._AccRgAT0343 WITH(SERIALIZABLE) (_Period, _AccountRRef, _Fld334RRef, _Fld335, _TurnoverDt344, _TurnoverCt345, _Turnover346, _Fld336, _TurnoverDt347, _TurnoverCt348, _Turnover349, _Fld337, _TurnoverDt350, _TurnoverCt351, _Turnover352, _Fld338, _TurnoverDt353, _TurnoverCt354, _Turnover355, _Splitter) |
It's easy to see that in the query column '_Fld1013RRef' isn't specified.
This field corresponds to the common attribute. I tried to disable it for accounting register, but I got a message:
| Code |
|---|
Registers that affect the sequence must have all separators for documents included in the sequence |
Platform version is 8.3.5.1119
DBMS is Microsoft SQL Server Standard (64-bit) 11.0.5058.0
Edited: - Jan 21, 2015 11:25 PM
