Hi Kogger.
To aswer Your question on deleting the Items - it will not create inconsistencies in the database, except this next :
- When You run a report (sales report for example), since the items have been deleted, the report will not be able to show you the Item information, like ItemlookupCode, description, etc..., but You can still see the image / photo of the sales transaction (if exists in the database)
- If You have any Purchase Orders, InterStore transfers or similar, that includes this items, RMS will not be able to show you that Item
- If You have suppliers, that servse You this Items, it could be that you can't see the Item information per supplier...
- In case You want to do a return transaction, by recalling a sale that have included one of those Items that you want to delete, RMS will pop up a message that the Item is not in the database
At the end, understanding that this is a single store (only one RMS database, not HQ environment), You can do a massive delete from the Administrator, but please You:
- ALWAYS do a database backup before deleting
- make sure there is nobody using the system (RMS) in that moment of deleting
- check if there are no workorders, backorders or purchase orders that include any of those items
- once deleted, test the system, by opening the Manager and POS and make test transactions and similar..
Regards, A.
