JoeThompson
Programmer
Hello All,
I'm trying to get a PO to import, but I'm getting a validation error that I can't figure out. The error is on the GL_ACCT field. I'm on MAS 90 4.10. I looked at the data in the GL_Account file and the Account that I'm trying to import into is in the AccountKey and RawAccount columns. I've included the job definition below. Can anybody tell me what I'm doing wrong?
Thanks!
Joe
Run Date: 07/10/2006 Page: 1
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
Import the PO file from JEFF.
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.ORDER P/O Purchase Order Entry File
IMPORT FILE: C:\Development\BN\BN\PurchaseOrder\Archive\0040000_0001_POEntry.txt
FILE TYPE: ASCII
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: Y
PASSWORD: NO
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION FIELD IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 PURCH_ORDER_NO H ACCOUNT NEXT ####### No
00002 PO_DATE H DATE REPLACE 00008 MMDDYY No
00003 ORDER_TYPE H STRING REPLACE 00014 Start: 14 Len: 1 No
00004 DIVISION_NO H ZERO-FILL REPLACE 00015 Start: 15 Len: 2 No
00005 VENDOR_NO H ACCOUNT REPLACE 00017 ####### No
00006 PO_SHIP_TO_CODE H STRING REPLACE 00024 Start: 24 Len: 4 No
00007 ORDER_STATUS H STRING REPLACE 00028 Start: 28 Len: 1 No
00008 USE_TAX_HDR H YES/NO REPLACE 00029 Start: 29 Len: 1 No
00009 PRINT_PO? H YES/NO REPLACE 00030 Start: 30 Len: 1 No
00010 ON_HOLD? H YES/NO REPLACE 00031 Start: 31 Len: 1 No
00011 BATCH_FAX H YES/NO REPLACE 00032 Start: 32 Len: 1 No
00012 ORDER_WHSE_CODE H ACCOUNT REPLACE 00033 ### No
00013 TERMS_CODE H ZERO-FILL REPLACE 00036 Start: 36 Len: 2 No
00014 TAX_SCHEDULE H STRING REPLACE 00038 Start: 38 Len: 9 No
00015 ITEM_NUMBER L1 STRING REPLACE 00047 Start: 47 Len: 15 No
00016 LINE_TYPE L STRING REPLACE 00062 Start: 62 Len: 1 No
00017 USE_TAX_LINE L6 YES/NO REPLACE 00063 Start: 63 Len: 1 No
00018 INV_ITM_GL_ACCT L1 ACCOUNT REPLACE 00064 ######### No
00019 COST_TYPE L1 STRING REPLACE 00073 Start: 73 Len: 1 No
00020 ITEM_UM L1 STRING REPLACE 00074 Start: 74 Len: 4 No
00021 WAREHOUSE_CODE L1 ACCOUNT REPLACE 00078 ### No
00022 PRODUCT_LINE L1 STRING REPLACE 00081 Start: 81 Len: 4 No
00023 EXTEND_DESC? L7 YES/NO REPLACE 00085 Start: 85 Len: 1 No
00024 RESCHED? LA YES/NO REPLACE 00086 Start: 86 Len: 1 No
00025 REC_GOODS_UPDT? L6 YES/NO REPLACE 00087 Start: 87 Len: 1 No
00026 ALLOC_LNDED_CST L7 YES/NO REPLACE 00088 Start: 88 Len: 1 No
00027 TAX_CLASS L6 STRING REPLACE 00089 Start: 89 Len: 2 No
00028 U_M_CONV_FACTOR L7 NUMBER REPLACE 00091 No
00029 SPECIAL_ITEM_NO L2 STRING REPLACE 00103 Start: 103 Len: 15 No
00030 UNIT_MEASURE L9 STRING REPLACE 00118 Start: 118 Len: 4 No
00031 GL_ACCT L8 ACCOUNT REPLACE 00122 ######### No
00032 MISC_SLASH LB STRING REPLACE 00131 Start: 131 Len: 1 No
00033 MISC_CODE LB STRING REPLACE 00132 Start: 132 Len: 14 No
00034 VENDOR_NAME H STRING REPLACE 00146 Start: 146 Len: 30 No
00035 VENDOR_ADDRSS1 H STRING REPLACE 00176 Start: 176 Len: 30 No
00036 VENDOR_ADDRSS2 H STRING REPLACE 00206 Start: 206 Len: 30 No
00037 VENDOR_CITY H STRING REPLACE 00236 Start: 236 Len: 20 No
00038 VENDOR_STATE H STRING REPLACE 00256 Start: 256 Len: 2 No
00039 VENDOR_ZIP_CODE H STRING REPLACE 00258 Start: 258 Len: 10 No
00040 SHIP_TO_NAME H STRING REPLACE 00268 Start: 268 Len: 30 No
00041 SHIP_TO_ADDRSS1 H STRING REPLACE 00298 Start: 298 Len: 30 No
00042 SHIP_TO_ADDRSS2 H STRING REPLACE 00328 Start: 328 Len: 30 No
Run Date: 07/10/2006 Page: 2
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION FIELD IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00043 SHIP_TO_CITY H STRING REPLACE 00358 Start: 358 Len: 20 No
00044 SHIP_TO_STATE H STRING REPLACE 00378 Start: 378 Len: 2 No
00045 SHIP_TO_ZIP_CD H STRING REPLACE 00380 Start: 380 Len: 10 No
00046 REQ/EXPR_DATE H DATE REPLACE 00390 MMDDYY No
00047 PURCH_ADDRS_CD H STRING REPLACE 00396 Start: 396 Len: 4 No
00048 SHIP_VIA H STRING REPLACE 00400 Start: 400 Len: 15 No
00049 FOB H STRING REPLACE 00415 Start: 415 Len: 15 No
00050 ARDIVISION_NO H ZERO-FILL REPLACE 00430 Start: 430 Len: 2 No
00051 CUSTOMER_NO H ACCOUNT REPLACE 00432 ####### No
00052 VENDOR_CNTRY_CD H STRING REPLACE 00439 Start: 439 Len: 3 No
00053 SHIP_COUNTRY_CD H STRING REPLACE 00442 Start: 442 Len: 3 No
00054 INVALID_TX_CALC H YES/NO REPLACE 00445 Start: 445 Len: 1 No
00055 NON_TAXABLE_AMT H NUMBER REPLACE 00446 No
00056 JOB_NUMBER L6 STRING REPLACE 00458 Start: 458 Len: 7 No
00057 COST_CODE L6 ACCOUNT REPLACE 00465 ######### No
00058 COST_CODE_TYPE L6 STRING REPLACE 00474 Start: 474 Len: 1 No
00059 DESCRIPTION L1 STRING REPLACE 00475 Start: 475 Len: 30 No
00060 QTY_ORDERED L7 NUMBER REPLACE 00505 No
00061 UNIT_COST L7 NUMBER REPLACE 00519 No
00062 ORDER_EXTENSION L7 NUMBER REPLACE 00533 No
00063 QTY_INVOICED L7 NUMBER REPLACE 00545 No
00064 SPEC_ITEM_DESC L9 STRING REPLACE 00559 Start: 559 Len: 30 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Item Record 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00002 2 Special Item Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00003 3 Misc Charge Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00004 4 Comment Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00005 5 Misc Item Line 00001 00062 00001 = 5
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
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
Run Date: 07/10/2006 Page: 3
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
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
00015 TAX_SCHEDULE FILE N SY.TXSCHDH
00016 INVALID_TX_CALC STRING Y YN
00017 ITEM_NUMBER FILE N IM.ITEM
00018 LINE_TYPE STRING N 12345
00019 USE_TAX_LINE STRING N YN
00020 INV_ITM_GL_ACCT FILE N GL.ACCOUNT
00021 COST_TYPE STRING N 123456
00022 ITEM_UM EXPRESSION N PO2$(71,4)<>DIM(4)
00023 WAREHOUSE_CODE FILE N IM.WHSE
00024 PRODUCT_LINE FILE N IM.PRODUCT
00025 EXTEND_DESC? STRING N YN
00026 RESCHED? STRING N YN
00027 JOB_NUMBER FILE Y JC.JOBS
00028 COST_CODE FILE Y JC.COSTCD
00029 REC_GOODS_UPDT? STRING N YN
00030 WORK_ORDER_NO FILE Y WO.MASTER
00031 ALLOC_LNDED_CST STRING N YN
00032 TAX_CLASS FILE N SY.TXCLASS
00033 U_M_CONV_FACTOR EXPRESSION N PO2[6]>0
00034 SPECIAL_ITEM_NO EXPRESSION N PO2$(1,1 )="*"
00035 UNIT_MEASURE EXPRESSION N PO2$(79,4)<>DIM(4)
00036 GL_ACCT FILE N GL.ACCOUNT
00037 MISC_SLASH STRING N /
00038 MISC_CODE FILE N PO.MISC
I'm trying to get a PO to import, but I'm getting a validation error that I can't figure out. The error is on the GL_ACCT field. I'm on MAS 90 4.10. I looked at the data in the GL_Account file and the Account that I'm trying to import into is in the AccountKey and RawAccount columns. I've included the job definition below. Can anybody tell me what I'm doing wrong?
Thanks!
Joe
Run Date: 07/10/2006 Page: 1
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
Import the PO file from JEFF.
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.ORDER P/O Purchase Order Entry File
IMPORT FILE: C:\Development\BN\BN\PurchaseOrder\Archive\0040000_0001_POEntry.txt
FILE TYPE: ASCII
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: Y
PASSWORD: NO
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION FIELD IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 PURCH_ORDER_NO H ACCOUNT NEXT ####### No
00002 PO_DATE H DATE REPLACE 00008 MMDDYY No
00003 ORDER_TYPE H STRING REPLACE 00014 Start: 14 Len: 1 No
00004 DIVISION_NO H ZERO-FILL REPLACE 00015 Start: 15 Len: 2 No
00005 VENDOR_NO H ACCOUNT REPLACE 00017 ####### No
00006 PO_SHIP_TO_CODE H STRING REPLACE 00024 Start: 24 Len: 4 No
00007 ORDER_STATUS H STRING REPLACE 00028 Start: 28 Len: 1 No
00008 USE_TAX_HDR H YES/NO REPLACE 00029 Start: 29 Len: 1 No
00009 PRINT_PO? H YES/NO REPLACE 00030 Start: 30 Len: 1 No
00010 ON_HOLD? H YES/NO REPLACE 00031 Start: 31 Len: 1 No
00011 BATCH_FAX H YES/NO REPLACE 00032 Start: 32 Len: 1 No
00012 ORDER_WHSE_CODE H ACCOUNT REPLACE 00033 ### No
00013 TERMS_CODE H ZERO-FILL REPLACE 00036 Start: 36 Len: 2 No
00014 TAX_SCHEDULE H STRING REPLACE 00038 Start: 38 Len: 9 No
00015 ITEM_NUMBER L1 STRING REPLACE 00047 Start: 47 Len: 15 No
00016 LINE_TYPE L STRING REPLACE 00062 Start: 62 Len: 1 No
00017 USE_TAX_LINE L6 YES/NO REPLACE 00063 Start: 63 Len: 1 No
00018 INV_ITM_GL_ACCT L1 ACCOUNT REPLACE 00064 ######### No
00019 COST_TYPE L1 STRING REPLACE 00073 Start: 73 Len: 1 No
00020 ITEM_UM L1 STRING REPLACE 00074 Start: 74 Len: 4 No
00021 WAREHOUSE_CODE L1 ACCOUNT REPLACE 00078 ### No
00022 PRODUCT_LINE L1 STRING REPLACE 00081 Start: 81 Len: 4 No
00023 EXTEND_DESC? L7 YES/NO REPLACE 00085 Start: 85 Len: 1 No
00024 RESCHED? LA YES/NO REPLACE 00086 Start: 86 Len: 1 No
00025 REC_GOODS_UPDT? L6 YES/NO REPLACE 00087 Start: 87 Len: 1 No
00026 ALLOC_LNDED_CST L7 YES/NO REPLACE 00088 Start: 88 Len: 1 No
00027 TAX_CLASS L6 STRING REPLACE 00089 Start: 89 Len: 2 No
00028 U_M_CONV_FACTOR L7 NUMBER REPLACE 00091 No
00029 SPECIAL_ITEM_NO L2 STRING REPLACE 00103 Start: 103 Len: 15 No
00030 UNIT_MEASURE L9 STRING REPLACE 00118 Start: 118 Len: 4 No
00031 GL_ACCT L8 ACCOUNT REPLACE 00122 ######### No
00032 MISC_SLASH LB STRING REPLACE 00131 Start: 131 Len: 1 No
00033 MISC_CODE LB STRING REPLACE 00132 Start: 132 Len: 14 No
00034 VENDOR_NAME H STRING REPLACE 00146 Start: 146 Len: 30 No
00035 VENDOR_ADDRSS1 H STRING REPLACE 00176 Start: 176 Len: 30 No
00036 VENDOR_ADDRSS2 H STRING REPLACE 00206 Start: 206 Len: 30 No
00037 VENDOR_CITY H STRING REPLACE 00236 Start: 236 Len: 20 No
00038 VENDOR_STATE H STRING REPLACE 00256 Start: 256 Len: 2 No
00039 VENDOR_ZIP_CODE H STRING REPLACE 00258 Start: 258 Len: 10 No
00040 SHIP_TO_NAME H STRING REPLACE 00268 Start: 268 Len: 30 No
00041 SHIP_TO_ADDRSS1 H STRING REPLACE 00298 Start: 298 Len: 30 No
00042 SHIP_TO_ADDRSS2 H STRING REPLACE 00328 Start: 328 Len: 30 No
Run Date: 07/10/2006 Page: 2
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION FIELD IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00043 SHIP_TO_CITY H STRING REPLACE 00358 Start: 358 Len: 20 No
00044 SHIP_TO_STATE H STRING REPLACE 00378 Start: 378 Len: 2 No
00045 SHIP_TO_ZIP_CD H STRING REPLACE 00380 Start: 380 Len: 10 No
00046 REQ/EXPR_DATE H DATE REPLACE 00390 MMDDYY No
00047 PURCH_ADDRS_CD H STRING REPLACE 00396 Start: 396 Len: 4 No
00048 SHIP_VIA H STRING REPLACE 00400 Start: 400 Len: 15 No
00049 FOB H STRING REPLACE 00415 Start: 415 Len: 15 No
00050 ARDIVISION_NO H ZERO-FILL REPLACE 00430 Start: 430 Len: 2 No
00051 CUSTOMER_NO H ACCOUNT REPLACE 00432 ####### No
00052 VENDOR_CNTRY_CD H STRING REPLACE 00439 Start: 439 Len: 3 No
00053 SHIP_COUNTRY_CD H STRING REPLACE 00442 Start: 442 Len: 3 No
00054 INVALID_TX_CALC H YES/NO REPLACE 00445 Start: 445 Len: 1 No
00055 NON_TAXABLE_AMT H NUMBER REPLACE 00446 No
00056 JOB_NUMBER L6 STRING REPLACE 00458 Start: 458 Len: 7 No
00057 COST_CODE L6 ACCOUNT REPLACE 00465 ######### No
00058 COST_CODE_TYPE L6 STRING REPLACE 00474 Start: 474 Len: 1 No
00059 DESCRIPTION L1 STRING REPLACE 00475 Start: 475 Len: 30 No
00060 QTY_ORDERED L7 NUMBER REPLACE 00505 No
00061 UNIT_COST L7 NUMBER REPLACE 00519 No
00062 ORDER_EXTENSION L7 NUMBER REPLACE 00533 No
00063 QTY_INVOICED L7 NUMBER REPLACE 00545 No
00064 SPEC_ITEM_DESC L9 STRING REPLACE 00559 Start: 559 Len: 30 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Item Record 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00002 2 Special Item Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00003 3 Misc Charge Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00004 4 Comment Line 00001 00001 00001 =
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
00005 5 Misc Item Line 00001 00062 00001 = 5
PERFORM: AFTER WRITE ../po/powvip;PO_ORDER
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
Run Date: 07/10/2006 Page: 3
V/I Date: 07/10/2006 JOB DEFINITION PRINTING FOR JOB: JEFF_PO_IMPRT Time: 03:38 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
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
00015 TAX_SCHEDULE FILE N SY.TXSCHDH
00016 INVALID_TX_CALC STRING Y YN
00017 ITEM_NUMBER FILE N IM.ITEM
00018 LINE_TYPE STRING N 12345
00019 USE_TAX_LINE STRING N YN
00020 INV_ITM_GL_ACCT FILE N GL.ACCOUNT
00021 COST_TYPE STRING N 123456
00022 ITEM_UM EXPRESSION N PO2$(71,4)<>DIM(4)
00023 WAREHOUSE_CODE FILE N IM.WHSE
00024 PRODUCT_LINE FILE N IM.PRODUCT
00025 EXTEND_DESC? STRING N YN
00026 RESCHED? STRING N YN
00027 JOB_NUMBER FILE Y JC.JOBS
00028 COST_CODE FILE Y JC.COSTCD
00029 REC_GOODS_UPDT? STRING N YN
00030 WORK_ORDER_NO FILE Y WO.MASTER
00031 ALLOC_LNDED_CST STRING N YN
00032 TAX_CLASS FILE N SY.TXCLASS
00033 U_M_CONV_FACTOR EXPRESSION N PO2[6]>0
00034 SPECIAL_ITEM_NO EXPRESSION N PO2$(1,1 )="*"
00035 UNIT_MEASURE EXPRESSION N PO2$(79,4)<>DIM(4)
00036 GL_ACCT FILE N GL.ACCOUNT
00037 MISC_SLASH STRING N /
00038 MISC_CODE FILE N PO.MISC