Information Systems:FIN03FPMG Does Not Balance to FIN03 - Revision history

Norwinu at 23:06, 3 October 2016

2016-10-03T23:06:23Z

New page

=FIN03KFMG Does not Balance to FIN03=

The problem is that the net earnings on FIN03 (Detail Statement of Income) and on FIN03-KPMG (KPMG Summary Income Statement) don't agree.

So far, the issue has always been the 'Out of Balance' G/L account. When an out of balance journal is forced to update, it creates a balancing record into the out of balance account, or 730200. When this transaction is added to ANOBAL, for some reason it does not set the proper keys.

Use [[QUERY|Query]] to look at records in ANOSTK that have

KESUTA = A11
KEMK01 = 730200

Look at field KEMK14. It should be MISC for all records. If it is not, it must be changed.

Account number 730200 is set up in the chart of accounts to have a second summary identity of MISC, so why is it updated to a summary ID of blank?

Use [[Information Systems:DFU]] or [[EZVIEW]] on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).

==Rebuild the ‘KPMG statement section’==

Only ASW administrators can do this, so sign on as FINADMIN.

On a command line in ASW, key in GO GLPER and press enter. Select the option ‘Rebuild summary identities’.

*VA/480B* G/L summary identity rebuild 5/26/15 18:25:09 FMR22201
-------------------------------------------------------------------------------
Summary identity Changed Summary identity Changed
Statement Section... N
Cost Center Group 1. N
Cost Center Group 2. N
KPMG stmt section... N

NO SUMMARY IDENTITY HAVE BEEN CHANGED

THIS JOB WILL BE CANCELLED

If this process will not run, because no changes have been made, you can force it by setting the changed flag to ‘Y’ in G/L Control File Maintenance.

Key in GO GLSET and press enter. Select the option ‘Work with G/L control file’.

Press Enter until this screen shows.

*VA/480B* G/L control file maintenance 5/26/15 18:27:42 GDMD0922
-------------------------------------------------------------------------------
Related to
account part Changed
Summary id part 1... Statement Section 1 N
Summary id part 2... Cost Center Group 1 4 N
Summary id part 3... Cost Center Group 2 4 N
Summary id part 4... KPMG stmt section 1 N

F7=Translate

Change the column ‘Changed’ to Y for the section you want to rebuild (in this case ‘KPMG stmt section’), then go back to ‘Rebuild Summary Identities’.

Check results by running the report. Go to ASW / business reporting / work with reports. Print (option 6) FIN03-KPMG for the appropriate year and period .

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

Norwinu: Text replacement - "DFU" to "Information Systems:DFU"

2016-06-17T22:30:05Z

Text replacement - "DFU" to "Information Systems:DFU"

Sheilav: /* FIN03KFMG Does not Balance to FIN03 */

2015-10-30T22:37:42Z

FIN03KFMG Does not Balance to FIN03

172.30.20.117 at 16:54, 22 October 2015

2015-10-22T16:54:00Z

172.30.20.117 at 16:52, 22 October 2015

2015-10-22T16:52:24Z

172.30.20.117 at 16:51, 22 October 2015

2015-10-22T16:51:26Z

Sheilav: Created page with "=FIN03KFMG Does not Balance to FIN03= Use Query to look at records in ANOSTK that have KESUTA = A11 KEMK01 = 730200 Look at field KEMK14. It should be MISC for all r..."

2015-10-19T17:24:18Z

Created page with "=FIN03KFMG Does not Balance to FIN03= Use Query to look at records in ANOSTK that have KESUTA = A11 KEMK01 = 730200 Look at field KEMK14. It should be MISC for all r..."

New page

=FIN03KFMG Does not Balance to FIN03=

Use Query to look at records in ANOSTK that have

KESUTA = A11
KEMK01 = 730200

Look at field KEMK14. It should be MISC for all records. If it is not, it must be changed.

When an out of balance journal is forced to update, it creates a balancing record into the out of balance account, or 730200. When this transaction is added to ANOBAL, for some reason it does not set the proper keys.

Account number 730200 is set up in the chart of accounts to have a second summary identity of MISC, so why is it updated to a summary ID of blank?

Use DFU or EZVIEW on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).

==Rebuild the ‘KPMG statement section’==

Only ASW administrators can do this, so sign on as FINADMIN.

On a command line in ASW, key in GO GLPER and press enter. Select the option ‘Rebuild summary identities’.

*VA/480B* G/L summary identity rebuild 5/26/15 18:25:09 FMR22201
-------------------------------------------------------------------------------
Summary identity Changed Summary identity Changed
Statement Section... N
Cost Center Group 1. N
Cost Center Group 2. N
KPMG stmt section... N

NO SUMMARY IDENTITY HAVE BEEN CHANGED

THIS JOB WILL BE CANCELLED

If this process will not run, because no changes have been made, you can force it by setting the changed flag to ‘Y’ in G/L Control File Maintenance.

Key in GO GLSET and press enter. Select the option ‘Work with G/L control file’.

Press Enter until this screen shows.

*VA/480B* G/L control file maintenance 5/26/15 18:27:42 GDMD0922
-------------------------------------------------------------------------------
Related to
account part Changed
Summary id part 1... Statement Section 1 N
Summary id part 2... Cost Center Group 1 4 N
Summary id part 3... Cost Center Group 2 4 N
Summary id part 4... KPMG stmt section 1 N

F7=Translate

Change the column ‘Changed’ to Y for the section you want to rebuild (in this case ‘KPMG stmt section’), then go back to ‘Rebuild Summary Identities’.

Check results by running the report. Go to ASW / business reporting / work with reports. Print (option 6) FIN03-KPMG for the appropriate year and period .

@@ Line 14: / Line 14: @@
 Account number 730200 is set up in the chart of accounts to have a second summary identity of MISC, so why is it updated to a summary ID of blank?
-Use [[DFU]] or [[EZVIEW]] on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).
+Use [[Utilities#DFU|DFU]] or [[Utilities#EZVIEW|EZVIEW]] on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).
 ==Rebuild the ‘KPMG statement section’==

@@ Line 5: / Line 5: @@
 So far, the issue has always been the 'Out of Balance' G/L account.  When an out of balance journal is forced to update, it creates a balancing record into the out of balance account, or 730200.  When this transaction is added to ANOBAL, for some reason it does not set the proper keys.
-Use [[Query]] to look at records in ANOSTK that have
+Use [[Utilities#QUERY|Query]] to look at records in ANOSTK that have
  KESUTA = A11

@@ Line 1: / Line 1: @@
 =FIN03KFMG Does not Balance to FIN03=
  KESUTA = A11
@@ Line 7: / Line 11: @@
 Look at field KEMK14.  It should be MISC for all records.  If it is not, it must be changed.
 Account number 730200 is set up in the chart of accounts to have a second summary identity of MISC, so why is it updated to a summary ID of blank?
-Use DFU or EZVIEW on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).
+Use [[DFU]] or [[EZVIEW]] on file AN1STK to make the key fields (11 to 14) the same as the other records that match this account number (parts 1 to 6).
 ==Rebuild the ‘KPMG statement section’==