RouterRanger
IS-IT--Management
Aloha POS Ver. 6.7.66
ISSUE:
------
All Items lost sales categories, GNDITEM.DBF all items have a 0 in "Category" Column - Problem started today.
Tableservice sales reports and other reports no longer show item categories.
When you exit tableservice - VERIFY.TXT tells me that all of my individual sale items have lost their category - it lists every item with "is not in a sales or retail cateogry".
Upon inspecting the Items themselves in Maintenance>Menu>Items, all items are present in the drop down and listed in the correct order under categories we have set up in the Item list (Ex. Item 001000 is the header for "***APPETIZERS***" such that Items 001001-001020 are then appetizers, and so on).
However, down in the bottom right hand corner of the Items menu, it says that "Member of Category" : "No Category" for every item.
If I open up the DATA\GNDITEM.DBF file for today, everything sold is marked as 0 for "Category" Column.
I have daily backups, I checked yesterdays GNDITEM.DBF and everything sold is in it's correct category.
QUESTIONS:
----------
How do I rectify this without manually re-entering all of my items by hand?
How did this happen?
How can I prevent it from happening again?
I have a backup from yesterday, can I pull a copy of the items from yesterday and just replace the one in the live Aloha folder?
Any help would be greatly appreciated!
Thank you Tek Tips!
ISSUE:
------
All Items lost sales categories, GNDITEM.DBF all items have a 0 in "Category" Column - Problem started today.
Tableservice sales reports and other reports no longer show item categories.
When you exit tableservice - VERIFY.TXT tells me that all of my individual sale items have lost their category - it lists every item with "is not in a sales or retail cateogry".
Upon inspecting the Items themselves in Maintenance>Menu>Items, all items are present in the drop down and listed in the correct order under categories we have set up in the Item list (Ex. Item 001000 is the header for "***APPETIZERS***" such that Items 001001-001020 are then appetizers, and so on).
However, down in the bottom right hand corner of the Items menu, it says that "Member of Category" : "No Category" for every item.
If I open up the DATA\GNDITEM.DBF file for today, everything sold is marked as 0 for "Category" Column.
I have daily backups, I checked yesterdays GNDITEM.DBF and everything sold is in it's correct category.
QUESTIONS:
----------
How do I rectify this without manually re-entering all of my items by hand?
How did this happen?
How can I prevent it from happening again?
I have a backup from yesterday, can I pull a copy of the items from yesterday and just replace the one in the live Aloha folder?
Any help would be greatly appreciated!
Thank you Tek Tips!