on 09-01-2007 10:09 AM
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.
sandip
Hi Sandip,
Modifying the OnHand quantity for an item directly through SQL is forbidden by SAP. Updating a UDF is also not recommended. The recommended method for updating a UDF is through the SDK.
I'm not sure what you are trying to achieve. If you wish to change the stock quantity for an item then you need to add the most appropriate transaction, either through the UI or via the SDK (eg Goods Issue, Goods Receipt, AR Delivery etc).
Kind Regards,
Owen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
9 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.