Relationship Map Query/SQL Script

[Former Member]

Hi all,

Can anyone help me to do this? A query to show Sales order,Purchase Order, A/R Invoice, CMs, Delivery, Returns, Incoming payment, Deposit, GRPO, A/P Invoice, Outgoing Payment. All in one query, seems like the relationship map

Any help will be highly appreciated. Thanks.

[Former Member]

Hi Kennedy T. the goal is to see the entire relationship (transaction flow) row. i.e given that a purchase order uses procurement document wizard. That is Sales order to Deposit linked to Purchase order to Outgoing payment.