web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Data entry option - cu...
Microsoft Dynamics GP (Archived)

Data entry option - currency amount as whole dollars as default

(1) ShareShare
ReportReport
Posted on by Heather Roggeveen 9,146

Hi

I have one that I don't even know how to word correctly to search, so will try here with a more detailed explanation.

My client wants to be able to enter currency amounts in GP where it defaults to whole dollars first unless the decimal place is hit.  E.g. to enter $100, they want to type 100 rather than 100. or 10000.

Basically they want it the same as e.g. Excel - when you put a number in the field, it assumes a whole dollar unless you put a decimal in.

Does anyone know if there is a tool or add-in that enables this?

Cheers

Heather

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Heather,

    that sounds like a customization project :-)... By default GP will behave based on the definition of the number of decimals requested for a field.. so unless that field is whole number (no decimals), you're probably not going to get around hitting the "." to close the number entry, and even with no decimals defined, (i.e. for Inventory numbers) I'm not sure you can avoid the "." to separate the left from the right portion.

    My feeling is that the entry field is formatted to behave like that. If you open the form in Modifier and check its properties, you may be able to change it to "no-decimals". Don't forget to adjust the security after that for Modified/Customized forms & reports  security.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    Thanks Beat

    I think it probably will end up customisation - I just hate recreating the wheel.  So if someone already had a little tool that enabled this, that would be great.

    Cheers

    Heather

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,093 Most Valuable Professional on at

    Hi Heather

    You will not be able to change behaviour while it stays as a single field.

    This is Dexterity's default behaviour. If you want it changed you will need to log a product suggestion on MS Connect.

    One option for a customisation would be to split the value into two fields for dollars and cents. So then you will need to press tab to enter cents.

    David

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    Thanks for the feedback David.  It is good to know options - and this one looks like the too hard basket.  It is only a single client that finds it an issue, so not something I will end up putting as a product suggestion.

    Cheers

    Heather

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans