ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> New inventory fields
http://www.istechforum.com/YaBB.pl?num=1230672713

Message started by deburr on 12/30/08 at 14:31:53

Title: New inventory fields
Post by deburr on 12/30/08 at 14:31:53

Anybody figure out how to use or access the new inventory user defined fields?

Title: Re: New inventory fields
Post by deburr on 01/12/09 at 10:33:59

The update description below mentions "up to 40 user defined fields" for inventory. This was the main reason I rushed to install this update, but I can't find a hint of theses new fields. Anybody install the update yet, and have any luck finding these?

"The DBA Classic/Evo-ERP update posted December 21, 2008 includes future accounting post date control,Long AP Invoice numbers, PO Receiving Label printing, and payroll data encryption for both DBA Classic and Evo-ERP, enhanced Features and Options capability and up to 40 User Defined inventory fields for Evo-ERP, and numerous bug fixes for both platforms."

Title: Re: New inventory fields
Post by NovaZyg on 01/12/09 at 13:34:42

To setup these new Inventory fields you must run SM-P-E..  

this will let you use MTIC.PROD.SUBST[2 - 5]  each one is 25 characters  and you can specify the Number (mostly for screen position). A Label (text on the screen) What field to store it in ( MKIC.PROD.SUBSTR[2 - 5]) and the starting position and length in that field. once you have that filled in, then T7INA and T7INB will have a new tab called User Defined.

Title: Re: New inventory fields
Post by deburr on 01/13/09 at 10:30:58

Thanks Allen. I always check SD-Q as Lynn suggests after an update, but I never thought to check SM-P. Now I have found the instructions in the help files, and I should be all set. Without your help, I never would have found that.


Title: Re: New inventory fields
Post by RPCAdmin on 02/23/09 at 08:36:23

BTW - is it safe to assume that the new fields are only visible and usable in the EVO version of T7INA and not in the DBA version of T7INA?

Title: Re: New inventory fields
Post by RPCAdmin on 02/23/09 at 08:46:58

Allen,

One more thing - the descriptions of the fields seem to be limited.  If I type in a longer description, the description won't fit.  Not sure what the location number does, I have tried a few settings (10, 200, 3000) and it doesn't seem to change the start location of the field.

Title: Re: New inventory fields
Post by NovaZyg on 02/23/09 at 09:30:19

Where are you seeing Location number?  There is UDF Number, UDF Label, Inventory Field, Start Pos, and Length.

UDF Number controls the Screen Position, UDF label is the Name you want to give it on the screen (and yes it is limited to something like 10 chars) , Inventory field can de MITC.PROD.SUBST[2], [3], [4], or [5] , start pos is from 1 to 25, and length can be 1 to 25.


Seeing as this is a new feature it is only on the Tabbed views of T7INB and T7INA.


Title: Re: New inventory fields
Post by RPCAdmin on 02/23/09 at 10:10:00

Allen,

Yeah - I mispoke - The Start Position is what I am curious about.  What does it represent? (start position in the overall field of 100?  So if I start all of them at position 1, that is bad? ----or is it the start position after the end of the last field?)  How does it work?

Title: Re: New inventory fields
Post by NovaZyg on 02/23/09 at 10:43:26

example :  MITC.PROD.SUBST[2]    it is alphanumeric size 25.   1234567890123456789012345
                                                                                             test    fred     Bubba  junk 180


So in the above i have 5 UDF fields   udf1  label= 'TYPE'  Start pos = 1 leng = 5   value in this example is 'test '
                                                    udf2  label= 'Name' start pos = 6 leng = 6   value in this example is 'fred  '
                                                    udf3  label= 'Ref'    start pos = 13 leng = 6  value "            "           'Bubba '
                                                   

if start pos were all 1 then when the data was saved,  they would all write to the same place and the last one to save would erase the previous ones.   so in the example above if all had start pos 1  the field MITC.PROD.SUBST[2] would look like this in maintain database
                                                    1234567890123456789012345
                                                   180ka

as it was saved it would have been test
                                                   fred
                                                   Bubba
                                                   junka
                                                   180ka


ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.