Tuesday, January 10, 2012

Dynamics GP - How to change an Item type from Services to Sales Inventory

Only items going from non-inventory to  inventory can be changed this easily.
Do not attempt this for any other inventory types.
1)  Ensure all batches are posted
2)  Run this to change the type
update IV00101 set [ITEMTYPE] = 1 where [ITEMNMBR] = 'Item_to_change'

3) Valuation Method will be blank 
Go to
GP> Utilities>Inventory>Change Valuation
and set the valuation of the item to the correct valuation type

Item Types:
1 – Sales Inventory
2 – Discontinued
3 – Kit
4 – Misc Charges
5 – Services
6 – Flat Fee

No comments:

Post a Comment