Micros Checks Number of Prints

[jrahma]

Hi,

In Micros there is a report shows every check and how many times it was printed and the employee name.

I want to know how can I get this using SQL?


Thanks,
Jassim



Jassim Rahma

 

[mrunowho]

SELECT micros.chk_dtl.chk_num,
micros.chk_dtl.chk_prntd_cnt,
micros.emp_def.last_name,
micros.emp_def.first_name
FROM micros.chk_dtl JOIN micros.emp_def ON micros.chk_dtl.emp_seq = micros.emp_def.emp_seq

This will give you the Check #, # of times printed, and the employee first and last name.

 

[jrahma]

the employee name shown here.. is it the employee opened the check or printed it? because I can't see one check printed by more than one employee so I assume it's grouped check..

Am I correct?




Jassim Rahma

 

[pmegan]

It's the employee who owned the check.

 

[jrahma]

is there any way to get the employee who printed the check to know how many times check was printed and who printed each copy?




Jassim Rahma

 

[RitwickGupta]

That chk_prntd_cnt increases when I add something to the order and click send. Why is that? I just want to know if the check has been printed for the customer or not.