Micros 3700 Open/Closing Totals Over/Short Report

[Andy16H]

I have contacted Micros about this and they tell me 4 to 6 weeks and would like me to use Cash Management. We are a small bar and in past have kept our Business Cash Deposits and Over/Short calculations on separate report in Excel. I would like to consolidate all of this into Micros and I've been told that I can solve this the following way.
New Button--Opening Deposit
New Button--Closing Deposit

Daily Sales Summary Report has the following items:
Cash
Paid In
Paid Out
Total Tips

I would like the Daily Sales Summary Report to have the following items:
Cash
Paid In
Paid Out
Total Tips
Opening Deposit
Closing Deposit
Business Cash Deposit
Over/Short

Items entered and Calculations:
Opening Deposit--Entered at Open
Closing Deposit--Entered at Close
Business Cash Deposit-- (Closing Deposit - Open Deposit - Total Tips)
Over/Short-- (Cash + Paid In - Paid Out - Total Tips - Business Cash Deposit)

Does anyone have any idea how to set this up or know any one I can hire to set this up?

 

[BootstrapperRI]

Hi,

CM may be a bit overkill for your application. What it will provide is some system controls on things like opening and closing deposit, cash drops, etc.

Either way (using CM or just creating non-revenue service charges and linking buttons) you will need to edit your reports using Crystal Reports. This should be done by someone with experience, as it can be difficult for the novice.

I would go to your dealer/district MICROS provider and pay them to do it, or continue with the spreadsheet. Some dealers/districts have custom reports that include some of what you are asking, with the exception of opening deposit (but this is a known amount that usually does not change). Ask your dealer/district if they have or can get some examples of these custom reports to look at. The older you current system is (thus the older your current report set is), the more likely they have reworked their custom reports to include these items.

 

[Andy16H]

I appreciate your response, but since my Micros Dealer was taken over by Corporate. It is next to impossible to get anything done. I was hoping to find some detailed instructions or someone that is interested in Freelance work.