Information Systems:Cannot Close Cash Book - Revision history

Darrenf at 19:52, 4 October 2017

2017-10-04T19:52:48Z

Darrenf at 19:50, 4 October 2017

2017-10-04T19:50:30Z

Norwinu at 23:05, 3 October 2016

2016-10-03T23:05:14Z

New page

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.

*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 type 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

[[Category: Finance Problems (I.T.)]]

Sheilav: Created page with "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 th..."

2015-10-19T17:20:16Z

Created page with "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 th..."

New page

@@ Line 77: / Line 77: @@
  F9=Statistics  F10=Text
-Use DFU on file SR6CBA to add journal number, voucher type, voucher number, and voucher type to the cash book transaction.
+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

@@ Line 52: / Line 52: @@
  F2=Print  F6=Customer F7=Balances F8=Agreements F9=Statistics F10=Template
-Look at the detail of any of the transactions shown.
+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