Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

How To Add Tariffs To Sage 100cloud Purchase Orders and Sales Orders

August 13, 2019 by Wayne Schulz

Tariff Management With Sage 100cloud

The recent governmental activity has increased the likelihood that distributors who import goods from certain overseas countries will be assessed with a tariff.

While Sage 100cloud doesn’t have a native way to handle the tariffs your business may pay we have discovered the three most common methods consultants use to capture this new tax.

A tariff is a tax on imports or exports between sovereign states. It is a form of regulation of foreign trade and a policy that taxes foreign products to encourage or safeguard domestic industry.

Option 1: Use Sage 100cloud Landed Cost

The first option for managing tariff charges is to apply them using the native landed cost within Sage 100cloud.

Sage has a set of instructions on how to set up landed cost in Sage 100. This can be a quick and easy way to make sure all extra costs of import – including tariffs – are added to your product costs.

Using the standard Sage landed cost functionality you are able to allocate costs across your purchased items in one of four methods:

  • Weight
  • Cost
  • Quantity
  • Volume

Option 2: Use Scripting With Purchase Order

The second option which some companies have used is to create customization within their inventory items to:

  • Add a checkbox for “subject to tariff”
  • Add a field for “tariff percentage”

Then, using scripting, whenever an inventory item is placed onto a purchase order the system adds a separate miscellaneous code which contains the computed tariff for the line item.

Some companies have asked for this enhancement to make it easier to view the total tariffs charged.

Option 3: Use Scripting with Purchase Order and Sales Order

Lastly, a number of companies are using option 2 as well as creating a separate line charge on the sales order invoice to pass along the tariff amount to customers.

This separate line charge is similarly created using scripting which automatically adds a miscellaneous charge to any inventory item flagged as subject to the tariff.

The benefit of this method is the charge is separately stated so a customer can see that there wasn’t a random price increase.

Lastly, instead of using scripting to add a separate line item some users have opted to simply increase prices of the items subject to a tariff.

There are also various third-party solutions which can enhance the Sage 100cloud landed cost functionality.

No matter how complex your Sage 100cloud tariff situation, there are solutions – either built-in or custom – which can save you time processing shipments that include this new tax.

For more information on Sage 100 Tariff Management contact us here.

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: sage 100, sage 100cloud, tariff, tax, trade

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • WFH Tip For Sage 100: Go Paperless February 24, 2021
  • When is Sage 100 2021 Due for Release? February 19, 2021
  • Sage 100 Partner Cloud List of Supported ISVs as of January 2021 February 12, 2021
  • Sage 100 User Help Files and Table Layouts – Version 2018 – 2020 January 27, 2021
  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.