• saeed
  • New member
  • Offline
  • Registered: 04/06/2011
  • Posts: 4

Topic: Changing Item Type

Hi Friends,

I want to change the items type from purchased item to manfucturing item ... but it is not editable on my screen. as i have entered alote of data i can not do re work.. can some one help me regarding changing type.. what can i do with database so that it changes it nature without messing up things.

Thanks

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Changing Item Type

If you haven't done any operations on the items, you can use phpMyAdmin and load your database and go into X_stock_master (where X_ is the company table prefix, if any).
Find the items you want to change. Click the pencil in front and change the letter B to M in the field mb_flag.
After you have done that enter FA and check that the GL accounts for the changed items are correctly set.

You should now be able to create BOM and work orders for the items.

/Joe

  • emun2
  • New member
  • Offline
  • From: USA, New York
  • Registered: 10/14/2011
  • Posts: 5

Re: Changing Item Type

Is it possible to make Item Type and Units of Measure editable without going into phpMyAdmin?

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Changing Item Type

No, this should not be changed even by phpmyadmin. When you change it uom on already issued invoices will change also. Create new item with another uom instead.
Janusz