Symptom
You have observed incorrect Open Items Totals in Transaction Currency in Customer Account monitor. Basically, the total of the Open item in the Customer Account is not correct. When you compare the Balance Transaction Currency in Account Receivables - Open Items report then the amount is not matching.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Receivables work center.
- Click Customer Accounts view.
- Search for the Customer Account and Click View.
- Go to General tab.
- Filter Customer Balances with Open Items Totals in Transaction Currency.
- The balance amount is not matching with the Open Items total amount. Also, the same figure is not matching with Account Receivables - Open Items report.
Cause
The amount displayed in the information message depends on the following:
- Credit Limit maintained in the account master data.
- Credit Limit Check setting maintained in the Business Configuration.
- Account Balance of the open items in the receivables of the account.
Check the credit limit amount entered in the account master data:
- Go to the Account Management work center.
- Select the Accounts view.
- Open account ABC (ABC represents the ID of the account).
- Go to the Financial Data tab
- The amount 5.000,00 EUR is entered in the field Credit Limit (5.000,00 EUR represents the amount in your respective currency).
Check the account balance in the below steps:
- Go to the Account Management work center.
- Select the Accounts view.
- Open account ABC in overview mode.
- Go to the Financials tab.
- In the Account Balance section in our example the account balance is 3.000,00 EUR.
Therefore, expect that the credit limit in the sales order is not exceeded by 1.000,00 EUR and that there should still be 2.000,00 EUR left.
Also, check the Open Items Totals in Transaction Currency for account ABC in the receivables:
- Go to the Receivables work center.
- Select the Customer Accounts view.
- Select account ABC and click on the View button.
- Go to the General tab.
- In the Customer Balances section select in the Show field: Valuated Balances in Company Currency
In our example the amount is 3.000,00 EUR - In the Customer Balances section select in the Show field: Open Items Totals in Transaction Currency
In our example the amount of the Posted Items is 6.000,00 EUR - Go to the Trade Receivables tab and select the Invoices/Payments sub tab.
You can see that here the total amount in column Open Items Totals in Transaction Currency is 3.000,00 EUR
Hence the Open Items Totals in Transaction Currency in the General tab is different that in the Trade Receivables tab.
One of the possible reason could be TBT (Totals and Balances) is inconsistent in the backend.
Resolution
To make it consistent, create a case with the SAP Support and provide us the authorization to perform a backend correction to solve the inconsistency in the amount shown in the Customer Account Monitor.
Keywords
customer account monitor, open item, balance, customer balance , KBA , SRD-FIN-ACR , Receivables , Problem