This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear BIRT Experts,
I would like to get TOTALBASECOST value to be displayed on PR and PO Reports.
Does anyone know how to select PR.TOTALBASECOST and PO.TOTALBASECOST in birt since it's non persistent field?
Please advise. I really appreciate for any suggestions and comments.
Regards,
Tommy
since the totalbasecost is a non persistent field you need to use the fields that make up the totalbasecost value...(i.e. an example is actlabcost + actmatcost + actservcost = acttotalcost)
So in your Birt report where you wish to display the Totalbasecost you'd create the BIRT value to be a total of the fields that must up the totalbasecost.
From: Tommy Hediaka <hediaka@yahoo.co.id>
To: maximo yahoogroups <maximo@yahoogroups.com>
Sent: Friday, November 29, 2013 1:13 AM
Subject: [MAXIMO List] How to get TOTALBASECOST in BIRT
Dear BIRT Experts,
I would like to get TOTALBASECOST value to be displayed on PR and PO Reports.
Does anyone know how to select PR.TOTALBASECOST and PO.TOTALBASECOST in birt since it's non persistent field?
Please advise. I really appreciate for any suggestions and comments.
Regards,
Tommy
Hi Tommy,,
based on psdi.app.common.purchasing.FldPurTotalBaseCost it says :
...
MboValue totalBaseCost = getMboValue();
double totalBaseCos = 0.0D;
Mbo poOrpr = getMboValue().getMbo();
double totalCost = poOrpr.getDouble("totalCost");
Date currentDate =
MXServer.getMXServer().getDate(poOrpr.getClientLocale(),
poOrpr.getClientTimeZone());
CurrencyServiceRemote currService =
(CurrencyServiceRemote)MXServer.getMXServer().lookup("CURRENCY");
String baseCurrency1 = currService.getBaseCurrency1(poOrpr.getString(
"orgid"), poOrpr.getUserInfo());
if (poOrpr.getDouble("exchangerate") != 0.0D)
totalBaseCos = totalCost * poOrpr.getDouble("exchangerate");
else
totalBaseCos = totalCost *
currService.getCurrencyExchangeRate(poOrpr.getUserInfo(),
poOrpr.getString("currencycode"), baseCurrency1, currentDate,
poOrpr.getString("orgid"));
totalBaseCost.setValue(totalBaseCos, 11L);
...
Best Regards,
Yudi Irianto
Tommy Hediaka <hediaka@yahoo.co.id>
Sent by: MAXIMO@yahoogroups.com
29-11-2013 13:13
Please respond to
MAXIMO@yahoogroups.com
To
maximo yahoogroups <maximo@yahoogroups.com>
cc
Subject
[MAXIMO List] How to get TOTALBASECOST in BIRT
Dear BIRT Experts,
I would like to get TOTALBASECOST value to be displayed on PR and PO
Reports.
Does anyone know how to select PR.TOTALBASECOST and PO.TOTALBASECOST in
birt since it's non persistent field?
Please advise. I really appreciate for any suggestions and comments.
Regards,
Tommy
Many thanks for the enlightment Mas Yudi! I should know about it!
Really appreciate it Mas Yud!