Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: Change the Service Item Code to Stock code

Change the Service Item Code to Stock code

Article ID: 53036 Email Print
Question
How To Change the Service Item Code to Stock Code

Answer

Run Script :

For Change all the Service Item Code :

update STOCK

set itemtype='S'

where itemtype = 'V'

For Change the Certain Service Item Code :

update STOCK

set itemtype ='S'

where stockcode ='key in service item code here'

 


related articles

Article Details
Views: 548 Created on: Aug 18, 2014
Date updated: Aug 18, 2014
Posted in: Delphi

Poor Outstanding