Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 206
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???
  • JJDunaid Profile Picture
    JJDunaid 206 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 206 on at
    Error while opening the Trial Balance form in AX2012.
    Judy any suggestions?
  • JJDunaid Profile Picture
    JJDunaid 206 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:

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans