Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

modifier vba on sales transaction entry

Posted on by 3,125

good day,

 

I'm trying to make the name of the customer not to be editable but on sales transaction entry window. The problem is that i write false and assign on a user but it's still available to be edited.

*This post is locked for comments

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    Hello Aaron,

    Thanks I will test it our around, But i just figured out another problem because what i had assumed then was to removed it so only the cashier could place the name on the invoice if it was a special customer but the problem now is that the sales clerk need to place the name of the customer on the quotes.

     But thank you very much for being such a great sport in helping me out.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    I figured it out.  You can add the window and the Customer Name field to VBA and add the following on the Window_AfterActivate() event:

    SalesTransactionEntry.CustomerName.Enabled = False

    I tried this,and the field is now "greyed" out and is not editable.  

    I have not tested this to see if there are any advers affects, so you should play around with this alot until you feel comfortable witht the results.  I hate to assume but I'm wondering if there is a reason that Dynamics doesn't allow for you to change the property settings on the form so be very careful.

    If it seems to work, you can package the form up and import it on your user's workstation.

    Aaron 

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    Sorry I wasn't any help to you.  Even though I don't have a need to restrict this field, now I'm interested to know if it can be done.  Maybe we'll here from one of MVP's on this matter.....

    Aaron

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    Hello Aaron,

     don't worry. I appreciate your concern and thank you very much.

    Maybe some else has got a clue on solving this GP riddle

    Have a nice day

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    I see what you are saying.  I too cannot set the edit flag to false.  I should have tested it sooner myself, sorry.  I wonder if it's a GP thing?  Since the Customer name is required by SOP, we may not be able to restrict that field in any way.

    We have Field level security and I am not allowed to apply a lock restriction on that field from there either.   Frankly, I don't think this can be done....

    Aaron

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    Good day Aaron,

    - yes

    -yes

    - I have several id's but i'm assigning it specifically to the sales clerk id setup. I have setup this with several other windows the problem specifically is being presented on the customer name field which doesn`t allow me to make it uneditable.

    On the 3rd party note i really don`t think so because we only purchased GP and not had time yet to purchase other softwares to include in GP.

     Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: modifier vba on sales transaction entry

    Ok. So,

    -You are modifying the editable property of the field to 'false'

    -You have confirmed that security is set to view the modifyed form

    Do you have more than one ID setup for the Alternate/Modified Reports?  If so, check the user accounts that you want this form to be used for and make sure that the Alternate/Modified Reports ID is the same as the one you set to use this modified form.

    The other thing you might want to check is if you are using any 3rd party dictionaries.  If you are, confirm that these dictionaries do not include an alternate version of the form.  If so, and you are using that form versus the GP form, then you would need to apply the modification to the alternate form and set security accordingly.

    Hope this helps,

    Aaron

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: modifier vba on sales transaction entry

    Good day Aaron,

     I'm using the properties of that field and modifying it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: modifier vba on sales transaction entry

    Are you actually writing VBA code to do this or are you using the properties for that field?

    Aaron

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: modifier vba on sales transaction entry

    Good day Aaron,

     Yes I actually have. I apologize for not stating it before. It's quite odd what's happening.

     Thank you

    Have a nice day

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans