AUTOMATIC UPDATE OF DAILY TRANSACTION REGISTER
A security event has been added to Role Maintenance that allows you to automatically update the Daily Transaction Register. For any series of journal and register updates that concludes with the Daily Transaction Register, you will not receive a prompt to print and update the register if the security event check box is selected for your role. The Daily Transaction Register will be printed and updated automatically. The security event has been added for the following modules:
- Accounts Payable
- Accounts Receivable
- Bank Reconciliation
- Bill of Materials
- Inventory Management
- Job Cost
- Purchase Order
- Sales Order
- Work Order
AUTO-COMPLETE FOR ACCOUNT NUMBERS
The auto-complete feature has been added for general ledger account number fields. You can now search for an account by entering any of the following in an account number field: l Account number l Main account l Account description l Account group As you type, a list of accounts matching your entry appears, and you can select one from the list. This feature is automatically enabled for all users. You can disable the feature for individual users in Library Master > User Maintenance. To enable this feature, run the Build Search Index utility on the Library Master Utilities menu to create an index. As you add accounts, you’ll need to run the utility again to index the new records.
WARNING MESSAGE FOR DOCUMENT DATES
A Use Document Date Warning check box has been added to the Preferences tab in Company Maintenance. After selecting this check box, you can enter a value in one or both of the following fields:
Document Date – Prior Periods to Allow Outside of Current Period
Document Date – Future Periods to Allow Outside of Current Period
These values are compared to the current period entered in the module’s Options task to determine when a date falls outside of the valid date range. Alternately, in Bill of Materials, Inventory Management, Purchase Order, Return Merchandise, and Sales Order, the values are compared to the current calendar month and year if Calendar Months is selected in the Base Inventory Periods On field in Inventory Management Options.
If you start to create a document with a date that falls outside of the valid range, you’ll receive one of two messages:
If you’re using the default date for that session, a warning message appears, and you can click OK to continue.
If you manually enter the date, a warning message asks if you want to proceed. If you click Yes with the date entered, a record is written to the Activity Log. If you import records with a document date falling outside of the specified range through Visual Integrator, a warning is written to the Import Log. Document dates are checked in the following tasks:
- Bank Reconciliation
Reconcile Bank
Check Deposit and Adjustment Entry - Bill of Materials
Disassembly Entry
Production Entry - Accounts Payable
Invoice Data Entry
Repetitive Invoice Selection
Manual Check and Payment Entry - Accounts Receivable
Invoice Data Entry
Cash Receipts Deposit
Repetitive Invoice Selection - Inventory Management
Transaction Entry - Job Cost
Job Billing Selection - Purchase Order
Material Requisition Issue Entry
Purchase Order Entry
Receipt of Goods
Receipt of Invoice Entry
Return of Goods - Return Merchandise Authorization
Generate Transactions
RMA Entry
Receipts Entry - Sales Order
Sales Order Entry
Invoice Data Entry
ACCOUNTS PAYABLE
Ability to Set Default Expense Distribution Table
An Expense Distribution Table field has been added to the Additional tab in Vendor Maintenance. You can select a distribution table in this field, and it is then used as the default selection in Invoice Data Entry, Repetitive Invoice Entry, and Manual Check and Payment Entry. The default selection can be changed if needed. Also, you can enter a new code in Vendor Maintenance to create an expense distribution table on the fly.
JOB COST
Department Access for Time Track Selection
When departments are set up in the Payroll module, you no longer need access to all departments to run Time Track Selection. You can select all records associated with the departments to which you have access.
LIBRARY MASTER
E-mail Reports Printed Using Task Scheduler
If you’re using the Paperless Office module, you can e-mail reports printed through a Task Scheduler job. Enter the recipient’s e-mail address in the E-Mail address field which is available if Paperless Office is selected in the Printer field. You can enter multiple e-mail addresses separated by semicolons.
SALES ORDER
Add Tracking Number to Email Messages
In Electronic Delivery Message Maintenance, when you’re creating a message for a Sales Order invoice, you can add the tracking number to the subject or the body of the message. To add the tracking number, insert the new TrackingNo merge field. If you add the tracking number to the subject, they are displayed in plain text and multiple tracking numbers are separated by commas. In the body of the message, the tracking numbers are links that the recipient can click to track the shipment.
PAPERLESS OFFICE
Cc And Bcc Options For E-Mail Address
You can now specify whether the e-mail addresses used when e-mailing documents are added to the To, Cc, or Bcc field when e-mails are sent. In the locations listed below, a Recipient field has been added; use this field to select To, Cc, or Bcc. l Paperless Office Delivery Options (accessed from Customer Maintenance and Vendor Maintenance) l Electronic Delivery (accessed from the customer, employee, and vendor viewers) l Paperless Office Selection (accessed from all reports supported by Paperless Office) What’s New in Sage 100 2019 Page 16 Purchase Order When converting data, To is automatically selected in the Recipient field for the existing e-mail addresses. In the Paperless Office Delivery Options window accessed through Employee Maintenance, the E-Mail Address field has been relabeled as the To field, and Cc and Bcc fields have been added. When converting data, existing e-mail addresses are added to the To field. E-mail addresses entered in the Cc and Bcc fields are included in the customer, employee, and vendor listings if the option to print Paperless Office delivery options is selected.
Additional Attachments When Emailing Forms
In the Electronic Delivery for Forms window, you can now select additional attachments to include when emailing forms. You can select multiple attachments, and there is no restriction on the file type.
Option to Copy Salespeople When E-mailing Forms
A Paperless button has been added in Salesperson Maintenance. Click this button to open the Electronic Delivery Options window and specify whether the salesperson will receive a copy of orders, invoices, and statements when they are e-mailed to customers from data entry, inquiry, and history tasks
For more details, see What’s New in Sage 100 2019.