Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing to PO

Status
Not open for further replies.

armanps

MIS
Joined
Feb 3, 2004
Messages
9
Location
US
Hi!

I'm trying to to use the Visual Integrator on importing data from an SQL table to MAS' PO.Order. The import was successful except for the Item_Number field of MAS, it doesn't receive any data. Is there a way I can assign data on that (Item_number) field?

TIA,

Arman
 
Is this your referring to?





CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.ORDER P/O Purchase Order Entry File
DATA SOURCE: SQL_MAS
FILE TYPE: ODBC

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

DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 PURCH_ORDER_NO H ACCOUNT REPLACE 00001 ####### No
00002 PO_DATE H DATE REPLACE 00002 YYYY/MM/DD Start: 1 Len: 6
00003 ORDER_TYPE H STRING REPLACE 00003 Start: 1 Len: 1 No
00004 DIVISION_NO H ZERO-FILL REPLACE 00004 Start: 1 Len: 2 No
00005 VENDOR_NO H ACCOUNT REPLACE 00005 ####### No
00006 PO_SHIP_TO_CODE H STRING REPLACE 00006 Start: 1 Len: 4 No
00007 ORDER_STATUS H STRING REPLACE 00007 Start: 1 Len: 1 No
00008 USE_TAX_HDR H YES/NO REPLACE 00008 Start: 1 Len: 1 No
00009 PRINT_PO? H YES/NO REPLACE 00009 Start: 1 Len: 1 No
00010 ON_HOLD? H YES/NO REPLACE 00010 Start: 1 Len: 1 No
00011 BATCH_FAX H YES/NO REPLACE 00011 Start: 1 Len: 1 No
00012 ORDER_WHSE_CODE H ACCOUNT REPLACE 00012 ### No
00013 TERMS_CODE H ZERO-FILL REPLACE 00013 Start: 1 Len: 2 No
00014 TAX_SCHEDULE H STRING REPLACE 00014 Start: 1 Len: 9 No
00015 ITEM_NUMBER L1 STRING REPLACE 00015 Start: 1 Len: 15 No
00016 LINE_TYPE L STRING REPLACE 00016 Start: 1 Len: 1 No
00017 USE_TAX_LINE L6 YES/NO REPLACE 00017 Start: 1 Len: 1 No
00018 INV_ITM_GL_ACCT L1 ACCOUNT REPLACE 00018 ######### No
00019 COST_TYPE L1 STRING REPLACE 00019 Start: 1 Len: 1 No
00020 ITEM_UM L1 STRING REPLACE 00020 Start: 1 Len: 4 No
00021 WAREHOUSE_CODE L1 ACCOUNT REPLACE 00021 ### No
00022 PRODUCT_LINE L1 STRING REPLACE 00022 Start: 1 Len: 4 No
00023 EXTEND_DESC? L7 YES/NO REPLACE 00023 Start: 1 Len: 1 No
00024 RESCHED? LA YES/NO REPLACE 00024 Start: 1 Len: 1 No
00025 REC_GOODS_UPDT? L6 YES/NO REPLACE 00025 Start: 1 Len: 1 No
00026 ALLOC_LNDED_CST L7 YES/NO REPLACE 00026 Start: 1 Len: 1 No
00027 TAX_CLASS L6 STRING REPLACE 00027 Start: 1 Len: 2 No
00028 U_M_CONV_FACTOR L7 NUMBER REPLACE 00028 No
00029 SPECIAL_ITEM_NO L2 STRING REPLACE 00029 Start: 1 Len: 15 No
00030 UNIT_MEASURE L9 STRING REPLACE 00030 Start: 1 Len: 4 No
00031 GL_ACCT L8 ACCOUNT REPLACE 00031 ######### No
00032 MISC_SLASH LB STRING REPLACE 00032 Start: 1 Len: 1 No
00033 MISC_CODE LB STRING REPLACE 00033 Start: 1 Len: 14 No
00034 VENDOR_NAME H STRING REPLACE 00034 Start: 1 Len: 30 No
00035 SHIP_TO_NAME H STRING REPLACE 00035 Start: 1 Len: 30 No

VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 PO_DATE EXPRESSION N PO1$(8,6)<>DIM(6)
00002 ORDER_TYPE UPPERCASE N SDMRX
00003 DIVISION_NO FILE N AP.DIV
00004 VENDOR_NO FILE N AP.VENDOR
00005 PO_SHIP_TO_CODE FILE N PO.SHIPTO
00006 ORDER_STATUS UPPERCASE N BCNOX
00007 USE_TAX_HDR UPPERCASE N YN
00008 PRINT_PO? UPPERCASE N YN
00009 ON_HOLD? UPPERCASE N YN
00010 BATCH_FAX STRING N YN
00011 ORDER_WHSE_CODE FILE N IM.WHSE
00012 ARDIVISION_NO FILE Y AR.DIV
00013 CUSTOMER_NO FILE Y AR.CUST
00014 TERMS_CODE FILE N AP.TERMS
 
Yes. Did you go into tab #4 and identify your item records?

If each line of your import includes an item, then on tab #4 I usually make the condition be something that is always true -- like field 1 , pos 1,1 <>"?"



Regards,

Wayne Schulz
Schulz Consulting, LLC
 
Thanks a lot Wayne! Your a big help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top