@Dmitry_Kashulin
On another note you can no longer use the Ice.Sys* Tables in 10.2.300 – the columns come in blank for:
- Ice.SysCompany
- Ice.SysExtCompany
- Ice.SysFiscalCal
- Ice.SysFiscalPer
- Ice.SysFicalYr
- Ice.SysPlant
- Ice.SysUserComp
- Ice.SysUserCompExt
- Ice.SysUserFile
This may be probably by Design; Because there are other Aliases we should be using such as Erp.Company, Erp.UserFile… unfortunately those dont have all the columns.
It seems to be because 10.2.300 adds “zf.SystemCode = it.TableOwner” to its Query, which those Sys tables fail.
You might wonder which Columns one could need from Ice.SysCompany
SMTP or DefaultLabelPrinter seem to be used by folks, when they create their own “BarTender” Auto-Print like UD01.
I still got it to work by adding the Column in a Calculated Field and just hardcoding the Ice.Table.Column in the JOINs.
