===== Work with iACH Spool Capture Application ===== \\ \\ Selecting option one from the iACH menu will evoke the maintenance program below enabling a new iACH application to be configured to capture the relevant data elements from a spooled file. \\ \\ \\ \\
5/24/09 iDocs Form Suite FM0465C1 15:55:27 Work with ACH Applications QSECOFR 1=Edit 2=Configure datamap 3=Copy 4=Delete 7=Rename 8=Work with map fields 11=Conditional 12=Configure XLS 14=Smart Routing 15=Merge with Spool File 16=Print Overlays 17=Import Map 18=Spool Routing Opt ACH Description Status ACHAPP ACH Sample Application *CHECKIN CANYONOIL Canyon State Oil *CHECKIN Bottom F3=Exit F6=Add F13=Database Mapping F15=Global Offset F21=System\\ \\ By selecting an existing application or pressing F6 to create a new iACH application, the next screen will be rendered. \\ \\ \\
5/24/09 iDocs Form Suite FM0465C3 15:55:53 Define a ACH Application QSECOFR ACH Application. . . . . . . CANYONOIL Canyon State Oil ACH Size . . . . . . . . . . 2 Letter(8 1/2 x 11 in.) F4=List Collate(Y/N). . . . . . . . . . . N Use Mapped Fields Only (Y/N). . . Y Orient (P)ortrait or (L)andscape. P Pages per Overlay (1-9) . . . . . 1 Front Map File. : F4=List Back Map File . . : F4=List X adjustment value. . . . . . . . 30- Y adjustment value. . . . . . . . 0 Removable Check Secure (Y/N) . . N Color Output . . . . . . . . N F4=List Signature on Zero $ Check (Y/N) . N Select Bank by User Data (Y/N) . N Front Side Back Side Form Destination Overlay Seq Drawer Merge Overlay Merge Prompt Out Queue F4=List # F4=List Data F4=List Tumble Data F4=List F4=List *NONE 1 1 Y *STD *NONE + F1=Help F2=Data Map F3=Exit F5=iCheck F7=Footer F8=Mapped Fields F9=Advanced Functions F12=Cancel F15=Global Offset F17=Import Map\\ \\ For a base application to be created, the data elements should be completed as illustrated above. Once created as demonstrated above, return to the list of applications. At this point, the data from the spooled file needs to be associated with the fields used to record a transaction. Typically the spooled file is created in such a way as to generate one transaction per page. \\ \\ To accomplish this, select the iACH application with an option 2. A listing spooled files will be generated enabling the user to navigate to the appropriate spooled file. After the spooled file is located, selecting the file will enable the spooled file data elements to be mapped. Locate the first element to be mapped, for instance the invoice number. Position the cursor to the beginning of that data element, press F8. Next, position the cursor the end of the invoice number and press F8 again. \\ \\ \\ \\
5/24/09 iDOCS Form Suite FM2500C6 16:04:07 Data Mapping Definition Maintenance QSECOFR Form: CANYONOIL Canyon State Oil Begin window Colunm: 61 Line ...+... 7 ...+... 8 ...+... 9 ...+..100 ...+... 1 ...+... 2 ...+... 3 . 1 2 3 4 5 6 7 177925 12/31/98 8 9 10 11 12 13 8 14 ERPRISES, CORE DIV. 15 LESTOWN IND. DR. More... F3=Exit F8=Mark Datafield Start F12=Previous F19=Left F20=Right\\ \\ \\ At this point, the field name may be prompted to select the correct reserved field name associated with the invoice number. \\ \\ \\
5/24/09 iDOCS Form Suite FM2500D7 16:05:31 Map Field Maintenance QSECOFR Form Name. . . . . . CANYONOIL Field Name . . . F4=List Description. . . pooled File Source From Row . . . . . . 7 To Row . . . . . . . 7 From Column . . . . 65 To Column . . . . . 70 verlay Target Horizontal Position. 300dpi Vertical Position. . 300dpi Map Field . . . . . F4=List Map Type . . . . . . 2 F4=List Font . . . . . . . . F4=List Courier 10cpi Regular Line Spacing . . . . 300dpi Font Rotation. . . . 90° 180° 270° Form Side. . . . . . F4=List Non duplex field onditionally map If the value in column to column Map next field end Bursting. . . . . . N (Y/N) of this field . . . (Y/N) Color . F4=List Sort Sequence . . . . F4=List F3=Exit F4=Prompt F10=Save F12=Cancel\\ \\ Below lists a display of the selection list generated. Paging down from within this list will reveal the description for the invoice number. This iteration of mapping spooled file data to the data elements within the ACH transaction needs to continue until all the elements are mapped. The complete list of the necessary elements are displayed within the pick list. \\ \\ \\ \\
5/24/09 iDOCS Form Suite FM2500D7 16:05:31 Map Field Maintenance QSECOFR Form Name. . . . . . CANYONOIL Field Name . . . F4=List Spooled File Sourc Select a Reserved Field Name From Row . . . . 1-Select From Column . . Overlay Target Opt Field Description Horizontal Posit ACVEND Vendor Account Map Field . . . ACVNAM Vendor Name Font . . . . . . ACINV Invoice Number Line Spacing . . More... Form Side. . . . F1=Help F3=Exit F12=Previous Conditionally map If the value in Map next field end Bursting. . . . . . N (Y/N) of this field . . . (Y/N) Color . F4=List Sort Sequence . . . . F4=List F3=Exit F4=Prompt F10=Save F12=Cancel\\ \\