...
Egg Size Types
- Go to System, Settings (Ribbon Bar), System Types Tab, Select Egg Size Types from Drop down.These need to be set up exactly as they are in the report so we get the correct values back. Run the following script against the user database to set up the egg size types used:
update userbusinesstype
set sortorder = 20.00
where objectid = 77
update userbusinesstype
set BusinessTypeCode = 'Bs', BusinessTypeName = 'Bs', IsUserMod = 1, SortOrder = 7
where BusinessTypeID = 310
update userbusinesstype
set BusinessTypeCode = 'CRACKS', BusinessTypeName = 'CRACKS', IsUserMod = 1, SortOrder = 8
where BusinessTypeID = 311
update userbusinesstype
set BusinessTypeCode = 'REJECTS', BusinessTypeName = 'REJECTS', IsUserMod = 1, SortOrder = 9
where BusinessTypeID = 314
update userbusinesstype
set BusinessTypeCode = 'JUMBO', BusinessTypeName = 'JUMBO', IsUserMod = 1, SortOrder = 1
where BusinessTypeID = 293
update userbusinesstype
set BusinessTypeCode = 'X-LARGE', BusinessTypeName = 'X-LARGE', IsUserMod = 1, SortOrder = 2
where BusinessTypeID = 294
update userbusinesstype
set BusinessTypeCode = 'LARGE', BusinessTypeName = 'LARGE', IsUserMod = 1, SortOrder = 3
where BusinessTypeID = 295
update userbusinesstype
set BusinessTypeCode = 'MEDIUM', BusinessTypeName = 'MEDIUM', IsUserMod = 1, SortOrder = 4
where BusinessTypeID = 296
update userbusinesstype
set BusinessTypeCode = 'SMALL', BusinessTypeName = 'SMALL', IsUserMod = 1, SortOrder = 5
where BusinessTypeID = 297
update userbusinesstype
set BusinessTypeCode = 'PEEWEE', BusinessTypeName = 'PEEWEE', IsUserMod = 1, SortOrder = 6
where BusinessTypeID = 298
...