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, 2022, 2023 , 2025
Product
Keywords
FQM_INIT_BALANCES, FQM_INIT_BALANCE, FQM_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, G/L account * is linked with more than one bank account, G/L account is linked with more than one bank account, FQME140, FQME 140, cash accounts error , 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.
SAP Knowledge Base Article - Preview