Cash out report
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22526
Printed Date: 06 May 2024 at 9:55am
Topic: Cash out report
Posted By: Brenmac
Subject: Cash out report
Date Posted: 20 Jan 2018 at 6:25pm
I am trying to create an employee cash out report that will allow for paperless reporting. The issue that I am having is that the finance department has asked that the denominations being dropped are showing on the report and not just the total amount. Is there a way to achieve this?
For example if the amount of cash to be dropped is $100.00. Is there a way for Crystal to determine that the employee should drop 5 $20's?
Using Crystal XI
|
Replies:
Posted By: DBlank
Date Posted: 22 Jan 2018 at 3:03am
Why 5 $20s and not 1 $100 or 2 $50s or 1$50+1$20+2$10s+2$5s?
Do you have something in your data set that defines this?
|
Posted By: Brenmac
Date Posted: 22 Jan 2018 at 8:08am
|
At this point no. What I am planning on doing is having the employees enter their cashier ID into the parameters, which will pull all of their transactions for the day, and also enter their float count into the parameters ( 10 $5's, 20 $10's etc.). If their drop for the day is $100 but all they have is 5 $20's then obviously we don't want them to empty their float of $20's. Is there a way for CR to distinguish what would be the best option for the employee based on what is in their float?
|
Posted By: DBlank
Date Posted: 23 Jan 2018 at 3:51am
You would have to write the formula, following your preferred outcomes, to have it do that.
If you can write the logic out, likely you can accomplish it using a shared variable formula or possibly just a nested if-then formula.
|
Posted By: Brenmac
Date Posted: 23 Jan 2018 at 11:35am
Thank you for the input. I have started out with a few if then formulas and it seems to be working at this point.
Thanks again for your help.
|
|