View Single Post
  #1  
Old 25th August 2017, 08:07
DatinN DatinN is offline
Member
 
Join Date: Aug 2014
Posts: 65
DatinN is on a distinguished road
Baan: FP7 - DB: SQL - OS: Windows
Price Comparison Query
Baan: ERP LN 6.1 FP6
C/S: Both

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
Reply With Quote