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.