RitwickGupta
Programmer
Hello,
I am trying to extract check details from a micros 3700 db. Everything is going fine till someone voids an item from the check on the POS.
For every item that has been voided, 2 rows are added to trans_dtl and mi_dtl.
For example,
When I add Pizza1 with extra pepper and Pizza2 with extra cheese, (They will both have same object number in reality)
but when I void it,
I can easily figure out that a Pizza2 has been deleted, but how do I link that pizza in sql/code to which pizza was deleted? I want to not retrieve the second pizza. Is there way to do that linking? I tried all the fields in trans_dtl and mi_dtl but I was not able to figure out.
Below is an image of explaining a similar situation in an image form. I have only kept the non common rows. Sorry the row headings are missing. Stupid Sybase export
Thanks a lot
I am trying to extract check details from a micros 3700 db. Everything is going fine till someone voids an item from the check on the POS.
For every item that has been voided, 2 rows are added to trans_dtl and mi_dtl.
For example,
When I add Pizza1 with extra pepper and Pizza2 with extra cheese, (They will both have same object number in reality)
Pizza $5
Pepper $1
Pizza $5
Cheese $2
but when I void it,
Pizza $5
Pepper $1
Pizza $5
Cheese $2
Pizza $0
Cheese $0
Pizza -$5
Cheese -$2
I can easily figure out that a Pizza2 has been deleted, but how do I link that pizza in sql/code to which pizza was deleted? I want to not retrieve the second pizza. Is there way to do that linking? I tried all the fields in trans_dtl and mi_dtl but I was not able to figure out.
Below is an image of explaining a similar situation in an image form. I have only kept the non common rows. Sorry the row headings are missing. Stupid Sybase export
Thanks a lot