Home » Categories » Multiple Categories

Increment Document Date at Set Time

Datafile Software

Increment Document Date at Set Time

Order processing documents, particularly on the Sales Order side, are usually processed at today’s date. In some organisations at a particular point in the day – often relating to delivery collections – documents will need to be processed with the next day’s date and the operator must remember to update this date and, if exit from the document process, remember to set again each time the document is opened. This new feature allows the setting of a system time at which to clock on to tomorrows date and also, optionally, skip weekends and bank holidays.

Installation

Document Design Parameters

The configuration settings for the new ‘increment date’ option are included within the document design. To update select Installation from the main menu followed by, if Diamond or Premier, the option Application Manager and then Document Design Manager. Professional users should select Installation from the main menu and then Document Design Manager. Select Sales Order Documents or Purchase Order Processing as required and then select the document type before entering the number of the document you wish to update.

Once the document mask is displayed select the Parameters option at the top of the screen before selecting the ACTION button to move to screen 12 – Optional Features before clicking NEXT to move to screen 12a.


Use Today’s Date – the document date defaults to the system date which is usually today’s date but can be overridden by dates used in other options, setting this option forces the document to default to today’s date.

Clock on to next day at what time – enter the time in 24hr format at which to default the document to tomorrows date – i.e. 1545 / 1630 / etc.

When Clock On, Ignore Saturdays – if today’s date is a Saturday or Friday after the clock on time the system will, if set, ignore Saturdays and skip to the next day.

Ignore Sundays – similar to above but will (also) skip Sunday.

Ignore Bank Holidays – similar to above but will also skip Bank Holidays. Note however that the system uses the C29DATES.TXT file to determine which dates are bank holidays (this file is used with the special ‘!C29’ calculation option to determine the duration between two dates/times). When setting this option the system will warn if this file not found.

 C29DATES.TXT

 This file is a text file that can be maintained with any text editor (Notepad / WordPad etc.) which is created with a fixed layout in the DFCOMP location (usually \DFWIN\DATA). Its primary use is to calculate durations between start and end date/times but is now also used for this new feature to clock on the document date. The text file is formatted in a specific layout as below:

Line 1 – Flag if ignoring Saturdays in time calculations – Y or N

Line 2 – Flag if ignoring Sundays in time calculations – Y or N

Line 3 – Start of Working Day

Line 4 – End of Working Day

Lines 5-19 – records dates to be omitted from time calculations (bank holidays / firm closedowns etc.). The format is DD/MM/YY but all lines must be entered and if no date required set as XX/XX/XX.

 An example layout would therefore be:

Y

Y

0900

1700

01/01/10

02/01/10

16/04/10

19/04/10

01/05/10

31/05/10

25/08/10

24/12/10

25/12/10

31/12/10

XX/XX/XX

XX/XX/XX

XX/XX/XX

XX/XX/XX

XX/XX/XX

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Printer Settings - Document Design Manager
Viewed 1951 times since Wed, Jul 4, 2012
SOP Accessories Reports
Viewed 1551 times since Tue, Jul 3, 2012
Document Processing
Viewed 1515 times since Tue, Jul 3, 2012
Detail Optional 4
Viewed 1994 times since Wed, Jul 4, 2012
Order Entry - Alternative Title for Price/Cost
Viewed 2233 times since Fri, Oct 26, 2012
Report on Order Status
Viewed 1504 times since Tue, Jul 3, 2012
Pack Qty - Assume Detail Entry in Packs
Viewed 1978 times since Tue, Jun 12, 2012
Document Control Databases
Viewed 1524 times since Tue, Mar 3, 2020
Order Processing and Other Files
Viewed 1532 times since Tue, Jul 3, 2012
Change Order Status – Omit Option to Display in Sequence Entered
Viewed 136 times since Tue, Oct 15, 2024