Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
45%
Handover everything to System Integrator from drawing BP till implementation of ERP
18%
Hire more inhouse skilled & capable IT Resource to work directly with SI
36%
Rely on SI Architects/Consultants
0%
Total votes: 11

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th February 2021, 08:19
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 229
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Summation of all except 7 criteria, give result amount 0
Baan: Infor ERP 10.6
C/S: None/Unknown

hi,

i try to do summation based on all fields except the 7 fields that i already put in specific column. which i declared as others.amt.
but it print qty 0.

is there anything that i do wrong?

Code:
declaration:

	domain	tcamnt	others.amt, others.amt1


detail.1:
before.layout:
	if whina124.fitr<>tcfitr.adjustment and whina124.fitr<>tcfitr.revaluation and whina124.fitr<>tcfitr.value.correct and whina124.fitr<>tcfitr.issue and whina124.fitr<>tcfitr.var.adjustment and whina124.fitr<>tcfitr.receipt and whina124.fitr<>tcfitr.ftp.result then
		others.amt = others.amt + whina124.amtf(1)
	endif

lattr.print=false	

after.whina124.itmt.1:
after.layout:
	others.amt = 0
your support is highly appreciated.tq

Last edited by pegaga1979 : 10th February 2021 at 08:41.
Reply With Quote
  #2  
Old 10th February 2021, 11:21
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 229
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
tried below code also can't:

Code:
declaration:

extern	domain	tcamnt	others, total, rec, issue, adj, val.corr, var.adj, rev, result

detail.1:
before.layout:

	total = total + whina124.amtf(1)

	if whina124.fitr = tcfitr.receipt then
	rec = rec + whina124.amtf(1)

	else if whina124.fitr = tcfitr.issue then
	issue = issue + whina124.amtf(1)
	
	else if whina124.fitr = tcfitr.adjustment then
	adj = adj + whina124.amtf(1)

	else if whina124.fitr = tcfitr.value.correct then
	val.corr = val.corr + whina124.amtf(1)

	else if whina124.fitr = tcfitr.var.adjustment then
	var.adj = var.adj + whina124.amtf(1)

	else if whina124.fitr = tcfitr.revaluation then
	rev = rev + whina124.amtf(1)

	else if whina124.fitr = tcfitr.ftp.result then
	result = result + whina124.amtf(1)
	
	endif
	endif
	endif
	endif
	endif
	endif
	endif


lattr.print=0	

after.whina124.itmt.1:
before.layout:
	others = total - rec - issue - adj - val.corr - var.adj - rev - result

after.layout:
	total = 0 
	rec = 0
	issue = 0
	adj = 0
	val.corr = 0
	var.adj = 0
	rev = 0 
	result = 0

Last edited by mark_h : 10th February 2021 at 15:41. Reason: add code tags
Reply With Quote
  #3  
Old 10th February 2021, 15:43
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,562
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
When you debug the report does it hit the detail.1 before layout? Do you have a physical layout in the report called layout.1?
__________________
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
  #4  
Old 11th February 2021, 06:38
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 229
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Hi Mark,

when i enable detail.1 to print out, amount for field "others.amt" or "others" still not come out. seem it disable to calculate.
Reply With Quote
  #5  
Old 11th February 2021, 16:19
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,562
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Put it in debug mode and see if it hits the code in the detail.1, before:layout. You need to make sure the code is getting hit first.
__________________
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
  #6  
Old 17th February 2021, 08:41
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 229
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Quote:
Originally Posted by mark_h View Post
Put it in debug mode and see if it hits the code in the detail.1, before:layout. You need to make sure the code is getting hit first.
it seems, it is not calculate and read the formula.
where is the wrong?
Reply With Quote
  #7  
Old 17th February 2021, 15:08
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,562
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Are whina124.amtf(1) and whina124.fitr input fields on the report? When in debug mode you should be able to click on them and see the value. You should be able to watch it hit one of the calculations.
__________________
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
  #8  
Old 18th February 2021, 12:26
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 229
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Hi Mark,

thank you much. just noticed as my input is whina124.itmt i should use whina124.amtt(1) and not whina124.amtf(1).

it is working perfectly now

thank you so much.
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
SQL query with date conversion BaBernd Tools Development 14 16th March 2016 19:17
Convert a nominal to words Eddie Monster Tools Development 5 3rd December 2012 22:45
time conversion randeep Distribution, Transportation & Warehousing 3 19th December 2011 12:30
How to handle Excess Receipt amount in Baan EBS? srivinayak Finance, Invoicing and Integration 2 11th May 2010 07:42
Commissions riazsayeed Distribution, Transportation & Warehousing 4 31st May 2007 15:57


All times are GMT +2. The time now is 09:54.


©2001-2021 - Baanboard.com - Baanforums.com