NEWS CURATED BY

Wayne Schulz
Cell: 860-516-8990
e: wayne@s-consult.com
Schedule a time to talk ( link to my calendar )
|
|
|
SPONSOR: DataSelf Analytics for Sage 100
Customizing Analytics for Sage 100
Maintaining Sage 100 reports is time-consuming! This 30-minute webinar will show how IT and business analysts can automate and simplify the creation, refresh, and distribution of Sage 100 reports & dashboards by:
- Using the next-generation ETL+ technology for connecting to and optimizing Sage 100 data for reporting.
- Using Tableau, Power BI, or Excel, simplifying the report design and enabling quick customization of reports.
- Empowering managers with the most powerful natural-language search engine plus the industry’s most extensive analytical reports library.
This deeper dive into DataSelf Analytics includes how you can get DataSelf installed and provide key Sage 100 metrics in under 10 minutes.
Audience: Sage 100 report writers and business analysts
Presenters:
- Joni Girardi: DataSelf Founder, CEO, & self-proclaimed ‘Data Geek’
- Don Farber: DataSelf Industry Analyst
Customizing Analytics for Sage 100 (30 min video - no registration req'd)
|
|
SAGE 100 TECHNICAL
How To Calculate System Date For Visual Integrator Imports
- Open Import job in Import Job Maintenance
- Open date field in Data Tab
- Select Calculated as Operation
- Enter the following Calculation: DTE(0)
- Click Accept to accept change
|
|
SAGE
TLS 1.2 Compliance Update for Sage 100
Sage released an updated chart showing versions of Sage 100 compatible with an upcoming change at Sage.
Beginning in October 2023, Sage License Servers ( SLS ) will no longer accept communication using the less secure TLS 1.0 and 1.1 protocols. This means if your Sage 100 version is not at least one of those listed below you'll want to upgrade before October 2023.
After October 2023 if your Sage 100 ( subscription ) is not at one of the supported versions shown below your data may go into a read-only mode once your systems fails to login to SLS.
My suggestion is you set a goal to stay within 2 versions of the current release which is Sage 100 2022.
Full PDF Here

|
|
SAGE
Auto-Complete May No Longer Work With Avalara AVATAX is Installed
Several users have reported that auto-complete may no longer work to lookup customer accounts when the Avalara Avatax enhancement is installed.
Here are the steps to see if Avalara's enhancement is the cause.
- Download and install the latest AVATAX for your version of Sage 100 from here
- If autocomplete still doesn't work - rename AR_Customer.M4L in the MAS90\AR\ folder and replace with an unmodified version
- Go to the Sage 100 File menu and select - File - Run and *ESC (turns off customized screens)
- Test
|
|
|
Picking & Shipping Workflows Explained (with Demo)
Here's a great YouTube video ( 26 minutes / no login req'd ) that walks you through several different ways you may be able to enhance your warehouse operations ( that's a fancy way of saying do more with less people ).
- License plating - what is it?
- Pallet tracking
- Pre-allocation
- Stage items
- Single-scan your staged pallet
- Advanced Picking and Shipping
- Staged sales orders
- One-step shipping
- Directed Picking and Allocations
- Split picking - multiple people pick one sales order
- Businesses with large sales orders for one customer
- Directed picking tells the picker where to get the item
- Allocations at sales order (Automatic, Pre-allocation)
- Reserve items by location within warehouse
- Bin location is tied to the item on sales order
- Demo
- Q&A
|
|
SAGE
What Are The Differences Between Sage Fixed Assets Lite, Single-User, Network and Premier?

Are you confused by the various versions of Sage 100 Fixed Assets?
Each of the versions have slightly different functionality and limits to the number of assets they can process as well as whether the version can run on a network.
I have a concise summary of the differences between each version available on my website here which you might want to bookmark or PDF for future reference.
|
|
WHAT'S NEW IN SAGE 100?
MORE:
FILE LAYOUTS - ONLINE HELP:
Sage 100 version 2022 - File Layouts Online
Sage 100 version 2022 - Online Help
Sage 100 - Required Internet Access
NEED HELP?
Contact Us Here
|
|
NEWS EDITED / CURATED BY:
WAYNE SCHULZ
wayne.schulz@schulzsays.com
Office: 860-657-8544
Cell: 860-516-8990
The opinions and advice supplied in this newsletter are general in nature and represent the views of Wayne Schulz and no other entity or sponsors. You are advised to consult your Sage partner prior to implementing any recommendations or advice from this newsletter.
|
|
|
|