Price Comparison Query
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 .
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.
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.
|All times are GMT +2. The time now is 18:35.|
©2001-2017 - Baanboard.com - Baanforums.com