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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Accounts Payable Invoi...
Finance | Project Operations, Human Resources, ...
Suggested answer

Accounts Payable Invoice - Stop AutoPopulate

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

Question: Is it possible to stop the system from 'helping the user' by auto populating the VENDOR ID field with the value of the last entry?  

Situation: Client (old client) with new User has now created many invoices in error - number of many could be 100 - since the user did not pay any attention to the fact that she was not entering a new ID for each new invoice - can not believe that, but that is the story - and they are sticking to it.

So the Controller says - can we stop the Auto Population?

I thought the answer was yes - but I am not able to find the switch to change that behaviour.  Anyone out there have an idea - no programming or coding allowed.

Thanks.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    Hello Bill,

    Thank you for your question.

    There is no way to accomplish this without a customization. However, there is a process change you could have them do.

    This only defaults the Vendor if you have posted a transaction and not closed the window. They could change their process to close the window after everyone they post so they are forced to enter the Vendor ID.

    Another option would be to setup a workflow so the transactions can be verified before they are posted. This way corrections can be made before posting.

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    Hi Bill

    Are you talking about AutoComplete?  This can be reset or disabled if needed under User Preferences.

    Which window are you talking about, as by default all the windows will clear the Vendor ID when saved?

    I think you either have a customisation or code already in play.

    If this is a modified window, was the SaveOnRestart property for the Vendor ID changed to true?

    Please note that GP Power Tools allows customisations with any externals tools with zero deployment or upgrade effort needed.

    Regards

    David

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    With no programming and coding - no desired action is possible.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    It does not keep the Vendor ID for me. Something is making that happen.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    David, I just recreate the same on GP 2018, when you create new document from Payable transaction entry window and save it and go to make another one , just cursor focus on vendor ID field it fill it with the last vendor you selected.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    Thanks Almas. I was not clicking back on the Vendor ID field afterwards. I have now replicated.

    I have confirmed how the "feature" works and worked out how to "fix" it with only the modifier (no code needed).  

    How to fix with Modifier. I might have to blog this one.

    [Edit] Here is the blog:

    https://winthropdc.wordpress.com/2022/03/24/gppt-stopping-vendor-id-auto-populating-on-payables-transaction-window/

    [/Edit]

    Tools menu >> Customize >> Modify Current Window
    Layout menu >> Show Invisible Fields
    Scroll down to show 5 columns of pink hidden fields
    4th column of hidden fields beneath window
    Move '(L) Enable Intrastat' to blank spot
    Select '(L) Prev Vendor ID'
    Layout Menu >> Properties or press Ctrl-M
    If the window appears and disappears, place your mouse where it appears and press Ctrl-M
    Select Object Table
    Locate SavedOnRestart property and change to false.
    Close and Save Layout window.
    Click OK on Form Definition
    File menu >> Microsoft Dynamics GP
    Use Alternate Modified ID setup window to change security to the now modified window.
    Fixed.

    Please note that GP Power Tools could also fix this with a single custom trigger and would not need any modifications to the window or changes in security.

    Regards


    David

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    Yes, and similar can be done from dexterity , and both modifier or dexterity alternate window needs to be mark and this needs to be understand by user that even without code it is still a customization. :)

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    Sorry everyone, I have been involved in a number of personal issues and this is the first time I have been able to review.

    David, I will have to investigate this option with the client and see what happens.

    Thanks.

  • StefanieC Profile Picture
    StefanieC 434 on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    I just came across this post because my user reported that it stopped working after upgrade.  They want it back.  It turns out that when Document Attachment is enabled, the autofill Vendor ID from the last Vendor no longer works.  So, I guess turning that on would be an easy fix for this issue if you're still having it a year later. :)  

    Does anyone know how to get it turned back on with Document Attach enabled?  At this point, it is not important enough to do customizations.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    RE: Accounts Payable Invoice - Stop AutoPopulate

    What method was used to change the behaviour in the first place?

    Did you use the modified window method?

    when you say you have to turn Document Attach off, does that mean you are not using the modified window?

    Did you upgrade the forms dictionary to combine you customisations into the base window for the new version?

    If your modified window is missing the Document Attach features, delete the modified window and modify it again to change the behaviour.

    NOTE: Make sure you confirm if there are any other changes to the window or custom VBA code before deleting the modified window.

    Regards

    David

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 867 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans