Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

Federal Medical Device Excise Tax (MDET) for Sage 100 ERP (fka MAS90 and MAS200)

December 9, 2012 by Wayne Schulz

The Patient Protection and Affordable Care Act imposes an excise tax of 2.3 percent on the sale of certain medical devices. Recently the IRS issued TD 9604  (here) which spell out more of the guidelines for the MDET.

Deal or No Deal, Obamacare Taxes Poised To Hit Next Month

We recommend that you consult with a tax professional on how (or if) this new regulation may apply to your company.

Some users of Sage 100 ERP (formerly known as MAS90 or MAS200) have asked how to best change their software to account to capture any required excise tax.

One solution which is on the horizon is from Avalara who is a provider of integrated sales tax computation and reporting services. Their solution integrates to Sage 100 ERP and computes taxes during the order entry and invoicing process. They also offer tax reporting and filing services to help make the process manageable.

Avalara reports:
We want to update you on the next release of AvaTax Calc, which includes changes to the AvaTax WSDL (Web Services Definition Language), enhancements to the user interface and support of the new Federal Medical Device Excise Tax. The AvaTax Calc SDK-DEV environment will be updated on December 12, 2012 from 5:00-9:00pm and to the production environment on December 27, 2012 from 5:00-9:00pm. These enhancements will not affect your product usage or ability to access AvaTax Calc.

Medical Device Excise Tax

We have updated AvaTax Calc to support the Federal Medical Device Excise Tax (MDET) going into effect as part of the Health Care and Education Reconciliation Act of 2010 in January 2013. In support of this, AvaTax Calc will allow you to calculate medical device excise taxes and generate a report to file the appropriate federal IRS tax forms.
We are introducing a new report and two new Entity Use Codes. The Entity Use Codes, used in combination with a Tax Code, will support the proper tax calculation.

Federal excise tax summary report

MED1 – calculates excise tax only (exempt sales and seller’s use tax)
MED2 – calculates excise tax in addition to sales and seller’s use tax (taxable sales and seller’s use)

 

Avalara – Avatax

Share this:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Email a link to a friend (Opens in new window) Email
  • Share on LinkedIn (Opens in new window) LinkedIn

Filed Under: Sage 100 ERP Tagged With: avalara, avatax, Excise tax, mas200, MDET, sage 100, Sage 100 ERP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage-certified consultant based in Connecticut. He has worked with Sage 100 since 1986 and provides remote consulting to companies throughout the United States. He is a founding member of the 90 Minds Consulting Group. To discuss working with Schulz Consulting, start with the Sage 100 inquiry page. Information is reviewed before follow-up about fit and next steps; technical work is scoped and priced separately.

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter

Schulz Says Email Newsletter

Sent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.