Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting up Fiscal Year Budgets
Message
 
To
28/12/2003 11:43:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00862350
Message ID:
00862360
Views:
13
>I am working on a small application where I want the user to be able to setup their budget based off fiscal year (oct - nov). How do I have thesystem to automatically allow them to enter the data in and ensure that the months are properly populated without having to go through add physicall add the months? (is this confusing? )

Some shops enter and report by date ranges. For example, the first quarter would be allocations to months 10,11, and 12. At report time, for quarter one, the user would ask for allocations applied months 10 through 12.

However, if you want want to translate the months to quarters, you could set up a translation file:
Month     Quarter      Description
10        01           Quarter 1
11        01           Quarter 1
12        01           Quarter 1
01        02           Quarter 2
02        02           Quarter 2
.....
09        04           Quarter 4
This way, date based allocations could be allocated to fiscal quaters at report time.
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform