Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. microsNewb08

    using mi_seq vs obj_num for tracking items

    Sorry, it took me a while to get back to the forum. Thank you again for the valuable advice!
  2. microsNewb08

    using mi_seq vs obj_num for tracking items

    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...
  3. microsNewb08

    using mi_seq vs obj_num for tracking items

    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...
  4. microsNewb08

    using mi_seq vs obj_num for tracking items

    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...

Part and Inventory Search

Back
Top