Information Systems:A/R Reconciliation Not in Balance
Jump to navigation
Jump to search
The first thing to find out is when it went out of balance. We have a copy of the A/R Reconciliation for every period end. To see them, on a command line key in WRKOUTQ FINANCE/FIN* and press enter. Page down through the older periods, until you get to the more recent ones.
Work with All Output Queues
Type options, press Enter.
2=Change 3=Hold 4=Delete 5=Work with 6=Release 8=Description
9=Work with Writers 14=Clear
Opt Queue Library Files Writer Status
__ FIN201505 FINANCE 11 RLS
__ FIN201506 FINANCE 11 RLS
__ FIN201507 FINANCE 11 RLS
__ FIN201508 FINANCE 11 RLS
__ FIN201509 FINANCE 11 RLS
__ FIN201510 FINANCE 11 RLS
__ FIN201511 FINANCE 11 RLS
5 FIN201512 FINANCE 11 RLS
__ FIN201601 FINANCE 11 RLS
__ FIN201602 FINANCE 11 RLS
Command
===>
F3=Exit F4=Prompt F5=Refresh F12=Cancel F24=More keys
Use option 5 to see the spool files.
Work with Output Queue
Queue: FIN201512 Library: FINANCE Status: RLS
Type options, press Enter.
1=Send 2=Change 3=Hold 4=Delete 5=Display 6=Release 7=Messages
8=Attributes 9=Work with printing status
Opt File User User Data Sts Pages Copies Form Type Pty
_ GCFP231 FINADMIN RDY 92 1 *STD 5
_ GCFP233 FINADMIN RDY 185 1 *STD 5
_ GCFP235 FINADMIN RDY 199 1 *STD 5
5 FSR297P FINADMIN RDY 2 1 *STD 5
_ FSR297P FINADMIN RDY 2 1 *STD 5
_ FKR041P FINADMIN RDY 2 1 *STD 5
_ QPQUPRFIL FINADMIN RDY 81 1 *STD 5
_ QPQUPRFIL FINADMIN RDY 10 1 *STD 5
_ DMR606P FINADMIN RDY 911 1 *STD 5
More...
Parameters for options 1, 2, 3 or command
===>
F3=Exit F11=View 2 F12=Cancel F20=Writers F22=Printers
F24=More keys
The first ‘FSR297P’ is the A/R reconciliation (the second is A/P). Use option 5 to display it. Do this on several periods until you find the first one that has a difference. In this case, it is 201501.
*VA/480B* A/R RECONCILIATION LIST
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
A/R AMOUNT A/R AMOUNT G/L AMOUNT G/L AMOUNT G/L AMOUNT DIFFERENCE
Main Grou Subg Temp intrupt(a) Balance amt (b) Temp intrupt(c) Balance amt (d) Journal Maint(e) Diff (a+b)-(c+d+e))
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
120000 4,452,168.26 4,452,160.94 7.32
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Grand total 4,452,168.26 4,452,160.94 7.32
Then rebuild System Base Levels for A/R. This should be done on a Saturday, as it is not a good idea to rebuild Analyser while transactions are trying to update it.