I need to create a report of forecasted monthly depreciation expenses for a future date range.
So if an asset has a monthly dep. amount of $100.00 and a useful life of 60 months that started 10 months ago, I need to show this asset's forecast depreciation for the next 50 months (month by month). Any idea how I could explode a record times the number of remaining months in it's life?
If I had a period table that contained a record for each month from now until forever, I could use that. Unfortunately, I do not. I think the solution has something to do with a command table containing a SQL statement that provides a list of periods from now to a certain future date.
Any ideas ?
So if an asset has a monthly dep. amount of $100.00 and a useful life of 60 months that started 10 months ago, I need to show this asset's forecast depreciation for the next 50 months (month by month). Any idea how I could explode a record times the number of remaining months in it's life?
If I had a period table that contained a record for each month from now until forever, I could use that. Unfortunately, I do not. I think the solution has something to do with a command table containing a SQL statement that provides a list of periods from now to a certain future date.
Any ideas ?