Import comment line into SO using VI 2

[Sorebrek]

Using MAS200 version 3.7.1

I currently import Sales orders, including multiple line orders via VI, no problem there. I would like at a later time to do another import into SO which will add a comment line to the order (has some payment information)

I setup an import with all the required fields. I have an import field for the order number (which already exists). I use /C for the item number, and another field for the comment. Looking at existing comment records using Data File Display, it appears I need to set the Line Type field to 4 (although I have also tried 1, for normal lines).
When I run the import however, no lines are imported. Has someone else imported comment lines or have any ideas about what might be missing?
Thanks for thinking about this!

 

[Blorf]

Hi.

Under the records tab, you will need to add logic to the comments record item that says do this one if field X = 4 (Your line type field)

That should make it behave correctly.

ChaZ

 

[Sorebrek]

Thanks for the reply ChaZ. I'm still unable to get this to work.

On the Records tab I have selected Comment as the type. I unchecked the perform logic and selected to look at position one (my order number field), set a length of six characters and chose a relation value of anything > 0. I would think this should import all the records, as all the order numbers are greater than 0.
I have the second position of import a /C, which I'm importing into the item number field, and the third field is the comments.
When I run a test import I do not get any errors and it indicates the import was successful, but when I run the actual import nothing is imported.
I now have two applications where imported comment fields would be very useful. Any further help in this is greatly appreciated.

 

[Blorf]

Hi. Can you post your job? Maybe I will see something.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Sorebrek]

Here it is:

CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: SO.ORDER S/O Sales Order Entry File
IMPORT FILE: C:\FTP\Orders\Authout.csv
FILE TYPE: DELIMITED

INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: N
PASSWORD: NO

DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 ORDER_NUMBER H ACCOUNT REPLACE 00001 ####### No
00002 ORDER_TYPE H STRING ASSIGN S No
00003 DIVISION_NO H ZERO-FILL ASSIGN 01 No
00004 CUSTOMER_NO H ACCOUNT ASSIGN 0001500 No
00005 ORDER_STATUS H STRING ASSIGN N No
00006 DEFAULT_WHSE H ACCOUNT ASSIGN 005 No
00007 TAX_SCHEDULE H STRING ASSIGN NONTAX No
00008 TERMS_CODE H ZERO-FILL ASSIGN 06 No
00009 SALESPRSN_NO H ACCOUNT ASSIGN 0000 No
00010 PRNT_SALES_ORD? H YES/NO ASSIGN Y No
00011 PRNT_PICK_SHTS? H YES/NO ASSIGN Y No
00012 BATCH_FAX H YES/NO ASSIGN N No
00013 LOT_SERNO_EXIST H YES/NO ASSIGN N No
00014 SPLIT_COMMSN H STRING ASSIGN N No
00015 ITEM_NUMBER L1 STRING ASSIGN /C No
00016 ITEM_DESC L1 STRING REPLACE 00003 Start: 1 Len: 30 No
00017 INVALID_TX_CALC H YES/NO ASSIGN N No
00018 AUTH_REQD_FLAG H YES/NO ASSIGN N No

RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 4 Comment Record 00001 00001 00006 > 0
PERFORM: AFTER WRITE ../so/sowvip;SO_ORDER

 

[Blorf]

Hi. Just a guess but try chaning your record slection to say field 15, start 1, length 2 = /C

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[wolfe1]

I did this recently so maybe I can help you. I have a mix of item numbers, comments and misc charge items.

I added the following fields MISC_SLASH, MISC_CODE, COMM_DESC_LINE1 & COMM_DESC_LINE2 (optional)

00033 MISC_SLASH LC STRING REPLACE 00003 Start: 1 Len: 1 No
00034 MISC_CODE LC STRING REPLACE 00003 Start: 2 Len: 14 No
00069 COMM_DESC_LINE1 L4 STRING REPLACE 00004 Start: 1 Len: 50 No
00072 COMM_DESC_LINE2 L4 STRING REPLACE 00005 Start: 1 Len: 50 No

For record selection:
00004 4 Comment Record 00001 00001 00001 = C
PERFORM: AFTER WRITE ../so/sowvip;SO_ORDER


So my ('|' delimited) input file would look like this
[SO Num]|C|/C|* SPECIAL PRICING *|* SPECIAL INSTRUCTIONS *

 

[wolfe1]

The above was cut and pasted from my import which contains about 60 fields, so I hope I didn't leave anything out.

 

[Sorebrek]

Thanks Wolfe1, I believe this is it.

Either I'm overworked or MAS documentation is weak (maybe both?

I was trying to import my comment into the item description field. Now that I look at your info, and refer to the SO2 record type 4 detail in the TRSG, it all makes sense.

It would be helpful if Best would provide sample imports for different record types in each module.