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 strongm 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
- Thread starter armanps
- Start date
can you post your job layout here (print to ascii and paste)
Regards,
Wayne Schulz
Schulz Consulting, LLC
Regards,
Wayne Schulz
Schulz Consulting, LLC
- Thread starter
- #3
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
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
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
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question