Want to delete DRAFT entries in bulk mode

[labindia123]

I want to delete the DRAFT from year 2019. How can I delete in bulk mode?

Or can run a query to delete the DRAFT??

I create the following query. when I run query by DocNum, it works But if i add posting date selection, it gives error "1). [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 'User-Defined Values' (CSHS)" 

What should I do, to run the query by date selection option.

DELETE FROM

ODRF
WHERE
--DocNum = '20129';
DocDate = [%0] and DocDate = [%1] ;

[fabiobilicki · Accepted solution]

Dude, no no no no and NO. Forbidden by contract to do this in the SAP database, you can only update simple custom tables, doing this you lose the warranty, in addition to making the system present strange errors because it will not find the data.

I'll attach the notes that you can update here in the reply. But to close multiple sketches, you can go to the sketch report and mark multiple and close (new version of SAP FP 2405) 

https://file.io/Mj1BJ9BMmSFA

Rgs

Fabio.

SAP 9.3 PL14 / SQL SERVER 2014

[labindia123 · Accepted solution]

Thank you

[ANKIT_CHAUHAN]

Hi labindia123,

Refer to SAP Note 3450729 for the same.

The new functionality is provided in SAP Business One 10.0 FP 2405.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[labindia123]

Not able to open note SAP Note 3450729

[ANKIT_CHAUHAN]

Hi labindia123,

You need a valid S-User ID and Password in order to access SAP Notes.

Kindly contact your SAP Business One Partner for the same.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support