How to check if expected data are released from Universal Journals to Group reporting(FIN-CS-COR-DT)

[bowen_cao]

1) check if GRPL is activated (t-cd: CXB3)
1.1) if GRPL is activated, then please check in t-cd: FINCS_MAP_RLDNR_R,  get the Ledger which used for GRPL.
1.2) If GRPL is not activated, please check field value TF200-RLDNR_SOURCE to get the Ledger which used for data source.

2) Check in table FINCS_BUNIT , T001.  From table FINCS_BUNIT, you can get the assigned company for the cons.unit. And then use it to check in table T001 with RCOMP = company, with this you will know the company code(BUKRS)
3) With  ledger, company code, you may go to t-cd: FAGLB03, to check the balance for specific account in each month. Example below:


4) On the other hands, you may go to the data monitor, and run data release in test mode for specific cons.unit and fiscal year/period.  From the results screen, you can check the the account balance for by click on the toggle button. Please check the picture below:


5) Another approach to check the account balance is the app "Group Data analysis".
Input value for filter "Cons.unit" and "Document type = 0F", and in the result list, add "Account number".


6) If you found that the balance in FAGLB03 does not corresponding to the results in Group data analysis. (in my example, the balance is -2000 in FAGLB03 for 12530000 , but in GDA, the balance is -1000 in FAGLB03 for 12530000), then you will need to do data analysis in order to find the reason for the difference.
In that case, please refer to my blog: https://community.sap.com/t5/enterprise-resource-planning-blogs-by-sap/how-to-check-the-reason-when-...