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,

I am not sure why you have such request. AP & AR has very few direct link from those tables. How you can link them? Give a concrete business example.

Thanks,

Gordon

[Former Member]

I'm doing a customized report that will show the full transaction path from ORDR to OVPM. That is SO-ORCT linked to PO-OVPM. The process flow starts in SO (Drop ship setup). Here's what i want to obtain in one row, i'd like to see this trail in a query.

ORDR#>ODLN#>OINV#>ORCT#>ODPS#>OPOR#>OPDN#>OPCH#>OVPM#

link will be coming from ORDR & PO. I posted the query i made initially (still in moderators review)

Thanks,

Richard

[Former Member]

Hi Richard

This type of Query is extremely useful especially if you have a customer that does back to back orders.

Please can you let me know what you final query is as I would like to test the process from start to finish

Best Regards

Andrew