Parameters   Output Objects  

Deletes SAP Business One data.

Syntax

Remove-SAPBusinessOne [parameters]

Remarks

The Remove-SAPBusinessOne cmdlet allows you to use a syntax similar to SQL DELETE statements to delete SAP Business One data.

$conn = Connect-SAPBusinessOne -Url 'http://localhost:50000/b1s/v1' -User 'user' -Password 'password' -CompanyDB 'companydb'
Remove-SAPBusinessOne -Connection $conn -Table "Orders" -Id "22"

The Where parameter can also be used to specify the primary key:

Remove-SAPBusinessOne -Connection $conn -Table "exTablePowershell;" -Where "Id = 22"

The primary key can also be passed to the cmdlet along the pipeline:

Select-SAPBusinessOne -Connection $conn -Table Orders -Where "DocType = 'dDocument_Items'" | Remove-SAPBusinessOne