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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error while opening th...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Error while opening the Trial Balance form in AX2012.

(1) ShareShare
ReportReport
Posted on by JJDunaid 226
Hi everyone !
my client is facing issue when ever a user tries to open the "Trial Balance" form.
i have tried following:
Step 1 – Synchronize the SQL database
  1. Navigate to Administration module -> Periodic -> 'SQL Administration'
  2. Select the table and click table actions check/synchronize
    1. Sometimes you will not be able to determine which tables are causing the error so just do this for all
  3. Click 'Start' with the default options.
     
Step 2 – Step 1 with 'Remove unknown indexes' in the check/synchronize step
  1. Follow steps 1 and 2 from step 1
Following errors appear when user open the form:
can anyone suggest me solution???
I have the same question (0)
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Hi, for the error message, it indicates "arithmetic overflow error converting numeric to data type numeric". And the SQL statement has been raised. You can check with a developer to check if any field has reached the limit of system.
    The similar questions for the error arithmetic overflow error:
  • JJDunaid Profile Picture
    JJDunaid 226 on at
    Hi Judy, Sorry for the late reply as i was busy. So i have read your reply. we have four fields on trial balance form which are :
    1. opening balance
    2. closing balance 
    3. credit 
    4. debit
    they have EDT named "Amount Mst Long" i have increased the length to 100 and "No of decimals" to 30 as they were already 20 which was customized before.
    i have then compiled and synced. But the error is still not resolved. have i done it right ? if not can you kindly elaborate more?
  • JJDunaid Profile Picture
    JJDunaid 226 on at
    Judy any suggestions?
  • JJDunaid Profile Picture
    JJDunaid 226 on at
     Martin Dráb Sir, can you share your views 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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 802

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 636 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans