Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Check Links Error: No ...
Microsoft Dynamics GP (Archived)

Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

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

Running Check Links on the Purchasing tables resulted in the following message: 

No vendor ID exists for this period summary information. Please reenter the vendor ID information. Added using Check Link

I have more than one client who is getting this message from Check Links.  The Vendor ID does not exist in the Vendor Master Table PM00200 nor the Vendor Master Summary PM00201 but data does exist for the vendor in the Vendor Master Period Summary PM00202.  Is there a utility that can clean this up or do I need to do this through SQL?  Is it safe to assume that this is the only table with orphan data or could it be feeding from somewhere else?  Do we know why these orphan records have been left out there?

*This post is locked for comments

  • Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    Glad I could help, and Super job taking care of this within GP!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    Redbeard, thank you for all your help.  The article link you provided helped me focus in on a resolution.  To clean this up through GP, I had to add each Vendor ID on the Check Links report, then go to Remove Period History and run it for each of the Vendor ID's.  In many cases I had to do it twice, once for Fiscal and once for Calendar.  Because I had a total of 59 pages of cleanup it was just easier for me to do it through SQL.   The data only resided in the PM00202 table.  

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    Nasha -

    I am not a big fan of using SQL to remove data from Dynamics GP. It is always my last resort.  It sounds like it may well be the case here. Your earlier post mentioned you looked at Remove Transaction History and Distribution History.  These tables in GP are PM30200 and PM30600, you should take a look at the data in these tables when you restrict on the VENDORID Field.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    Because the data is obviously in another table and when Check Links is ran it created the period summary information.    The exact error I am getting is 'No vendor ID exists for this period summary information. Please reenter the vendor ID information. Added using Check Lin'

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    Nasha,

    Why not use the Remove Period History tool, rather than SQL?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    I went in and added one of the Vendor ID's back in.  When I looked at Remove Transaction History, no transactions showed up.  When I looked at Remove Distributions, nothing showed up but when I looked at Remove Period History it showed there was 1 transaction from 2002 which would indicate that there is history out there.  So, do I delete the history  through SQL and can anyone tell me all the tables I need to remove data from?

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Check Links Error: No Vendor ID exist Period Summary in Microsoft Dynamics GP 2013

    I seem to remember a similar situation with Temporary vendors. Take a look at this article written by Gina Hoener a GP Consultant I have worked with before, and a Microsoft Certified Trainer.

    dynamicsuniversity.com/.../mystery-around-temporary-vendors

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links Error: No Vendor ID exist Period Summary

    This is for Dynamics GP 2013 R2

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Check Links Error: No Vendor ID exist Period Summary

    Nasha,

    What Microsoft Dynamics product are you using? This will help in getting your question answered. Thanks

    Justin Salter

    Community Manager

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans