Hi All,

I need to produce a query where my user able to see purchase cost from previous purchase order and new purchase order. Example ,Item A , PO created in Jan 2017 with cost MYR 10 per pieces and ordered quantity 5 .
Item B , PO created April 2017 with cost MYR 3 per pieces and ordered quantity 10.

Both item ordered yesterday 24 August.
How can I produce the report from tdpur401 to become like this

Item | Previous Order | Latest Order
A | PO123 | 5 | MYR 10 | MYR 50 | PO888 | 10 | MYR 8 | MYR 80 |
B | PO225 | 10 | MYR 3 | MYR 30 | PO888 | 10 | MYR 2 | MYR 20 |

it would be better if we also able to calculate the unit price different and be like this
Item | Previous Order | Latest Order | Diff Pri
A | PO123 | 5 | MYR 10 | MYR 50 | PO888 | 10 | MYR 8 | MYR 80 | -2
B | PO225 | 10 | MYR 3 | MYR 30 | PO888 | 10 | MYR 2 | MYR 20 | -1

your support is much appreciated .

Thank you

Are you trying to do this with a query only or are you talking a session the user can run and generate a report? I might not be understanding the question.

On our 4c4 system I would get them to use a session, then I could just have one query to find current PO data, a second query to find the previous PO and just set the report fields to the information I needed.

Hello Sir,

I don't have capability as your 4c4.
I only knew the query which i will attach at session so my user can execute/run the query to have the report.

Thank you