Deleting Items

It will not make your sales reports inaccurate, but it will make them look funny if they include any item data like LookupCode or Description. More of a problem for Detailed sales than for Sales Summary.

All of the sales information is stored in the TransactionEntry table. TransactionEntry keeps a record of the price paid on that transaction and the cost of the item at the time of the sale. I don't remember of hand if it includes the retail price at the time of the transaction, but I think it does. Some reports, like Detailed sales, will join this TransactionEntry back to the Item table to show details of the item that was sold, but the monetary data is all in TransactionEntry.

There *may* be some reports that use an inner join to the Item table. If there are such reports (they would probably be custom reports), then their results would be affected by deleting items...

Glenn Adams Tiber Creek C> I have a number of inactive, discontinued items. I would like to start

Thanks Glenn. Based on this do you recommend a protocol for deleting items? What about cashiers? Other database entries?

Thanks,

Dan