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