Symptom
A Balance Confirmation Run for Suppliers has been executed whose Balance is 0.00 XXX (where XXX is the currency in use).
Once the run is completed and the Logs are opened, it's noticed that no Balance Confirmation has been created for them by going to the General tab: "No balance confirmation created".
By navigating to the Results tab, messages displayed are as such:
"No accounts have open items for the specified key date"
"Selection criteria for the account do not match or no account found"
It's noticed as well that for other Balance Confirmation Runs, some Suppliers whose Balance is also 0.00 XXX had a Balance Confirmation created.
Remark: the same logic applies to customer accounts and Balance Confirmation Run for Receivables.
Environment
SAP Business ByDesign
Reproducing the Issue
- Open the Payables work center.
- Navigate to the Periodic tasks View, select Balance Confirmation Run.
- Click on the New button, maintain the relevant data for the run. The Suppliers can be manually or automatically selected.
- Execute the run immediately.
- Navigate back to the Balance Confirmation Runs, select the last run and show All Logs. Click on the Log ID.
- Navigate to the General tab, summarizing messages, it reads: "No balance confirmation created".
- Navigate to the Results tab, two more messages are displayed:
"No accounts have open items for the specified key date"
"Selection criteria for the account do not match or no account found"
The results are not understood since for other runs, other Suppliers with Balance = 0.00 XXX were assigned a Balance Confirmation stating that no open items were available.
Cause
This is the expected system behavior.
If all Suppliers included in the run have a Balance which is equal to 0.00 XXX at the time of the Run, no Balance Confirmation will be created for them.
Resolution
If producing a document for these Suppliers is needed, make sure to include Suppliers who have open items available at the Cut-Off Date selected for the Balance Confirmation Run. In that case, all Suppliers will get a Balance Confirmation created that can then be printed or sent by email.
See Also
KBA 2196437 - Balance Confirmation Run for Cleared Items
Keywords
Balance Confirmation Run; Payables, Receivables; Account Balance , KBA , SRD-FIN-ACP , Payables , How To
SAP Knowledge Base Article - Public