Steve, Just thought I'd throw my pennies in here! I use a simple calculation to assign a fiscal period to all transactions to compile financials. I simply take the four digit year, multiply by 1000 and add the integer month value. So we would currently be on 200802. This is easy to assign based on a transaction date and calculated at the time of transaction entry without involving a lookup table. In addition to a transaction date (usually invoice date and payment date), I have 2 other fields (IPeriod and PPeriod), depending on if the customer is on a cash or accrual basis. In the company setup, I have the integer month for the first month of the fiscal year and all my calculations for YTD, LYTD, etc. are based on that. I can provide you with the argument I use to calculate that as well if you're interested!!!
Jan Barley --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
