cancel
Showing results for 
Search instead for 
Did you mean: 

Update fields in sap b1 query generator (update command)

makhamadzoidov
Explorer
0 Kudos
183

Hello

I used UPDATE query in query generator for sap business one to change items (oitm) validFor and frozenFor fields. Update query worked good but then I couldn't add item for oitm (items). How to fix it? 

 

makhamadzoidov_0-1726729752671.png

I have written 
UPDATE OITM T0

SET T0."ValidFor" = 'Y', T0."frozenFor" = 'N'

View Entire Topic
inga_babco2
Explorer
0 Kudos

Please check your stored procedure sp_TransactionNotification. Maybe something is wrong in this stored procedure.