Wow, I didn't think this would be that tough. I must be explaining it badly since it has to be a common funcion. All i want is the check subtotal and all the line itens that contributed to that total. Much like a check would have to use.
Thank you Michelle, What I am trying to do is get two tables exported, the check level data in one, the check detail data in another. But in order to insure we missed nothing an audit is done to check that the detail charges add up to the check total. So using your query I get this. ( I...
Perhaps another way to skin this cat is to ask is there a report that shows check header and check detail line the receipt would. It should have the correct query to get a check number, line items, and totals that match.
pmegan,
Thank you. I tried this and got same responce, howerver while putting togeher this post show the raw data does nto even match i noticed what appears to be the issue,
If the last two records were not there it totals properly... and their trans_seq number differs.
Dtl:
trans_seq...
Thank you for the assist. I ran that query and got the same results. The sum is in there solely to keep from using a calculator. The real issue is the the sum of the lineitems does not match the check subtotal. here are the results using that query. Note the sum of salesvalue = 158.48 but...
Hello gentlemen.
I have gone from gray'ed haired trying to figure this out. I am simply retrieving check level info and detail level info for each check and expect the sum of charges on the lineitem record to be = to some value in the chk_dtl table, i would expect subtotal. However virtually...
I see a lot of traffic involving what seems to be the programers way of interfacing to E7, the TIF DLL? Can anyone tell me where you get the docs on how to use that?
Hi there. I have a micros E7 install with terminals and a back office. We need to pull sales data so I added a step to the eod autosequence to export the item detailed sales report. It is not generating any report. I added the same to preclose so I could test it without closing and it worked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.