Micros 3700 - Refill Tracking

[bufftrek]

I have a client that is currently using refills on both food and liquor items.
For inventory purposes I need to be able to enumerate the number of times an item is refilled.
I have the item set to be prepended by 'RF' when it is refilled but I'm failing to find where this is logged in some of the main tables I am familiar with. Can anybody offer any guidance as to the direction I need to be looking in order to track appropriate usage for this client?

 

[pmegan]

How are you adding the "RF" prefix?

 

[bufftrek]

Unfortunately I am not in front of the POS currently but I believe it is under the 'Refill' tab under Item Classes

 

[BootstrapperRI]

Does the menu item report show the individual menu items sold at at what price? Any zero price would be a refill.

David Jenulis

http://www.ncbpinc.com

 

[pmegan]

Ok, cool. So you're using the actual refill functionality, not a workaround with levels or something like that.

I've only used refills once for a short promotion, so never really dug into them. I can't find anything in the reports that shows refills, but you can find them using SQL. There's a column in the mi_dtl table called refill_dtl_id. This is usually null, but when an item is rung in as a refill, this field is set to the dtl.dtl_id value for the original menu item. You can join together the trans_dtl, dtl, and mi_dtl tables, then sum up dtl.rpt_cnt grouped by trans_dtl.business_date and mi_dtl.mi_seq where mi_dtl.refill_dtl_id is not null.

 

[bufftrek]

Ok then. I was able to find the refill_dtl_id column but hadn't quite figured out how it was tracking counts. Essentially I'm trying to determine refill counts per an item rang in for inventory purposes. I have a client that unfortunately has unlimited refills on Liquors and Drafts. I've got the functionality in Micros set up but now I'm tasked with creating some alternate reports for tracking purposes (start looking at percentage of refills per employee class by employee, for example).

Thanks for your help again guys - your info has been the greatest wealth of information I've found and somehow I'm starting to pick up some SQL to boot from the code snippets that are posted!