Sage 100 version 2020.1

Released in September 2020, the Sage 100 version 2020.1 release includes several product updates that were recommended by Sage business partners.

Accounts Payable

A Net Balance button has been added to the Invoice Data Entry Lines tab, Repetitive Invoice Entry Lines tab, and the General Ledger Distribution window (accessed through Manual Check and Payment Entry). This button allows you to add your undistributed balance to the existing line.

Additionally, you can now change the Bank Code in Accounts Payable Check and Electronic Payment processing after your checks have already been printed.

Form 1099-NEC Option in Form 1099 Tax Reporting – Nonemployee Compensation has been added to the Form Type list in Form 1099 Tax Reporting.

Accounts Receivable

A Payments tab has been added to Invoice History Inquiry. It shows all the payments that have been applied to the selected invoice. You can also click the Cash Receipts History button to view the details about payments processed through Cash Receipts Entry. Additionally, you can click the Payment Information button to view details about credit card and ACH payments.

Inventory Management

Item Lot/Serial Traceability – You now have multiple options to trace where items from a particular lot or with a particular serial number have been used, including items used as bill and kit components. Note: This functionality is applicable only to transactions that you process after you’ve installed this update.

Where-Used Inquiry Window – You can click the ‘Where Used’ button which has been added to the Lot/Serial Inquiry to see where items from the current lot or with the current serial number were used as a component of a sales kit or a bill.

Customer Recall Report – The new Customer Recall Report allows you to see a list of customers to whom you have sold or shipped lot or serial items that must be recalled.

Lot Serial Transaction History Report – A Print Where-Used Items check box has been added to the Lot Serial Transaction History Report. On selection, you’ll be able to see the transactions in which lot and serial items have been used either as a standalone item or as a component of a bill or sales kit.

Fixed Assets

The checkboxes in the Period End Processing window posting book have been replaced by a grid with Book Name and Close Book columns. The Close Book column contains checkboxes that you can select for the books that you want to process for the period end.

Visual Integrator

Several changes were made to the Visual Integrator module. In this article, we’re only highlighting two updates. If you would like information about the additional updates made to this module, download the complete guide below.

ALE Lookups For Job Numbers – ALE lookups are now used when selecting jobs in the following locations:

• Export Job Selection window that opens when you start Export Job Maintenance.
• Import Job Selection window that opens when you start Import Job Maintenance.
• Copy From button and Chain To fields in Export Job Maintenance and Import Job Maintenance.
• Job Select

You can use Company Colors Used for Import and Export Jobs – In Company Maintenance, you have the option to set up company-specific background colors. These colors can be used for certain screens in Visual Integrator. Eg. You’ll see the color when you select a job and view the job log.

Learn more about Sage 100 Visual Integrator here.

Download complete guide:

‘What’s New in Sage 100 version 2020.1 ?

Get access to a complete listing of the Sage 100 2020.1 release notes here.

If you’re interested in sharing a Sage 100 product update idea to Sage, please submit it in the Sage 100 idea forum here.

About CTO Associates

Whether you’re looking to restructure your accounting operations, resolve inventory issues, quit using MS Excel spreadsheets for reporting; or find a replacement for your old accounting system, we’d love to talk with you.

Our team has combined experience of over fifty years in a wide variety of industries. We have a CPA, a senior financial consultant with a background in international operations and financial analysis, and experienced bookkeepers and consultants to assist your growing business.

At CTO Associates, we provide accounting and manufacturing software solutions to manufacturing, distribution, and service businesses. We have clients in MA, CT, NY, and across the US. We look forward to connecting with you soon.

Read more about CTO Associates here.