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

Article ID: 2669725 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

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.

EXCEPTION_CLASS_SCRIPT_DIVIDE_BY_ZERO

SCRIPT_CMD_MOD


CAUSE

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. 

RESOLUTION

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. 


MORE INFORMATION

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

Properties

Article ID: 2669725 - Last Review: February 10, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0, when used with:
    • Payables Management
    • Payables Management
    • Electronic Funds Transfer for Payables Management
Keywords: 
kbmbsmigrate kbsurveynew KB2669725

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com