Information Systems:Problem With EFT Batch
Accounts Payable - RPG program EFRUP011 reads records from ASW payment proposal files and creates CIBC EFT interface transactions.
Accounts Receivable – RPG program ARREFT40 is called from ‘View Statement Control Periods’ to read records created by the statement run and create CIBC EFT interface transactions.
These transactions are sent to CIBC via their Business Banking web site.
1 01000 01000332370152291386 0010009001016512 uniPHARM CAD 5 7001386 08/17015237 6C 0002120700037311 000147216812293/1607P1 BALANCED HEALTH INTEGR 6C 00048024008600426726 000081617610164/1607P1 CLINIC DRUG STORE 6C 00049352009700646887 000060041710292/1607P1 FRONT STREET PHARMACY 6C 0003023201050798 000025661411286/1607P1 GLOVER'S MEDICINE CENT 6C 0004918605209049 000024437312305/1607P1 LONGEVITY COMPOUNDING 6C 0001098901036867 000016364010699/1607P1 PEOPLES DRUG MART #175 6C 001610690201834001 000000514411706/1607P1 PHARMASAVE #027 6C 0002920800006211 000077974312169/1607P1 PRESCRIPTION HEALTH ST 6C 0010029208821216 000267932611044/1607P1 SUNNYSIDE EVERGREEN PH 6C 0003028801056639 000099383111306/1607P1 SURLANG MEDICINE CENTR 6C 0001098901027581 000035411310684/1607P1 TOFINO PHARMACY 6C 0001321701006913 000195974411105/1607P1 VICTORIA COMPOUNDING P 6C 0001083801029021 000080552711112/1607P1 VITA VIE PHARMACY 6C 0010005209602011 000292013711124/1607P1 WEST END MEDICINE CENT 6C 0002913890015113 000277018711566/1607P1 WESTWINDS PHARMACY LTD 77000000150000000000 000016821140 9000001000015
Batch number (1386 in first and second record) – This sequential number ensures that no batches are missing, or posted twice.
Date (08/17, 015237 in second record) – Format is month / day, then Julian.
Transaction Amount (first 10 digits in second block of numbers), D/C for debit or credit (second character of detail record) - The amount on the trailer must be equal to the total of the transactions.
If Nancy realises, after the file has been sent, that is something wrong, she can delete it from the bank, edit it on her PC, and resend it. But she must increment the sequential number in the file, then I.T. must also increment the control file. To do that, go to Unity / Start uniPharm Extensions / VA Company / Work with UWD IT Tools / FTP Connections.
To change the number for A/P, select ‘A/P FTP Configuration’. Press page down to see the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : EFCONFR File . . . . : EFCONFP
*RECNBR: 1 Next Create No: 2173
CIBC Originator #: 0100043801 EFT Tx Type: 460
Originator Short Name: uniPHARM
Originator Long Name: uniPHARM Wholesale Drugs Ltd.
Sett Inst ID: 010 Sett Branch Transit: 16512
Settlement Account: 0090010
CIBC EFT Data Folder: EFT
OMS footer line 1: Please be advised that with the electronic funds transfe
r (EFT) run
OMS footer line 2: above, the following invoices/credit notes will be settl
ed. Please
OMS footer line 3: direct any questions or concerns to Nancy Ng at 604.276.
5202 or
OMS footer line 4: nancyn@unipharm.com.
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Change the ‘Next Create No.’ to the next available sequential number. Press enter to update, then F3 and enter to exit.
To change the number for A/R, select either ‘Statement CAD EDI Config’ or ‘Statement USD EDI Config’. Press page down to see the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : EFARCONFR File . . . . : EFARCONFP
*RECNBR: 1
Next Create No: 1388
CIBC DR Originator #: 0100023576
CIBC CR Originator #: 0100033237
EFT Tx Type: 700
Originator Short Name: uniPHARM
Originator Long Name: uniPHARM Wholesale Drugs Ltd.
Sett Inst ID: 010
Sett Branch Transit: 16512
Settlement Account: 0090010
CIBC EFT Data Folder: EFT
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Change the ‘Next Create No.’ to the next available sequential number. Press enter to update, then F3 and enter to exit.