Master Import Tariffs with Business Central

Functional Enhancement and ERP Extended Process Customization Use Case

Overview of Tariff Management for Business Central

Tariffs can disrupt distribution businesses, spiking costs and complicating sales orders. Crestwood Associates tackled this for a large importer managing millions in goods, delivering a seamless tariff management solution within Microsoft Dynamics 365 Business Central. By integrating flexible tariff setups, real-time tracking, and automated updates, we streamlined their supply chain, saving time and ensuring accuracy across thousands of orders.

The Challenge: Manual Tariff Handling in ERP Systems

The client faced chaos when new tariffs hit:

  • Overwhelming Updates: Thousands of open sales orders needed tariff adjustments to reflect cost-sharing agreements with customers.
  • Time Pressure: Manual updates were too slow, risking delays and errors.
  • Complex Needs: They required flexibility to apply tariffs selectively and track costs across suppliers and buyers.
    They needed a fast, integrated solution within Business Central to manage tariffs without disrupting operations.

The Solution: Automated Tariff Integration for Business Central

Crestwood built a tariff management tool directly into the client’s Business Central environment, using native functionality for simplicity and speed.

Key Solution Components:

  • Default Tariff Setup: Added a 9.6% default tariff rate in sales and receivables setup, linked to accounting records for easy reporting.
  • Flexible Inventory Control: Introduced a “Tariffable” checkbox and custom rate field on the item list to flag and adjust tariffable products.
  • Real-Time Sales Order Updates: Automatically calculates tariffs for tariffable items on sales order lines, displaying costs clearly.
  • Shipment Charge Tracking: Tied tariffs to a charge item for shipments, enabling detailed reporting.
  • Retroactive Order Processing: Created a report to apply tariffs to existing orders, updating 6,000+ lines in minutes.

 

This solution empowers the client to manage tariffs effortlessly, with no manual workarounds or complex coding.

The Results: Real-Time Tariff Updates in ERP

The solution delivered immediate impact:

  • Rapid Deployment: Fully operational in under a week.
  • Effortless Updates: Sales orders now reflect tariffs instantly, supporting cost-sharing deals.
  • Time Savings: Retroactively updated 6,000+ order lines in minutes, not hours.
  • Clear Reporting: Shipment and order reports provide full visibility into tariff costs.
    The client now handles tariffs confidently, with a system that’s accurate and production-ready.

How It Works: Tariff Management in Business Central

Here’s how the solution operates:

  1. A default tariff rate (e.g., 9.6%) is set in sales and receivables setup, tied to accounting records.
  2. On the item list, a “Tariffable” checkbox and rate field flag products for tariffs, with adjustable percentages.
  3. When creating sales orders, tariffs auto-calculate for tariffable items, displaying on each line.
  4. Tariffs link to a charge item for shipments, enabling precise tracking in reports.
  5. For existing orders, a dedicated report applies tariffs retroactively, processing thousands of lines quickly.
    This streamlined process ensures tariffs integrate seamlessly into Business Central workflows.

Scalability: Scalable Tariff ERP Integration for Growing Businesses

Designed for growth, this solution scales effortlessly. The flexible setup—default rates, item-level controls, and automated updates—handles increasing order volumes or new tariff changes without rework. Features like country-of-origin tracking and variable rates are in development, making it adaptable for other distribution businesses. Whether you manage one warehouse or multiple, this tool grows with your supply chain needs.

Conclusion

Crestwood’s tariff management solution turns a supply chain headache into a competitive edge. By embedding default tariff setups, real-time calculations, and shipment reporting into Business Central, we eliminate manual errors and save you time. Perfect for distributors facing volatile tariffs, this fast, flexible tool ensures your ERP keeps pace with global trade. Ready to simplify your tariff process? Contact us to see it in action.

Explore how Crestwood can streamline your processes and enhance your Acumatica workflows.

Talk with an Expert →

Project Details

Industry:
Distribution

ERP System:
Business Central

ERP Customization:
Business Central tariff solution leverages native functionality with targeted configurations: a “Tariffable” checkbox and rate field on item lists, a default tariff in sales setup linked to accounting, real-time tariff calculations on sales order lines, and a shipment charge item for reporting. A custom report retroactively updated 6,000+ lines in minutes.

Key Results

  • Deployed in under a week for fast impact
  • Instant tariff updates on sales orders
  • Updated 6,000+ order lines in minutes
  • Clear tariff tracking in shipment reports
  • Supports cost-sharing with zero errors
  • Boosts supply chain efficiency

Explore how Crestwood can streamline processes and enhance your workflows.

Microsoft 365 outage: Email to and from our team is intermittent today. Submit or update a support case in the Crestwood Support Portal, which is running normally. We will follow up by email once Microsoft restores service.