Error 47 w/VI

[davewalden777]

We are getting an error-47(substring out of range) during an
import using Visual Integrator. The data appears to load fine, the error seems to occur when Mas is calculating the SO order total(SO_CALC_TOTAL job after import). The only things we have changed in the last few weeks are importing the new 2004 tax tables and recently adding/modifying some price levels. I have rebuilt the IM key/sort files with no luck.
Error screen data:
Program: SOWVIP Line: 30190
File: S)_12MII.SAO - IM_03 I/M Extended Item Desc.
Key: "90000-3 000"
Our actual item # is 90000-3, are the spaces and 000 tacked on to the end by Mas? It looks like the items ext. desc. is to long, or the char count for the desc. is wrong? Should I just reimport the ext. desc.? I don't think this is the only item causing the problem, is there any way to find which ones are without just redoing all the desc.?
Any ideas on the cause/solution would be appreciated.

 

[mas90guru]

You're probably on the right track with the length of the field possibly causing the problem. It seems likely that some data is being read in -- then when the calculation takes place the system is balking.

Regards,

Wayne Schulz
Schulz Consulting, LLC

http://www.s-consult.com

 

[davewalden777]

Thanks guru. I also found an error on the import list I got from our pricing guys. Then import sheet had the old item# 90000-4 instead of the 90000-3 item. When I checked the 90000-3 in Inv. Man. it didn't have a std-cost value(among other missing data) so there wasn't any thing for Mas to use to do the final order totals.
Question: when I import the ext.descriptions I do it in 3+ steps.

1st pass: set the ext. desc. flag to Y for each item#
2nd pass: set seq.#=000 & import the total string length
3rd pass: set seq.#=001 and import the first 50 chars.
...repeat step 3 until entire string is imported - ...incrementing the seq.# for each block new block of chars.

This setup was in place when I took over the IT/Mas stuff so I was just curious if this sounds right. Is there an easier way? Currently I use a .csv file in excell with columns for: item#,strlen,char block,char block,.... then just inc. the seq.# and the import column for each pass.

Any replies/info would be greatly appreciated, but no hurry.

 

[mas90guru]

Yes that is the way Best recommends doing the Extended.

Regards,

Wayne Schulz
Schulz Consulting, LLC

http://www.s-consult.com