Author Topic: to clear -ve inventory qty  (Read 11709 times)

zahirramputh

  • Newbie
  • *
  • Posts: 36
to clear -ve inventory qty
« on: July 02, 2013, 12:42:00 am »
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

  • Full Member
  • ***
  • Posts: 165
Re: to clear -ve inventory qty
« Reply #1 on: July 02, 2013, 11:43:49 am »
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

  • Newbie
  • *
  • Posts: 36
Re: to clear -ve inventory qty
« Reply #2 on: July 02, 2013, 10:10:19 pm »
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

  • Full Member
  • ***
  • Posts: 165
Re: to clear -ve inventory qty
« Reply #3 on: July 03, 2013, 01:34:22 am »
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

  • Newbie
  • *
  • Posts: 36
Re: to clear -ve inventory qty
« Reply #4 on: August 06, 2013, 05:10:03 am »
I have run the script but still some items is present in inventory report with -ve qty...why is zat so?