Information Systems:Bank EDI

Bank EDI

Bank EDI is a custom extension for ASW that allows the system to automate the processing of credit card and debit card transactions once a data file is downloaded from the bank and uploaded into the Bank EDI extension. Currently we are using the TD Bank for all of the debit card and credit card processing and the file is downloaded from their website by the finance department. The Bank EDI extension can be accessed from Mochasoft in the (1)UWD Extensions menu and then the (70)Bank EDI menu.

At a high level the way this works is that our shareholders get debit and credit card terminals for processing payments at their store through uniPHARM's account with TD Merchant Services. uniPHARM is able to get better rates than what a store could get on their own. The terminals are set up to deposit all of the funds collected into uniPHARM bank accounts. uniPHARM then uses the bank EDI extension process to move the funds back from the uniPHARM bank accounts onto the individual store accounts to offset their purchases. If a store makes less purchases than the amount collected then are sent an EFT for the difference. Do not confuse the Bank EDI extension with regular EDI (which is how we transmit and receive POs and invoices with our vendors) as this is a completely different and unrelated process.

For technical details on this click on the following document:

\\Superserver\Systemi Documentation\Extension Manuals\Bank EDI Technical Manual V1.0.doc 

Or you can go to:

\\Superserver\Unity\S000- UNITY Project\P0300 - Phase III Implementation\P0350 - UNITY Subprojects\UP016 -- Bank EDI Interfaces\... 

to see all of the files associated with this extension project.

Below is a screen shot of the main (70)Bank EDI menu:

12/03/14 11:48:32       uniPHARM -- PRODUCTION                   BERIQ030/CTL  
                        Bank EDI Status                                        
                                                                               
   FI=Files imported   FW=Files waiting                                        
                                                                               
                        ---------- Files ----------      Last        Last      
   Interface            Waiting  Imported  In error     Import       Post      
__ TD                               2254              2014-12-03  2014-12-03   
__ Global Payments                   577              2007-07-19  2007-07-19   
__ CIBC                             2131              2014-12-03  2014-12-03   
                                                                               
                                                                               
F3=Exit   F5=Refresh   F7=Merchants   F8=Configuration         F12=Previous    
                                                                               

• note that Global Payments is no longer in use *

As mentioned above, transactions from the debit/credit card machines in shareholder stores are not sent to them; they are sent to us. We summarize them by card type, and put them into accounts receivable for the shareholder. They will show on the next statement. If they make their account go into credit, we put the amount into their bank account via EFT. These transactions come from TD.

In addition to the credit / debit card processing the Bank EDI extension also allows CIBC to send us a cheque clearing file, which we use to reconcile cheques, and update the cash book.

These files are picked up by ‘TumbleWeed’, and placed on the IFS. To see where, press F8 for configuration. Press page down to see the record. Note that this is DFU, which is an uncontrolled update program. Be very careful what you do.

WORK WITH DATA IN A FILE                       Mode . . . . :   CHANGE         
Format . . . . :   BECONFR                     File . . . . :   BECONFP        
                                                                               
*RECNBR:                       1        uniPHARM TD Merchant:   22378885       
uniPHARM GP Merchant:   999999999999                                           
TD Folder:              BankEDI2/TD                                            
                                                                               
TD Archive Folder:      BankEDI2/TD/Archive                                    
                                                                               
Global Payments Folder: BankEDI2/Global                                        
                                                                               
Global Archive Folder:  BankEDI2/Global/Archive                                
                                                                               
CIBC Folder:            BankEDI2/CIBC                                          
                                                                               
CIBC Archive Folder:    BankEDI2/CIBC/Archive                                  
                                        Printer:                LP05           
Copies:                  1              Hold?:                  N              
Save?:                  N               uniPHARM TD-M Merchant: 23035553       
uniPHARM GP-M Merchant: 999999999999                                           
                                                                               
F3=Exit                 F5=Refresh               F6=Select format              
F9=Insert               F10=Entry                F11=Change                    
                                                                               

You can use Navigator to go into these directories, and copy files to your PC to look at.

Bank EDI Does Not Post

BERUP060 – writes transactions to SROKBP

BERUP070 – updates payment batches from SROKBP (which posts 120000 and 730200), then writes transfers from 730200 to correct bank account into SROIBT Sometimes these batches do not completely post to ASW, but instead sit in SROKBP. (The function to update payment batch is locked by ASGR007. See job name FKR051 in file SROJBN. If status is ‘A’, the job is currently running, and cannot run again now.)

If there are records in SROKBP for the current batch with identity = ‘FI’, they will have to be changed to the correct identity. For example –

update srokbp set ptiden = 'VI' where ptiden = 'FI' and ptpadt = 20121207 and ptjono = 10006

So far, when I have had to do this, the records with an identity of FI have all had to be changed to VI.

To Post Manually –

Select option 7 – Update A/R batch payments on menu ARPAY A/R Payment Tasks.

Voucher type is 75.

Document type / identity is AMX / AX, DBT / DB, DS / DS, MC / MC, VIS/ VI. This will post to A/R and 730200. Entries to move from 730200 to the correct bank accounts will not post, but will still be in SROIBT. The next time bank EDI is posted, they will be included. However one entry will be missing, so the journal will not be balanced. See ‘Problems / Finance / Journal in Error / Out of Balance – Debit/Credit Card Transactions’ for an explanation and how to fix it.