When you print a General Ledger Trial Balance (TB) detailed report, you may receive the following error message in Microsoft Dynamics GP:

[Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero.
[Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered.


After you click OK , you receive another error message that is similar to the following:

The stored procedure glprinttrialbalancereport returned the following results: DBMS: 8134, Great Plains: 0


The following options may be selected for your computer that is running Microsoft SQL Server on the Connections tab in SQL Server Management Studio:

• ANSI Warnings
• Arithmetic Abort

Note These options are not selected be default.


Clear the options that are listed in the "Cause" section. To do this, follow these steps:

1.  Open SQL Server Management Studio and right-click your instance of Microsoft SQL Server in the Object Explorer section, and then select Properties .  

2.  In the Select a Page list, click the Connections tab.  

3.  Unmark (or set to False) the following two options in the Default Connections Options section: 
• ANSI Warnings 
• Arithmetic Abort 

4.  Click OK to close the window.  

5.  In Object Explorer again, expand Databases and right-click on the Company database that has the issue and select Properties .  

6.  Click the Options tab.  

7.  In the Miscellaneous section, make sure the Arithmetic Abort Enabled option is set to False .  

8.  Click OK to close the window.  

Note Examine the options for the data source that you use with GP. Make sure that the options for the data source on the computer are the same as the options that are required to create a data source for Microsoft Dynamics GP. For more information about how to create a data source for Microsoft Dynamics GP, click the following article number to view the article in the Microsoft Knowledge Base: 

870416 How to set up an ODBC Data Source on SQL Server for Microsoft Dynamics GP 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!