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
List Matrix Entries
Viewed 1812 times since Mon, Nov 25, 2013
X – Custom Point (if applicable)
Viewed 773 times since Fri, Jun 29, 2012
Confirm Printer - Sales/Purchase Batch Updates
Viewed 1694 times since Thu, Jul 5, 2012
Alternate Panels in Ledger Enquiry
Viewed 1980 times since Tue, Jun 12, 2012
F4 Search - Default Search Method
Viewed 1935 times since Fri, Jun 8, 2012
Contact and CRM Management
Viewed 2221 times since Tue, Jun 27, 2017
Screen Actions - Additional F4-Select Options
Viewed 1498 times since Fri, Jun 8, 2012
Data Interchange Omit First Row from Import
Viewed 1995 times since Fri, May 27, 2016
Additional Display Options for Nominal / Cashbook Enquiry
Viewed 2157 times since Fri, Oct 26, 2012
Report Specification - Sales/Purchase Batch Updates
Viewed 1723 times since Thu, Jul 5, 2012