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">
Pages
- axsolution.com
- D365 Opening Balance Upload entity( JV Upload)
- Dynamics AX 2009 & Ax2012 Keyboard Shortcuts
- Error Running Trial Balance Report at AX2012
- How to make Site Mandatory at Sales order or Purchase Order at AX 2009 and Ax2012.
- Inventory Closing and Adjustment in AX (AXAPTA)
- Product Variants are not displayed at Purchase order in AX 2012
- Start Date of Project cannot be updated since earlier hour forecasts exist. AX2012
- Sure Step Go Live Check List for AX
- The Transaction Combination Activate item Relation table is not Activated,AX2012
- Upload Account structure in D365 through Data Management
- Workflow in AX2012
- AX 2012 Account structure Report
- Fixed Assets Creation in AX 2012
- How to Add A New Field in AX Form : AX 2009 & AX 2012
- Configuring Advanced Bank Reconciliation Bank Statement Importing
- Encumbrance & Pre- Encumbrance in AX2012
- Price Discount In AX 2009 & AX 2012
Categories
Posts per category
AX Blog
- Creation of credit Note on same Sales order which is Imvoiced, in D365
- Hours exist for project XXXXXXX posted to voucher XX/HRS/0000002 on 9/28/2016 that is not included in WIP, in AX 2012 R3
- Prepayment must be created in a journal where amount is including of sales tax, A2012
- The transaction combination Activate item relation Table is not activated, In Ax2012 R3
- Wrong tax Calculation in AX2012 R3
- Voucher DM/PINV/16/000001 is already used as of date 5/10/2016. in Ax2012
- The estimate date must be the last day of the period. Periods are maintained in the Periods form. In Ax2012
- AX2012, Worker dropdown list is black at Hour Journal Lines
- HotFix for AX2012 for project Module.
- Changing the Decimal Places to More than 2, in AX2012
AX Error
- Hours exist for project XXXXXXX posted to voucher XX/HRS/0000002 on 9/28/2016 that is not included in WIP, in AX 2012 R3
- Prepayment must be created in a journal where amount is including of sales tax, A2012
- The transaction combination Activate item relation Table is not activated, In Ax2012 R3
- Wrong tax Calculation in AX2012 R3
- Voucher DM/PINV/16/000001 is already used as of date 5/10/2016. in Ax2012
- The estimate date must be the last day of the period. Periods are maintained in the Periods form. In Ax2012
- An exchange rate cannot be found for exchange rate type Average between currencies USD and AED on exchange date . in AX 2012
- ERROR :Enter an Activity number. The require Activity number for Expense forecast is marked in Project. In AX2012
- AX2012, Worker dropdown list is black at Hour Journal Lines
- No Account Exists for account Type Cost for the project, AX2012
AX Training Manual
D365 Post
- Creation of credit Note on same Sales order which is Imvoiced, in D365
- D365 Entity for Inventory balance Upload
- How to Upload Opening Balance with Finaancial Dimension having – in value
- D365 Opening balance Entity : (JV Upload)
- Upload Account Structure in D365 Through Data management
- Uploading Item Posting profile in D365 through Data management
- Create a business unit value in D365
- difference in Item Posting profile naming from AX2012 to D365
- How to Import Data from D365 Using Data management Utility
- Export D365 Master Data Using Data management Functionlity
Download
Management Reporter
- Management Reporter (MR2012) Exchange Currency Rate Issue, AX2012
- Management Reporter for Microsoft Dynamics ERP (MR2012) known issues,AX2012
Posting Definition
- Hours exist for project XXXXXXX posted to voucher XX/HRS/0000002 on 9/28/2016 that is not included in WIP, in AX 2012 R3
- The transaction combination Activate item relation Table is not activated, In Ax2012 R3
- Posting Defination Issue : Voucher Do not balance,AX2012
Uncategorized
- Creation of credit Note on same Sales order which is Imvoiced, in D365
- Upload Account Structure in D365 Through Data management
- Create a business unit value in D365
- Azure VPC Connection
- Workflow – work item Subject in ax2012
- Online Microsoft Dynamics Learning Portal
- Encumbrance & Pre- Encumbrance in AX2012