Welcome, Guest. Please Login.
05/16/25 at 05:05:47
News:
Home Help Search Login


Pages: 1
Send Topic Print
Issues - Field size problem (Read 293 times)
rmh148
Member
**




Posts: 84
Issues - Field size problem
12/21/06 at 08:20:02
 
Here goes!  We had a user enter the part number as the issue quantity, normally no problem, just reverse the issue.  Well, the part number was 9 digits long (5,555,555 million) so the issue worked.  However, I found that when I tried to reverse the issue I got a INVTXN with zero quantity.  The problem appears to be that the field size is 13.4 which works for a positive number, but a negative number needs the "-" sign, and does not work.  The work around is to split the 5,555,555 into multiple transactions not to exceed 999,999 when doing a credit!  By the way, it also messed up the quantity in WIP and AVGC on the item because these are being dynamically incremented.
Back to top
 
 
  IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: Issues - Field size problem
Reply #1 - 12/21/06 at 12:45:29
 
Rather than reverse the transaction, DBA allows you to back out the original entry. See "Editing Previous Entries" in the WO-G (Issue Material) help. It's probably not worth it, but if you're really unhappy with the results of your reversals, assuming you did them through WO-G, you could back them out as well as the original offending transaction.
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Issues - Field size problem
Reply #2 - 12/22/06 at 06:29:25
 
You can also fix the average cost through IN-K even if there is no quantity.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print