What's new in Sage 100 2017 - Accts. Receivable, Bank Reconciliation, CRM and more

Ready for more new features available in Sage 100 2017?

Last week I provided a list of general updates in the latest version of Sage 100. This week, I'm taking a look at the Accounts Receivable and Bank Reconciliation module updates, as well as updates to CRM, General Ledger, and more.

Accounts Receivable

Ability to Accept ACH Payments

You can now enter ACH payments in the following tasks:

      • A/R Invoice Data Entry
      • Cash Receipts Entry
      • Repetitive Invoice Entry

To enable this feature, you must have a Sage Payment Solutions account that is set up for ACH payments. You can then enable the feature on the Payments tab in Company Maintenance and set up ACH payment types in Payment Type Maintenance.

To accommodate this feature, some tasks, fields, and tabs have been renamed to reference "payments" instead of "credit cards." Details are in the following sections.

ACH Payment Processing

ACH payments are submitted to Sage Payment Solutions as part of the Cash Receipts Journal and A/R Sales Journal update process. They cannot be processed individually. 

Data Entry Tasks

The following changes were made in the data entry tasks.

      • The Credit Card tab has been renamed; it is now the Payment tab. Fields related to ACH payments have been added, and the Payment ID field has replaced the Card ID field.
      • On the Payment tab, the Fix button is available based on the Allow to Override ACH Payment Transaction security event in Role Maintenance.
      • ACH payment related fields have been added to the Cash Receipts Deposit window and the Cash Receipts Entry Header tab.

Maintenance Tasks

The following changes were made in maintenance tasks:

      • In Payment Type Maintenance, you can now select ACH Payment as the payment method.
      • On the Customer Maintenance Additional tab, the Payment ID field has replaced the Card ID field. ACH payment-related fields have been added.
      • On the Customer Maintenance Invoices and Transactions tabs, ACH payments now appear in the secondary grid.
      • The Customer Credit Card Maintenance window has been renamed Customer Credit Card and ACH Payment Maintenance. ACH payment-related fields have been added to the window.
      • In Invoice History Inquiry, an ACH account field displays the last four digits of the ACH payment bank account for invoices with ACH payments. A Payment Information button has replaced the Credit Card Information button. The button opens the new Payment Information window to view additional details about the payment.

Reports and Listings

The following changes were made in reports and listings:

      • The option to print customers’ ACH payment information has been added to the Customer Listing task window. The last four digits of the bank account appear on the listing.
      • On the Deposit Transaction Report, the last four digits of the bank account appear for ACH payments in the renamed Credit Card/ACH/Reference/Check Number column.
      • The Credit Card Settlement Report has been renamed Credit Card and ACH Settlement Report. ACH payments are included on the report.

Changing Transaction Information

A new security event, Allow to Override ACH Payment Transactions, has been added. This security event enables the Fix button on the Payments tab in A/R Invoice Data Entry and Cash Receipts Entry, which lets users update ACH payment transaction information.

Bank Reconciliation

Option to Keep Bank Reconciliation Report Window Open

The following check boxes have been added to the Bank Reconciliation Report task window:

      • Keep Window Open After Print
      • Keep Window Open After Preview

Note that the task window will automatically close when updating the report, even if the check boxes are selected.

Improved Export to Excel for Reports

When exporting Bank Reconciliation reports to Microsoft Excel, the resulting Excel file is easier to view and manipulate.

      • The minimum font size is 8 points.
      • Empty columns and rows are minimized.

Customer Relationship Management

Sage CRM 7.3 SP3 is now included with Sage 100. For information on what’s new in this version, see Sage CRM 7.3 SP3 Release Notes. This document is available in the Documentation folder within the Sage CRM installation program.

To access this guide, click the Documentation link on the Autorun screen that appears when you start the Sage CRM installation program.

General Ledger

Improved Export to Excel for Financial Reports

When exporting financial reports to Microsoft Excel, the resulting Excel file is easier to view and manipulate.

      • The minimum font size is 8 points.
      • Empty columns and rows are minimized.

Library Master

Search Added to Role Maintenance

After selecting a role in Role Maintenance, you can click the Search button and enter search criteria. A list of matching tasks, security events, and module options appears, and you can select one to go to its location on the applicable tab.

Company Maintenance Changes for ACH Payments

The following changes were made to support the ACH payment processing feature.

      • The Credit Card tab has been replaced with the Payment tab.
      • The Enable Credit Card Processing check box has been replaced with the Enable Payments field. You can select whether to accept credit cards, ACH payments, both payment types, or neither option.

Sales Order

Ability to Accept ACH Payments

You can now enter ACH payments in the following tasks:

      • Sales Order Entry
      • S/O Invoice Data Entry

To enable this feature, you must have a Sage Payment Solutions account that is set up for ACH payments. You can then enable the feature on the Payments tab in Company Maintenance and set up ACH payment types in Payment Type Maintenance.

To accommodate this feature, the following changes were made in the data entry tasks:

      • The Credit Card tab has been renamed; it is now the Payment tab. Fields related to ACH payments have been added, and the Payment ID field has replaced the Card ID field.
      • On the Payment tab in Invoice Data Entry, the Fix button is available based on the Allow to Override ACH Payment Transaction security event in Role Maintenance.

ACH Payment Processing

ACH payments are submitted to Sage Payment Solutions as part of the Sales Journal update process. They cannot be processed individually.

Anonymous