web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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 28

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.

I have the same question (0)
  • 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 28 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 28 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 28 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,816 Moderator 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 28 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,816 Moderator 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 28 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 756 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 629 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 514 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans