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!

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

Micros 3700 Custom SQL Query

Status
Not open for further replies.

bufftrek

Technical User
May 13, 2014
68
US
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 client who shift price levels to create different portion sizes.

A shot of Jack Daniels will have 2 price levels. One for singles and one for doubles.
They also have "$ Rocks" upcharges.

So I would need tos create unique item names and PLUs for the following instances:

[ul]
[li]Jack Daniels[/li]
[li]Jack Daniels (Price 2)[/li]
[li]Jack Daniels, $ Rocks[/li]
[li]Jack Daniels (Price 2), $ Rocks[/li]
[/ul]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top