Hii,
What tables are involved and relation among these entities...
Vendors -> List of Purchase Orders -> All Invoices on a Purchase Order | Prepayments -> Invoice Settled / Unsettled.
We want to get a vendor and its purchase orders and invoices on PO and invoices settled or open in one temp table to show on SSRS report.
How we can get above results in a query or x++ and what tables should be joined.
Thanks,
*This post is locked for comments
I have the same question (0)