Symptom
Account Open Amounts web service (QueryAccountOpenAmountsIn) is not retrieving the correct results.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Application and User Management Work Center > Service Explorer view
- Search for QueryAccountOpenAmountsIn
- Click Download WSDL
- Configure the SoapUI to use the web service QueryAccountOpenAmountsIn
- Enter the payload
- 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