SAP Knowledge Base Article - Public

2372214 - Suppliers with Balance = 0.00 XXX are not included in Balance Confirmation Run

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

  1. Open the Payables work center.
  2. Navigate to the Periodic tasks View, select Balance Confirmation Run.
  3. Click on the New button, maintain the relevant data for the run. The Suppliers can be manually or automatically selected.
  4. Execute the run immediately.
  5. Navigate back to the Balance Confirmation Runs, select the last run and show All Logs. Click on the Log ID.
  6. Navigate to the General tab, summarizing messages, it reads: "No balance confirmation created".
  7. 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

Product

SAP Business ByDesign all versions