Information Systems:Bank EDI
Bank EDI
Bank EDI is a custom extension for ASW that allows the system to automate the processing of files received from the banks. Do not confuse this 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. Bank files are not received automatically; The finance department uses secure services to manually get them from the banks.
There are two types of files; debit and credit card transactions from stores, and detail of the cheques clearing uniPHARM's accounts.
The Bank EDI extension is accessed from Mochasoft in the (1)UWD Extensions menu and then the (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
__ Chase Paymentech
F3=Exit F5=Refresh F7=Merchants F8=Configuration F12=Previous
- note that Global Payments is no longer in use *
The interface name is passed as a parameter to all called programs, and controls the kind of processing done. 'CIBC' is cheque clearing; the others are debit and credit card processing.
'Files waiting' have been received from the bank and placed onto the IFS, but have not yet been imported. 'Files in error' have been imported, but something prevents them from being posted.
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.
Credit and Debit Card Transactions
Up to November 2016, we have been using the TD Bank for all of the debit card and credit card processing. After that, we will be switching to Chase Paymentech. The files are downloaded from the bank website by the finance department, then put onto the IFS. Bank EDI is used to upload it an post it to ASW.
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 the bank. Because of the combined volume, uniPHARM is able to get better rates than 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.
Transactions are summarized 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.
Cheque Clearing
These files are used to reconcile cheques, and update the cash book. They used to be are picked up by ‘TumbleWeed’, but are now done manually by the finance department.
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.