Storing a digital copy of Micros 3700 receipts

[CathalMF]

When i close a check through the Micros API it returns the print line array which i am storing in a database for later use.

I would also like to store a digital copy of the receipts when checks are closed normally on the workstations via Cash or Credit Card and I would like to have it in the same format as it is printed on the Micros printers.

So far i have failed to find a way to do this without having to build the check receipt myself through a SIM script.

It would be excellent if i could configure a workstation to print to two receipt printers. I could configure one as being the physical printer and the other as a disk file, however i cannot find a way to do this.

Any ideas?




Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

Does the 3700 have a report like 9700 system does (NetVu point and MyMicros)? Sorry, I am not that familiar with the 3700 system (I'm a pro at the 9700 system).

Do you have a physical Printer that prints the receipt? If not, does the 3700 allow you to setup a printer that writes to a file on the server?

 

[CathalMF]

Yes we also have MyMicros but using it is not an option as it's remotely hosted.

I can configure it to print to a disk file but that would cause a loss of physical printing.



Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

I know the info is stored in the DB, I don't know where off hand. Maybe pmegan or Moregelen might know where.

 

[CathalMF]

Yes the sales data is stored in the db but its not formatted as it prints on the receipt. I'm very familiar with the db contents.
I want to avoid having to build the receipt myself but it looks like that's my only option.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

9700 has an image/journal area.

For the 9700, it is located here. LOCATION_ACTIVITY_DB.dbo.POS_JOURNAL_LOG

SELECT
	rvc.revenueCenterPOSRef as RVCNUM
	,rvc.name
	,pjl.businessDate
	,pjl.transDateTime
	,pjl.type
	,pjl.employeeID
	,pjl.guestCheckID
	,pjl.checkNum
	,pjl.journalLogID
	,pjl.journalText

FROM LOCATION_ACTIVITY_DB.dbo.POS_JOURNAL_LOG pjl

Join LOCATION_ACTIVITY_DB.dbo.REVENUE_CENTER rvc on rvc.revenueCenterID = pjl.revenueCenterID

Where pjl.transDateTime >= '2015-02-23 00:00:00.000'

Order by pjl.transDateTime DESC

 

[CathalMF]

Yes, 3700 doesn't have the same.

9700 also has the CheckPrint.exe which is very useful.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

Sample output:

http://i58.tinypic.com/2cmlsa9.jpg

The journalText when copied can be pasted into a notepad and shown like it is when Printed.

 

[hosehead78]

Hmm, Yeah, sorry I am very limited with my 3700 knowledge (database wise).

 

[Wildbar]

You can run Transaction Analyzer at the end of night through an autosequence setup up to print the days receipts in bill format to the hard drive. Not sure how long it would take to print them all (or if it will with out crashing or getting stuck) We do something similar but only print a couple of bills that are flagged for certain reasons.

 

[CathalMF]

I was not aware the trans analyzer existed. It looks useful and gives the check details however it doesnt generate the receipts as they would print on the Micros printers. Unfortunately thats the main goal of what im trying to do.



Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[Wildbar]

Set transaction Analyzer to print as report type check. Once you get it setup run it as an external program in your end of night autosequence. We set the report to export as a pdf.

 

[CathalMF]

Yes i did that.

The result is like a receipt but not the same.
It doesnt show Vat lines, header, trailer or change due if its overtendered.

For my purposes i need this to be almost identical to the receipts that will print on the printers.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

Can you print to another Device Printer when all orders are done? So it prints the Receipt at the workstation and prints another one a remote printer.

 

[Moregelen]

I'd definitely be interested if you figure out a way to get a perfect digital copy of the receipt... have a signature capture program for the E-Series tablets, but it still prints a physical receipt with no option to email. If the guest wants a receipt the server has to run back to get it. It does print the signature on it, so this is good for record keeping, but avoiding the need for servers to go back inside every-time a guest wants a receipt would be great.

 

[pmegan]

Do you need printed copies as well? If not you can set the check printer to a disk file and use a SIM final tender event to read and process it.

 

[CathalMF]

@Moregeleen - Looks like ill just have to write a SIM script to generate a receipt which is as close as possible to the original but its unlikely to be perfect and wont take into account any changes that someone makes in the RVC Print Design.

@pmegan - Yes i need a printed copy too so i cant do this.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[CathalMF]

@Morgelen - I must do something in my spare time to query the database, format receipts and extract them to files on the server. Its not hard to get the information its just that the formatting of the receipt is tedious.

Ill let you know if i ever do it.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[DJensen999]

I have a script which prints a close reproduction of a receipt for coupon/discount redemption purposes. It might be a start to get an actual full receipt printed, for anyone looking for the same.

You'll need to remove the discount triggers near the top if you want it to print for all jobs.

Script is here. Disclaimer: I'm not the author on this one.

 

[Moregelen]

I mean, I have something that gets me close already, which I used to give a customer a way to print a catering quote basically. It does other things obviously in the background to prevent the check from being used to convince the customer that they paid, even though the server is pocketing the money. I just don't know how close this gets me given I haven't looked at it in a while.

STARTPRINT @RCPT
		//running subtotal
		VAR SUBTOTAL : $12
		
		//print the header
		FOR I = 1 TO ARRAYSIZE(HEADER)
			PRINTLINE HEADER[I]
		ENDFOR
		PRINTLINE ""
		
		VAR PADDING : A40 = "                                        "
		VAR TEMPPADDING : A40
		//print all of the items current rung up
		VAR COND_NAME : A40
		FOR I = 1 TO @NUMDTLT
			SUBTOTAL = SUBTOTAL + @DTL_TTL[I]
			IF @DTL_TYPE[I] = "M"
				IF @DTL_IS_COND[I] = 0
					FORMAT TEMPPADDING AS MID(PADDING, 1, 40-LEN(@DTL_NAME[I])-LEN(@DTL_TTL[I]))
					FORMAT CURRENTLINE AS CLEAR, @DTL_QTY[I], " ", @DTL_NAME[I], TEMPPADDING, @DTL_TTL[I]
				ELSE
					COND_NAME = @DTL_NAME[I]
					IF @DTL_QTY[I] > 1
						FORMAT COND_NAME AS @DTL_QTY[I], " ", @DTL_NAME[I]
					ENDIF

					FORMAT TEMPPADDING AS MID(PADDING, 1, 40-LEN(COND_NAME)-LEN(@DTL_TTL[I])-3)
					IF @DTL_TTL[I] > 0
						FORMAT CURRENTLINE AS CLEAR, "     ", COND_NAME, TEMPPADDING, @DTL_TTL[I]
					ELSE
						FORMAT CURRENTLINE AS CLEAR, "     ", COND_NAME
					ENDIF
				ENDIF
				PRINTLINE CURRENTLINE
			ENDIF
		ENDFOR
		
		PRINTLINE ""
		PRINTLINE ""
		
		FORMAT TEMPPADDING AS MID(PADDING, 1, 40-9-LEN(SUBTOTAL))
		FORMAT CURRENTLINE AS CLEAR, "Subtotal:", TEMPPADDING, "  ", SUBTOTAL
		PRINTLINE CURRENTLINE
		
		VAR CURRENTTAX : $12
		FOR I = 1 TO 8
			CURRENTTAX = CURRENTTAX + @TAX[I]
		ENDFOR
		
		FORMAT TEMPPADDING AS MID(PADDING, 1, 40-LEN("Tax:")-LEN(CURRENTTAX))
		FORMAT CURRENTLINE AS CLEAR, "Tax:", TEMPPADDING, "  ", CURRENTTAX
		PRINTLINE CURRENTLINE
		
		PRINTLINE ""
		PRINTLINE CLEAR, JUST_CENTER, @DWON, "Total: $ ", @TTLDUE
		PRINTLINE ""
		CALL GETNEXTBARCODE( BARCODE )
		CALL GETBARCODE( BARCODE, CURRENTLINE )
		PRINTLINE CURRENTLINE
		
		PRINTLINE CLEAR

	ENDPRINT