Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP account is different from default for few vendors

(0) ShareShare
ReportReport
Posted on by

Hello, i have a problem that pops up now and then.  Default account set up for AP on the company level for some vendors changes to different accounts.  Please see below.  First image is the set up of the AP account under Vendor Class Account Set up and the second image is from vendor account maintenance (for a particular vendor) where account is different.  Any ideas on why this is happening and is there a way to run a report to show which vendors have wrong account.

Thank you.

Vendor_5F00_Class_5F00_Account_5F00_Setup.gifVendor_5F00_account_5F00_maintance.gif

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: AP account is different from default for few vendors

    I only have one class, and when i check it under Vendor Class it has proper account assigned to it.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: AP account is different from default for few vendors

    If you go to Tools->Setup->Purchasing->Vendor Class and then enter the vendor class you are using you can then click on Accounts and set the AP account to any account. When you click save tell it to roll down the changes. Then pull that class back up again only this time change the AP account to what you want it to be and click saved and roll down the changes. This will update all vendors assigned to this class to the desired AP account.

  • Community Member Profile Picture
    on at
    RE: AP account is different from default for few vendors

    Not sure i understand...  I run a report and found out that over 2000 accounts have different account entered under vendor maintenance screen.  Is there a way to fix it without doing one by one by hand?

    Thank you.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: AP account is different from default for few vendors

    You can run this script in SSMS. You would need to add the FastPath product to run audit trails to find out who is changing the AP account.

     

    SELECT *

    FROM PM00200 PM2

    INNER JOIN PM00100 PM1 ON PM2.VNDCLSID=PM1.VNDCLSID

    WHERE PM2.PMAPINDX<>PM1.PMAPINDX

  • Community Member Profile Picture
    on at
    RE: AP account is different from default for few vendors

    I don't think that this has anything to do with class.  All my users are the same "Default" class.  Is there a way to run an audit report to see which user change account under vendor maintenance?

    Thank you.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: AP account is different from default for few vendors

    Sounds lie a little security may be needed to stop users from getting to the Account screen for the vendors. Leslie, as usual, is 100% correct. If you have  a little SQL experience you could write a query that compares the GL accounts of the class to the GL accounts of the vendors to list any differences.

  • Suggested answer
    L Vail Profile Picture
    65,271 on at
    RE: AP account is different from default for few vendors

    Hi,

    The class is never looked at to find the account. The account can roll down from the class, but most likely, someone changed the vendor card itself. You can find the accounts assigned to the vendor using the Vendor SmartList. The system looks to the Vendor account first, and if it doesn't find one there, it will look at the company posting account defaults. The class is never referenced.

    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans