Hi,
I'm trying to import AP invoices in MAS90, but so far I have problem importing invoice amount in the detail line.
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: AP.INVOICE A/P Invoice Data Entry File
DATA SOURCE: New Invioice
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 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00002 VENDOR_NO H ACCOUNT REPLACE 00001 ####### No
00003 INVOICE_NO H STRING REPLACE 00002 Start: 1 Len: 10 No
00004 INVOICE_DATE H DATE REPLACE 00003 YYYY/MM/DD No
00005 INVC_DUE_DATE H DATE REPLACE 00003 YYYY/MM/DD No
00006 TERMS_CODE H ZERO-FILL FILE ASSIGN AP.VENDOR:TERMS_CODE No
00007 HOLD_PAYMENT H YES/NO REPLACE 00007 Start: 1 Len: 1 No
00008 ADJUSTMENT H YES/NO REPLACE 00008 Start: 1 Len: 1 No
00009 RECUR_INVOICE H YES/NO REPLACE 00009 Start: 1 Len: 1 No
00010 SEPARATE_CHECK H YES/NO ASSIGN N No
00011 GL_JC_LINE_TYPE LA STRING REPLACE 00015 Start: 1 Len: 1 No
00012 EMPLOYEE_CODE LB ACCOUNT REPLACE 00016 #### No
00013 CLIENT_CODE LB ACCOUNT REPLACE 00017 ####### No
00014 ENGAGEMENT_CODE LB ACCOUNT REPLACE 00018 #### No
00015 WORK_CODE LB ACCOUNT REPLACE 00019 ### No
00016 CATEGORY_CODE LB ACCOUNT REPLACE 00020 ### No
00017 BILL_TYPE LB STRING REPLACE 00021 Start: 1 Len: 1 No
00018 BILL_TAXABLE LB YES/NO REPLACE 00022 Start: 1 Len: 1 No
00019 EXTND_COMMENTS LB YES/NO REPLACE 00023 Start: 1 Len: 1 No
00020 RATE_METHOD LB STRING REPLACE 00024 Start: 1 Len: 1 No
00021 BATCH_NUMBER H ACCOUNT ASSIGN CATEX No
00022 INVOICE_AMT H NUMBER REPLACE 00004 No
00023 GL_ACCOUNT L STRING FILE ASSIGN AP.VENDOR:STANDARD_GL No
00024 GL_JC_COMMENT LA STRING REPLACE 00006 Start: 1 Len: 30 No
00025 TB_COMMENT LB STRING REPLACE 00007 Start: 1 Len: 30 No
00026 TRNSF_1099_FORM L STRING FILE ASSIGN AP.VENDOR
EFLT_1099_FORM No
00027 GL_ACCOUNT L STRING REPLACE 00005 Start: 1 Len: 7 No
00028 AP6_LINE_INDEX L STRING ASSIGN 1 No
00029 AMOUNT LA NUMBER REPLACE 00009 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 H Header Record 00009 00001 00001 <> 0
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
00002 H Header Record 00001 00001 00001 <> 0
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
00003 1 Gl/Jc Line Type 00009 00001 00010 <> 0
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 DIVISION_NO FILE N AP.DIV
Run Date: 07/24/2006 Sidley Austin Catering Page: 2
V/I Date: 07/24/2006 JOB DEFINITION PRINTING FOR JOB: AP Time: 02:44 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00002 VENDOR_NO FILE N AP.VENDOR
00003 INVOICE_NO EXPRESSION N AP5$(10,10)<>DIM(10) AND AP5$(10,10)=UCS(AP5$(10,10))
00004 INVOICE_DATE EXPRESSION N AP5$(20,6)<>DIM(6)
00005 INVC_DUE_DATE EXPRESSION N AP5$(26,6)<>DIM(6)
00006 TERMS_CODE FILE N AP.TERMS
00007 HOLD_PAYMENT UPPERCASE N YN
00008 JOB_NUMBER FILE Y JC.JOBS
00009 ADJUSTMENT UPPERCASE N YN
00010 RECUR_INVOICE UPPERCASE N YN
00011 1099_FORM STRING Y MID
00012 1099_BOX EXPRESSION Y AP5$(103,2)<>DIM(2)
00013 SEPARATE_CHECK UPPERCASE N YN
00014 GL_ACCOUNT FILE Y GL_Account
00015 JOB_NUMBER_LINE FILE Y JC.JOBS
00016 COST_CODE FILE Y JC.COSTCD
00017 GL_JC_LINE_TYPE EXPRESSION N AP6$(84,1)=DIM(1)
00018 EMPLOYEE_CODE FILE N TB.EMPLY
00019 CLIENT_CODE FILE N TB.CLIENT
00020 ENGAGEMENT_CODE FILE N TB.ENGAGE
00021 WORK_CODE FILE N TB.WORKCD
00022 CATEGORY_CODE FILE N TB.CATEGRY
00023 BILL_TYPE UPPERCASE N EX
00024 BILL_TAXABLE STRING N YN
00025 EXTND_COMMENTS STRING N YN
00026 RATE_METHOD STRING N REF
00027 TRANSFER_DIV FILE Y AP.DIV
00028 TRANSFER_VENDOR FILE Y AP.VENDOR
00029 TRNSF_INVCE_NO EXPRESSION Y AP6$(110,10)=UCS(AP6$(110,10))
Here is the import file:
Vendor No INV NO INV Date INV Am GL ACC GL Comment TB Comment Ext Comment Amount
1234 1 2/5/2006 6000 5100-01 babab uha ohjo 6000
I'm doing something wrong, but have no idea what it is
Please help!
I'm trying to import AP invoices in MAS90, but so far I have problem importing invoice amount in the detail line.
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: AP.INVOICE A/P Invoice Data Entry File
DATA SOURCE: New Invioice
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 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00002 VENDOR_NO H ACCOUNT REPLACE 00001 ####### No
00003 INVOICE_NO H STRING REPLACE 00002 Start: 1 Len: 10 No
00004 INVOICE_DATE H DATE REPLACE 00003 YYYY/MM/DD No
00005 INVC_DUE_DATE H DATE REPLACE 00003 YYYY/MM/DD No
00006 TERMS_CODE H ZERO-FILL FILE ASSIGN AP.VENDOR:TERMS_CODE No
00007 HOLD_PAYMENT H YES/NO REPLACE 00007 Start: 1 Len: 1 No
00008 ADJUSTMENT H YES/NO REPLACE 00008 Start: 1 Len: 1 No
00009 RECUR_INVOICE H YES/NO REPLACE 00009 Start: 1 Len: 1 No
00010 SEPARATE_CHECK H YES/NO ASSIGN N No
00011 GL_JC_LINE_TYPE LA STRING REPLACE 00015 Start: 1 Len: 1 No
00012 EMPLOYEE_CODE LB ACCOUNT REPLACE 00016 #### No
00013 CLIENT_CODE LB ACCOUNT REPLACE 00017 ####### No
00014 ENGAGEMENT_CODE LB ACCOUNT REPLACE 00018 #### No
00015 WORK_CODE LB ACCOUNT REPLACE 00019 ### No
00016 CATEGORY_CODE LB ACCOUNT REPLACE 00020 ### No
00017 BILL_TYPE LB STRING REPLACE 00021 Start: 1 Len: 1 No
00018 BILL_TAXABLE LB YES/NO REPLACE 00022 Start: 1 Len: 1 No
00019 EXTND_COMMENTS LB YES/NO REPLACE 00023 Start: 1 Len: 1 No
00020 RATE_METHOD LB STRING REPLACE 00024 Start: 1 Len: 1 No
00021 BATCH_NUMBER H ACCOUNT ASSIGN CATEX No
00022 INVOICE_AMT H NUMBER REPLACE 00004 No
00023 GL_ACCOUNT L STRING FILE ASSIGN AP.VENDOR:STANDARD_GL No
00024 GL_JC_COMMENT LA STRING REPLACE 00006 Start: 1 Len: 30 No
00025 TB_COMMENT LB STRING REPLACE 00007 Start: 1 Len: 30 No
00026 TRNSF_1099_FORM L STRING FILE ASSIGN AP.VENDOR
EFLT_1099_FORM No00027 GL_ACCOUNT L STRING REPLACE 00005 Start: 1 Len: 7 No
00028 AP6_LINE_INDEX L STRING ASSIGN 1 No
00029 AMOUNT LA NUMBER REPLACE 00009 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 H Header Record 00009 00001 00001 <> 0
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
00002 H Header Record 00001 00001 00001 <> 0
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
00003 1 Gl/Jc Line Type 00009 00001 00010 <> 0
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 DIVISION_NO FILE N AP.DIV
Run Date: 07/24/2006 Sidley Austin Catering Page: 2
V/I Date: 07/24/2006 JOB DEFINITION PRINTING FOR JOB: AP Time: 02:44 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00002 VENDOR_NO FILE N AP.VENDOR
00003 INVOICE_NO EXPRESSION N AP5$(10,10)<>DIM(10) AND AP5$(10,10)=UCS(AP5$(10,10))
00004 INVOICE_DATE EXPRESSION N AP5$(20,6)<>DIM(6)
00005 INVC_DUE_DATE EXPRESSION N AP5$(26,6)<>DIM(6)
00006 TERMS_CODE FILE N AP.TERMS
00007 HOLD_PAYMENT UPPERCASE N YN
00008 JOB_NUMBER FILE Y JC.JOBS
00009 ADJUSTMENT UPPERCASE N YN
00010 RECUR_INVOICE UPPERCASE N YN
00011 1099_FORM STRING Y MID
00012 1099_BOX EXPRESSION Y AP5$(103,2)<>DIM(2)
00013 SEPARATE_CHECK UPPERCASE N YN
00014 GL_ACCOUNT FILE Y GL_Account
00015 JOB_NUMBER_LINE FILE Y JC.JOBS
00016 COST_CODE FILE Y JC.COSTCD
00017 GL_JC_LINE_TYPE EXPRESSION N AP6$(84,1)=DIM(1)
00018 EMPLOYEE_CODE FILE N TB.EMPLY
00019 CLIENT_CODE FILE N TB.CLIENT
00020 ENGAGEMENT_CODE FILE N TB.ENGAGE
00021 WORK_CODE FILE N TB.WORKCD
00022 CATEGORY_CODE FILE N TB.CATEGRY
00023 BILL_TYPE UPPERCASE N EX
00024 BILL_TAXABLE STRING N YN
00025 EXTND_COMMENTS STRING N YN
00026 RATE_METHOD STRING N REF
00027 TRANSFER_DIV FILE Y AP.DIV
00028 TRANSFER_VENDOR FILE Y AP.VENDOR
00029 TRNSF_INVCE_NO EXPRESSION Y AP6$(110,10)=UCS(AP6$(110,10))
Here is the import file:
Vendor No INV NO INV Date INV Am GL ACC GL Comment TB Comment Ext Comment Amount
1234 1 2/5/2006 6000 5100-01 babab uha ohjo 6000
I'm doing something wrong, but have no idea what it is
Please help!