ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Issues - Field size problem
http://www.istechforum.com/YaBB.pl?num=1166718002

Message started by rmh148 on 12/21/06 at 08:20:02

Title: Issues - Field size problem
Post by rmh148 on 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.

Title: Re: Issues - Field size problem
Post by Cyndee Pappas on 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.

Title: Re: Issues - Field size problem
Post by Karen Mason on 12/22/06 at 06:29:25

You can also fix the average cost through IN-K even if there is no quantity.