Mas90 v. 4.3
I'm trying to import new sales orders into v. 4.3. I am able to import regular inventory lines successfully, but my misc item lines are being rejected. In earlier versions I think there was a separate field for the misc item codes. I'm assuming the misc item code goes in the L.ItemCode field now. I've got line type 5 in the data file, and I've indicated that line type is the field to consider in record selection. I've pasted the import listing below. When I test the import, the line is rejected. L.ItemCode fails, with the message Item Code is not on file.
Should I be using a different field for the misc item code?
Thanks,
Kath
Import Job Definition ABC Distribution and Service Corp. (ABC)
Configuration Information
Table Name: SO_SalesOrderHeader
Import File: C:\data\current\Clients\ARXMisc\Royal\TestdataABC.csv
File Type: DELIMITED Delimiter: , Import File On Host:
Next Job Chain:
Job Name: ROYSOIMP Compiled Name: VIWI0C
Data Elements
Seq No Column Name Type Type Oper Col Mask Default Value
Data Field
0001 H.SalesOrderNo STR STD REPL 2 Start: 1 Len: 7
0002 H.ARDivisionNo STR STD REPL 3 00
Import Substring: Pos: 1.00 Len: 2.00 Record Substring: Pos: 1.00 Len: 2.00
0003 H.CustomerNo STR STD REPL 3 Start: 4 Len: 4
Import Substring: Pos: 4.00 Len: 4.00 Record Substring: Pos: 1.00 Len: 7.00
0004 H.OrderDate STR DATE REPL 1 M/D/Y
0005 H.ShipToCode STR STD REPL 4 Start: 1 Len: 4
0006 H.CorporateTaxOverrd STR Y/N ASSN 4 Start: 1 Len: 1 N
0007 H.DepositCorporateTaxOverrd STR Y/N ASSN 5 Start: 1 Len: 1 N
0008 L.ItemType STR STD REPL 7 Start: 1 Len: 1
0009 L.ItemCode STR STD REPL 5 Start: 1 Len: 15
0010 L.WarehouseCode STR STD REPL 6 Start: 1 Len: 3
0011 L.UnitOfMeasure STR STD REPL 8 Start: 1 Len: 4
0012 L.QuantityOrdered NUM STD REPL 9 ##,###,###.000000-
0013 L.UnitPrice NUM STD REPL 10 ##,###,###.000000-
Record Type Elements
Seq No Type Description Col/Pos Start Len Relation Value
0001 1 RegularItem 7 1 1= 1
0002 5 MiscellaneousItem 7 1 1= 5
