05-10-2014, 01:48 AM
Performed a few Goods Receipts today on a new system.
systypes for 25 set to 100000 before start. Now systypes set to 100003 as expected but GRN number was stored as 32767 for ALL receipts in table grns. gltrans has correct typeno
How to troubleshoot and fix existing data?
The problem was grnbatch was a SMALLINT and my systypes value is too large so the maximum value is assigned (instead of returning an error from the DB).
I have made my DB Change to Allow INT in that field.
systypes for 25 set to 100000 before start. Now systypes set to 100003 as expected but GRN number was stored as 32767 for ALL receipts in table grns. gltrans has correct typeno
How to troubleshoot and fix existing data?
The problem was grnbatch was a SMALLINT and my systypes value is too large so the maximum value is assigned (instead of returning an error from the DB).
I have made my DB Change to Allow INT in that field.