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
Batch Update Processing - Stock Batch Update
Viewed 1808 times since Thu, Jul 5, 2012
Table Maintenance
Viewed 1779 times since Mon, Nov 25, 2013
Ledger Enquiry - Application Panels – Allow Up to Ten Items / Faster Display
Viewed 55 times since Tue, Oct 15, 2024
Installation Details - Stock Batch Update
Viewed 1684 times since Thu, Jul 5, 2012
Ledger Enquiry - Alternate Link Item for History Databases
Viewed 245 times since Tue, Oct 15, 2024
Update Ledger from UDR (9903)
Viewed 1592 times since Fri, Jun 29, 2012
History Database Cross-Links
Viewed 2324 times since Tue, Jun 12, 2012
Stock Batch Update
Viewed 1679 times since Thu, Jul 5, 2012
Custom Features - Stock Batch Update
Viewed 1825 times since Thu, Jul 5, 2012
Warehouse Tablet - User-Defined Database Landing Page / Edit
Viewed 342 times since Thu, Jan 9, 2025