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

How to Change the Service Item Code to Stock Code ?

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

Answer

Run this Script for solve the Problem :

For change all the Service Items :

update STOCK
set itemtype='S'
where itemtype = 'V'

For Change the Certain Service Items :

update STOCK
set itemtype ='S'
where stockcode ='key in service item code here'


related articles

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

Poor Outstanding