Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Change Item Type in Business Central

Posted on by 1,360
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
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,563 Super User 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 8,087 Super User 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans