Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: Unable to search some stock code in stock module due to wrong stock type

Unable to search some stock code in stock module due to wrong stock type

Article ID: 52661 Email Print
Question
Due to the stock type was not set under 'S'(stk item) or 'V'(svc item), so when we wanna to search that particular stock item in stock module, was not found there

Answer

If all of the stock items is 'S' type, u may run the following SQL script in order to set all the stk items to 'S' type

Update Stock Set ItemType = 'S'

Where ItemType not in ('S', 'V')


related articles

Article Details
Views: 788 Created on: Aug 07, 2014
Date updated: Aug 07, 2014
Posted in: Delphi

Poor Outstanding