Information Systems:FIN03FPMG Does Not Balance to FIN03

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 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 .