Service Layer - Filtrar IncomingPayments por factura

[former_member1165493]

Hola,

Hay alguna forma de filtrar por factura? Ya que no encuentro forma, la factura se encuentra en las líneas.

GET https://localhost:50000/b1s/v1/IncomingPayments

El resultado deseado sería poder obtener un listado de pagos filtrado por factura (DocEntry)

Saludos

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[JohnR095]

POST https://yourserver:50000/b1s/v1/QueryService_PostQuery

{

    "QueryOption": "$expand=IncomingPayments($select=DocEntry, DocNum),IncomingPayments/PaymentInvoices($select=DocEntry,DocNum)&$filter=IncomingPayments/DocEntry eq IncomingPayments/PaymentInvoices/DocNum and IncomingPayments/PaymentInvoices/DocEntry eq 2472",

    "QueryPath": "$crossjoin(IncomingPayments,IncomingPayments/PaymentInvoices)"

}

[ANKIT_CHAUHAN]

Hi mcachile,

Yes, that should be possible.

Kindly refer to SAP Note 3121601 for the same.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support