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

Created by Cheng Kah Poh, Modified on Thu, 25 May, 2023 at 4:28 PM by Cheng Kah Poh

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