Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
JKatulka
Posts: 215
Registered: 07-19-2010
0

SO VI Import Comment Line

Does anyone have any examples of this in MAS 4.40+?  Seems like no matter what I do, I can't get a comment line imported, just regular items.  Any help would be appreciated.

Justin
Regular Contributor
Gator
Posts: 270
Registered: 12-05-2008
0

Re: SO VI Import Comment Line

This should be pretty straight forward.  You would just need to have the ItemCode and CommentText fields set (ItemType should set itself, but perhaps this one too).  What kind of error is it throwing during the import?  Also what does your Records tab look like?

Sage MAS Partner
JKatulka
Posts: 215
Registered: 07-19-2010
0

Re: SO VI Import Comment Line

Hi Gator,

 

I agree it should be pretty straightforward, and I've muscled my way through some VI humdingers in the past, but alas, I'm unable to get a comment line in.

 

My header and detail are on the same line, so, - correct me if I'm wrong - my Records tab should be empty.  Basically, I have a column in my source file containing item codes.  If the column is empty, I have a condition to assign the item code '\C' (which I agree should automatically set the item type to 4).

 

Interestingly, no errors are being thrown, the import just completely ignores the comment line - it's not present in the log.  I will attempt to set the item type column conditonally, I just wanted to see if there were any tricks I was unaware of in regards to importing comments.  Thanks for your input gator. 

Justin
Regular Contributor
Gator
Posts: 270
Registered: 12-05-2008
0

Re: SO VI Import Comment Line

I wonder if the conditional is failing (and I assume you put "/C" and not "\C").  I would try hard-coding all ItemCode to "/C" and see what it does.  Does it ignore every line now?

Sage MAS Partner
JKatulka
Posts: 215
Registered: 07-19-2010
0

Re: SO VI Import Comment Line

OK.  I assigned '/C' to every line and it recognized the lines as comments - I had some other conditional replaces on 'item type 1' related fields that must have been throwing it off.  I removed all and will now work on getting the conditions back in place working properly.  Thanks so much for the suggestions gator - I'll post back when complete to let all know the results.

Justin