Add Ons | Schulz Consulting

One or more Avatax objects could not be created. The Avalara Avatax adapter.dll must be registered to continue

April 7, 2021 by Wayne Schulz

If you are using Avalara integrated to Sage 100 then you may have run into this error message on one or more of your workstations.

One or more Avatax objects could not be created. The Avalara Avatax adapter.dll must be registered to continue

This error should only occur on Sage 100 Standard as both Advanced and Premium will use the components from the server.

Here’s how to fix the problem.

On the local workstation you must be an Administrator or the needed DLL files might not register.

First, copy the .\mas90\Avatax folder from the server to the local c:\ of the workstation you are receiving the error on.

Copy and paste these three files from c:\avatax into the local c:\windows\sysWOW64
I copy all three of these files
- Avalara.AvaTax.Adapter.dll
- Avalara.AvaTax.Adapter.dll.config
- Avalara.AvaTax.Adapter.tlb

Edit the register_for_com.bat file in the c:\avatax folder and stick a PAUSE at the end so you can read the results or it will be difficult to know for sure if your DLL registers.

To manually register the file:

Open the c:\AvaTax folder on each workstation, and then right-click and run as administrator register_for_com.bat
MUST HAVE FULL ADMINISTRATOR RIGHTS ON THE COMPUTER
Link to manual: https://www.dsdinc.com/enh/downloads/LMAV700.pdf

Once you’ve done this your Sage 100 should no longer have an error message related to “One or more Avatax objects could not be created. The Avalara Avatax adapter.dll must be registered to continue”.

If the above did not work (a) be sure you’re a local administrator and (b) review the batch file progress which is possible by editing and adding a “PAUSE” command at the end of the bat.

If you are on a 64-bit OS – be sure you copied the three files mentioned above into c:\windows\sysWOW64

If you don’t have a c:\windows\sysWOW64 then use c:\windows\system32

Crystal Reports Schedulers for Sage 100cloud

October 15, 2020 by Wayne Schulz

One of the questions that we’re often asked surrounds how to automatically extract data from Sage 100 / Sage 100cloud on a regular basis without needing to manually run a program or report.

While there are a few ways to do this ( Visual Integrator, ODBC ), the typical way many consultants approach this is with Crystal Reports.

Crystal Reports is a report writer included with Sage 100 and the starting point they use for creating a report which can export data.

However, standard Crystal Reports usually rely on someone manually starting the report and running it on a regular basis.

Thankfully, there are numerous scheduling tools that work to automatically run a Crystal Reports at a preset time on a regular schedule.

In some cases you also use Windows Task scheduler to create the automation. The degree with which you manually create this task schedule varies based on the product used.

The two products that I’ve used the most are Visual Cut and Logicity. Both are affordable ( under $500 ) and support most of the recent versions of Crystal Reports.

The website Crystal Reports Underground has a review of both desktop and server-based scheduler programs.

Desktop Crystal Report scheduling tools reviewed include:

Crystal Delivery by Groff Automation
Smart Report Organizer 2018 by DataZimmerman
Logicity Pro by Saber Logic
Report Commander by Arcana Development
cViewMANAGER by Chelsea Technologies
Softline Crystal Scheduler by Softline Solutions France
R-Tag Crystal Scheduler Light by R-Tag
Visual CUT by Millet Software

Server Crystal Report Scheduling tools reviewed include:

ReportServer by InfoFabrik GmbH
R-Tag Crystal Scheduler by R-Tag:
Navarre Report Scheduler by PCS Programming
cViewSERVER by Chelsea Technologies
CrystalKiwi Scheduler by CrystalKiwi Ltd
Softline Crystal Scheduler by Softline Solutions France
Liaison Messenger EDD by Liaison Software Corp
rePORTAL SCR by rePORTAL Software
Report Runner Batch Enterprise by Jeff-Net

The next time you are wondering if there is a better way to automatically run a Crystal Report at a preset time – consider using one of the report schedulers reviewed above. And remember that Crystal Reports can be set to print a report as well as export data which can be handy if paired up with an FTP service scheduled to automatically upload a file on a set schedule.

Free Webinar 8/12/20: Creating Dashboards Using Sage Intelligence Reporting

August 10, 2020 by Wayne Schulz

Join Sage on Wednesday, August 12, 2020 for a free webinar spotlighting how you can use Sage Intelligence Reporting to create dashboards for viewing your Sage 100cloud data.

This one-hour session will also be made available as a recording so even if you can’t attend on Wednesday, sign up and you’ll receive a copy of the recording.

Midyear Sales Tax Update from Avalara

June 24, 2020 by Wayne Schulz

Join Avalara on Tuesday, June 30, 2020, for a 90-minute update on the latest sales tax trends and regulations. This webinar is free for all users and contains handouts with links to the latest sales tax and marketplace rules by state. ( Register Here )

If you’re worried that you may not be charging the appropriate sales tax or are considering expanding your sales online then this is an educational event you will not want to miss.

Avalara interfaces directly to Sage 100cloud accounting. It automatically computes sales tax based on the ship-to location and the type of product shipped.

While Sage 100cloud allows for creating your own sales tax codes and tracking tax manually the reality is that states are changing their rules so frequently that it might not make sense to manually track sales tax.

As of June 2020, there are only 5 states with no sales tax ( Avalara terms them as NOMAD states after the first letter of each state name ).

States continue to change rules for those who are required to charge tax ( aka Nexus ) for sales made into their states even when a company making the sale doesn’t have a traditional presence/office.

Join Avalara on June 30, 2020 for an update on sales tax for 2020 by registering here.

2020 Sales Tax Changes for Sage 100 Users ( Free Webinar )

December 11, 2019 by Wayne Schulz

Join Sage on December 18, 2019, for a 90 minute overview of upcoming sales tax issue which may impact your business during 2020.

Users of Sage 100cloud have access to Sage Sales Tax which is a version of Avalara Sales Tax with deep integration to Sage 100cloud sales tax processing.

Avalara offers:

Computation of sales tax for multiple states
Processing and tracking of sales tax exemption forms
Sales tax reporting on your behalf
More

The agenda is listed as:

What you need to know about the new tax rules going into effect

2019 brought dramatic changes in sales and use tax rules: 43 states adopted economic nexus laws, requiring out-of-state sellers to collect sales tax, and 36 of those states also enforced marketplace facilitator laws. Businesses of all sizes have had to scramble to keep up with changing tax liabilities, and it’s not expected to slow down.

As 2020 nears, now’s the time to prepare for even more sales tax changes to go into effect.

Attend this webcast as our strategic partner, Avalara, will again provide in depth insight to arm you with knowledge on the biggest sales tax changes that went into effect in 2019 and what changes you can expect in 2020.

Scott Peterson, Vice President of U.S. Tax Policy and Government Relations for Avalara, will cover:

The current state of sales and use tax in the U.S.
Which states have enacted economic nexus, and what’s expected to change in 2020.
New requirements for marketplace sellers (Amazon, Etsy, etc.)
A look at cross-border ecommerce and what international sellers must know about sales tax.
Answers to your questions.

The webinar is geared to both Sage partners and end-users. To register follow this link.

Contact Us