Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Error while opening th...
Microsoft Dynamics AX forum
Suggested answer

Error while opening the Trial Balance form in AX2012.

(1) ShareShare
ReportReport
Posted on by JJDunaid 204
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???
Categories:
Development / Customization / SDK
  • JJDunaid Profile Picture
    JJDunaid 204 on at
    Error while opening the Trial Balance form in AX2012.
     Martin Dráb Sir, can you share your views on this?
  • JJDunaid Profile Picture
    JJDunaid 204 on at
    Error while opening the Trial Balance form in AX2012.
    Judy any suggestions?
  • JJDunaid Profile Picture
    JJDunaid 204 on at
    Error while opening the Trial Balance form in AX2012.
    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?
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Error while opening the Trial Balance form in AX2012.
    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:

Helpful resources

Quick Links

First Dynamics 365 Community Call (CRM Edition)

Don't miss the first D365 Community Call on 7/10!

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 285,407 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,446 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans