Dynamics Community Forum Thread Details

Freight cost on

Hi!

We use NAV 2016 and have a question about freight costs. The the freight cosst is handle by special items. The are added to the order just to be able to charge the freight. Step by step, this is how we do it:

The sales order is created.
The order lines is added for the items.
The freight cost order line is added. The freight cost item might be "SHIPPING_COST_PARCEL" (the order person is guessing)
The order is released.
An inventory picking is created
The warehouse staff is picking the order.
Shipment is created. But the say: "Hey, we need to use a pallet instead of the parcel".

The problem is:

How to change the freight cost item from "SHIPPING_COST_PARCEL" to "SHIPPING_COST_PALLET"? It is not simple because the order is allready released and an inventory pick is created.

Is there any other way to handle this problem? Is there some kind of other way to handle freight costs, that can be updated eaven if the order is released.

Hi Sirva,

Thank you for your question on this Forum.

So to confirm, you are not using a GL Account or an Item Charge - 'Charge (Item)' - on the Sales line, correct?

It is a just Item you have setup which is for your freight charges?

Then, further, I understand the Pick is created from the shipment, and the Pick is then Registered...thus moving Inventory Items from your storage bin to your designated shipping bin...and at that point in time, it is when they realize they have the wrong Item "SHIPPING_COST_PARCEL" and it should have been "SHIPPING_COST_PALLET". I understand this freight charge item is on the Warehouse documents, correct?

If I understand all that correctly, then from a processing standpoint, yes this would be quite a bit to handle...

...and keep in mind the item setup for freight on the warehouse is just seen as another item.....

So you would have to Open the Whse. Shipment, delete the Freight Item Line (Not the warehouse shipment itself, just that wrong line)...it'll tell you that you need to place it back into stock....but that is not necessary because that is just a factious item anyways (as I'm understanding) as it is just freight charge....go back to the Sales Order, reopen it, delete the wrong freight item line, then add the "SHIPPING_COST_PALLET" one you want, and Release the Sales Order again. Go back to the Warehouse Shipment, go up and choose 'Get Source Documents', grab your sales order so it should then add the new item onto it, Create a new Pick for the new freight cost item, register it, then you can ship the Warehouse Shipment......wow, yes that is a lot.

Instead of all that, you may want to think about just use an 'Item Charge' or a 'GL Account' on the Sales Line....or even, you can use the Items you have setup if you want to track those, but just set the line to a non warehouse location... just a blank location (if you have that allowed) or some other Freight Location you have setup where it will not follow the Warehouse processing.

There would then need to be some communication between the warehouse and sales order person to let them know what Freight item they actually used, so that the sales order person can reopen the sales order and update the sales line to the correct item. Again, this would not have a Warehouse type of a location so would not need to do all the warehouse processing for it. You could then invoice the Sales Order with correct Freight charge. And again, you could do this with Item Charge or GL Account as well.

These are just some ideas for you. I don't now all the specifics. You could check with others or with your partner who should know your business and process flows better. Hopefully that helps and if anyone else in the community would like to add to this, it would be great. Thank you and take care Sirva. :-)

Bryan Tschosik

Quick Links