Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Bulk Transaction journal is not printing

Posted on by 520

Dear All,

I am trying to print one journal in General journal window and getting the following error.

"Cannot edit a record in Print journal (LedgerJournalTmp).

The SQL database has issued an error."

other journals are printing fine. this particular journal has more than 500 lines.

any one please let me know the possible solution.

Regards,

Moin.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bulk Transaction journal is not printing

    thanks.. my issue also resolve by it. thanks again

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Bulk Transaction journal is not printing

    Hi Dragos

    The ExtendedDataType is a property of the table field.

    So, go through the table, open the fields node, choose the field and with right click choose property.

    In the property change the ExtendedDataType

  • Dragos Profile Picture
    Dragos 120 on at
    RE: Bulk Transaction journal is not printing

    Hi Denis and Muhammad,

    I am getting a similar error while printing a journal. Could you explain in more detail the above advice? I don't know where to search for changing the ExtendedDataType.

    Thanks!!

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Bulk Transaction journal is not printing

    Your welcome

    Have a nice day

  • RE: Bulk Transaction journal is not printing

    Thanks Denis it's solved.

    Thanks & Best Regards,

    Moin

  • Verified answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Bulk Transaction journal is not printing

    Hi Moin

    The problem is on AccountName field of LedgerJournalTmp Table.

    On AccountName field, change the ExtendedDataType from AccountName to DirPartyName.

    The AccountName lenght is 60, instead DirPartyName is 100.

    The field AccountName come from Name field of DirPartyTable table that have a stringsize greater than AccountName field.

  • RE: Bulk Transaction journal is not printing

    Hi Denis,

    Thanks for your reply.

    I followed these steps to un-check the CIL.

    Development Work space > Tools > Options > Development > Execute business operation in CIL.

    It was previously checked, then I run the report and getting same error. this is the second line of error

    "[Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated."

    and the third line is.

    "SQL statement: UPDATE T1 SET ACCOUNTNAME=T4.NAME,ACCOUNTNUM=T2.DISPLAYVALUE,RECVERSION=? FROM tempdb."DBO".t10841_69B3F7D1F031409EBC810A2C719FD5DB T1 CROSS JOIN DIMENSIONATTRIBUTEVALUECOMBINATION T2 CROSS JOIN CUSTTABLE T3 CROSS JOIN DIRPARTYTABLE T4 WHERE ((T1.PARTITION=?) AND (T1.ACCOUNTTYPE=?)) AND ((T2.PARTITION=?) AND (T2.RECID=T1.LEDGERDIMENSION)) AND (((T3.PARTITION=?) AND (T3.DATAAREAID=?)) AND (T3.ACCOUNTNUM=T2.DISPLAYVALUE)) AND ((T4.PARTITION=?) AND (T4.RECID=T3.PARTY))"

    waiting for your response.

    Regards,

    Moin.

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Bulk Transaction journal is not printing

    Hi Moin

    To find out where is generated this error, try to :

    1- Disable CIL on your AX Option

    2- Run the Report

    3- Double Click on Infolog.

    Now you can see the line of code that generate the error.

    Please, move also here.

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans