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
Post Code Analysis
Viewed 1809 times since Wed, Jun 13, 2012
Large File Sizes
Viewed 2115 times since Mon, Jun 11, 2012
A1 Background Note on EDI
Viewed 1535 times since Thu, Jul 5, 2012
Customer / Product History Enquiry
Viewed 4510 times since Tue, Jun 12, 2012
Image Display on Maintenance Screens
Viewed 2428 times since Wed, Jun 13, 2012
L7 - User Defined Reports
Viewed 1967 times since Thu, Jun 28, 2012
Default Printer / Tray Settings
Viewed 2173 times since Wed, Jun 13, 2012
Landing Pages - Filters – Context Sensitive or Global
Viewed 54 times since Thu, Oct 17, 2024
Desktop Database Tools - Additional F4-Select Options
Viewed 2345 times since Fri, Jun 8, 2012
Database Utilities
Viewed 1522 times since Fri, Jun 29, 2012