Hi, is this as designed or a bug?
I have a report including a Currency field. If I generate the report to screen,
I get this result:
[cid:image001.png@01D0754A.706DD420]
'Value' has been selected:
[cid:image002.png@01D0754A.706DD420]
But report to CSV file sends all data from the field
What happens if you choose 'Associated Cost' instead of Value?
On Apr 12, 2015 9:59 AM, lars.j.petters...@vattenfall.com wrote:
**
Hi, is this as designed or a bug?
I have a report including a Currency field. If I generate the report to
screen, I get this result:
‘Value’ has been
field. My
initial thought was to create a new currency field named Cost and do a simple
SQL update statement to get the data copied rather than rely on an escalation.
I thought that this statement would work and it does update the destination
fields to the expected values, however when I look
. From: Rick WestbrockSent: Monday, May 19, 2014 6:10 PMTo: arslist@ARSLIST.ORGReply To: arslist@ARSLIST.ORGSubject: Copying a decimal field into a currency field**
Hi folks, I am working with a legacy custom application on my ARS 7.0.1 system (Oracle 10 back-end) where the initial
| IT Department
24 Hour Fitness USA, Inc.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Randeep Atwal
Sent: Monday, May 19, 2014 3:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Copying a decimal field into a currency field
**
Check out the database Ref document
, 2014 7:18 PMTo: arslist@ARSLIST.ORGReply To: arslist@ARSLIST.ORGSubject: Re: Copying a decimal field into a currency field**
Thanks Randeep, I only saw three fields in the DB associated with my new Cost field: CostC (currency type such as USD), CostV (the numeric value) and CostD (epoch time
From: Rick WestbrockSent: Monday, May 19, 2014 7:18 PMTo: arslist@ARSLIST.ORGReply To: arslist@ARSLIST.ORGSubject: Re: Copying a decimal field into a currency field**
Thanks Randeep, I only saw three fields
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
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
Hi,
Can anyone confirm that this is the easiest way to set both VALUE, TYPE
and DATE on a currency field?
Set-Fields: CURRSETVALUE(CURRCONVERT(0, $char$, $date$), $real$)
In the above example, i use a real-type field, but it should work fine
with decimal or integer as well.
Another question
at www.arslist.org ARSlist:Where
the Answers Are
--
View this message in context:
http://www.nabble.com/Currency-Field-Push---AST%3AAsset-tp7205611p19778206.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com
Hello, All!
I have a problem with a Currency Field,
I defined USD as dafault. When I changed a MXN and save it, returned a
USD. Only happend whith field that have 0 value.
Thanks in advance for your help
**
We are in need of updating our existing Asset records with
Cost information and I would like to export our existing records to csv, mass
update the Cost field (Currency field) and re-import back in place to our 6.3
Patch 16 server (Windows 2003, SQL Server 2000). I am getting
**
Hi Candace
Yes, importing into currency field is
tricky. One way you could do this is to import the data into a
display-only character field, then use filters running on Merge to set the
correct value to the real currency field.
HTH
David Sanders
Remedy Solution Architect
Help Importing
CSV Asset Records With Currency Field
Thanks David what is the
correct value I see it displayed differently in User than
in Admin.
How in the heck are you anyway? I am
busy solving all the CSS problems here LOL. Miss you.
J
Candace
From: Action Request
System
15 matches
Mail list logo