SAP Knowledge Base Article - Public

3477403 - Web Service QueryAccountOpenAmountsIn is not retrieving the correct results.

Symptom

Account Open Amounts web service (QueryAccountOpenAmountsIn)  is not retrieving the correct results.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Application and User Management Work Center > Service Explorer view
  2. Search for QueryAccountOpenAmountsIn
  3. Click Download WSDL
  4. Configure the SoapUI to use the web service QueryAccountOpenAmountsIn
  5. Enter the payload
  6. As response, the system is not retrieving the correct information
    Example of response:

    <env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
       <env:Header/>
       <env:Body>
          <n0:AccountOpenAmountsQueryResponse_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:LWK:/1SAI/TAS63BA8AD59E7F8E4948CA:804">
             <ProcessingConditions>
                <ReturnedQueryHitsNumberValue>0</ReturnedQueryHitsNumberValue>
                <MoreHitsAvailableIndicator>false</MoreHitsAvailableIndicator>
             </ProcessingConditions>
          </n0:AccountOpenAmountsQueryResponse_sync>
       </env:Body>
    </env:Envelope>

Cause

During web service execution, system retrieves payment agreement data from FSI view 'A1FOP_PAY_AGREE_CRED_LIM'.
This FSI view checks the default currency is maintained for the company in the org structures.

If the default currency is not maintained in the org structures for the company, then, the web service will not fetch the expected results.

 

 

Resolution

Maintain the default currency for the affected company in the Organizational Management Work Center > Org Structures view

Keywords

web service, webservice, QueryAccountOpenAmountsIn, Query Account Open Amounts, Find accounts open amounts , KBA , SRD-FIN-ACR , Receivables , Problem

Product

SAP Business ByDesign all versions