FrontAccounting forum — Changing Item Type

Re: Changing Item Type

null@example.com (itronics) — Fri, 13 Jan 2012 11:40:09 +0000

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

Re: Changing Item Type

null@example.com (emun2) — Thu, 12 Jan 2012 18:03:28 +0000

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

Re: Changing Item Type

null@example.com (joe) — Wed, 06 Apr 2011 13:52:35 +0000

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

Changing Item Type

null@example.com (saeed) — Wed, 06 Apr 2011 11:32:05 +0000

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