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) / AP account is differen...
Microsoft Dynamics GP (Archived)

AP account is different from default for few vendors

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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
    Community Member Microsoft Employee 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
    Richard Wheeler 75,788 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
    Community Member Microsoft Employee 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
    Richard Wheeler 75,788 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
    Community Member Microsoft Employee 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
    Richard Wheeler 75,788 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
    L Vail 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans