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 possible to link 1 modifier to it's parent item? Essentially I get the following if I run a consolidated sales report:
[ul]
[li]Jack Daniels: 4 sold[/li]
[li]Grey Goose 3 sold[/li]
[li]$ Rocks: 1 sold[/li]
[li]$ Double: 3 sold[/li]
[/ul]
I'm trying to get the following:
[ul]
[li]Jack Daniels: 4 sold[/li]
[li]Rocks [Jack Daniels]: 1 sold[/li]
[li]Double [Jack Daniels]: 2 sold[/li]
[li]Grey Goose: 3 sold[/li]
[li]Double [Grey Goose]: 1 sold[/li]
[/ul]
[ul]
[li]Jack Daniels: 4 sold[/li]
[li]Grey Goose 3 sold[/li]
[li]$ Rocks: 1 sold[/li]
[li]$ Double: 3 sold[/li]
[/ul]
I'm trying to get the following:
[ul]
[li]Jack Daniels: 4 sold[/li]
[li]Rocks [Jack Daniels]: 1 sold[/li]
[li]Double [Jack Daniels]: 2 sold[/li]
[li]Grey Goose: 3 sold[/li]
[li]Double [Grey Goose]: 1 sold[/li]
[/ul]