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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    I'm afraid I would not know how to check that.
  2. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    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.
  3. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    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...
  4. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    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.
  5. jfitchett

    Micros 3700 checkitem totals and check totals dont 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...
  6. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    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...
  7. jfitchett

    Micros 3700 checkitem totals and check totals dont match.

    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...
  8. jfitchett

    Micros E7 DLL

    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?
  9. jfitchett

    Micros E7 AutoSeq no running

    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...

Part and Inventory Search

Back
Top