Skip to Content
0
Jan 20, 2023 at 09:47 PM

Service Layer - cross join IncomingPayments and Invoices

110 Views Last edit Jan 22, 2023 at 09:35 AM 2 rev

Hi All, I want to get the IncomingPayments related to a specific Invoice Doc entry. I tried different things but I couldn´t find the solution.

I did this: https://<serviceLayer>/b1s/v1/$crossjoin(Invoices,IncomingPayments/PaymentInvoices)?$apply=filter(Orders/DocEntry eq IncomingPayments/PaymentInvoices/DocEntry and IncomingPayments/PaymentInvoices/DocEntry eq 5)