web
You’re offline. This is a read only version of the page.
close
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

Freight item - wrong type

(1) ShareShare
ReportReport
Posted on by 423
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: 
 
 
 
 
 
 
 
 
 
 
'
 
 
 
 
 
 
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    31,551 Super User 2025 Season 2 on at
    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.
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,763 Super User 2025 Season 2 on at
    Although not recommended, you can use the following method.
    Dynamics 365 Business Central: Can we skip/ignore field validation errors?
     
    Thanks
    ZHU

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans