Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   Price Comparison Query (http://www.baanboard.com/baanboard/showthread.php?t=70369)

DatinN 25th August 2017 08:07

Price Comparison Query
 
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

mark_h 25th August 2017 13:22

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.

DatinN 28th August 2017 02:51

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


All times are GMT +2. The time now is 02:24.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com