Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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


↑ Back to the top

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. 

↑ Back to the top

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


↑ Back to the top

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. 

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2669725
Revision : 1
Created on : 1/7/2017
Published on : 2/10/2012
Exists online : False
Views : 144