Fiscal Year

I have a report that currently gives totals depending on the MOYR you
enter (0405) and it works back to 0005, then it starts with 0405 and
subtracts 1 from yr (0404) and works back to 00 month. They want to
give an option to use fiscal year instead June-May. I am having a time
coming up with logic if you enter 0405 it needs to go back June I
guess. Any help would be appreciated.

In article <1114172830.129788.228170@l41g2000cwc.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>I have a report that currently gives totals depending on the MOYR you
>enter (0405) and it works back to 0005, then it starts with 0405 and
>subtracts 1 from yr (0404) and works back to 00 month. They want to
>give an option to use fiscal year instead June-May. I am having a time
>coming up with logic if you enter 0405 it needs to go back June I
>guess. Any help would be appreciated.

I am uncertain what it is that you need.  What you have at present appears
to be a routine which, given a month and a year, produces a report based
on the data from the calendar year preceding.

Your fiscal year runs from June - May.  Are you saying that if you run the
report using the fiscal year on 01 Aug 2005 you wish to see data only for
01 Jun 2005 - 31 Jul 2005?

DD

Yes. and the same for 01 Jun 2004- 31 July 2004

Sorry just got more info. The fiscal year can be any period, different
Companies use different. My example happened to be June-May, but it can
be March - Feb or any other. It's nice to get all the specs up front
huh?

In article <1114176910.053899.276720@z14g2000cwz.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>Sorry just got more info. The fiscal year can be any period, different
>Companies use different. My example happened to be June-May, but it can
>be March - Feb or any other. It's nice to get all the specs up front
>huh?

It certainly is... so there are multiple fiscal years which are determined
by the company for which the program is being run?  That might seem to be
taken care of by:

If Fiscal-Year-Option
Evaluate True
When First-Company
Move 06 To From-MM
If To-MM < 06
Compute From-YY = (To-YY - 1)
Else
Move To-YY To From-YY
End-If
When Second-Company
Move 02 To From-MM
If To-MM < 02
Compute From-YY = (To-YY - 1)
Else
Move To-YY To From-YY
End-If
End-Evaluate
End-If

... or is there something I am not understanding here?

DD

No, Sorry again, I guess I explained that wrong this is a standard
report, we have 180 companies that use this program the fiscal year
will be determined by a 2 digit code (beginning month) read from the
control-file. So It is parameter driven depending on parameter(98) = 06
or 02 or 12 or whatever.

No, Sorry again, I guess I explained that wrong this is a standard
report, we have 180 companies that use this program the fiscal year
will be determined by a 2 digit code (beginning month) read from the
control-file. So It is parameter driven depending on parameter(98) = 06
or 02 or 12 or whatever.

Jeff wrote:
> No, Sorry again, I guess I explained that wrong this is a standard
> report, we have 180 companies that use this program the fiscal year
> will be determined by a 2 digit code (beginning month) read from the
> control-file. So It is parameter driven depending on parameter(98) = 06
> or 02 or 12 or whatever.
>

Why not just keep a from-date/to-date in the control file? You only set
it once per year. We have companies that use a complete list of fiscal
periods, as they run on 13 4 w "months".  It is not like someone
enters it every day, and there is probably a professional handling year
ends.

Donald

In article <1114182239.613306.4270@l41g2000cwc.googlegroups.com>,
Jeff <jmoore207@hotmail.com> wrote:
>No, Sorry again, I guess I explained that wrong this is a standard
>report, we have 180 companies that use this program the fiscal year
>will be determined by a 2 digit code (beginning month) read from the
>control-file. So It is parameter driven depending on parameter(98) = 06
>or 02 or 12 or whatever.
>

I see... where does the solution proposed fall short of what you need?

DD

..    On  22.04.05
wrote  jmoore207@hotmail.com (Jeff)
on  /COMP/LANG/COBOL
in  1114182241.955579.64870@o13g2000cwo.googlegroups.com
about  Re: Fiscal Year


j> No, Sorry again, I guess I explained that wrong this is a standard
j> report, we have 180 companies that use this program the fiscal year
j> will be determined by a 2 digit code (beginning month) read from the
j> control-file. So It is parameter driven depending on parameter(98) =
j> 06 or 02 or 12 or whatever.

Frankly, I do not understand at all what is so complicated about
that?

The file which is to be reported or summariesed is sequentially
accessible via the date, isn't it? With an index on it, where you can
start with the appropriate month, right?

So, where is the problem?



Yours,
Lüko Willms                                     http://www.willms-edv.de
/--------- L.WILLMS@jpberlin.de -- Alle Rechte vorbehalten --

Wir wohnen in Göttingen in Scheiterhaufen, die mit Türen und Fenstern verseh
en sind. -G.C.Lichtenberg