Information Systems:Cannot Close Cash Book
On a command line in ASW, key in GO CASHBOOK and press enter. Select option ‘Work with Cash Book reconciliation’. Key in bank number, and page down until you get to the transaction.
*VA/480B* Work with Cash Book reconciliation 4/07/15 12:18:25 FSR46001
Open transactions
-------------------------------------------------------------------------------
Bank: 001 CIBC - Chequing Account (Cdn) Open...... 1969626.82-
Reconciled 116652750.67
Balance... 114683123.85
-------------------------------------------------------------------------------
2=Change 5=Display 6=Related documents 7=Connected entries
8=Reconcile 9=Unreconcile 10=G/L transactions
Bank Dt Doc date Rscd Transaction ref. Open amount Curr B
__ 001 CHQ 04/07/15 AP 70561 784.44- CAD
__ 001 CHQ 04/07/15 AP 70562 18900.79- CAD
__ 001 CHQ 04/07/15 AP 70563 1856.29- CAD
__ 001 EFT 03/02/15 AR05 201601P2 00000 425716.44- CAD *
__ 001 EFT 04/02/15 AP 8318745 01587 7396.53- CAD
__ 001 EFT 04/02/15 AP 8318746 01587 3158.45- CAD
__ 001 EFT 04/02/15 AP 8318747 01587 1194.96- CAD
__ 001 EFT 04/02/15 AP 8318748 01587 1101.74- CAD
More...
Bank Dt Doc date Rscd Transaction ref. Open amount Open
001 ___ ______ ____ _________________________________ ____________ Y
F1=Info F8=Move cursor
The asterisk on the right means that the batch is open – the program determines this because the voucher fields on this transaction are blank. In this case, there is another problem. This transaction was created by ARREFT60, which reads the EFT work file created from A/R statements, totals it, and gets the journal and voucher information from the A/R transaction file.
In this case, that information was not available in SRODTA while ARREFT60 was running. (I don’t know why). So get it from there now. In A/R transaction inquiry, lookup the document type and document date of the cash book transaction.
*VA/480B* A/R transactions and balance enquiry 4/07/15 13:54:59 FKR01610
-------------------------------------------------------------------------------
Sequence A/D
Debtor number....... __ _
_
Document type....... __ _
Document number..... __ _
Document date....... 1 D
Due date............ __ _
Transaction currency __ _
Selection
Debtor number....... ___________
Document type....... 1 EFT ___ ___ ___ ___ ___
Document number..... _ _______ _______ _______ _______ _______ _______
Document date....... 1 030215 ______ ______ ______ ______ ______
Due date............ _ ______ ______ ______ ______ ______ ______
A/R group........... _ __ __ __ __ __ __
Transaction currency _ ____ ____ ____ ____ ____ ____
Transaction amount.. _________________ - _________________
Settled items....... Y Open items.......... Y
F2=Print F6=Customer F7=Balances F8=Agreements F9=Statistics F10=Template
Look at the detail of any of the transactions shown that are related to the cashbook entry in question.
*VA/480B* A/R transactions and balance enquiry 4/07/15 14:01:48 FKR01607
-------------------------------------------------------------------------------
Debtor number....... 10136 CATES MEDICINE CTR Cred limit 300000
-------------------------------------------------------------------------------
Document type....... EFT Voucher type........ 27
Document number..... 8317261 Voucher number...... 2700012
Document date....... 03/02/15 Voucher date........ 03/02/15
Due date............ 03/02/15 Period.............. 1602
Year/Journal number. 16 / 743 Batch number........
Text................ Statement Period 201601P2
Transaction currency CAD Primary currency.... CAD
Original amount..... 15695.06 Original amount..... 15695.06
Remaining amount.... Remaining amount....
Exchange rate....... 1.0000000 Exch rate period.... M 1503
A/R group........... 1
Interest stop code.. Payment stop code...
Reminder stop code.. Payment mode........
User................ NANCYN Last maint date.....
F2=G/L transactions info F6=Customer F7=Balances F8=Agreements
F9=Statistics F10=Text
Use DFU on file SR6CBA to add journal number, voucher type, voucher number, and voucher date to the cash book transaction.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : CBA File . . . . : SR6CBA
Bank company: 001
Transaction reference: 201601P2
Ref no: 23763324
Cash Book Data type: 1
Stat: Y
NCR acc ref: 3
Syst id: 2
Statement number:
Batch no:
Journal no: 743
Acc per: 201602
Doc date: 20150302
Docu type: EFT
Doc no: 8317280
Value date: 20150302
Vt: 27
Vou no: 2700012
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change
Press enter to see the rest of the record.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE
Format . . . . : CBA File . . . . : SR6CBA
Vou dte: 20150302
Transaction text: EFT from A/R Statements
Bank Currency: CAD
Bank Amount: 425716440-
Bank Amount Sys curr: 425716440-
Bank Open amount: 425716440-
Bank Open amount sys curr: 425716440-
Exch rate per: 3
Exch rate lvl: M
Exch rate time: 201503
Exch rate trans: 10000000
Cash Book Reason Code: AR05
Crt dte: 20150302
Time: 104751
User id: NANCYN
F3=Exit F5=Refresh F6=Select format
F9=Insert F10=Entry F11=Change