December 11, 2013 at 5:07 am
Koen Verbeeck (12/10/2013)
Greg Edwards-268690 (12/10/2013)
If a customer can change back and forth several times during the month, I'm missing some concept.Why would this freeze at the end of the month?
Billing is at the month level, so the last status of billable/non-billable is what we need.
Why does it change? I don't have that info yet, but I guess people change their mind a lot 🙂
It is interesting that with millions of records, most billable it sounds, this seems to be somewhat unknown.
Maybe a dart board is involved. 😀
Once a month - quite different from sending invoices daily.
And the concept in many businesses today - you pay me as soon as I ship, but I'll wait as long as possible to pay you.
December 11, 2013 at 5:15 am
Greg Edwards-268690 (12/11/2013)
Koen Verbeeck (12/10/2013)
Greg Edwards-268690 (12/10/2013)
If a customer can change back and forth several times during the month, I'm missing some concept.Why would this freeze at the end of the month?
Billing is at the month level, so the last status of billable/non-billable is what we need.
Why does it change? I don't have that info yet, but I guess people change their mind a lot 🙂
It is interesting that with millions of records, most billable it sounds, this seems to be somewhat unknown.
Maybe a dart board is involved. 😀
Once a month - quite different from sending invoices daily.
And the concept in many businesses today - you pay me as soon as I ship, but I'll wait as long as possible to pay you.
It's a bit like Azure: you only pay for your usage of the last month. You're not billed daily.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 11, 2013 at 6:46 am
Service Industry, not Mfg.
So the back and forth is bi-directional bandwidth!
Makes a lot more sense now, thank you for taking the time.
I hope for the most part, you have a situation where the bulk of the customers start as billable.
If they build over the period, then become billable, that opens a can of worms, depending on how they use it.
We had this with Production for the month.
There we used daily average rate for the month (planned) vs. actual.
So how you tracked to the plan MTD was the visual.
And same with Sales Plans.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply