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

Micros3700 Delivery Dispatch

Status
Not open for further replies.

Jsmarty

MIS
Feb 22, 2011
78
KW
Hi All,
We are facing issue in delivery dispatch
check created and by using delivery dipatch this check transfer to driver,
by mistake without making driver return they closed a check from normal POS Operation
now this driver in screen showing 1 check open but when we double click driver there is no check and if we trying to make driver return this is also not happening,
we are unable to transfer anymore order to this driver

Any solution for this

THANKS
 
We have had the same issue come up occasionally. This is how we resolve it. You may have to make adjustments based on your order type numbers though (our delivery types are 2 & 5 and carry-out is 1). You may also have different distribution status definitions to us as well.

To search for the offending check
SQL:
select * from micros.chk_dtl
where order_type_seq in (2,5) and
sub_ttl = 0.00 and
distribution_status = 100
order by chk_open_date_time desc

Once you have found the check
SQL:
update micros.chk_dtl
set chk_open = 'T',
order_type_seq = 1,
distribution_status = 30
where chk_seq = xxxxx
commit;

The go to ops and open your Unpaid Guest Checks. Select the check to open it (it should be a carry-out type now). Add a low value item to it and tender the check to close it. Re-open dispatch, select the driver and do a driver return. The "ghost" order should now be cleared.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top