Home » Categories » Multiple Categories

Forecast Dates - Additional Options

Forecast dates allow you to analyse date’s in different ways.  Existing option types allow you to add set number of days to a base date, show the Age in years/months/days, show the week in year of the base date and so on. New options have been added to allow for the calculation of expiry dates based on a set number of months or years and to calculate a ‘due date’ with our standard credit terms.

            H-Month Expiry – when creating a forecast date for a month expiry it asks for base date and a data item/constant value.  If, for example, you have a base date of 17/11/2014 and add 1 from a data item / constant then the expiry date would be 16/12/2014, add 2 then expiry date would be 16/01/2015 and so on.

 

            Y-Year Expiry – when creating a forecast date for a year expiry the system asks for the base date and a data item/constant value.  If, for example, you have a base date of 17/11/2014 and add 1 from a data item/constant then the expiry date would be 16/11/2015, add 2 then expiry date would be 16/11/2016 and so on.

 

            C-Credit Terms – when creating a forecast date for a due date the system asks for the base date and a data item containing the credit terms value.  Usual DF credit terms can be used - D30, D60, M131, M231 and so on.

 

In addition to the above the type D/E forecast dates will now allow setting the base date against another forecast date (types D/E/H/Y/C) and not just standard date item types.

Custom Fields
  • Release ID: 6.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
G1 – Global Update to a Database
Viewed 713 times since Thu, Jun 28, 2012
Output to Excel Pivot Table
Viewed 23882 times since Tue, Jun 12, 2012
Additional Display Options for Nominal / Cashbook Enquiry
Viewed 1920 times since Fri, Oct 26, 2012
Password Security
Viewed 670 times since Thu, Jun 18, 2020
Event Logging - Record Deletion
Viewed 1745 times since Wed, Sep 21, 2016
Additional Forecast Date Options
Viewed 2298 times since Mon, Jun 11, 2012
Print Scans to PDF
Viewed 1702 times since Mon, Jun 11, 2012
Copy to Clipboard - Use <TAB> Delimiter
Viewed 3422 times since Fri, Oct 26, 2012
G - Global Update
Viewed 1133 times since Thu, Jun 28, 2012