cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Relationship Map Query/SQL Script

Former Member
0 Likes
4,442

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.

View Entire Topic
Former Member
0 Likes

Hi Richard,

You can use Union All for this purpose

Regards,

JP