Sim guru needed 1

[azrobert]

Hello,
I have been working on a gift card interface for a while now. It accesses a remote sql server database for card information and I have most everything working. I am looking for ideas or code to do a manager approval for some transactions within my sim code, and have not found an easy way to do it yet.
any one have any ideas ?

Thanks in advance
Robert

 

[jd11111]

you could use sim privilige levels for each transaction...

I think it is @EMPLOPT...

so you could start the inquiry with (assume managers have the highest level of 4)

if @EMPLOPT[4]

 

[azrobert]

That cold kind of work, but then a manager would have to initiate the transaction, I am looking fot a way to have a manager have to authorize the transaction, kind of like a void.

 

[jd11111]

what if you called an autosequence that only prompts for manager authorization before moving on to the actual transaction?

 

[azrobert]

That is brilliant..... I will look into that

 

[azrobert]

Now I just have to figure out how to call an autoseq from
sim... I have never needed to do that....
Any ideas ?

 

[jd11111]

you might try using a macro....
so the touchscreen key calls a macro which calls the autosequence first then calls the sim?

not sure if this would work...

 

[azrobert]

Using the touchscreen key to call a macro that calls an empty autoseq with manager privlege, then calls the sim event works great!!!!!

 

[jd11111]

I recently wrote a similar SIM. How are you handling the void of a gift card tender?

 

[azrobert]

I am not adding the tenders to the tickets yet.... I would like to but have not gotten that far. Right now I am manually tendering them as we did in the past as if it were a old style papaer certificate. I am adding the service charge manually to a ticket when the certificate is sold though. I allow for a gratuity to be added to my gift certificates so the tender part has been a little hard for me to figure out. I kind of wanted to treat them like a credit card, but haven't figured out a way to put an auth on the ticket and then final tender later.... Right now the whole interface is kind of a seperate program inside Micros that handles the sale, redeems, recharges, reprints and voids directly to my sql server database.

I am always looking for ways to improve it though....
my sim skills are rough, I attended a Micros sim training class several years ago and have not done that much sim work. Most of my programing with Micros has been mining data from the system for our corporate accounting and payroll. This is my first heavy use of sim.

 

[jd11111]

I would probably do at least couple sql tables for this

cert definition (with current balance)
transactions (redeem, void, sale, authorize, etc.)

You could have a column in the definition table for authorizations, so when you authorize a certificate you update the auth column with that amount. The balance check query would have to subtract the auth amount from the balance.

Then when finalizing the total amount with tip, you would have to update the auth amount back to 0 then update the balance appropriately (auth + tip). The transaction table should have a field for tip amount also.

For any transactions not finalized, you could have a stored procedure that runs nightly to clear any authorized amounts.

hope that helps when you get to that stage.