to clear -ve inventory qty

[zahirramputh]

Hi

Am using sambapos version 2.9  and I want to know in database which table i need to delete inventory items qty which are appearing as -ve in inventory reports?

[lemmings]

Deleting inventory items will probably require you to remove many other tables of data as they are all linked.

You could start with the SQL query:

DELETE FROM SambaData2.dbo.PeriodicConsumptionItems;
DELETE FROM SambaData2.dbo.PeriodicConsumptions;
DELETE FROM SambaData2.dbo.TransactionItems;
DELETE FROM SambaData2.dbo.Transactions;

Which will remove the data that appears in the reports, it will not delete the actual recipes or inventory items but will clear the totals.

[zahirramputh]

I just want to clear the data which appear in the inventory reports only,is it possible or do i need to delete my sales transaction also?

[lemmings]

The tables mentioned are all linked to inventory and not sales. Your recipes will stay in the database.

Your tickets and sales are not affected.

Transactions data refers to the document you create when adding stock received

[zahirramputh]

I have run the script but still some items is present in inventory report with -ve qty...why is zat so?