JobBOSS ACH Vendor Payment Utility Version Log
Displays the version change notes for the ACH starting with 3.0.0
3.0.1 (2018-08-01):
— Added “client.ServerCertificateValidationCallback = Nothing” to cEmail to allow MailKit to work with hosted Exchange Servers with self-certificates
— Added code in cEmail to set MailKit.Security.SecureSocketOptions.None when user does not check the “Use SSL” box
— Modify cPayment to correctly update Cost table for Bank Account when posting payments
— Fix updater to properly reference web-based update file
3.0.2 (2018-08-02)
— Fix bug for failure to load Help file
3.0.3 (2018-08-03)
— No changes to code base – versioning to account for fix in the deployment mechanism to avoid removal of license key during updates
3.0.4 (2018-08-20)
— Remove Customer Name from cACH.Init_File and cACH.Init_File_CA. We are no longer storing the Customer Name in the Registry. It is stored directly in the license now.
— Add upgrade coding to fMain.Load to modify/add database tables for users moving from 2.0 to 3.0
— Modify tab order on db login page
— Added ACH30Upgrade resource for database modifications to 3.0
3.0.5 (2018-08-22)
— Design modification to db login form: added anchoring to all controls to accommodate different display resolutions
— Code fix: Fix filtering on Vendor Payments to recognize Start and End dates
— Code fix: Modify cACH to properly add Payment Date
— Modify ACH Table Build to use DateTime instead of Date
3.0.6 (2018-09-13)
— Code fix: Modify cACH to format Payment Date correctly
— Modify Remittance Report to break between vendors
3.0.7 (2018-09-20)
— Modify Remittance Report to remove sum for Check
— Modify ucVendors to properly store Contacts when user selects
3.0.8 (2018-10-02)
— Fix code on ACH Message to correctly point to ACH Folder
3.0.9
— Add: Database modification to include RBC column in ACH_Banks
— Add: Header line to Canadian ACH Documents for Royal Bank requirements
3.0.10 (2018-11-06)
— Modify Bank Save routine to include IsRBC
3.0.11(2018-11-08)
— Modify licensing to use same license code for all
3.0.12(2018-11-08)
— Modify Payment module to ignore Hold invoices
03.0.13(2018-11-09)
— Modify utility to report on stored Jobboss Customer name instead of name embedded in license
03.0.14 (2018-11-14)
— Modify Refresh Invoices code to correctly handle Hold status
03.0.15 (2018-12-01)
— Modify error messages for update failure, remove second notif when no updates are available
— Fix code when loading Vendor Contacts to correctly select contacts
03.0.16 (2018-12-08)
— Rework validation routine for Vendor form to allow users to type in Vendor name
— Add validation routine to cVendor to ensure valid data is added to the system
— Modify code in ucVendors to properly store user Contact selections
— Fix vendor combo to allow users to type in values
03.0.17 (2018-12-10)
— Fix code issue with Vendor Validation – validate on JBVendor, not Vendor
03.0.18 (2018-12-13)
— Add more compliant PreNote functionality to system
— Add Prenote Amount and Prenote Code to Bank section, and modify underlying data structures and such to accommodate
— Modify Database Modification routine to try the default credentials first, which will make mods transparent to the user.
03.0.19 (2019-1-18)
— Modify Email Template handling – store in the database so users can have different templates for each Jobboss database
— Fix email save code to correctly save Email Subject to database
— Fix code in ucPayments to pass filtered datatable to CheckInvoicesDate
03.0.20 (2019-1-26)
— Add logging to output datatables for remittance and payment reports, and for emails. Only for ADMINISTRATOR user
— Changed location of smtp_errlog to Roaming data in user profile
— Add code to show email password when logging in as Administrator
03.0.21 (2109-1-31)
03.0.22 (2109-1-31)
03.0.23 (2109-1-31)
— Code fix in cVendor, cVendorEmails, ucACH, and ucPayments – fix code in SQL statements to correctly delimit names like O’Hare
03.0.24 (2019-2-5)
— Code fix in remittance report: Add Vendor and APDocCheck filter in uchReports.PrintRemittanceReport to allow identically named invoices for different vendors
— Code fix in Vendor Emails: Add Vendor and APDocCheck Filter in cVendorEmails.SendVendor Emails to allow identically named invoices for different vendors
03.0.25 (2019-4-6)
— Add 80-byte format for Canadian customers
— Add EFT dropdown to Banks form
— Add database modification to add CA80 rows to ACH Matrix
— Modify cBanks to include new EFTFormat property
03.0.26 (2019-05-05)
— Modify database login form to remove sa credentials
— Modify Help File to remove sa credentials
— Modify online Install Help file to remove sa credentials
03.0.27 (2019-05-28)
— Add ability to reset File Creation Number for Canadian installations
— Refactor cACH.Init_CA to clean up code handling Destination Data Center for Canadian installations
03.0.28 (2019-05-29)
— Add ability to output 1464 byte documents with Credit or Debit transaction formatting
— Modify Help file to include information about recent changes
03.0.29 (2019-05-30)
— Modify ACH routine to use D for 1464 file if user selects Format Output as Debit, and C for Format Output as Credit
— Update usr_ACH_Matrix to remove default for Record Type Code for C block in 1464 documents
— Add wait cursor when creating Bank Validation File
— Add automatic casing to force logins to upper case for more consistent validation
3.1.00 (2109-06-10)
— Added ISO 20022 formatting
— Modify bank page to show ACH/EFT Format for all customers
3.1.01 (2019-06-28)
— Add ISO 20022 output for Bank Validation file creation
— Add ISO 20022 alert when saving vendor with missing Bank Name, Country, or ID Number if one or more Banks use that format
— Add ISO 20022 alert when saving bank to alert user that one or more Vendors have missing Bank Name, Country, or ID Number
— Add Sender ID and ACH ID as Bank attributes
3.1.02 (2019-06-28)
— Version bump to get installer back in sync
3.1.03 (2019-07-10)
— Add error code for IAT transactions
3.1.04 (2019-07-26)
— Fix: Add checks to ACH Log table when using ISO 20022 format
— Fix: Remove preceding “1” from ACH ID field when creating ISO 20022 format
3.1.05 (2019-10-09)
— Modify error messages on Payment report to be more descriptive
— Add mask to Check Number field on Vendor payments to allow 9 numeric values only – avoids overflow error when trying to process checks.
— Modify licensing form to not show license key, reformat to show only OK button, and to not store license key.
— Modify licensing process to require user to uninstall app to apply new license.
— Modify email process to connect to email provider one time, instead of each time a message is sent.
— Modify ACH Document grid to detect when a Vendor does not have an email option associated. Colors line in Yellow if so.
3.1.06 (2019-10-24)
— Modify code to properly show Vendor Contacts when Vendor code includes single quote
— Added new columns to accommodate Integrated Payments to ACH_Vendors and ACH_Banks tables
3.1.07 (2019-11-05)
— Modify code in several places to handle single quote in vendor name
3.1.08 (2019-12-12)
— Fix misspellings on user messages in mDatabaseMods
— Added CA80 lines to Jobboss_ACH_Matrix
— Added code to insert CA80 lines to usr_ACH_Matix for existing installs
3.1.09
— Add additional error handling to cVendorEmails and ucACH.SendVendorEmails
— Added Support section the ACH 3.0 Help file
— Fix SQL error in Create Table routine
3.1.10
— Added additional logging features for email connect/send errors
— Added more robust error logging for email connect/send errors
— Move formatting code to Load event to Payments form
— Fix issue where selecting all Invoices does not force update of Totals item in main ribbon
— Add ability to auto-populate invoices to Other Setup
— Remove close button on dock panels for Payments and ACH
— Fix issue where preceding space in Contact Email address resulted in invalid email address
3.1.102
— Add Company ID to Bank setup to allow for 3rd party processors
— Modify 5 lines (Batch Header) to use Company ID instead of TaxID
3.1.103
— Modify 8 lines (Batch Control) to use Company ID instead of TaxID
3.1.104 (2020-07-02)
— Modify Bank Create Test file to address issue with invalid Batch Footer amount
— Modify Canadian to use 0001 instead of 0000 for Test File
3.1.105
— Fix issue in ucPayment where blank Discount caused error – defaulted to 2000-01-01 for blank/null Discount Dates
— Fix issue on ucPayment re: Invoice Total not properly updating for Deselect All
— Fix issue on ucPayment re: Reset Invoice Total to 0 when refresh
3.1.106
— Fix issue with Payment and ACH Batch re: Duplicate Number triggers error
— Fix issue on Payment screen: rename batch button to read “Create Payment Batch”
— Add ability to set Account Type for Vendor, which sets the Transaction Code for the “6” lines
— Add code to add Account_Type column to ACH_Vendors table
— Added 2 new Tokens to email body: Our Vendor Acct and Vendor Bank Acct #
— Allow all tokens in Subject line of email.
3.1.107
— Fix issue with Vendor – Account Type not allowing edit
3.1.108
— Fix issue with Vendor – Account Type not saving between edits
3.1.109
— Fix issue on Payment Report – Invoice Date column was incorrectly set to Discount Date
— Set Vendor information to be all Upper Case when entering
3.1.110
— Fix issue where contacts were not showing when adding new Vendor
— Fix issue with “No Account Type” when adding new vendor
3.1.111
— Fix issue with Vendor – Format_ID not added to Vendor Tables in 3.1.110
3.1.112
— Fix issue with Vendor – Bank_ID not added to Vendor Tables in 3.1.110
3.1.114
— Fix issue with Vendor – ensure all columns are added to tables from 3.1.110
3.1.115
— Fix issue with Vendor – Account_Type was not populated, added code to fMain.Load to set any rows with NULL values to “Checking”
3.1.116
— Added class to match schema to existing – requires a recreate of ACHSchema.XML when changes are made.
— Modify ACHTableBuild.txt to include all new columns
— Removed db mods in fMain.Shown – the schema check should take care of all those items now
— Added Auto Populate ACH to Other Setup page
— Modify mACHFunctions.LoadVendor to remove dtNew datatable – no longer needed
— Remove Vendor ID Number from vendor list on ucVendors (in mACHFunctions.LoadVendor)
3.1.117
— Fix issue with setting Open_Amt_Curr_Per if paying in a period other than the current AP period (cPayment class)
3.1.118
— Revert removal of db mods in fMain – need more work on this
3.1.119
— Fix creation of table via Schema – if table was missing, the system wouldn’t add the table
3.1.120
— Modify ACH page to show checks drawn on banks setup for ACH only
— Modify ACH routine to correctly create Canadian ACH documents with single penny transactions
3.1.121
— no mods
3.1.122
— Modify ACH routine to use BankLegalName for Record 1, Immediate Destination Name
3.1.123
— Add Starting Check Number to Bank
— Modify Payments screen to default to bank’s Starting Check Number if available
— Modify ACH Processing screen to only show checks created through the ACH Utility
3.1.124
— Skip version to line up with install build processes
3.1.125
— Modify File Creation Number process – allow user to edit File Creation Number to line up with banking requirements
3.1.126
— Add ability to use the same check number when creating payments
3.1.127
— Fix issue with setting Open_Amt_Curr_Period when paying outside of the current A/P period
3.1.128
— Fix issue with setting Open_Amt_Curr_Period – using Payment Date to determine if payment is made IN or BEFORE the current AP Period
If so, we set the OACP to 0, otherwise it’s set to the invoice amoutn.
3.1.129
— Fix for setting OACP, cPayment appx line 280+
3.1.130
— Fix for loading AP Document – Document Date was NOT being properly loaded, added several other fields to Load routine
3.1.131
— Remove tag line on email
— Refactor code that creates Vendor Payments – remove duplicated loops
— Refactor code in basGlobals – remove unused routines, clean up dead code
— Refactor code that validates Vendor Payments – ensure proper currency codes are being used when creating Payments
3.1.132
–Fix issue where ACH Processing did not show Cleared checked when box was checked.
3.1.133, 133
— Version change only to resolve issue with website – no code changes
3.1.135
— Fix issue where users were not able to change the User Type
3.1.136
— Add sorting to Vendor Emails
3.1.137
— Add Trim to cEmail.SendEmail
— Add Vendor Name to Payments
— Add Vendor Name to report
3.1.138
— Fix code in cBank – found one instance where no CurrencyDef was present for bank, default to BaseCurrency
— Fix code in cFinPrefs – added Else statements to return False if no data found
3.1.139
— Add Discount Totals to reports
— Add ability to persist Create ACH checkbox value between sessions
— Add ability to auto-add days to the ACH Date
— Add customization of ACH formats for each bank
— Add ability to see Vendor Name or Vendor Code on reports
3.1.140
— Fix issue where partial payment not accurately displayed on Emails and in AP_Doc_Check
— Add ability to set colors for Vendor Payments grid
— Rework Other Setup page to add tabs to separate the Setup sections for more room
— Add option to use Jobboss Check Number or ACH Check Numbers
— Modify New Database install message to more clearly inform the user of the correct credentials to use
— Remove date range limiters for ACH Processing Date
— Remove side panel for ACH and Payment batches and add new user controls for better usability
— Add ACH Totals item to main ACH ribbon\
3.2.2
— Update build numbers – 3 previous versions were released in 3.2.2
— Fix to release – failed to add Use_Jobboss_Next_Check_Number to ACH_Banks table
3.2.3
— Add Collapse method to batch windows for ACH and Payment
— Fix issue with invalid ACH and Batch Totals
— Fix issue with email totals not reflecting actual payments
— Fix issue with discounted Vendor Payments
— Add Invoices panel to ACH tab
3.2.4
— Fix ACH Total – Discount already in place, should only total Check Amount
— Fix Banks – Add Use Next Jobboss# when saving a new bank
— Fix Payments Layout – Show Discount Amt (formatted)
— Fix issue with Always Take Discounts not working correctly
3.2.5
— Auto check Show Open if neither Show Open or Show Closed is checked (new installations)
— Fix issue with Always Take Discounts when loading a Batch
— Fix issue with creating new Bank
— Fix issue with cEntrypt when passing in blank string
3.2.6
— Fix issue in email code – remove capabilities
3.2.7
— Fix issue with error when creating payments
3.2.7
— Fix issue with EFT 80 byte format – incorrectly calling into 1464 for custom formatting on header
3.2.8
— Add Company Discretionary Data field to Bank and to ACH file – JP Morgan Chase Requirement
3.2.9
— Fix issue with IAT where routing numbers less than 9 digits caused error (Record Type 6)
— Fix issue where Vendor ID was not populating correctly when entered in Vendor tab and in ACH document
3.2.10
— Fix issue where Vendor ID was not being inserted into correct segment on ACH
— Modify ACH Data grid to show unprocessed with black forecolor
3.2.11
— Fix issue with Vendor International Banking info not saving properly up when using International Payments
3.2.12
— Add ability to exclude/include ID Number on “6” line
3.2.13
— Fix issue where Cleared checks are not showing up in ACH Processing when option is checked
3.2.14
— Fix issue with Cleared Checked – remove STATUS IN (‘Open’,’Cleared’) from WHERE Clause, and require
user to check either Show Cleared or Show Open before filtering
3.2.15
— Add validation to ensure user enters Offset Value when selecting Balanced File
— Modify fMain Load routine to ensure a value exists in EFT_Format
— Add code to add EFT_Format if one is missing, based on the Base Currency of the Jobboss account
— Modify CreateACH routine to use the EFT Format defined for the Bank when creating EFT documents
— Add ability for user to define file extension used for ACH documents (defaults to .txt)
— Modify initial table build scripts to include recent database modifications
— Add ability to store layouts for ACH and Invoice grids
— Add check to ensure calculated Batch Total is same as computed total
— Add functionality to allow for Batch Approval
3.2.16
— Fix issue with Batch Total calculation
3.2.17
— Add settings for Jobboss Connection and Database Login – only allow Admins to view/edit
3.2.18
— Fix for converting Vendor Payment amounts when using a bank with Trade Currency different from the Base Currency
Base Currency is used when posting the Invoice, so a US based Vendor Invoice posted in a database with a
Base Currency of CDN would be converted. If that payment is then made through a US-based bank, the Amount
must be converted back to USD.
3.2.19
— Added Admin Setup shortcut for use when requirements do not allow stanard database connections
3.2.20
— Add option to include Settlement Date (on Bank tab)
— Fix issue with Vendor Emails not showing correct amount when including converted invoice amounts
3.2.21
— Mods for Windows Authentication
3.2.22
— Fix for users not being created with Windows Authentication
3.2.23
— Modify Bank page to show information on two tabs – one for bank, the other for formatting
— Add options to allow USD payments from RBC – remove routing number, allow for different currency codes, etc
3.2.24
— Add Vendor name to IAT 7-15
3.2.25
— Fix issue with Discounts not showing correctly when item is edited in Jobboss (Vendor Check Edit)
— Fix issue with currency values in reports when paid with different currency
— Fix issue with Check Number not properly validating when creating payments
3.2.26
— Add Return Account and Transit Number to Banks
— Add Return Transit and Account Numbers to various formats (1464, 94 byte, etc)
— Add Show Vendor Banking Information – includes Account and Routing numbers when exporting Vendors
3.2.27
— Modify login process – create the Jobboss Connection string and store as a public variable,
and provide methods to use Standard, Trusted, and User-Entered credentials.
Connection info is stored in a User Setting between sessions.
3.2.28
— Update copyright info
3.2.29
— Upgrade to DevExpress 22
— Fix issue with rRemittance Report (change BeforePrint handler, added Imports statement)
— Add CIBC Setup info
— Fix issue with Discounts
— Fix issue with 0 dollar Invoices showing in Vendor Payments
— Add ability to show only ACH Checks in ACH Processing
3.2.30
— Added columns to ACH_Matrix for CIBC Setup Info
3.2.31
— Fixed issue when creating CIBC file – added DateStamp and Random number to ensure uniqueness
3.2.32
— Fixed issue where renaming bank in Jobboss – unable to remove the bank if needed, changed to look for ID not Name
3.2.33
— Added fix to CA1464 to include Vendor ID if filled in on C lines
3.2.34
— Fix issue with BeforePrintEvent for Payment Report
3.2.35
— Upgrade Mailkit and other references to latest version
3.2.36
— Add new Discount handling process – allow user to user JB Method, Always Take, and Never Take
— Modify payment page to retain user selections between refreshes on certain actions
— Modify connection process in fMain to recognize change of databases
3.2.37
— Added MailBEE to handle email processing
3.2.38
— Resolved issue with JBConnectionString – removed insert to ACH_Settings table, on first use those
tables were not yet created so the connection validation failed
3.2.39
— Modify ucPayments to compare bank currencydef to apdoc currencydef instead of financial preferences currencydef
— Add check for Currency_Rate table to insure valid values
3.2.40
— Add CC to Mailbee email send
— Add “Show ACH Only” for the ACH Processing tab – allows users to toggle the display to ONLY show checks created in the ACH utility
3.2.41
— Fix issue with IAT and Bank Validation Files not balancing correctly
3.2.42
— Modify User section to disable and hide Password for all non-Admin users
— Modify login to hide Email setup for ReadOnly users
— Modify cUser to actually delete users instead of making them inactive. User can still set Status to Inactive
— Fix issue where TSL/SSL setting was not being saved and retrieved correctly
3.2.43
— Add ability to include GL Code on Remittance Report
— Fix issue with Show Vendor Name on Reports
3.2.44
— Fix issue with <ach_amt> in Send Vendor Emails – was dropping the cents off <ach_amt>
3.2.45
— Fix issue with email – showing a messagebox after each email
— Removed code that set port to 25 if no login is required
— Added call to get Jobboss Vendor information when adding a new vendor
3.2.46
— Added option to remove highlighting from Payments and ACH grids
3.2.47
— Modify Bank dropdowns on Vendor Payment and ACH screen to hide Inactive banks
3.2.48
— Modify Remittance Report to hide Discount when user selects Never Take Discounts in the Payments section
— Fix Check Number issue – change to allow 10 digits
3.2.49
— Fix Next Check Number on Bank tab – only allowed 9 characters (up to 999999999), changed to allow 10 digits
— Changes to My.Settings are persisted in the RDS system at Users\UserName\AppData\Local\ECI_Solutions_LLC\ACH30.exe.xxxxxx|
in a user.config file
3.2.50
— Fix issue – ACH Processing – 0 or Negative value line forces error. Change to check and alert user
— Fix issue with achupdater.ini – found that URL had to be in the correct case in order for the system to locate the updates.
3.2.51
— Version bump to ensure that .ini file for updater is included