Project and Portfolio Management Practitioners Forum
cancel

Problem with Field with Data Mask as "Currency"

Highlighted
PPMRam
Super Contributor.

Problem with Field with Data Mask as "Currency"

Hi,

 

We are in PPM 7.5. We are using validation "Currency Extended Text Field" for one of the field in request type with data mask as "currency". When we update this field with any value it will concatenate with $ symbol before the value. For ex: if the value is 100 it will look like $100.00 and in kcrt_request_details table also, it will store as $100.00. But some times it is showing as "USD100.00" in kcrt_request_details table. But when we update from front end, it is storing as $100.00. What could be the problem. Why it is behaving inconsistently.

Can anyone update me ASAP.

 

Thanks

Shravan

7 REPLIES
PPMRam
Super Contributor.

Re: Problem with Field with Data Mask as "Currency"

Attaching the screenshot of validation...

Celil
Acclaimed Contributor.

Re: Problem with Field with Data Mask as "Currency"

Hi,

 

Your stored data could has different formats because of client regional settings. It stored numbers with $ or USD symbol because of the validation type is text field (component type). If you look at time sheet table you will see the same thing. In time sheet table, time sheet names(consist dates) stored as text and depand on client regional settings.

 

Celil

Celil

IT Governance Professional
& PPM Solution Architect
PPMRam
Super Contributor.

Re: Problem with Field with Data Mask as "Currency"

Hi Celil,

 

Can you please eloborate your response. How can we chekc the regional settings of user.

 

Thanks

Shravan

Utkarsh_Mishra
Acclaimed Contributor.

Re: Problem with Field with Data Mask as "Currency"

Go To

 

Administrator -> Edit Profile

 

here you can find the regional setting.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
PPMRam
Super Contributor.

Re: Problem with Field with Data Mask as "Currency"

HI Celil,

 

We have tried to update the profile for one of the user( who is having Base Currency") and updated the request type field with that user and again we have changed the field data with another user (who is having Local Currency"). But with these two users, the field got updated with "$100" only. Not sure where we need to change apart from User profiles.

 

Thanks

Shravan

 

 

Celil
Acclaimed Contributor.

Re: Problem with Field with Data Mask as "Currency"

Hi Shravan,

Regional Settings is in control panel of windows OS. But Utkarsh mentioned the good point too.

Celil
Celil

IT Governance Professional
& PPM Solution Architect
Utkarsh_Mishra
Acclaimed Contributor.

Re: Problem with Field with Data Mask as "Currency"

Hi PPMRam,

 

Can you please tell me your default region of PPM and also share its screen-shot.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)