Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / The record already exi...
Finance | Project Operations, Human Resources, ...
Suggested answer

The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by @rp@n 5,901

Hi All,

When trying to post few invoices from Pending Vendor Invoice then will get below error

The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None.

Kindly let me know what are the cause and how to fix this?

Please give me more shed on this.

  • sumanth kumar Profile Picture
    sumanth kumar 9 on at
    The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3
    did u get any solution for this error is yes please share it with me I'm facing the same problem when confirming the Purchase order.
  • sumanth kumar Profile Picture
    sumanth kumar 9 on at
    The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3
    Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. The record already exists.
     
    INSERT INTO tempdb."DBO".t521IISSHAMALDEV2_47836_79EEC0922CF145DAA7CA03B5805485E9 (ISFINAL,TYPEENUMNAME,TYPEENUMVALUE,STATUS,SOURCEDOCUMENTHEADER,PARENTSOURCEDOCUMENTLINE,SOURCERELATIONTYPE,EXCHANGERATEDATE,SOURCEDOCUMENTLINE,ACCOUNTINGDATE,RECVERSION,PARTITION) SELECT T1.ISFINAL AS f1,T1.TYPEENUMNAME AS f2,T1.TYPEENUMVALUE AS f3,T1.ACCOUNTINGSTATUS AS f4,T1.SOURCEDOCUMENTHEADER AS f5,T1.PARENTSOURCEDOCUMENTLINE AS f6,T1.SOURCERELATIONTYPE AS f7,T1.EXCHANGERATEDATE AS f8,T1.RECID AS f9,T2.ACCOUNTINGDATE AS f10,1 AS RECVERSION,5637144576 AS PARTITION FROM SOURCEDOCUMENTLINE T1 CROSS JOIN tempdb."DBO".t1705IISSHAMALDEV2_47836_7AFECBBD8426433AB5A570960DF4D590 T2 WHERE ((T1.PARTITION=5637144576) AND (T1.SOURCEDOCUMENTHEADER=5637204621)) AND ((T2.PARTITION=5637144576) AND (T2.SOURCEDOCUMENTLINE=T1.RECID))
     
    even I'm getting the same error  anyone please help
     
     
     
  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    hi everyone,

    is anyone having solution for this? pls help me out.

    thanks!

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    anyone pls help me how to resolve this issue

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    Hi Ergun

    Stopped (error): INSERT INTO tempdb."DBO".t101281_85C57D22470A465E9EDCC794B2FE1E2A (ISFINAL,TYPEENUMNAME,TYPEENUMVALUE,STATUS,SOURCEDOCUMENTHEADER,PARENTSOURCEDOCUMENTLINE,SOURCERELATIONTYPE,EXCHANGERATEDATE,SOURCEDOCUMENTLINE,ACCOUNTINGDATE,RECVERSION,PARTITION) SELECT T1.ISFINAL AS f1,T1.TYPEENUMNAME AS f2,T1.TYPEENUMVALUE AS f3,T1.ACCOUNTINGSTATUS AS f4,T1.SOURCEDOCUMENTHEADER AS f5,T1.PARENTSOURCEDOCUMENTLINE AS f6,T1.SOURCERELATIONTYPE AS f7,T1.EXCHANGERATEDATE AS f8,T1.RECID AS f9,T2.ACCOUNTINGDATE AS f10,1 AS RECVERSION,5637144576 AS PARTITION FROM SOURCEDOCUMENTLINE T1 CROSS JOIN tempdb."DBO".t100010_2117FB687CE6467CB380000255D79CD0 T2 WHERE ((T1.PARTITION=5637144576) AND (T1.SOURCEDOCUMENTHEADER=5642933293)) AND ((T2.PARTITION=5637144576) AND (T2.SOURCEDOCUMENTLINE=T1.RECID)) Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None.

    The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None.

    Here 101281 = SourceDocumentLineTmpJournalize

    100010 = Common

    Please give me suggestion to fix this.

    thanks!

    The record already exists.

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User 2024 Season 1 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    There should be an sql clause behind the info above. Can you share the full error?

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    Thanks Ergun,

    I tried but still having problem.  I have change the table property of SourceDocumentLineTmpJounalize - TempDB to Regular, but still data not saved.

    I wants to check the data.

    Please give me some suggestions on this.

    Thanks!

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User 2024 Season 1 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    msdax.wordpress.com/.../

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: The record already exists. Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None. In Pending Vendor Invoice in AX 2012 R3

    pls help me on this

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans