Skip to content
logo Knowledgebase

Unable to change Bank Codes for custom Form Code in Accounts Payable Check and Electronic Payment Processing in Sage 100 2020

Created on  | Last modified on 

Summary

Unable to change Bank Code for custom Form Codes in Accounts Payable Check and Electronic Payment Processing in Sage 100 2020 Unable to change Bank Code for custom Form Codes in Sage 100 2020

Description

Possible Workaround:

  1. Open Library Master, Utilities, Data File Display and Maintenance and click OK the the Warning message
  2. Open the table ..\MAS90\MAS_System\SY_ReportOption.M4T
  3. Click the Key Scan lookup and select the record with the desired AP Check Form
  4. Click Edit
  5. Double-click in OptionString$ Value and change ML_BANKCODE$ to the desired Bank Code and click Update
    • Note: Bank Description can also be changed if desired
  6. Close Data File Display and Maintenance and the desired Bank Code will display when selecting the Check Form Code

Another option: This will work if only using one form code and preprinted checks. Make changes to the STANDARD form code which can be used for any bank code.

Cause

  • Bank Code for form is stored in ..\MAS90\MAS_System\SY_ReportOption.M4T

Resolution

  • Fixed on AP6000T for Sage 100 2020.1
  • Will also be released with Sage 100 2020.2

Program fix released on versions 2021.0 and 2020.2

DocLink: Unable to change Bank Code in Accounts Payable Check and Electronic Payment Processing after checks have already been printed in Sage 100 2020

Defect ID

112247 & 112363

Steps to duplicate

Steps to Duplicate (ABC Demo Company) 1. Open Account Payable, Check Printing and Electronic Payment, Invoice Payment Selection 2. Select 'Clear' if applicable 3. Click 'Cancel' 4. Open Account Payable, Check Printing and Electronic Payment, Check and Electronic Payment Processing NOTE: If prompted select 'Checks' then click OK 5. Change 'Bank Code' to 'B' 6. Type 'NEWFORM' in Form Code field 7. Press Tab on you keyboard 8. Select Plain Report Template then click 'OK' 9. Click Preview. Click 'OK' at warning message 10. Click 'OK' to 'Data is not selected for reporting' NOTE: the issue occurs whether there's data selected for printing or not 11. Change the Bank Code to 'A' 12. Change the Form Code to 'NEWFORM' 13. Notice how the Bank Code changes to 'B', which is the initial Form Code used with this form. NOTE: There are no Bank Codes with Default Form codes linked to them in Bank Code Maintenance