SAP Knowledge Base Article - Public

2926134 - Balance Confirmation Run Does not Work with Customer Country as Restriction Criteria

Symptom

You have created a balance confirmation run and set the criteria for customer selection with a specific country, however no balance confirmations were generated.

You also notice that if no country is given the balance confirmations are created.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Receivables work center.
  2. Go to Balance Confirmation runs.
  3. Create a new balance confirmation run and under Restrictions step, in the section Choose Criteria for Customer select Business Partner Country and specify the country.
  4. Create the run and schedule an execution.

No balance confirmations are created. If you select a customer account manually for the specified country and execute the run, the balance confirmation is then created.

Cause

The criteria for business partner filtering based on customer country only works if a Customer from / to ID range is defined. If this range is empty and only the country criteria is given, then the filtering criteria logic does not apply.

Resolution

When creating the balance confirmation run, in the Restrictions step, you need to specify the Customer from / to ID under General Selection Criteria section. Once this range is defined, the Choose Criteria for Customer based on customer country will apply for the specified range.

If you wish to select all customer accounts to then apply the Criteria for Customer based on Customer Country, you may sort the IDs (Ascending) e give the first ID as 'From' and the last ID as 'To' in the selection range. However, note that the value help shows only 500 entries at a time. Hence, if you have more than 500 customer accounts you may filter the accounts as follows, to assure that all are selected:

  1. Go to Receivables work center.
  2. Go to Customer Accounts view.
  3. Open the Advanced filter and select by Company ID.
  4. In the result list, sort the Account ID Ascending.

Once the list is sorted, you may use the first and last IDs as a range within the balance confirmation run.

Our developers are working on enhancing this system logic, which is to be delivered in one of the future ByDesign releases.

Keywords

Balance Confirmation Run, Business Partner Country, Account Balance. , KBA , SRD-FIN-ACR , Receivables , How To

Product

SAP Business ByDesign 2002 ; SAP Business ByDesign 2005 ; SAP Business ByDesign 2008