View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001008 | Склад | General | public | 2017-01-16 18:01 | 2017-04-06 14:31 |
| Reporter | ruslan | Assigned To | barry | ||
| Priority | immediate | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Summary | 0001008: +/-Склад-закладка Расход/Заказы-Контекстное меню "Экспорт налоговой в XML"-При выгрузке Ошибка | ||||
| Description | Произошла ошибка: Dynamic SQL Error SQL error code = -206 Column unknown K2.VERDORNAMEID At line 6, column 4 ----- SELECT 1 TYP, G.NAME, G.FULLNAME, G.CODE, D.ID, D.QUANT, D.PRICE, D.NDS, K.TGRPCODE CODUKTVED, G.CODUKTVED HBUKTVED, g.OneID, h.Name One, h.Code One_Code, K.GTDDATE, K.GTDNBR, K2.GTDDATE SGTDDATE, K2.GTDNBR SGTDNBR, K2.VerdorNameID, V.Name VendorName FROM GDDDT D LEFT JOIN GDDKT K ON K.ID=D.GDDKEY LEFT JOIN GOODS G ON G.ID=K.GDSKEY LEFT JOIN GddKt_SrcKtID(K.ID) S on 0=0 LEFT JOIN GddKt K2 on K2.ID=S.KTID LEFT JOIN VendorName V on V.ID=K2.VendorNameID LEFT JOIN HbOne h on h.ID=g.OneID WHERE D.DGVKEY=:ID UNION ALL SELECT 2 TYP, G.NAME NAME, Cast(Null as varchar(255)) FULLNAME, Cast(Null as varchar(20)) CODE, D.ID, D.QUANT, D.PRICE, D.NDS, Cast(Null as varchar(20)) CODUKTVED, Cast(Null as varchar(20)) HBUKTVED, g.OneID, h.Name One, h.Code One_Code, Cast(Null as TimeStamp) GTDDATE, Cast(Null as varchar(32)) GTDNBR, Cast(Null as TimeStamp) SGTDDATE, Cast(Null as varchar(32)) SGTDNBR, Cast(Null as integer) VendorNameID, Cast(Null as varchar(255)) VendorName FROM GDDDTDDU D LEFT JOIN HBGDDDU G ON G.ID=D.NAMEID LEFT JOIN HbOne h on h.ID=g.OneID WHERE D.DGVKEY=:ID ORDER BY 1, 2, 3, 4, 5 Склад[ADMIN] Application.MainForm: FormStor(TFormStor) XE2 Склад: Тест (ГОЛОВКО ЧП) [Администратор Системы] ActiveForm: FormStor(TFormStor) XE2 Склад: Тест (ГОЛОВКО ЧП) [Администратор Системы] ActiveCustomForm: FormStor(TFormStor) XE2 Склад: Тест (ГОЛОВКО ЧП) [Администратор Системы] | ||||
| Steps To Reproduce | При Экспорте налоговой без установки флагов "Объединять одинаковые позиции" | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-01-16 18:01 | ruslan | New Issue | |
| 2017-01-17 11:08 | barry | Note Added: 0002572 | |
| 2017-01-17 11:08 | barry | Status | new => resolved |
| 2017-01-17 11:08 | barry | Resolution | open => fixed |
| 2017-01-17 11:08 | barry | Assigned To | => barry |
| 2017-04-06 14:31 | ruslan | Status | resolved => closed |
