You are currently offline, waiting for your internet to reconnect

Your browser is out-of-date

You need to update your browser to use the site.

Update to the latest version of Internet Explorer

Error message when you generate an EFT file for Payables Management in Microsoft Dynamics GP: "EXCEPTION_CLASS_SCRIPT_DIVIDE_BY_ZERO"

When you generate the Payables Management EFT file, you receive the following error message. The EFT file still generates, however the batch remains in the Generate EFT Files window.

Unhandled script exception:

Division by zero, script aborted.



This message is caused by having the Add Pad Blocks check box marked in the EFT File Format Maintenance window but one of the supporting lines for Number of Pad Chars or Pad Lines in Multiple Of  has a value of '0'. The system is unable to calculate how to pad the rows in the file because of the 0 value. 

To resolve this problem, follow these steps: 

  1. Click Cards, point to Financial, and then click EFT File Format to open the EFT File Format Maintenace window.
  2. Select the EFT Format ID.
  3. In the EFT File Format Maintenance window, review the Add Pad Blocks section. If this check box is marked, then the three supporting lines underneath should also have a value defined in each field. Refer to the options below to resolve this problem:
    • Option 1
      If the bank does not require the file to be padded, unmark the checkbox next to Add Pad Blocks to disable this feature.
    • Option 2
      If the bank requires pad blocks to be used, refer to the bank's Requirement documentation to determine the required value to enter in the Pad Character, Number of Pad Chars, and Pad Lines in Multiple Of fields.

      As an example, consider the following scenario: The bank requires the file to be 94 characters wide, and padded with the number "9" with a block count of 10. For this specific scenario, enter the following information in these fields:

      • Pad Character: 9
      • Number of Pad Chars: 94
      • Pad Lines in Multiple of: 10
  4. To remove EFT batches that are still listed in the Generate EFT window, generate a new EFT file with those batches as usual to have the system clear them from the window.  Then delete the new EFT file that was created. Do not send the new EFT file to the bank again. 

Pad Blocks means that the bank requires the EFT output file to be rounded up to a certain number of rows so their system will accept it. So the Add Pad Blocks feature will add dummy rows to the end of the file to bring the file up to a specific rounded number of rows as required by the bank.  

For example, assume the bank requires the file to be padded in blocks of 10 rows. Below are examples of how the Pad Blocking will work:  
  • If your EFT file has 22 rows, GP will add 8 dummy row to the end of the EFT file to make it an even 30 rows.
  • If your EFT file has 29 rows, GP will add 1 dummy row to the end of the EFT file to make it an even 30 rows.
  • If your EFT file has 41 rows, GP will add 9 dummy row to the end of the EFT file to make it an even 50 rows.
  • If your EFT file already has an even 10, 20, 30, 40, 50, etc. rows, GP will not add any dummy rows to the EFT file. 
blocking padded electronic funds transfer payables PM divide by zero
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2669725 - Last Review: 02/10/2012 15:34:00 - Revision: 2.0

  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • kbmbsmigrate kbsurveynew KB2669725