Schulz Consulting

Consulting and Upgrades

  • 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.

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

CT Employer’s Tax Guide Circular CT – 2013

January 1, 2013 by Wayne Schulz

The State of Connecticut have just released their withholding tax guide for the year 2013. This booklet provides information on the amounts to withhold from CT employee payroll, a comprehensive frequently asked questions (FAQ) section as well as contact phone numbers for questions.

State of CT Tax Guide – Circular CT 2013

Additional CT Employment Forms

 

CT – W4 – 2013 – Employee’s Withholding Certificate

CT-941 -2013 – Connecticut Quarterly Reconciliation of Withholding

CT-W3 -2013-  Connecticut Annual Reconciliation of Withholding

Filed Under: Sage 100 ERP Tagged With: payroll, state, table, tax

MAS90 Update To Compute Connecticut Payroll Taxes (August 1, 2011 Changes)

July 22, 2011 by Wayne Schulz

As of August 1, 2011 Connecticut has new tax withholding rules which require some modification to the standard MAS0/MAS200 payroll module.

The new CT withholding rules can be reviewed here on the Connecticut Department of Revenue Services site. Be sure you consult your tax advisor on the best way to apply these rules. As a reminder Schulz Consulting does not provide tax or accounting advisory services. We recommend you consult your tax advisor with specific questions on the new tax rules. This update is not meant as a substitute for such discussions.

Because these Connecticut withholding tax changes required new computation steps in the MAS90 and MAS 200 payroll – Sage released an updated tax calculation program for those users on Sage ERP MAS 90 or 200 v4.2.0.26+, 4.3.0.17+, 4.4.0.0+.

IMPORTANT: Please be sure to read the instructions for the respective update. There may be several steps including some manual computations due to the complexity of the new Connecticut rules.

At a minimum you will need to:

A. Install the modified tax calculation program for your version of MAS 90 or MAS 200
B. Install the Payroll Tax Table Update
C. Assign the appropriate new employee filing status for each employee that earned Connecticut income in 2011 prior to August 1 (see the instructions for the modified tax calculation program).

We recommend you manually verify the computed payroll taxes for at least the first payroll run which includes the new CT updates. You are responsible for verifying the accuracy of tax information withheld and compliance with regulations – not Sage. Compare the withheld amounts against what the tables provided by CT indicate should be withheld.

You can access the tax calculation updates and view more information at the following link.

Here’s a quick review of the steps you’ll need to complete for version 4.4.0.1 to 4.4.0.6

Download the latest tax calculation updates

Sage CT Tax Withholding Instructions

Filed Under: Sage 100 ERP Tagged With: ct, tax, updates, withholding

Connecticut Payroll Tax Table Changes for Sage ERP MAS 90 and MAS 200

June 16, 2011 by Wayne Schulz

It appears the Connecticut payroll tax TABLE changes are effective August 1, 2011 – that is the changes (including catch-up amounts) are incorporated into rate tables that Connecticut indicates should be put into place on August 1, 2011

(View Information About Connecticut Tax Table Changes for August 2011: http://goo.gl/ABI8V ) .

Sage is planning to include these changes (which seem to also require some programming updates) in the version 4.5 release of MAS90/200 – as well as free program patches for versions 4.2 to 4.4.

(Link: http://goo.gl/eiJnx )

In July we will be able to download a program update for users of MAS90/200 payroll on version 4.2, 4.3 and 4.4.

If users are presently on a version BELOW version 4.20 (which hopefully is not many people) they’ll need to plan an upgrade in order to take advantage of payroll program updates.

Filed Under: Sage 100 ERP Tagged With: changes, connecticut, ct mas90, mas200, payroll, Sage 100 ERP, tax

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?
  • Sage 100 Payroll Tax Update Set for 10/27/22 for New York State Health Care Workers Bonus Program (HWB)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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