Re: Calculations in Browser

You can create logical attributes in Integrator to perform basic
arithmetic expressions using other attributes within the business
object's query scope. These host logicals can be used for column totals.
Be sure to test the performance of using the types of fields, due to the
fact that these calculations are being performed with SQL.  A less
dynamic approach would be to perform the calculation in a user exit and
persist the value in a user field or a user created extension object.

Hope this helps,


Robert Russell | Vice President, Product Development DG | Infor |
office: 678-319-8277 | mobile: 404-388-8640 | fax: 678-319-9277 |
robert.russell@xxxxxxxxx 
 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
ARojas@xxxxxxxxxxxxxxxxxxx
Sent: Tuesday, June 20, 2006 11:18 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Calculations in Browser

Integrator is the solution, you can use user exits, triggers or 'user
actions' to perform this type of calculations.








"Joe Perrault" <JRPERRAULT@xxxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/20/2006 07:07 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
"MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
cc

Subject
Re: [MAPICS-L] Calculations in Browser






I don't believe you can do this in Browser or PowerLink at this time
although coincidently I just sent in a suggestion to add that type of
capability.  Specifically I suggested adding a feature that would allow
users to define attributes and then use those defined attributes in
subsets or views.  I also suggested adding the capability to compare
attributes in subset tokens.  As to your issue, you could run a
scheduled RPG program or use a file trigger program that pre-calculates
the amount you want and loads it into one of the User Fields in POITEM
which would then be available in Browser/PowerLink.


Joe Perrault

-----Original Message-----
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx] 
Sent: Tuesday, June 20, 2006 8:45 AM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] Calculations in Browser

I'd like to take create a view of  PO showing item with on-order
quantities and multiply the on-order quantity times the item's cube and
weight to get an item total and a column total.  Can calculations such
as this be done in browser? 

TIA 
 
Mike Dreimiller
Mandis Inc. 
410-526-5996
Mandis-Inc@xxxxxxx
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.