RE: [sap-business-one] UDF at Title as sum of UDF at Rows
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by mwhite949 (Sr. Solution Consultant) on Jan 29 at 2:33 PM |  Mark as helpful |
Just found this in the SAP Forums:
Before saving a document there is no possibility to get the sum of a column
by FMS.
The references to the current data in an FMS ( $[ . . . ) can refer only to
the data from the header or from the current row, as is what you are
experiencing.
You can only sum the column of a saved document, getting the data from the
data base using the document identifier from the header.
Options would be:
1) SDK
2) Install the B1 Usability package, and my guess is a Macro could
total this for you, without using the SDK.
3) Save the record before trying to get the total.
Good luck, sorry I wasn't able to help you.
Mike
From: ilun82 via sap-business-one
[mailto:sap-business-one@Groups.ITtoolbox.com]
Sent: Friday, January 29, 2010 8:46 AM
To: mwhite949
Subject: RE: [sap-business-one] UDF at Title as sum of UDF at Rows
Posted by ilun82 (System Analyst)
on Jan 29 at 11:47 AM
<http://it.toolbox.com/api/ContentVote/3270742/1/1/> Mark this reply as
helpfulMark as helpful
Mr.mwhite949, thanks for your reply.
I've tried your query. However, value of SumTotalCost at Title always equal
to value of TotalCost at First Row, instead of sum of TotalCost at Every
Row.
Any idea what have gone wrong?
From: sap-business-one@Groups.ITtoolbox.com
To: leeailoon@hotmail.com
Subject: RE: [sap-business-one] UDF at Title as sum of UDF at Rows
Date: Fri, 29 Jan 2010 00:58:18 -0800
Toolbox sap-business-one
Posted by mwhite949 (Sr. Solution Consultant)
on Jan 29 at 4:05 AM
Mark as helpful
I have run into similar problems when dealing with formatted
searches/queries in forms that have not yet been saved.
This is what works for me, try this:
SELECT SUM($[$-13.U_TotalCost.NUMBER])
I found that putting a - (negative) in front the number can fix issues like
this.
Mike White
www.esapuniversity.com
Online SAP Business One University
From: ilun82 via sap-business-one
[mailto:sap-business-one@Groups.ITtoolbox.com]
Sent: Friday, January 29, 2010 12:25 AM
To: mwhite949
Subject: [sap-business-one] UDF at Title as sum of UDF at Rows
Posted by ilun82 (System Analyst)
on Jan 29 at 3:28 AM
Hi all,
I have a UDF - TotalCost at Rows. This UDF is working fine.
I need to have another UDF - SumTotalCost at Title.
UDF - SumTotalCost will based on Saved Query:
SELECT SUM($[$13.U_TotalCost.NUMBER])
But the UDF is not working. Please advise.
Thanks.
_________________________________________________________________
Hotmail: Trusted email with Microsoft's powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969=
__.____._ Before saving a document there is no possibility to get the sum of a column
by FMS.
The references to the current data in an FMS ( $[ . . . ) can refer only to
the data from the header or from the current row, as is what you are
experiencing.
You can only sum the column of a saved document, getting the data from the
data base using the document identifier from the header.
Options would be:
1) SDK
2) Install the B1 Usability package, and my guess is a Macro could
total this for you, without using the SDK.
3) Save the record before trying to get the total.
Good luck, sorry I wasn't able to help you.
Mike
From: ilun82 via sap-business-one
[mailto:sap-business-one@Groups.ITtoolbox.com]
Sent: Friday, January 29, 2010 8:46 AM
To: mwhite949
Subject: RE: [sap-business-one] UDF at Title as sum of UDF at Rows
Posted by ilun82 (System Analyst)
on Jan 29 at 11:47 AM
<http://it.toolbox.com/api/ContentVote/3270742/1/1/> Mark this reply as
helpfulMark as helpful
Mr.mwhite949, thanks for your reply.
I've tried your query. However, value of SumTotalCost at Title always equal
to value of TotalCost at First Row, instead of sum of TotalCost at Every
Row.
Any idea what have gone wrong?
From: sap-business-one@Groups.ITtoolbox.com
To: leeailoon@hotmail.com
Subject: RE: [sap-business-one] UDF at Title as sum of UDF at Rows
Date: Fri, 29 Jan 2010 00:58:18 -0800
Toolbox sap-business-one
Posted by mwhite949 (Sr. Solution Consultant)
on Jan 29 at 4:05 AM
Mark as helpful
I have run into similar problems when dealing with formatted
searches/queries in forms that have not yet been saved.
This is what works for me, try this:
SELECT SUM($[$-13.U_TotalCost.NUMBER])
I found that putting a - (negative) in front the number can fix issues like
this.
Mike White
www.esapuniversity.com
Online SAP Business One University
From: ilun82 via sap-business-one
[mailto:sap-business-one@Groups.ITtoolbox.com]
Sent: Friday, January 29, 2010 12:25 AM
To: mwhite949
Subject: [sap-business-one] UDF at Title as sum of UDF at Rows
Posted by ilun82 (System Analyst)
on Jan 29 at 3:28 AM
Hi all,
I have a UDF - TotalCost at Rows. This UDF is working fine.
I need to have another UDF - SumTotalCost at Title.
UDF - SumTotalCost will based on Saved Query:
SELECT SUM($[$13.U_TotalCost.NUMBER])
But the UDF is not working. Please advise.
Thanks.
_________________________________________________________________
Hotmail: Trusted email with Microsoft's powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969=
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Share Knowledge About SAP Scripting. Join the New Discussion Group
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
