How to check if customer invoice is paid in ByD via webservice.

[Jay_Bhambhani]

Hello,

I am trying to check if the customer invoice is paid or not via webservice. I have tried QueryCustomerInvoices and QueryTradeReceivablesPayablesAccountIn SOAP web service and it doesn't seem to work in this scenario( unless I am going wrong somewhere). Can anyone please assist me on this ?

[Jay_Bhambhani · Accepted solution]

Thanks for response guys, I used the Odata Service to achieve so.

Regards

Jay

[jaime_dominguez · Accepted solution]

Hey Jay

I face with the same issue. And I think that the best way is by Odata Query with report Accounts Receivable- Line items, filtering by item Status (cleared), Clearing date...

Anyway, did you find a better way or OData to get the info of customer invoices paid?

Thanks

Regards

[former_member183363]

You could maybe look into the structure of the payments in the system; if it's possible to query them using the reference document as a filter then you'll know when something's paid if an invoice has an entry. That's a potential alternative.

[HarshalVakil]

Hello Jay,

I think in QueryCustomerInvoices would provide you this details.

in the response structure of the service, I see that the clearing status code is also provided. If the invoice is cleared, that means it is paid. Not sure if there is anything additional you would like to get here.

Regards,

Harshal

[Jay_Bhambhani]

Hey Harshal,

That's what I thought as well. But I was getting code 4, for invoices paid or unpaid. Upon asking SAP, I got this response :

"The clearing status code 4 (not relevant) in this case is correct. On standard invoices, there is no clearing process, and hence, any status other than 4 will only occur on Downpayment requests. I understand the documentation does not make this point clear, so we will try to amend this going forward."

To sum it up, that Clearing Status Code is only for DownPayments not for standard invoices.

Regards,

Jay