Down To Earth - Patches

DTE v3.5 and prior Program Patches

The following program patches and download files are for Down To Earth supported customers. The specific applications, versions, and a summary of the change is also noted.

Patch downloads are not available for DTE versions prior to 3.5 -- please refer to the "Summary of change: " section for a detailed description or Contact us.

In all situations, once a changed program is installed into the source directory, system logicals must be assigned, the application(s) affected must be rebuilt. Once the executible program is rebuilt, Operators must log out and back into DTE again to reflect the new changes.

All Applications
System / Utility

Job Cost
Accounts Payable
General Ledger

Sales Order Entry
Payroll

All Applications
SynergyDE v9 series code changes

Code Examples

Contact Technical Support if you have any questions, plan to add a Vista client to your network, or wish to schedule a SynergyDE update.

Summary of Change:

With Windows ® exclusive Vista ® OS license distribution starting in July 2008, SynergyDE and consequently Down To Earth v3.5 require updates to run on any Vista PC.
Up-to-date ALM allows a "no cost" update to SynergyDE v9 for all Windows 32-bit networks or single user PCs.
Supported (Windows) DTE customers with v3.5 are automatically scheduled for a Down To Earth update.
Please Note: A SynergyDE update is not required for Vista PC connections to UNIX servers via terminal emulation or Windows network access via Remote Desktop Connection. The DTE update is required, however, if a UNIX server is updated to SynergyDE v9 series.

System Subroutine

dtedll.zip

The subroutine, dll_subr is replaced with dll_call and includes an additional argument, DLL_TYPE_WINAPI, within the call.

Summary of Change:

Without this change, an "Argument missing, Argument number was 8, at line 98 in routine WINLOGO, at line 153 in routine DTEMNU, called from line 165" displays when initializing dtemnu.dbr.
This change applies only to those customers operating with Synergy version 8.3 or higher and re-building DTE version 3.5 or before. The section of the UTS:dtedll.dbl program logic loads the initial splash graphic and the license agreement when first executing the software.
Replace the exisiting program with the file contained in the *dtedll.zip* download or *link to the source code example. (The system code changes are shown in blue bold* .)

System Utility

Inquiry and Find selection window displays are missing the field headings for current windows system codes. Instead, the (display) "page" number replaces the heading labels.

NOTE: All operators must exit Down To Earth and you must rebuild all utilities and applications to incorporate this change into your Down To Earth executables.

Summary of Change:

For Down To Earth version 3.4.1 or 3.5, running D2E in a Windows or NT environment, add the system codes for NTv5.x (15), WIN98 (16), WIN ME (17), WIN XP (18), and 2003 Server (19) to the list of existing system codes in the ifind.inc and clslp.dbl utility programs.
For Example, the system codes are listed in the third line of instruction of the ifind.inc file and the file is found in the directory assigned to the UTS logical.
The system code change is noted below in bold . Repeat the same codes for clslp.dbl and askpr.dbl program when the gui_flag is defined: xcall envrn (oper_sys) using oper_sys select (11,13,14, 15,16,17,18,19 ), gui_flag = 1 ( ), clear gui_flag endusing eof = false
It is suggested to make a backup copy of the EXE directory and use the bldallv6w batch file found in the directory assigned to the D2EHOME logical to rebuild.

System Manager
application

sm8000_35.zip

The Down To Earth version 3.4.1 or 3.5 Initialize data files programs require a change for current hardware systems.

System Manager application, sm8000.dbl and Utility utinit.dbl programs, must also be updated to reflect NTv5.x (15), WIN98 (16), WIN ME (17), WIN XP (18), and 2003 Server (19) system codes.

Summary of Change:

The system code change is noted below in bold and included in the downloadable file, sm8000_35.zip:
case sys_code of begincase 04: clear flag ; tsx-plus 06: nop ; vms 07: clear flag ; ms-dos 08: clear flag ; unix 09: clear flag ; networks 10: clear flag ; tsx-32 11: clear flag ; Win32s/NT 13: clear flag ; Win95 14: clear flag ; WinNT4X 8/10 vv 15: clear flag ; WinNT5X 16: clear flag ; Win98 17: clear flag ; Win ME 18: clear flag ; Win XP 19: clear flag ; 2003 Server endcase
Once the changes are made to the sm8000.dbl program file, rebuild System Manager application. It is not necessary to build all programs with this change. The utinit.dbl utility requires that you rebuild this separatly using the UTS:bldutxx.bat batch file.

Job Cost application

This change applies only to systems operating with Synergy version 8.3 or higher and re-building DTE v3.5.

The changes resolve an incorrect message number sent to the status utility program. Once the programs are changed, you must rebuild the Job Cost application.

Summary of Change:

The status utility program (UTS:status.dbl) takes the first argument for a message number and the second as a message string. If the message number is sent, it uses that for the message display. Otherwise it uses the actual text message string.

In some programs within Job Cost, Synergy v8 is intrepreting a text argument incorrectly as the message number. Searching the posting programs and adding a comma resolves this situation.

Insert a comma within the xcall status line.   Search for the value of
           xcall status ('             that should be
                  xcall status (,'

in the program files:
jc4025.dbl, jc4030.dbl, jc4055.dbl, jc4125.dbl, jc4130.dbl, jc4135.dbl, jc4155.dbl, jc4225.dbl, jc4230.dbl, jc4255.dbl

Accounts Payable application
(DTE V3.5 only)

The second segment of the second key of the aphist.ism file is defined incorrectly.

Because the A/P History by check report sorts off of this key, the sort order of this report is random unless this patch is performed.

Summary of Change:

Follow these instructions to correct the sort order:

1. Unload the aphist.ism data file. Select “ Unload file ” from the Files menu column of System Manager. Follow the screen prompts entering values defined for your system and “No” for the Clear file AFTER unload field. The ascii file is written as WRK:aphist.ddf .

2. Edit the aphist.ism file characteristics by selecting “ File characteristics ” from the Maintenance menu column. Change the second segment of the second key from starting in Position 80 and Size 16 characters to starting in Position 84 and a Size of 14 characters.

3. If your system space allows, make a backup copy of your aphist.ism and aphist.is1 files (except VMS systems, only aphist.ism ) as a precaution. Then, initialize the aphist.ism file by selecting “ Initialize file(s) ” from the System Manager Files Menu Column. This creates a new A/P history file with the correct second key segment.

4. Load the data back into the newly defined aphist.ism file by selecting “ Load file ” from the Files menu column in System Manager. Again, follow the window prompts for your unique system indicating "No" to the Merge into existing records field.

This patch does not require rebuilding the Accounts Payable application.

Accounts Payable application
(DTE V3.5 only)

app35.zip

Occasional circumstances of entry allowed the Accounts Payable Distribution window to verify and accept an inactive chart of accounts number for distribution.

Summary of Change:

Make the following changes to correct this situation:
In the ap4000d section of the dteap.wsc window script file, change (all on a single line): .field dept, a4, fpos(4,15), break, user("#f/gltabl/0/f/2#"), - to: .field dept, a4 , fpos(4,15), break(always), user("#f/gltabl/0/f/2#"), -
Once this is changed, set your logicals and reload the new dteap.wsc window script into the UTF:dte.ism file. Refer to the readme.pat file included in the download for detailed instructions. This replaces the previous A/P window parameters.
In the ap4000.dbl program, there are several changed lines. Down To Earth versions prior to v3.5 require special instructions. For v3.5, download the patch and search for the comment "2/23" to inquire on the changes made.

General Ledger application

glp341.zip

glp35.zip

Change a date designation from two digit year to a four digit year.

Summary of Change:

To correct the SY financial statement formatting command date (year) for Down To Earth version 3.4.1 or 3.5.

The program, gl7000.dbl requires 2 line changes:

1. The variable sysdt field length from : a9 to : a11

2. Change (all on a single line):
xcall s_bld (glf_text,,'%a %d, 19%d',work_month,sysdt(1:2),sysdt(8:2))

to:
xcall s_bld (glf_text,,'%a %d, %d',work_month,sysdt(1:2),sysdt(8:4))

General Ledger application

glp4000_35.zip

glp4120_35.zip

A journal entry and posting change.

Summary of Change:

The following two changes are associated with the G/L journal transaction entry and posting programs, respectively.
The gl4000.dbl program change clears all posting flags when first writing a new G/L transaction to correct the application of existing gltran.ism posting flag identifiers. This only applied to newly written records possibly taking on partially posted transactions flag characteristics. The symptoms were that the new records appeared partially posted.
The gl4120.dbl program change validates the posting date entered is for an open period.

Order Entry application

The oe4100.dbl program requires one line of change to enable remarks to print on picking tickets for serial numbered items.

Summary of Change:

For Down To Earth version 3.4.1 or 3.5, in the remarks (rmrks) section, add the "if" statement line as noted below in bold :
rmrks, opcde = DTE_RETRY xcall ismrd (DTE_NEXT,oeline_chan,oeline,,opcde,0) if ( opcde . eq . 0 . and . oel _ key . eq . oem _ key . and . oel _ lineno . eq . opline ) then begin if (oel_linetype.eq.'Q') goto rmrks if (oel_linetype.eq.'R') then begin

Payroll application

The pr4325.dbl program in Down To Earth version 3.4.1 or 3.5, Direct Deposit Report, does not clear the total amount if the report is printed twice in a row.

Summary of Change:

This issue only applies if printing twice without exiting Payroll application in-between prints.

The report automatically prints if direct deposits apply to the current transaction batch when selecting “Print payroll register” from the Checks menu column.

To define the program to clear the total between printing, add the "clear" statement line as noted below in bold:

.include "UTS:inprint.inc"
clear tot_amt, prempl loop,
reads (ddep_chan,prddep,eof)
if (pre_empl.ne.prp_empl) 
  begin

Additional assistance is also available from our Technical Support department.