web service to retrieve all detailed open customer invoices for a certain Account ID

[tomer-shavit]

Hi experts.

We are looking for SAP ByDesign web service to retrieve all open customer invoices for a certain SAP account ID (all the 'ready to be paid' invoices, which mean opened customer invoices ID, invoices date, due dates, invoice amounts).

1. Running standard SAP WS querycustomerinvoicein and referring to SAP documentation for the SelectionByClearingStatusCode = 1 = Open.
   …. With this parameter you can search for customer invoices that have a specific clearing status.
   
   

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/2405/en-US/PSM_ISI_R_II_A1SCI_CI_QUERY_IB....

<SelectionByClearingStatusCode>

  <InclusionExclusionCode>I</InclusionExclusionCode>

   <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>

<LowerBoundaryCustomerInvoiceClearingStatusCode>1</LowerBoundaryCustomerInvoiceClearingStatusCode>

              <!--ClearingCode          = 1 = Open, 2 = Cleared-->

       </SelectionByClearingStatusCode>

We can see that the field value that is recorded = 4 (= Not relevant) and therefore we cannot use this web service

2. Running standard SAP WS QueryAccountOpenAmountsIn can query only TOTAL open customer amount, but NO detailed transactions/invoices/payments.

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/2405/en-US/PSM_ISI_R_II_QUERY_ACCOUNT_OPEN...

Please advise.

Thanks, Tomer