Showing results for 
Search instead for 
Did you mean: 

SQL Query to update Item OnHand in SAP B1 2005

Former Member
0 Kudos

hi all,

is it possible to write a Update query in sql to modify item OnHand ? is it possible to do that in SAP B1 for UDF?

i want to create a UDF and the enter value in it should be deducted from the Item OnHand Stock. is there any query is possible to modify the item on hand.

if it is possible then kindly send me the query.


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hey sandip if u are updatin ur own fields then it is allowed. But if it a field in the sap tables then NO way.. U gotta use the DI API to update these fields.. I u want to reduce the stock the n use the Goods Issue DIAPI.. I tink its The INVGenEXit DiAPI.. Remember if u using the DiApI u Allowed to do only wat u can in the front end



Answers (0)