Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Change Item Type in Bu...
Small and medium business | Business Central, N...
Answered

Change Item Type in Business Central

(1) ShareShare
ReportReport
Posted on by JGarcia123 1,608
We have a BC customer that uses Purchase Orders with Non-Inventory items.  Turns out they had a couple of items that were inadvertently setup as Inventory Items and were used on one or more purchase orders.  Not certain of the status of the line items. Is it possible to change them back to /Non-Inventory/ and if so what steps do we need to take.
 
Look forward to a response:
 
//
 
JG
Categories:
Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    Change Item Type in Business Central
    Just add some information:
    Dynamics 365 Business Central: Can we skip/ignore field validation errors?
     
    Thanks.
    ZHU
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    Change Item Type in Business Central
    Once an item card has item ledger entries, the system will not allow you to go to the item card and change the item type. You have two options, but I would first ensure the incorrect items have a quantity of zero in inventory, and are not present on any document/journal lines:
     
    1. Stop using this item card, and create a new item with the correct item type. You can block the old incorrect item, and add a variation of z or zz in the item no. so it sits at the bottom of the item list and you can also reuse that item no. for the new item card. 
     
    2. You can use a configuration package for the item table to modify the item type and keep using the same item card. The configuration package would be for the item table and only contain two fields, the item no. and the item type. Configuration packages allow to skip the validation for specific fields so we can make it skip the validation on the item type to allow us to change it. Here is an example:
     
     
     
    Also, if the existing items have inventory in stock, you can use the item journal with a negative adjustment to get them out of inventory. I am guessing you would want to do so regardless, as these items should have been expensed rather than sitting on your balance sheet. Something to keep in mind is that doing a negative adjustment in the item journal will Debit your Inventory Adjustment Account and Credit your Inventory Account. Without knowing what your chart of account and other setup looks like, an accountant might also want to then re-allocate the amount booked in the Inventory Adjustment Account to an expense account for your items with the type non-inventory, as again these items should have been originally expensed. 
     
     
     
    Valentin Castravet
    Zander ERP Services

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans