Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 got to love it

Author  Topic 

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-01-25 : 11:42:56
Controller: I want you to create a screen that shows all sales commissions on invoices paid for a period.

IT: Ok we can do that.

Controller: They have to be paid complete.

IT: Ok we can do that. But we need to change the sales order to reflect commissionable and non commissionable items.

Controller: No we don’t need to do that.

IT: If we do not do that the totals will not be correct.

Controller: Oh we are not going to use the screen we will figure it out by hand. It’s too sensitive to leave to the computer.


W.T.F. I wish they would let me issue stupid signs.



Jim
Users <> Logic

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-25 : 11:53:00
You ask too many questions...

Just build him the damn thing....and let them keep coming back...

Too bad you're not hourly..



Brett

8-)
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-01-25 : 11:57:40
"her"

working 10-14 hours a day on sal I dont have time for this S#!^.



Jim
Users <> Logic
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-25 : 12:16:59
You need another body or 2....

btw...do you have task lists with difficulty ratings and priorities?

put it on the list until she forgets about it...



Brett

8-)
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-01-25 : 12:42:46
Would prefer to rip off head and crap down neck.

Sorry folks it's just one of those days.

Jim
Users <> Logic
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-01-25 : 12:46:28
Jim, go to happy place.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-25 : 12:52:29
Look!

It's Jim and the controller

http://www.calumetcarton.com/html2/meet_us.asp





Brett

8-)
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-01-25 : 13:00:40
The gal on the top is our sales office manager.

The guy on the bottom was one of our carton designers.
He had to leave as his Parkinson’s got too bad.


Jim




Jim
Users <> Logic
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2005-01-25 : 14:32:21
quote:
Originally posted by JimL

Controller: Oh we are not going to use the screen we will figure it out by hand. It’s too sensitive to leave to the computer.
Organizations (and especially sales organizations) are microcosoms of politics. There's the usual position and power found in any organization but sales has bonuses for goals mixed with monthly commissions owed which are usually calculated behind closed doors and in anything but an up-front manner. The rational for your requirement not including valid totals to yield commissions translates roughtly into something like:
quote:
We don't want commissions owed to be clear as we tend to move things all around the last week of the month to reward our buddies and <explicative-deleted> those who are out of step. Additionally, we don't want our managers to get their data from anything but our own memorandum.
Sort of unrelated, but this reminds me of a genius who rewarded a manager by allocating an end of year bonus if spending was kept under a certain level. I saw this setup cost the company millions in revenues by not spending a few thousand, all in the name of collecting his/her end-of-year bonus.

But then I'm off-topic here.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-25 : 19:16:40
Sam-

I don't know how you did it, but you described the EXACT scenario I worked in when I designed a commission-tracking database to replace the old Excel sheets they were using. Fortunately after about six months I was able to hand it over to the commissions processor and she did all the customizations.

Unfortunately, making it easier to calculate commissions also made it easier for sales managers to add shit that would help out the underachievers, the frauds, etc. She spent so much of her time UNDOING the calculations that it took almost as long to process them as it did in Excel, and probably with more effort.

If I had known, I would've put in a random-number generator and let the whole thing run off of it. I'm not kidding, with all the data-monkeying they ended up doing it would've turned out exactly the same numbers.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-25 : 20:23:15
Hey, you've worked with data rectangles too! Did you get rid of the "nasty couplings" ?


Damian
Go to Top of Page
   

- Advertisement -