way to capture denominations counted for beginning/ending amounts?

It would have to be an add-in - I'm not aware of any that do this. THe built-in calculator just generates a sum of the values and enters that as the Cash value at open/close - it does not store the denomination counts entered.

Glenn Adams Tiber Creek C> When our cashiers count down the drawer to record beginning and ending

Thanks Glenn, I'll start looking at that as an option. When you enter opening/closing amounts, where does RMS write the count data, besides the TenderTotals table? To what other table(s) if any?

If I write an add-in for this I want to make sure that in addition to capturing the denomination data I need for cash, it also duplicates what RMS currently does

Thanks Kev> It would have to be an add-in - I'm not aware of any that do this. THe

filename="moneycalc.htm"

PGh0bWw+IDxoZWFkPiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KIDxTQ1JJUFQg TEFOR1VBR0U9IkphdmFTY3JpcHQiPg0KPCEtLSBCZWdpbg0KZnVuY3Rpb24gcyhudW0sIHZh bCkgew0KYW1vdW50ID0gbnVtICogMTsgLy8gYW1vdW50IGlzIHRoZSBudW0gb3IgTmFODQpz dW0gPSAoIW51bSA/IDAgOiBudW0pICogdmFsOyAgLy8gdGhlIHN1bSBmb3IgdGhhdCBiaWxs IG9yIGNvaW4NCg0KaWYgKGlzTmFOKGFtb3VudCkpIHsgLy8gaWYgdGhlIGVudGlyZSBpcyBu b3QgYSBudW1iZXINCg0KYWxlcnQoDQoiJyAiICsgbnVtICsgIiAnIGlzIG5vdCBhIHZhbGlk IGVudHJ5IGFuZCB0aGF0IGZpZWxkIHdpbGwgIg0KKyAibm90IGJlIGluY2x1ZGVkIGluIHRo ZSB0b3RhbCBtb25leSBjYWxjdWxhdGlvbi4iDQopOw0KDQpyZXR1cm4gMDsNCn0NCmVsc2UN CnJldHVybiBzdW07IC8vIGlmIGl0IGlzIE9LLCBzZW5kIHN1bSBiYWNrDQp9DQoNCmZ1bmN0 aW9uIG1vbmV5KGZvcm0pIHsNCmh1biA9IHMoZm9ybS5odW4udmFsdWUsIDEwMCk7IC8vIEVh Y2ggYW1vdW50IGlzIHRoZSByZXR1cm5lZCB2YWx1ZQ0KZmlmID0gcyhmb3JtLmZpZi52YWx1 ZSwgNTApOyAgLy8gZm9yIHRoZSBhbW91bnQgaW4gdGhlIHMoKSBmdW5jdGlvbg0KdHdlID0g cyhmb3JtLnR3ZS52YWx1ZSwgMjApOw0KdGVuID0gcyhmb3JtLnRlbi52YWx1ZSwgMTApOw0K Zml2ID0gcyhmb3JtLmZpdi52YWx1ZSwgNSk7DQpvbmUgPSBzKGZvcm0ub25lLnZhbHVlLCAx KTsNCmhsZiA9IHMoZm9ybS5obGYudmFsdWUsIC41KTsNCnF0ciA9IHMoZm9ybS5xdHIudmFs dWUsIC4yNSk7DQpkbWUgPSBzKGZvcm0uZG1lLnZhbHVlLCAuMSk7DQpuY2sgPSBzKGZvcm0u bmNrLnZhbHVlLCAuMDUpOw0KcG55ID0gcyhmb3JtLnBueS52YWx1ZSwgLjAxKTsNCg0KLy8g YWRkIHVwIGFsbCB0aGUgYW1vdW50cw0KdmFyIHR0bCA9IGh1biArIGZpZiArIHR3ZSArIHRl biArIGZpdg0KKyBvbmUgKyBobGYgKyBxdHIgKyBkbWUgKyBuY2sgKyBwbnk7DQoNCi8vIHJv dW5kcyB0b3RhbCB0byB0d28gZGVjaW1hbCBwbGFjZXMNCg0KdHRsID0gIiIgKyAoKE1hdGgu cm91bmQodHRsICogMTAwKSkgLyAxMDApOw0KDQpkZWMxID0gdHRsLnN1YnN0cmluZyh0dGwu bGVuZ3RoLTMsIHR0bC5sZW5ndGgtMik7DQpkZWMyID0gdHRsLnN1YnN0cmluZyh0dGwubGVu Z3RoLTIsIHR0bC5sZW5ndGgtMSk7DQoNCmlmIChkZWMxICE9ICcuJykgeyAvLyBhZGRzIHRy YWlsaW5nIHplcm9lcyBpZiBuZWNlc3NhcnkNCmlmIChkZWMyID09ICcuJykgdHRsICs9ICIw IjsNCmVsc2UgdHRsICs9ICIuMDAiOw0KfQ0KZm9ybS50b3RhbC52YWx1ZSA9ICIkICIgKyB0 dGw7IC8vIGRpc3BsYXkgdG90YWwgYW1vdW50DQp9DQovLyAgRW5kIC0tPg0KPC9zY3JpcHQ+ DQo8L2hlYWQ+ICA8Ym9keSBiZ2NvbG9yPSIjZmZmZmZmIiBURVhUPSIjMDAwMDAwIiBBTElO Sz0iI2NjNjZmZiIgVkxJTks9IiNjYzY2ZmYiIExJTks9IiM5OTAwZmYiPg0KPGJhc2Vmb250 IHNpemU9IjIiPg0KPCEtLUFEIEJBTk5FUlMtLT4NCjxjZW50ZXI+DQo8YnI+ICAgIDx0YWJs ZSBib3JkZXI9IjAiIHdpZHRoPSI1MDAiIGNlbGxwYWRkaW5nPSIyIiBjZWxsc3BhY2luZz0i MiI+ICAgICA8dHI+ICAgICAgIDwhLS1CRUdJTiBBUlRJQ0xFIE9QRU4tLT4gICAgICAgICAg PHRkIGFsaWduPSJsZWZ0IiB2YWxpZ249InRvcCIgd2lkdGg9IjQ2NSI+ICAgICAgICAgIDxw IGFsaWduPSJsZWZ0Ij4NCgk8Zm9udCBzaXplPSI0Ij48Qj48ST5Nb25leSBDYWxjdWxhdG9y PC9JPjwvYj48L2ZvbnQ+PGNlbnRlcj4NCjxmb3JtIG5hbWU9Y29pbmZvcm0+DQo8dGFibGUg Ym9yZGVyPTE+DQo8dHI+DQo8dGQgYWxpZ249Y2VudGVyPiQgMTAwPC90ZD4NCjx0ZCBhbGln bj1jZW50ZXI+JCA1MDwvdGQ+DQo8dGQgYWxpZ249Y2VudGVyPiQgMjA8L3RkPg0KPHRkIGFs aWduPWNlbnRlcj4kIDEwPC90ZD4NCjx0ZCBhbGlnbj1jZW50ZXI+JCA1PC90ZD4NCjx0ZCBh bGlnbj1jZW50ZXI+JCAxPC90ZD4NCjwvdHI+DQo8dHI+DQo8dGQgYWxpZ249Y2VudGVyPjxp bnB1dCB0eXBlPXRleHQgbmFtZT1odW4gc2l6ZT0zPjwvdGQ+DQo8dGQgYWxpZ249Y2VudGVy PjxpbnB1dCB0eXBlPXRleHQgbmFtZT1maWYgc2l6ZT0zPjwvdGQ+DQo8dGQgYWxpZ249Y2Vu dGVyPjxpbnB1dCB0eXBlPXRleHQgbmFtZT10d2Ugc2l6ZT0zPjwvdGQ+DQo8dGQgYWxpZ249 Y2VudGVyPjxpbnB1dCB0eXBlPXRleHQgbmFtZT10ZW4gc2l6ZT0zPjwvdGQ+DQo8dGQgYWxp Z249Y2VudGVyPjxpbnB1dCB0eXBlPXRleHQgbmFtZT1maXYgc2l6ZT0zPjwvdGQ+DQo8dGQg YWxpZ249Y2VudGVyPjxpbnB1dCB0eXBlPXRleHQgbmFtZT1vbmUgc2l6ZT0zPjwvdGQ+DQo8 L3RyPg0KPHRyPg0KPHRkIGNvbHNwYW49Nj6gPC90ZD4NCjwvdHI+DQo8dHI+DQo8dGQ+oDwv dGQ+DQo8dGQgYWxpZ249Y2VudGVyPjUwIKI8L3RkPg0KPHRkIGFsaWduPWNlbnRlcj4yNSCi PC90ZD4NCjx0ZCBhbGlnbj1jZW50ZXI+MTAgojwvdGQ+DQo8dGQgYWxpZ249Y2VudGVyPjUg ojwvdGQ+DQo8dGQgYWxpZ249Y2VudGVyPjEgojwvdGQ+DQo8L3RyPg0KPHRyPg0KPHRkPqA8 L3RkPg0KPHRkIGFsaWduPWNlbnRlcj48aW5wdXQgdHlwZT10ZXh0IG5hbWU9aGxmIHNpemU9 Mz48L3RkPg0KPHRkIGFsaWduPWNlbnRlcj48aW5wdXQgdHlwZT10ZXh0IG5hbWU9cXRyIHNp emU9Mz48L3RkPg0KPHRkIGFsaWduPWNlbnRlcj48aW5wdXQgdHlwZT10ZXh0IG5hbWU9ZG1l IHNpemU9Mz48L3RkPg0KPHRkIGFsaWduPWNlbnRlcj48aW5wdXQgdHlwZT10ZXh0IG5hbWU9 bmNrIHNpemU9Mz48L3RkPg0KPHRkIGFsaWduPWNlbnRlcj48aW5wdXQgdHlwZT10ZXh0IG5h bWU9cG55IHNpemU9Mz48L3RkPg0KPC90cj4NCjx0cj4NCjx0ZCBjb2xzcGFuPTUgYWxpZ249 Y2VudGVyPg0KPGlucHV0IHR5cGU9YnV0dG9uIG5hbWU9Y2FsYyB2YWx1ZT0iQ2FsY3VsYXRl IiBvbkNsaWNrPSJqYXZhc2NyaXB0Om1vbmV5KHRoaXMuZm9ybSkiPqANCjxpbnB1dCB0eXBl PXRleHQgbmFtZT10b3RhbCBzaXplPTEwPg0KPC90ZD4NCjwvdHI+DQo8L3RhYmxlPg0KPC9m b3JtPg0KPC9jZW50ZXI+DQo8L1A+DQo8QlI+DQo8L3RkPjwvdHI+PC90YWJsZT4gDQo8L2Jv ZHk+IDwvaHRtbD4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCQkgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAkJICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIAkJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAkJICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAJCSAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAJCSAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAJCSAgICAgICAg IA=--------------080305050505090006090908--

I don't see what this is doing differently from the built in denomination calculator in RMS. Am I missing something?

Glenn Adams Tiber Creek C> We had the same problem.

Thanks for the reply, but it looks like this just creates a form to input the denominations, then gives you a grand total for the cash field in your openings amounts and as Glenn said I can already accomplish this with RMS's input form. I need to take it a step further and have it actually record the total quantities for each separate denomination to a table in the DB, presumably by batch number.

Any other ideas - Glenn or anyone? Appreciate any help, thanks

Kevin

"Glenn Adams [MVP - Retail Mgmt]" wrote:

You could actually add that feature to this HTML addin. You'd have to create a table, then you can insert into it from the add-in. You'd need to do some error checking and make sure that the batch totals were not already entered. As long as you only touch your newly created table you can't do any real damage though...

Glenn Adams Tiber Creek C> Thanks for the reply, but it looks like this just creates a form to input the

What denomination calculator in RMS? is there one? I can't find it in help...

...I have never seen this in any documentation or the expensive training I went through.

Mickie

"Glenn Adams [MVP - Retail Mgmt]" wrote:

When you go into enter opening/closing amount screen, on the bottom left is the button for the denomination calculator. Craig

I know that - the issue is that this denomination-specific information is not stored in the DB after the opening amounts are entered - only a total dollar amount for the cash is saved in the DB

"Craig" wrote:

Before that will work, you have to edit the Cash Tender Type to define the denominations. On the Tender Type properties for "Cash" type tenders, there is a "denominations" button - click that, then enter the names and values for your denominations and the calculator on the open/close window will start displaying them.

Glenn Adams Tiber Creek C> When you go into enter opening/closing amount screen, on the bottom left is