Information Systems:A/R Reconciliation Not in Balance - Revision history

Norwinu at 23:07, 3 October 2016

2016-10-03T23:07:10Z

New page

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 [[Information Systems: Analyser Problems#Rebuild System Base Levels|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.

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

Sheilav at 19:15, 27 January 2016

2016-01-27T19:15:13Z

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

2015-10-19T17:13:01Z

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

New page

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

Follow the instructions in ‘ASW Analyser / Rebuild / Rebuild System Base Levels’. This should be done on a Saturday, as it is not a good idea to rebuild Analyser while transactions are trying to update it.

← Older revision		Revision as of 19:15, 27 January 2016
Line 60:		Line 60:
	Grand total 4,452,168.26 4,452,160.94 7.32		Grand total 4,452,168.26 4,452,160.94 7.32

−	~~Follow the instructions in ‘ASW~~ Analyser / Rebuild / ~~Rebuild~~ System Base ~~Levels’~~. This should be done on a Saturday, as it is not a good idea to rebuild Analyser while transactions are trying to update it.	+	Then [[Analyser Problems#Rebuild System Base Levels\|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.