How to tick Stock Batch Number for Stock item which already have Transactions : QNE Software Sdn. Bhd.

How to tick Stock Batch Number for Stock item which already have Transactions Print

Created by: Cheng Kah Poh

Modified on: Thu, 25 May, 2023 at 4:28 PM

Scenario:

Solution:

Step 1 - Press Start > Search SSMS > Then Execute "Microsoft SQL Server Management Studio"

Step 2 - Connect Instance

Step 3 - Expand 'Database' > Right Click Database Code > Click New Query.

Step 4 - Paste the Script.

Script:

update stocks set usebatchno = '1' where stockcode = 'put the stock code here'

Click Execute, Done!

** Learn more about Azure Cloud

Cheng is the author of this solution article.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk