Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot create a record...
Microsoft Dynamics AX (Archived)

Cannot create a record in Global address book (DirPartyTable) in AX 2009

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

Dear all,

It has error meesage "Cannot create a record in Global address book (DirPartyTable)" when we create new customer ID and vendor ID, and we ensure it is not duplicate number. Would you have any solution to fix the problem?

Many thanks

Christy Pang

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Mark,

    Find out the solution to fix the problem

    Basic -> set up -> number sequence -> AB (global address book) -> General (tab) -> untick "Manual"

    Many thanks

    Christy Pang

  • Mark Boy2 Profile Picture
    Mark Boy2 490 on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    addtion information: check your table Relation about dirpartyTable/CustTable/VendorTable

    If there's more misinformation pls show out

  • Mark Boy2 Profile Picture
    Mark Boy2 490 on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Did you check your dirpartyTable -> partyNumber is not maxinum?

    After you synchronize, Did you check the table again to see if there is a record exists about you mentioned?

    or you can write query in SQL,

    select partyNumber from dirpartytable

    where partyNumber = 'yournumberValue'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Mark,

    All three steps done, but cannot fix the problem. We suspect that it is because of a number in the Global address which is blank but being locked.

    Do you have any suggestion to fix it.

    Many thanks

    Christy Pang

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Mark,

    I have done Step 1, but cannot find step 2 "system management". Can you let me know how I find it.

    Is it need to do all 3 steps to fix problem?

    Many thanks again.

    Christy Pang

  • Mark Boy2 Profile Picture
    Mark Boy2 490 on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    3.In the System management -> Periodic -> Database -> SQL Administration -> table actions ->synchronize database

  • Mark Boy2 Profile Picture
    Mark Boy2 490 on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Christy Pang,

    1. In the AOT -> datadictionary -> table ->dirpartyTable ->right click ->synchronize

    2. In the System management -> Periodic -> Database -> Consistency Check

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Mark,

    I think we need to synchronize our DirPartyTable. Can you let me know how to synchronize it

    Many thanks.

    Christy Pang

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Dear Ludwig,

    All of users has this problem in one entity and where I can find out global address book in AX 2009.

    Best regards

    Christy Pang

  • Mark Boy2 Profile Picture
    Mark Boy2 490 on at
    RE: Cannot create a record in Global address book (DirPartyTable) in AX 2009

    Hi Christy，

    As Satish Panwar said, check the number sequence,

    If that there is no problem, you can try to Synchronize your DirPartyTable

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