Error message "Divide by zero" when you print a General Ledger Trial Balance detail report in Microsoft Dynamics GP

Applies to: Dynamics GP 2010Dynamics GP 2013Microsoft Dynamics GP 2015

SYMPTOMS


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.
or
[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

CAUSE


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.

RESOLUTION


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