Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Customer Maintenance - Tax Schedule ID

(0) ShareShare
ReportReport
Posted on by 15

Is there a way in GP 10 to have the Tax Schedule ID a default value without having to rely on class ID's etc. Basically so when the Customer Maintenance form is open it already defaults to one particular Tax Schedule ID?


Thanks!

*This post is locked for comments

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,957 Most Valuable Professional on at
    RE: Customer Maintenance - Tax Schedule ID

    Hi Tyler

    VBA is stored in a .vba file with the same name as the dictionary the code is written against. Eg Dynamics.vba

    Make sure you are the only user using that instance of the application folder.

    Make sure the *.vba files are not read only.

    Try using Run as Administrator when launching GP to avoid issues with Windows UAC.

    David

  • Tyler84 Profile Picture
    Tyler84 15 on at
    RE: Customer Maintenance - Tax Schedule ID

    Thank you both. That help a lot. Had to add one more part of the If statement to only apply to a single company.

    On a side note my VBA script is not saving. Get an error:

    vba project cannot be saved because there are other users in the system or file is read only.

    Can this only be done when no one is on the system?

    or if the file is read only, what file is this?

    Sorry new to Dynamics probably a simple answer.

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,957 Most Valuable Professional on at
    RE: Customer Maintenance - Tax Schedule ID

    You can use Me.Changed=False to clear the window changed flag. That is a better approach than modifying the window to change the SetChangeFlag on the field.

    You can also use GP Power Tools to create a trigger which can perform the same job. The advantage of GP Power Tools is that it works with the web client and only needs to be created on one workstation to be automatically deployed to all workstations.

    GP Power Tools Portal: http://WinthropDC.com/GPPT

    David

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Customer Maintenance - Tax Schedule ID

    I think you could do this with Modifier/VBA. You could use the after open event and populate the field with the string of your choice. You would also need to do something similar on the Customer Address Maintenance window. Your VBA code would look something like this:

    Private Sub Window_AfterOpen()
    If CustomerID = "" Then
    TaxScheduleID = "USASTCITY-6*"
    End If
    End Sub

    You'll also want to set the Save on Restart property to TRUE in Modifier. Since that field will trip the field change as soon as you open the window, it will ask you if you want to save changes even if you do not change anything. If you don't want it to do that, change the SetChangeFlag property to FALSE using Modifier.

    Kind regards,

    Leslie

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans