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) / auto-complete in the f...
Microsoft Dynamics GP (Archived)

auto-complete in the financials series

(0) ShareShare
ReportReport
Posted on by Esther Perez 275

Hello,

I am currently using Microsoft Dynamics GP10 at work and am wondering if there is a way to have auto-complete in the financials series? I ask this because the account numbers we use are 10 digits long and often times, 9 of the 10 digits should be zero when I am making an entry. Can those 9 digits auto fill so I don't have to type them in?  Someone mentioned the following three options:

You could write a macro that you can execute with a hot key (like F2)

You could use VBA to programmatically change it.

You could use a nickname (alias) for the account.

Can anyone please tell me more about these or offer new suggestions.

Thank you,

Esther

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Esther,

    Looks like you have some pretty good advice!

    Looking over the options from the 'I'm not a VBA programmer' standpoint, the macro with hot key is where I would go. The reason I would choose that one is because it's only one keystroke, F2 (or whatever)

    The nickname method requires two keystrokes. You have to select CTRL+Q.

    VBA is cool if you own the Modifier module and you know how to do it.

    That's my two cents.

    Kind regards,

    Leslie

  • Esther Perez Profile Picture
    Esther Perez 275 on at

    Thank you!

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Leslie has some good perspectives.  Let me expand a bit on the Alias response.  I am a "nothing special" kind of person and alias's are built into the program while macros and VBA require "custom" coding that can get lost or present update issues.  (Yes, Leslie, I said "can"  not "will")

    The alias needs to be added to those accounts you frequently use and need to be simple and easily remembered.  For example, you could use CSH for the main cash account.  You hit Control+Q and then type CSH and the entire cash account is copied into your account number field.  Yes, it is not as easy as the auto-fill but you can use it the FIRST time you use an account as well!

    We discuss this in our soon to be released MS Dynamics GP Financial manual.  Watch our site ( http:\\www.AccoladePublications.com )

  • Esther Perez Profile Picture
    Esther Perez 275 on at

    Thank you very much!

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
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans