Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
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 Ledger posting setup (ProjPosting). Account type: . The record already exists.

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

Hi,

I am trying to add a new main account in "Ledger Posting Setup" form for Project posting but getting error "Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists."

I checked but these main accounts haven't been used in the Ledger posting setup elsewhere.

Also checked other thread in the forum which points to number sequence length issue but that is also correct in my case.

Any suggestions please ?

Thanks in advance.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi Mattguo,

    I was trying to assign the main account to ALL projects and ALL category relations.

    But when I checked the category relations as per your suggestion, found that all project categories have already been assigned main accounts.

    Hence the error.

    I can either add main accounts to specific project types or need to change the assigned main accounts now.

    Thanks for your help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi Deepak,

    No. none of the above changes were made.

  • Deepak Agarwal Profile Picture
    Deepak Agarwal 148 on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi,

    Did you recently modified this table and added new PK/Indexes. If yes, this might be data issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi Crispin,

    I had removed the "Account type" values  from the post to make it generic. Receiving value for example "Account type: Cost, 54200" there. (this is the account I am trying to add to the Cost Ledger posting setup along with several others including Revenue accounts.

    Regarding Index violation and table fields, I will take help from my technical colleague to check these and get back to you.

    Thanks for the suggestions.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi Ludwig,

    Yes tried refreshing and restarting instance several times but still in vain.

    The version we are using is 6.3.164.0.

    This is AX 2012 R3 RTM version.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi,

    Have you tried refreshing the form and removed any filter that exists?

    Please also let us know what version of AX you operate.

    Thanks

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    I checked. The set of accounts which I am trying to configure does not exist in any posting type in Ledger posting setup.

  • Verified answer
    MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Cannot create a record in Ledger posting setup (ProjPosting). Account type: . The record already exists.

    Hi Yash,

    Do you check whether the category relation already exists?

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

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