Search results for query: *

Does anybody write custom Micros 3700 querys for compensation? In short, I have a script that pulls sales such that modifiers are paired with their parent items to make 'unique' items. This is working rather well but I no we need to start taking Price Levels into consideration. I have a...

I'm trying to programmatically pull sales info from our Micros 3700 POS for inventory purposes and am running into issues. While I can determine usage from individual line items (Jack Daniels, Grey Goose, etc), I'm having difficulties when it comes to modifiers such as Doubles and Rocks. Is it...

Does e7 have the capability to display a historical transaction report? I'm trying to determine various routes to determine who is ringing in product that we are finding losses for. Thank you!

Over a year ago I requested some help with a custom SQL query for Micros 3700 and it has proven quite beneficial (thank you pmegan!). The thread in reference is as follows: thread693-1764179 I am using it with a new client and all of a sudden I am getting a plethora of negative sales items. I...

Does Aloha have functionality for an employee with higher access levels (e.g. Manager/Shift Lead) to alter the price of a button mid-shift? I understand that this can be done in the Back Office but we are trying to completely lock down office access and one key thing has been impromptu price...

thread693-1765950 Since the aforementioned thread was started I have since taken up learning Python (as opposed to the suggested R due to ease of use) and and now on the right path to linking modifiers to their parent items to create unique items for inventory purposes. At this point...

Is there a way I can limit the number of times a specific modifier is selected? I understand that that the collective number of modifiers can have a min and max range but I was hoping I was missing something for individual buttons. An example is Liquor modifiers. I would like to limit the...

POS is Micros 3700. Our owner is tasking me with including line items for 6 choice items on each server's checkout. Essentially each of these items that is sold gets a small amount paid out by the bartender to the seller as a 'commission' of sorts. Any advice as to how to go about doing this...

I'm hoping that somebody might be able to point me in the correct direction with this. I have a client that is need VERY specific inventory tracking for alcohol, thus far I have found info via a suggestion to use a did viewer. Within the daily gnd files is a column for any item rang as a...

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

I am still learning a lot of the ins and outs of Micros and can't seem to find an option for a modifier to increase an item's base price by a multiplier modifier. In short, I would like to be able to use a Double modifier on bar items to simply increase the price by 2x (and have another...

Has anybody had any experience with a query that coalesces all item modifier to the patent item? I'm not abundantly familiar with the Micros Databasr and have been offered extremely helpful advice here once before on generating unique identifiers for items ran in at various menu levels...

I am using the following query to pull sales from Micros 3700: SELECT micros.trans_dtl.chk_seq as CheckNo, micros.mi_def.obj_num AS PLU, micros.mi_def.name_1 AS ItemName, (micros.dtl.rpt_cnt) AS Qty, micros.dtl.date_time AS DateTimeOrdered, micros.lan_node_def.name AS...

Quick question for those that may be able to help. I have been going through some of the truckloads of tables that Micros employs and I'm stuck at the moment. Are there any ways in which items are linked to other items when they are being used as modifiers? For example, if a user rings in a...

Essentially I have a situation where I have a number of liquor items that have 5 different price levels and then I have those same items as iterations of Doubles and Rocks (essentially Jack Daniels, DBL Jack Daniels, ROX Jack Daniels). All iterations have 5 different price levels and right now...

Regarding items and how they are rang in, I am being tasked with creating a new items for EACH general type of pour for EVERY liquor in house for a client. For example, they pour 'Shots', 'Doubles', 'Martini Rocks', and 'Martini Up' and I have created each of these items for each Vodka. This...

I work for an independent company that integrates with POS software to collect sales information. I have some experience working with databases but it has mostly been Micros - I am unfamiliar with Aloha's database structure so I'm hoping to glean some answers/insight/direction! In short, I...

I work for an independent company that integrates with POS software to collect sales information. As of recently, I moved to a territory where Micros modifies prices(for Rocks and Double upcharges, for example) by means of price levels vs. individual line items. I currently have the following...