Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Site ID Table and Table Name??

Posted on by Microsoft Employee

I am working on an integration CRM<-->GP , to "push" an Account record from CRM to GP to create a new customer one of the fields we want to populate is Site ID.

Can someone please tell me which table this field can be found on and what the field would be called on the table?

Thanks

Retreever

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Site ID Table and Table Name??

    Thanks, LOCNCODE it is.

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Site ID Table and Table Name??

    The Site is also held at the address level for the customer so it's the RM00102 table.  It's the LOCNCODE field.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Site ID Table and Table Name??

    The Site Master in GP in IV40700.  

    But not clear on how/why you would tie to a customer.  GP holds on Item/Site combinations.  

    Good Luck!  

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans