Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cannot create a record...
Finance | Project Operations, Human Resources, ...
Suggested answer

Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

(0) ShareShare
ReportReport
Posted on by Sinan.C 20

I check all the area... even I could' not find solution. I cleared number sequences .... no change.. can any one help???

  • Suggested answer
    TracyXing Profile Picture
    TracyXing on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    There is a bug related: fix.lcs.dynamics.com/.../Details

    This KB was released in CU11, please check if your AX version is higher than CU11

  • TracyXing Profile Picture
    TracyXing on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    Hi Sinan, what is the version information for your AX2012?

  • Sinan.C Profile Picture
    Sinan.C 20 on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    can I get your contact ?

  • Sinan.C Profile Picture
    Sinan.C 20 on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    How I can clear this entries ? bcoz it is under note payable now. I have to make settle entry to bank.

    pastedimage1630410154305v1.png this is coming. Instead of posted, it should be paid. 

  • Suggested answer
    Sinan.C Profile Picture
    Sinan.C 20 on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    pastedimage1630409941554v1.png PDC doing under Accounts Payable Module. it is base function but improvised 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    Hi,

    The journal PDC seems already setup.

    You cannot create a new journal with the same name.

    If you want to setup a new journal use a different Id, such as PDC2 or something alike.

    Best regards,

    Ludwig

  • MuthukumaranAX Profile Picture
    MuthukumaranAX 2,901 on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    Hi

    is there any customization done on this?

    can you also check the next number in the number sequence form?

    Thanks

  • Sinan.C Profile Picture
    Sinan.C 20 on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    pastedimage1630406978833v1.png

  • TracyXing Profile Picture
    TracyXing on at
    RE: Cannot create a record in Ledger journal table (LedgerJournalTable). Name: PDC, Posted Dated Cheque. The record already exists.

    Could you please check if there is a record name with "PDC, Posted Dated Cheque" in LedgerJournalTable from SQL server management studio

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans