Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Business Central Freight & Duty Costing Puzzle

(1) ShareShare
ReportReport
Posted on by 5
  1. We are working on switching someone over to dynamics 365. They sell components that come on sea containers from overseas (Taiwan, China, Vietnam, etc.). At the time of the purchase order and receiving of the inventory, they do not yet know the cost of the freight and the tariffs on the individual items. Up to 10 days later, they get a bill with freight and duties. Someone manually assigns a percentage weight to each item from the tariff tables assigning their portion of the duties and freight (particularly as of late with the trade war there are very strange trade rules resulting in wildly difference duties for each items. Example: no tariff on one item, 25% on another item). Freight is also divided up this way.

    Problem:

    In dynamics 365, when the purchase order posts, it affects the standard costing - this occurs before freight is added. They frequently sell merchandise before they get their freight bill and they don't want the price to be affected.

    Furthermore, if they were to use purchase orders and edit them after they receive the freight bill, adding it as an item charge and using item charge assignment, there is no option that allows a weighted percentage method of assigning cost to each item.

    One possible workaround to this is using the indirect cost % and adjusting that on the item card. The downside to this is that given the current international trade climate, both freight and duties change on a dime.

    This company has many items that are extremely price sensitive so doing accurate cost accounting is important.

www.rapidfs.com

  • N2K Profile Picture
    5 on at
    RE: Business Central Freight & Duty Costing Puzzle

    Hello Magdalena,

    Did you find a way to incorporate this freight charges and duties to your standard cost when doing the roll-up?

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Business Central Freight & Duty Costing Puzzle

    Magdalena,

    BC during Charge(Item) entry, allows for the charge to be spread across the Receipt Items by weight. You can pull all the Receipts in and distribute by weight.

    pastedimage1629610471338v1.png

    This is possible and you should test in your Sandbox.

    Thank you,

    Steve

  • Suggested answer
    Andy Sather Profile Picture
    on at
    RE: Business Central Freight & Duty Costing Puzzle

    Thank you for this question. It is pretty in depth. If you don't receive an answer from the community shortly, please raise a support request with Microsoft support via your CSP/Partner.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans