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
39%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 36

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th November 2017, 20:24
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 28
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
after.field based on multiple column values
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: None/Unknown

Is it possible to do an after.field section that is based on multiple column values?

I have an order number and an order line number. I'd like to display a layout when the combination of those 2 values changes.

What I'm trying to accomplish is this.. Right now we have a report that displays certain sales order delivery lines depending on what selection criteria they use. It's sorted by order number, order line number, and then item. However, if certain lines from those sales order delivery lines have multiple different delivery lines for the same item they'd like this particular report to roll up the quantities for that item into 1 line.

Any suggestions on a good way to approach this?
Reply With Quote
  #2  
Old 14th November 2017, 21:20
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,923
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I have done something like this 2 different ways - in 1 case what I did was I just created a report which printed the details. Then I created a second report which only printed totals - so basically I just added the header and one after field layout (this was based of the last of my sorted fields) - so 1 item and 1 deliver would print the total. Then 1 item with multiple deliveries got a totaled value. The only problem with this is things like deliver date had to be removed. In my case it was not sales reports but around SFC planning.

The second way I did this was to just change the session script to pass only the totals for each line. Basically I got the orders and lines, then just ran some functions to total the values and then did a rprt_send().

Not sure if this helps or I am misunderstanding the requirement.
__________________
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
  #3  
Old 15th November 2017, 16:01
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 28
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
I think what they want to see in this case instead of a subtotal or total line is for the detail lines themselves to be rolled up into a single one. So if an order/position number combination had multiple delivery lines instead of showing 4 different lines with a quantity of 1 they'd want to see 1 line with a quantity of 4.
Reply With Quote
  #4  
Old 15th November 2017, 23:03
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,923
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
That is what I was thinking with the reports - basically I created a report that showed order - line - qty for the details. Then I copied the report to a new report - added sort fields, and put in an after.field layout on the line. Then the total for qty. I would run that to get it to look like I wanted in the after field layout. Then just delete the detail.layout from the report. Then when you ran it all you got was the total layout with everything needed in it.
__________________
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
  #5  
Old 16th November 2017, 13:42
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,305
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
I am not completely sure about the requirement here. But, since the question is about using multiple column values in after.field, yes, there is a way.

What I did was, use a string variable say, e.g. comb.f, now, concatenate all the values you need and assign it to this field. Now, use this field on your report layout as after.field.

It has worked for me, so why not give it a try.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
  #6  
Old 16th November 2017, 16:01
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 28
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
I think I'll do a combination of both your suggestions. Concat all values and use as a sorted input field, then display only that as an after.field. Should work nicely. Thanks, guys!
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
Invoices printing issue-display last record with 2 lines tracylee Tools Development 7 20th October 2017 11:51
Totalling a column in report based on multiple other columns lotius81 Tools Development 2 27th June 2017 19:39
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
Get multiple rows values in script aamir_faried Tools Development 1 29th October 2009 13:35
multiple values of one column in a table hprhpr Tools Development 8 11th May 2007 15:21


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


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