Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #1
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.
Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)