SAP Knowledge Base Article - Preview

3331289 - S/4 Hana Cash management : Central KBA for issues related with report FQM_INITIAL_BALANCE_UPLOAD or FQM_INIT_BALANCES

Symptom

Various issues related with Initial Bank Account or GL Account Balance using report  FQM_INITIAL_BALANCE_UPLOAD. Customer uses Transaction FQM_INIT_BALANCES to upload initial balance for "Bank Account Balance" . An entry gets created in table FQM_FLOW-OWNER = IBU and Certainty_Level = ACTUAL.  

Note: Most common scenario where one can upload the initial balances is:

Suppose there are historical entries in BSEG from last many years and you don't want the historical data to be updated into FQM_FLOW. So in this scenario fix a date as value date like 31/12/2021 and get the bank G/L account balance in FBL3N for open date = 31/12/2021. Use the same balance in upload file as  balance amount for value date = 01/01/2022

Once an Initial Balance for a Bank G/L  account gets created via FQM_INITIAL_BALANCE_UPLOAD with FQM_FLOW-OWNER = IBU and Transaction_date = 31/12/2021., then no other entry for the same bank account G/l will get updated with  Planning/Transaction date < 31/12//2021 in table FQM_FLOW. All the later balance >31/12//2021  can be uploaded via transaction FCLM_FLOW_BUILDER.

Note : From OP2023 onward we have new transaction FQM_INTBAL_AUTOCRT or program FQM_INITIAL_BALANCE_MASSCREATE to create initial bank account balance. 


Read more...

Environment

S/4 Hana 1709, 1809, 1909, 2020, 2021

Product

SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022

Keywords

FQM_INIT_BALANCES, FQM_INIT_BALANCE, FQMS_INITIAL_BALANCE_UPLOAD, FQME130, FQME131, FQME129, Invalid amount; enter the amount in the correct format, Invalid date; enter the date in the correct format, GL account does not exist, FQM_INTBAL_AUTOCRT , FQM_INITIAL_BALANCE_MASSCREATE. , KBA , FIN-FSCM-CLM , SAP Cash Management , FIN-FSCM-FQM , One Exposure , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.