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:
- Open Library Master, Utilities, Data File Display and Maintenance and click OK the the Warning message
- Open the table ..\MAS90\MAS_System\SY_ReportOption.M4T
- Click the Key Scan lookup and select the record with the desired AP Check Form
- Click Edit
- 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
- 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
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