Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th August 2017, 09: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
  #2  
Old 25th August 2017, 14:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,934
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 28th August 2017, 03:51
DatinN DatinN is offline
Member
 
Join Date: Aug 2014
Posts: 65
DatinN is on a distinguished road
Baan: FP7 - DB: SQL - OS: Windows
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
comparison enum value in query priyanka pawar Tools Administration & Installation 2 23rd April 2012 17:41
Cost Price Vs Std price Babuplus Finance, Invoicing and Integration 0 13th July 2011 02:12
cost price to standard price updation Babuplus Blogs and Web links 0 12th July 2011 19:02
Calculate Cost Price jinseong Finance, Invoicing and Integration 4 13th March 2009 06:30
Cost Price Question on Standard Items Eddie Monster Manufacturing & Supply Chain 3 8th February 2007 22:15


All times are GMT +2. The time now is 04:34.


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