|
midrange.com
Store by week? Gee, our week starts on Friday and ends on Thursday
including payroll and accounting. We have 13 periods. Each period is 4
weeks except for every 5 years we have one 5 week period.
(52weeks*7days/week=364days, 365days/year-364days=1day, 1day*5years=5days,
2 leap days for every 5 years + 1 extra day per year = 7 days or 1 week).
Our fiscal year is very closely aligned with a calendar year. Something we
switched several years ago when we started spawning a plethora of Chapter S
corporations which legally require that you be closely aligned with a
calendar year. And, yes, every 5 years I switch visitation weekends with
my ex regarding our daughter. I have to keep the weekend 2 weeks prior to
closing open in case it's my turn to work the scheduled down times.
Rob Berendt
==================
Remember the Cole!
Buck Calabro
<buck.calabro@aptissof To:
MIDRANGE-L@midrange.com
tware.com> cc:
Sent by: Subject: Re: Fw: fiscal
year change
owner-midrange-l@midra
nge.com
12/21/00 09:59 AM
Please respond to
MIDRANGE-L
Ken Sims wrote:
>>I've also worked with companies that have changed their idea of what
>>constitutes a year, so by hard knocks, now keep all data by calendar
>>month (it never changes). A control file has the fiscal start month to
>>use as an offset.
>
>And what about companies that use a 13 period system?
It takes a bit more work, but if you normalise the files and store by week,
I've been able to handle swaps between a 12 month calendar and a 13 period
calendar. If the original poster gets to re-design in Utopia, perhaps he
can store each day separately. Either way (from month to (period or week
or
day)) the fundamental business rules have to change. It doesn't do much
good to try to accumulate data on a weekly basis if you run a batch at end
of month...
Daily has several advantages: more current data, flexibility in reporting,
can readily adapt to "outside" system (i.e. Corporate Headquarters).
Disadvantages: application must post daily, more complex reporting (i.e.
what days made up quarter 1? Create a calendar file and join to it?), disk
space (is that an issue any more?)
Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
