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, however, I'm not seeing a programmatic way to assign multiple modifiers to their respective single parent item. In case this isn't clear, consider the following transaction:
Grey Goose
Martini up
Absolut
Double
The previous two items are easily converted to "Grey Goose, Martini Up" and "Absolut, Double" as each modifier clearly defines what Item Number it modified (seen within the GNDITEM.DBF). Unfortunately, the following example becomes an issue:
Grey Goose
Martini Up
Lime
Since the modifiers only relate to an item number (as opposed to a line item or unique transaction number) I'm having an issue assuredly assigning a group of modifiers to a single parent item.
With all of that being said, is anybody familiar with either of the following:
- GNDITEM.DBF has a EntryID column that appears to be a uniquely assigned that follows some semblance of a sequence but does not consist of fully consecutive integers. I assume this is a transaction record of sorts. Are the missing items in the apparent sequence logged elsewhere (I have found some in GNDVOID and GNDLINE but they were obvious)?
- Is GNDITEM.DBF a direct representation of when buttons are pressed or simply when items are 'sent'. In other words, can I expect all modifiers to immediately follow their parent without interruption in the sequence despite sales potentially being rang on other terminals at the same time.
Thanks again for any insight into these questions!
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, however, I'm not seeing a programmatic way to assign multiple modifiers to their respective single parent item. In case this isn't clear, consider the following transaction:
Grey Goose
Martini up
Absolut
Double
The previous two items are easily converted to "Grey Goose, Martini Up" and "Absolut, Double" as each modifier clearly defines what Item Number it modified (seen within the GNDITEM.DBF). Unfortunately, the following example becomes an issue:
Grey Goose
Martini Up
Lime
Since the modifiers only relate to an item number (as opposed to a line item or unique transaction number) I'm having an issue assuredly assigning a group of modifiers to a single parent item.
With all of that being said, is anybody familiar with either of the following:
- GNDITEM.DBF has a EntryID column that appears to be a uniquely assigned that follows some semblance of a sequence but does not consist of fully consecutive integers. I assume this is a transaction record of sorts. Are the missing items in the apparent sequence logged elsewhere (I have found some in GNDVOID and GNDLINE but they were obvious)?
- Is GNDITEM.DBF a direct representation of when buttons are pressed or simply when items are 'sent'. In other words, can I expect all modifiers to immediately follow their parent without interruption in the sequence despite sales potentially being rang on other terminals at the same time.
Thanks again for any insight into these questions!