Dynamics Community Forum Thread Details

Business Central Freight & Duty Costing Puzzle

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

Categories:

Dynamics 365 Business Central

Quick Links