View source for 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|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.)]]