[Chase Landorf]

We have an item number that is not set correct. The area that needs to change, is grayed out. Where do I go to do this?

——————————
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
——————————

[Beat Bucher]

Hi Chase,

Not much you can do… unless there are transactions attached to this item, in which case you can’t delete it, I would just remove it from GP and recreate the item with the proper type.

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
————————————————————————-

[SYED ARSHAD]

Or you can use the backend (SQL) to change the item type. That’s is what I was used to do

——————————
Syed Arshad
IT Business Analyst
Supreme Oil
englewood NJ
————————————————————————-

[Don Pugh]

If nothing has been posted to the item, and there are no unposted transactions, then delete the item, and reenter it.  If there are only unposted transactions, delete the transactions, then delete/add the item, then recreate the transactions.

If you have posted transactions, then one option would be do discontinue the old item number, and recreate a new similar item number, with a suffix/prefix to make the distinction.

Each of the item types has an underlying business process associated with it, so I would be reluctant to change the item type from the backend, because the first transactions were done one way, and subsequent transactions will be different.  Plus on hand inventory might be a bit confused.

I suggest using item classes, and this will insure that the correct settings are done for an item, such as item type and decimal places, etc.

Don

——————————
Don Pugh
GP Consultant
Sandon Associates
Woodside CA
————————————————————————-

[Leslie Vail]

Syed,

That is what I would do too. It’s an easy change because there cannot be any existing quantities to worry about, so there wouldn’t be any ‘costs’ to be concerned with. It would be helpful if there weren’t any unposted transactions outstanding, but even that isn’t a deal killer.

Kind regards,

Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
————————————————————————-

[Jan G]

??Syed and Leslie — Can you please describe the process of making this Item Type change in SQL?
I need to change Service Type to Discontinued.  Thank you.  Jan

——————————
Jan G
Accounting / AIS Manager
California Radiographics, Inc.
Soquel CA
——————————
——————————————-