Microsoft Dynamics AX (Archived)

Bulk Transaction journal is not printing

(0) Share

Report

Posted on by Muhammad Moin Mubeen

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

All responses (8)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Bulk Transaction journal is not printing

thanks.. my issue also resolve by it. thanks again
Denis Macchinetti 16,444 on at

Like (0)

Report

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 120 on at

Like (0)

Report

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 16,444 on at

Like (0)

Report

RE: Bulk Transaction journal is not printing

Your welcome

Have a nice day
Muhammad Moin Mubeen 520 on at

Like (0)

Report

RE: Bulk Transaction journal is not printing

Thanks Denis it's solved.

Thanks & Best Regards,

Moin
Verified answer

Denis Macchinetti 16,444 on at

Like (1)

Report

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.
Muhammad Moin Mubeen 520 on at

Like (0)

Report

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 16,444 on at

Like (0)

Report

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.