Hi team,
Need to build a query with this tables from SAP B1:
ORDR - Sales Order
RDR1 - Sales Order - Rows
OCRD - Business Partner Data Master
ORCT - Payments Received
how can I join all these tables to use their fields?
I need to know the payments received for the items purchased by the customer
Regards.