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