Thanks again for the info. Sorry, I have been away from the forum for a few days.
Do you suggest that the historical data be rewritten (updated) to include mi_seq in addition to obj_num, so that when obj_numbers are reused the references to historical item sales will remain unique? Otherwise...
Thanks a bunch for the feedback!
The data are loaded into a data warehouse with subsequent reporting on daily sales, etc. The main data pulling queries are using obj_num to identify items when menu_item_groups are not applicable (there are a bunch of them with '-1' assigned to family and major...
Hi, I am new to Micros 3700. My client's data extraction queries and reports are using obj_num to track items. Since their menu items are continuously changing (unused ones are taken off the menu and new ones are added), they want to start reusing obj_numbers (obj_num) for new menu items.
This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.