First of all, we're on Version 4.05.
I've created a simple vi job to import AP invoices from a delimited file. The import SEEMS to work; there are no errors, and I can see the invoices in the invoice register. However, If I go to Invoice Data Entry, I can see that no batch was created.
I've tried setting perform logic to AP_INVOICE_MANUAL and AP_INVOICE_CALC (as was suggested to a user experiencing a similar problem.) Still no luck.
TEST COMPANY, INC.
JOB DEFINITION PRINTING FOR JOB: AP_REF_INVOICE
CONFIGURATION INFORMATION
FILE NAME: AP.INVOICE A/P Invoice Data Entry File
IMPORT FILE: C:\Refund\REFUNDTEST001.TXT
FILE TYPE: DELIMITED DELIMITER: ~
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: Y
PASSWORD: NO
PERFORM: ON SUCCESS ../ap/apwvip;AP_INVOICE_MANUAL
PERFORM: ON FAILURE ../ap/apwvip;AP_INVOICE_MANUAL
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 00012 ####### No
00003 INVOICE_NO H STRING REPLACE 00012 Start: 1 Len: 10 No
00004 TERMS_CODE H ZERO-FILL ASSIGN 00 No
00005 HOLD_PAYMENT H YES/NO ASSIGN N No
00006 ADJUSTMENT H YES/NO ASSIGN N No
00007 RECUR_INVOICE H YES/NO ASSIGN N No
00008 SEPARATE_CHECK H YES/NO ASSIGN N No
00009 CATEGORY_CODE LB ACCOUNT ASSIGN No
00010 BILL_TYPE LB STRING ASSIGN E No
00011 BILL_TAXABLE LB YES/NO ASSIGN N No
00012 INVC_COMMENT H STRING ASSIGN REFUND No
00013 INVOICE_AMT H NUMBER REPLACE 00011 No
00014 GL_ACCOUNT L STRING ASSIGN 470000100 No
00015 INVALID_TX_CALC H YES/NO ASSIGN N No
00016 USE_TAX H YES/NO ASSIGN N No
00017 TAX_CLASS H STRING ASSIGN NT No
00018 TAX_SCHEDULE H STRING ASSIGN NONTAX No
00019 INVOICE_DATE H DATE REPLACE 00002 YYYYMMDD No
00020 INVC_DUE_DATE H DATE REPLACE 00002 YYYYMMDD No
RECORD SELECTION
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
00001 1 Gl/Jc Line Type 00001 00001 00001 =
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
00002 2 Tb Line Type 00001 00001 00001 =
PERFORM: AFTER WRITE ..\AP\APWVIP;AP_INVOICE
VALIDATION RECORDS
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
00001 DIVISION_NO FILE N AP.DIV
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 TAX_SCHEDULE FILE N SY.TXSCHDH
00015 TAX_CLASS FILE N SY.TXCLASS
00016 INVALID_TX_CALC STRING N YN
00017 USE_TAX STRING N YN
00018 GL_ACCOUNT FILE Y GL_Account
TEST COMPANY, INC.
JOB DEFINITION PRINTING FOR JOB: AP_REF_INVOICE
Application Date: 06/14/2010 User: MAH / MAHER
System Date: 06/14/2010 / 12:37 pm Page: 2
VALIDATION RECORDS
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
00019 JOB_NUMBER_LINE FILE Y JC.JOBS
00020 COST_CODE FILE Y JC.COSTCD
00021 GL_JC_LINE_TYPE EXPRESSION N AP6$(84,1)=DIM(1)
00022 EMPLOYEE_CODE FILE N TB.EMPLY
00023 CLIENT_CODE FILE N TB.CLIENT
00024 ENGAGEMENT_CODE FILE N TB.ENGAGE
00025 WORK_CODE FILE N TB.WORKCD
00026 CATEGORY_CODE FILE N TB.CATEGRY
00027 BILL_TYPE UPPERCASE N EX
00028 BILL_TAXABLE STRING N YN
00029 EXTND_COMMENTS STRING N YN
00030 RATE_METHOD STRING N REF
00031 TRANSFER_DIV FILE Y AP.DIV
00032 TRANSFER_VENDOR FILE Y AP.VENDOR
00033 TRNSF_INVCE_NO EXPRESSION Y AP6$(110,10)=UCS(AP6$(110,10))
