Error Running Trial Balance Report at AX2012

There are cases where System shown an error message while running the trail balance Report

Error Message as given below:

Cannot edit a record in Trial balance (LedgerTrialBalanceTmp). The SQL database has issued an error.

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

SQL statement: UPDATE T1 SET TEXT=((T1.TEXT+?)+T5.DESCRIPTION),RECVERSION=? FROM tempdb.”DBO”.t18016_D2DF6844079AF699F82413 T1 CROSS JOIN GENERALJOURNALENTRY T2

solution for the above issue :

After analyzing the Code by debugging the issue, we found that the issue was due to inappropriate length of TEXT field in LedgerTrialBalanceTmp table

change the EDT Type of TEST field from Description to Str1260,compile and run the report

Similar type of errors can be seen in other reports too



style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

Posts per category

AX Blog

AX Error

AX Training Manual

Download

Management Reporter

Posting Definition

Uncategorized