Is it possible to remove items from sap b1 using delete statement query

[makhamadzoidov]

Is it possible to remove all items from sap business one using query?

for example:

DELETE FROM OITM T0

or

TRUNCATE TABLE OITM T0

why don't recommend these ways to remove items or etc data?

[ANKIT_CHAUHAN]

Hi makhamadzoidov,

You can use DI API for Items object. It contains Remove() method.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[patrice_vigier]

Does the remove() works id the ItemsCode was used? I do not think so.