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

3 months ago 16

Hi experts.

We are looking for SAP ByDesign web work to retrieve each unfastened lawsuit invoices for a definite SAP relationship ID (all the 'ready to beryllium paid' invoices, which mean opened lawsuit invoices ID, invoices date, owed dates, invoice amounts).

  1. Running modular SAP WS querycustomerinvoicein and referring to SAP documentation for the SelectionByClearingStatusCode = 1 = Open.
    …. With this parameter you tin hunt for lawsuit invoices that person a circumstantial 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 tin spot that the tract worth that is recorded = 4 (= Not relevant) and truthful we cannot usage this web service

2. Running modular SAP WS QueryAccountOpenAmountsIn tin query lone TOTAL unfastened lawsuit amount, but NO elaborate transactions/invoices/payments.

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

Please advise.

Thanks, Tomer

Read Entire Article