Small and medium business | Business Central, N...

Freight item - wrong type

(1) Share

Report

Posted on by MS-30040609-0

199

Hi all,

I noticed that we have set up our freight item wrong. So we now get a lot of negative sums on sales order and on the item card regarding availability and net invoiced quanity for example.

When I try to change the type to service instead of non-inventory I get the error massage that i cannot do that because we have entries in Item Ledger Entry.

How do I fix this?

On sales order:

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 84,621 Super User 2025 Season 1 on at

Like (0)

Report

Freight item - wrong type

Although not recommended, you can use the following method.

Dynamics 365 Business Central: Can we skip/ignore field validation errors?

https://yzhums.com/44435/

Thanks

ZHU
Suggested answer

Valentin Castravet 28,279 Super User 2025 Season 1 on at

Like (1)

Report

Freight item - wrong type

Out of the box, once an item has ledger entries, you can't change the item type. There are workarounds you can do, but in your specific case, there is little difference between a Non-Inventory item and a Service item. You can choose to keep it as a Non-Inventory item or change it to a Service item; either way, you will still face the same issue with item availability. For more details on item types, you can refer to the provided link here.

Additionally, it's generally advisable to categorize freight as an Item Charge rather than as an actual item. More information on item charges can be found here. However, if Item Charges are not applicable in your situation, the item availability for freight is not critical, and you can simply disregard it, as it won’t affect anything. It's always the case for non-inventory and service item types to have a negative availability and net invoiced quantity. These fields are simply ignored as they don't mean anything. To summarize, you can switch to using item charges, or keep using your current non-inventory item.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/