Sage 100

Not really Urgent Urgent, but I need to close this project and this is my last step! Does anyone know if it is possible to use temp fields to create an item code when it's the key field in VI? I have a spreadsheet has the complete Item number in column 3 like this BRD15-GA-SUT-TR-BL-N-Y-D-WC-00 Each section is its own part (i.e. BRD15 is a part, GA is a part, etc.) I need to add a word before each section (BADGE:BR15, Finish:GA, etc) to further define them I created two temp fields, Temp1: Assign = ""Finish;"" Temp 2: Replace, Col 3, (substring 7,2,30), placed them above the item code and attempted to calculate the item code field with Temp001$+Temp002$, but I get errors saying the item code is required. anyone know a way around this?

in the field properties for the temp variable look for the field for ""assign temp on"" and set it to ""Key Assigns Only

I hit send before I was done, but that should populate the temp variable and allow the calculation to concatenate those fields properly.

David is correct Michelle, you should have no problem accomplishing what you're trying to do.

That Worked! Thank you so much, I was banging my head against the wall on that one. Tricky little temp fields :)

Cool - I've been wondering about that one for a couple years. ""Assign temp on key assigns only"". What a concept :)

I also pulled my hair out on that one once and after I figured it out I vowed not never forget that again!