Hi,
I allways get data in 'Field.VALUE', but...
It does not seem to be possible to specify the conversion date of a field,
as the actual conversion values is based on the current date rather than
the conversion date specified.
If you click on the expand box to show all currencies, you will NOT get
the field values stored in the database. It will always show conversions
based on the current time. This makes things hard to debug.
I have reported this currency deficiency (and many more) to BMC, but have
not received much of a response. Except the usual "give me more logs",
"give me your ar.conf", etc.
I was on version 7.6.04 when I did my struggling, and you seem to be way
behind with 6.3. On the other hand, I do not believe that much has been
done to the currency field since they were introduced.
The lack of response when posting to the list also seems to indicate that
the currency field functionality is simply not in use. At least nothing
more than getting a formatted field.
I also noticed that the new 7.6.04 built in web reporting does not allow
computation/statistics/summaries on currency fields at all...
What I ended up doing was this:
1. For each currency field, I created a shadow in my base accounting
currency (SEK), where I stored the actual SEK-value based on the
conversion date.
2. I created a service that did all the calculation. For example allowing
me to add two currency fields together without loosing precision and the
conversion ratios based on the conversion date.
3. If web reporting is required, you must create another decimal-type
shadow to hold the value.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi All,
>
> Ideally I would like to export the value from a currency field into a csv
> file, convert to excel and the total up the values.
>
> I have a requirement to replace some decimal fields with some currency
> fields. The field set up along with the currency ratios are
> straightforward, export to rep file works fine but I am having an issue
> exporting the data to a csv file.
>
> The field is called Total Contract Value. If I use that field in the
> report I get the value for each currency configured such as 1.00 USD 1.02
> CAD 0.68 EUR.
>
> If I select one of the sub-fields such as Total Contract Value.VALUE it
> appears blank in the csv file. Field permission is Public.
>
> I imagine it is something simple that I am missing.
>
> ARS 6.3 patch 20
> SunOS 5.9
> Oracle 9.2
>
> Mark Brittain
> Remedy Developer
> NaviSite - A Time Warner Cable Company
> mbritt...@navisite.com
> Office: 315-453-2912 x5335
> Mobile: 315-317-2897
>
>
> ________________________________
> This e-mail is the property of NaviSite, Inc. It is intended only for the
> person or entity to which it is addressed and may contain information that
> is privileged, confidential, or otherwise protected from disclosure.
> Distribution or copying of this e-mail, or the information contained
> herein, to anyone other than the intended recipient is prohibited.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
