Sage 100

Looking for WO pros! Working on a VI Import into WO Transaction Entry for CLOSE transactions types. Having a heck of a time...seems like it should be so easy. Does anyone have an import that works...care to share the VI definition? I am using 5.1.03, but I suspect the VI logic has not changed for WO in several versions. Issues I am having: -WO number does not land - Batch is not created VI JOB: CONFIGURATION INFORMATION ------------------------------------------------------------------------------------------------------------- FILE NAME: WO.TRNSENT W/O TRANSACTION ENTRY IMPORT FILE: C:\Data\WO Close Files\WO_Ready To Close 1-28-2015.csv FILE TYPE: DELIMITED DELIMITER: , 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 TRANS_NUMBER H ACCOUNT REPLACE 00010 ####### No 00002 TRANS_TYPE H STRING ASSIGN 8 No 00003 TRANS_DATE H DATE ASSIGN 01/28/15 No 00004 BATCH_NUMBER H ACCOUNT REPLACE 00011 ##### No 00005 CREW_ENTRY H YES/NO ASSIGN N No 00006 LINE_TYPE L STRING ASSIGN D No 00007 WORK_ORDER LE ZERO-FILL REPLACE 00001 Start: 1 Len: 7 No RECORD SELECTION ------------------------------------------------------------------------------------------------------------- ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE ------------------------------------------------------------------------------------------------------------- 00001 D Close 00001 00001 00001 = PERFORM: AFTER WRITE ..\WO\WOWVIP;WO_TRNSENT 00002 SKIP Skip Record 00006 00001 00001 <> 7 SAMPLE SOURCE FILE: WorkOrderWODateWODueDateStatusTransDateTransTypeQtyCompletedItemNumberCompleteToOrderNumberTransBatch W00005012/10/201412/10/2014R12/31/201471MISCSHOP1231141214 W00009012/11/201412/11/2014R12/31/20147100SRA90121231141214 W00010112/11/201412/11/2014R12/31/2014720PA1231141214 W00011612/12/201412/12/2014R12/31/2014720TY1410101231141214 W00012212/12/201412/12/2014R12/31/20147100SRA90081231141214 W00012312/12/201412/12/2014R12/31/2014710CC061231141214 W00012412/12/201412/12/2014R12/31/2014730CSD101231141214 W00012512/12/201412/12/2014R12/31/2014730CSD081231141214 W00012612/12/201412/12/2014R12/31/2014715TR1231141214 W00012812/12/201412/12/2014R12/31/2014710TR1231141214 W00012912/12/201412/12/2014R12/31/2014710TR1231141214 W00013012/12/201412/12/2014R12/31/2014710TR1231141214

Isn't your Record select type D saying it is a Close when the first character of the first column is BLANK? Shouldn't that be a Not Equal blank?

Great Eye!! Yes, that was my issue!! Thank you Thank you!!

YAY!