Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Address ID's missing after GL close

Posted on by Microsoft Employee

I was able successfully close our GL last night. However after the close it appears that all our Address ID's (Purchasing, Sales, HR & Payroll) are missing. Has anyone had this happen before and if so how do I restore these Address ID's?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Address ID's missing after GL close

    Understood. I guess I was just hoping there was Master table that housed all of these ID's. I will get to work on restoring these in each module. Thank you all for your help.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Address ID's missing after GL close

    Hi,

    I'm with Richard, it doesn't make any sense for the close to have caused this. If you can't restore everything, you could just restore the addresses. The are in the following tables in the company database:

     Vendors: PM00300

     Customers: RM00102

     Payroll: UPR00102

     Company Locations: SY00600

    Which other addresses do you need?

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Address ID's missing after GL close

    I completely agree this makes no sense at all. Nothing out of the ordinary aside from Mekorma, Regal Pay, Greenshades. I'm working on a restore to our DEV environment now. What table are the Address ID's stored in. I checked SY06000 but that looks like all addresses for all customers and vendors.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Address ID's missing after GL close

    That makes absolutely no sense. Do you have third-party products or custom triggers that would have caused this?  Is it too late to restore from backup? If it is, you can restore to another database and then restore those IDs using SQL.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans