Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
GRN Batch Number wrong - Solved
05-10-2014, 01:48 AM, (This post was last modified: 05-10-2014, 01:52 AM by agaluski.)
GRN Batch Number wrong - Solved
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.


Messages In This Thread
GRN Batch Number wrong - Solved - by agaluski - 05-10-2014, 01:48 AM

Forum Jump:

Users browsing this thread: 1 Guest(s)