Completed Enhancements Archive

Posted on:April 2, 2014
Posted in:Completed Enhancements
Posted by:softworks

Go to enhancement list for…

Response Log
Pavement Management
Fleet Maintenance
Garage and Parts Inventory
Daily Crew Worksheet
Sign Management
Culvert/Bridge Management
Guardrail Management
Payroll Management
Government Accounting System
Fixed Asset Inventory
A/R-Receipt Management
Time Management
Address Management
Ohio Accident Statistics

All Applications

Make Data Entry Screen Size an OPTION (maximized/normal) 08/08/07
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability
Disable SELECT PICTURE button until EDIT is selected
Simplify Download (Update)
HELP added to HELP menu
Menu option added to check and REPAIR any damaged data files
Index Data Files – Physically delete and recreate index files
Add LINE after each field on E-MAIL record option (11/09/07)
Make BACKGROUND COLOR different for fields with available POPUP (01/26/08)
Do not allow programs to be loaded multiple times on one machine (02/26/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/26/08)
Resize Popup selection list when form is maximized (10/14/08)
All forms – Display first record in file upon entry (based on last sort order)(10/14/08)
Popups – When SORT ORDER is changed, allow operator to navigate quickly, BASED ON SORT ORDER CHOSEN (in progress 04/01/08)
Add OPTION for allowing updates (like GPI Browse)- BROWSE SELECTION SCREENS (in progress 04/01/08)
Highlight the field where the cursor is located (in progress 07/03/08)
Highlight the field where the cursor is located (2009)
Give option to turn CAPS LOCK ON when using program (System Variables) – Done in all modules – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/0)
Add ZIP file downloads to DOWNLOADS page
When PRINT is selected from SCREEN REPORT, prompt for pages to print (2009)
FORCE CAP LOCKS when character field selected IF CAP LOCKS set to YES on System Variables form (12/01/09)
Move all resource files from PROGRAM FILES folder to USER PROFILE folder so program does not need to be run as Administrator in Windows 7 – available upon request (07/20/11).
Background Color modified – Fields on data entry forms with yellow background (pop up available) did not change color when the cursor moved to the field (from 4/07/11 to 7/20/11). This was changed 07/20/11
New setups created for all modules. Resource files moved from PROGRAM FILES folder to USER PROFILE folder – available upon request (07/20/11).
Data Entry – All DATE fields now have a RIGHT MOUSE CLICK OR DOUBLE MOUSE CLICK CALENDAR SELECTION option (04/12/13)
The PICTURE on all applications will display properly, regardless of your screen resolution. 4/18/14
DATE field popup (calendar) – Change DEFAULT to current date-modification will be in all applications (11/03/16)
REPORT ENGINE – We have changed the report engine in all modules so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). You can remove the HIGH DPI COMPATIBILTY icon property so your screens will display larger and your reports will not. If your program release date is after 12/21/20 and before 03/07/21, some of your report and browse selection screens may display maximized when they should not. This was a result of the changes made on 12/21/20 and has been corrected. (03/07/21)
Change link on HELP/ABOUT to access SOFTWORKS.ORG securely (https:\\www.softworks.org) 03/08/23
Remove email icon from data entry forms (05/05/23)
Change made on 3/8/23 did not work – corrected (07/11/23)
Print Dialog in Windows 11 22H2 – If you are printing Landscape Reports and they now default to Portrait, check your operating system. If running Windows 11 22H2, you can restore the print dialog by typing
```
reg add "HKCU\Software\Microsoft\Print\UnifiedPrintDialog" /v "PreferLegacyPrintDialog" /d 1 /t REG_DWORD /f
```
in the command window…Start Quick Support and send us the Teamviewer information and we would be happy to do this for you. (08/31/23)

Response Log

Add PATH field for IMAGE FILE (with ability to browse for image file) and option to view image
Add MAIL TO option for e-mailing current record
Add E-MAIL ADDRESS to NEW Landscape Report
NEW REPORT – Work Order With Constituent History prints Work Order, followed by all calls from that constituent
Add RIGHT CLICK from Page One of Response Log form to print reports – Selection screen defaults to the current constituent
Add Selection and Sort for HOME and WORK PHONE NUMBERS (Browses and Reports)
Add Option to Duplicate Record – on RIGHT CLICK MENU – Response Log Entry form
Add POPUP on WORK CODE DESCRIPTION field
Add another image file path and caption fields – Display 2 pictures with captions on “Pictures” page.
Add System Option to Scan Data Files
Change ‘Picture Location’ fields to MEMO fields (indefinite length)
All Report Options are now available in PDF format
Display a portion of MEMO on Browse screens so operator can see contents of memo
Add REPORT menu
Right Click – Print Current Work Order
Change SORT DEFAULT to LAST NAME on Browse and Report Selection Screens
Report cleanup done (10/23/06) due to graphic changes in Visual Foxpro 9.0
Add option to sort DESCENDING by DATE so most current work orders appear first
(Reports and Browses)
Move TOWNSHIP to Site Location area of form (rather than CALLER INFORMATION)
Maintenance Menu – new procedure added – Import Response Log Records. This will allow you to retrieve records entered at another location.
Add menu option to check and repair data files (03/16/07)
Add HELP button on HELP/ABOUT (03/16/07)
Road Section added to Response Log data file – Using Road Section, road information is retrieved from Road Master File (Work Order Reports) 4/12/07
Modify Browse – Do not allow DELETE or APPEND 4/18/07
Add Secondary Sort Option to Report Selection screen (05/17/07)
Add Table File with CITY/STATE/ZIP/TWP and allow popup selection when entering Work
Orders (05/17/07)
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability
Add popup for HOME PHONE, WORK ORDER (Report Selection)
Maximize Response Log Form when opened (05/17/07)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (10/25/07)
Make BACKGROUND COLOR different for fields with available POPUP (10/25/07)
Do not retrieve Township field when Constituent selected from popup in Response Log Form (10/25/07)
Do not allow programs to be loaded multiple times on the same computer (10/25/07)
When ACTIONS have been entered, change TAB title of RESPONSE page to RESPONSE ENTERED (10/25/07)
When PICTURES have been selected, change TAB title of PICTURES page to PICTURES DISPLAYED (10/25/07)
Index procedure modified – Update PROBLEM field (IF BLANK) with first 60 characters of MEMO – PROBLEM is displayed in POPUP of Response Log records (11/07/07)
Response Log Reports-Add another Work Order Report (Work Order 2 and Work Order 2 w/Pictures) that more closely represents the Work Order Data Entry Form (02/13/08)
Add option to print digital photo on reports (Print on Work Order 2 w/Pictures) (02/13/08)
Add TO LOCATION, LOG POINT, SIGN #, CULVERT #, BRIDGE # and GUARDRAIL # to Response Log file. (02/13/08)
Response Log Form – Add ‘Print Work Order 2’ option on menu that is displayed with RIGHT MOUSE CLICK from Page 1 (03/13/08)
Add sort option (Reports and Browses) for ADDRESS (03/24/08)
Add sort option (Reports and Browses) for COMPLETION DATE (03/24/08)
Maintenance menu – Add Archive and Retrieve Response Log Records menu options (03/24/08)
Work Order Reports – Print Road Information ONLY when Road Section field is non-blank (04/15/08)
Highlight the field where the cursor is located (07/26/08)
Sign Interface modified – Add RIGHT CLICK from Sign Popup to Edit Sign Master File Record. Add Button to create new Sign Master File Record. (07/26/08)
Work Code File – Add option to exclude work codes from Response Log Pop up window (10/14/08)
Constituent Names file – Township field should not be saved to Constituent Names file when record is created during Response Log entry (10/14/08)
Response Log data entry – Completion Date field background color set to red (10/14/08)
Work Order with Constituent History report modified – Response Log records are now sorted DESCENDING by date – previously, oldest records were listed first (11/20/08)
Work Order 2 With Pictures – Enlarge pictures on report (01/07/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/12/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09) (07/27/09-refined)
Add DEFAULT USER to System Variables form – Use this value as DEFAULT ‘Taken By’ on new Response Log entries (07/23/09)
Response Log date entry – Completion Date is currently displayed in RED. Display in RED only when Completion Date is BLANK. (07/23/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Work Order Status Reports added -Print Detail or Summary Status Reports including Work Order (Response Log), Actual Costs (DWS), Payments to Vendors (Government Accounting), Receipts (Government Accounting), Invoiced and Payment Amounts (Accounts Receivable) (04/28/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Maintenance menu – Add option to Change Work Order Number in all data files (07/14/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Response Log Entry – Add PRINT BLANK WORK ORDER option (10/29/10)
Response Log BROWSE – Add F1 option to view Daily Crew Worksheet entries made for the work order (01/19/11)
Add GPS coordinates (LATITUDE and LONGITUDE) to Response Log file (04/08/11)
Response Log Master File – GPS page – Add BUTTON for retrieving LATITUDE and LONGITUDE (04/29/11)
Add Latitude and Longitude to Browse screen (07/13/11)
Maintenance Menu – Add REVERSE GEO-CODE menu option. This option will attempt to find the physical address of any record containing LATITUDE and LONGITUDE values. Internet connection is required (07/13/11)
Maintenance menu – Add option to create Response Log File records from geo-coded photos. This option will create a Response Log record for every picture contained in the selected picture folder (12/09/11)
Add DATA ENTRY top menu option (03/15/12)
Response Log Browse – Add ROUTE sort option (07/26/12)
Reports – Add Landscape Format 2 w/ Memos (08/20/14)
Response Log Entry Form – Add PDF page for attaching and viewing PDF files (12/03/14)
Response Log Browse/Report Selection screens – Save selected SORT ORDER as default (11/10/15)
Response Log Entry Form – Display ‘Road Width-ROW’ when cursor leaves Road Section field (07/13/16)
Response Log Browse – Add SORT by ADDRESS (08/29/16)
Response Log – Change “Who” title to “Assigned To” (08/29/16)
RIGHT CLICK PRINT OPTIONS – Response Log Form – Add option to send to PRINTER, SCREEN, OR PDF (08/29/16)
Reports – Change Date format to 99/99/9999 (06/27/17)
Response Log Browse – Modify F1 on Browse – Display all DWS detail entries by using matching Log Numbers – previously only found matching Work Order Numbers (04/19/18)
Response Log Entry – Remove NOWAIT from ROW popup that displays when cursor leaves Road Section field so popup will remain to be seen. 11/18/19
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)
Data Entry Forms (do not minimize when popup selected). 05/17/21
Work Order Reports – Change TITLE from “Work Order/Complaint” to “Service Request” (06/14/23)

Pavement Management

Add four PATH fields and captions for IMAGE FILES (with ability to browse for image files). Images are displayed on PICTURES page.
Add BROWSE selection screen – Project File
Add REPORT menu
Add Work Order File Option so Work Orders can be entered without selecting a Road Section form the Road Master File
Add popup selection of Work Orders on Browse and Report Selection screens (Work Order and Estimate Number fields)
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Add menu option to check and repair data files (03/28/07)
Add HELP button on HELP/ABOUT (03/28/07)
Maximize Project Form when opened (05/08/07)
Disable SELECT PICTURE buttons until EDIT is selected
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability 9/12/07
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/11/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/11/08)
Add Sign, Culvert, Bridge and Guardrail Numbers to Work Order File (02/11/08)
Add Completion Date to Work Order Report (02/11/08)
Sign Interface modified – Add RIGHT CLICK from Sign Popup to Edit Sign Master File Record. Add Button to create new Sign Master File Record. (07/26/08)
Highlight the field where the cursor is located (07/28/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/09/08)
Part Pop ups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/09/08)
Work Code File – Add option to exclude work codes from Pavement Management Pop up window (10/14/08)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
Work Order Browse/Report Selection screens – Add CULVERT/BRIDGE/SIGN/GUARDRAIL selection range (09/22/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Work Order Report – Print complete COMMENTS/NOTES field on Work Order Report (11/05/09)
Work Order Report menu – Add “Work Order Report” to Report Type selection (11/05/09)
Work Order Form – Add new page (tab) for COMMENTS/NOTES. The notes field on this page is the same field displayed on the Work Order page (11/05/09)
Add Project TYPE field with corresponding table file for selection (11/23/09)
Report menu – Add “Project Type” Report Listing (11/23/09)
Add Project PRIORITY table file so priority can be selected from list (11/23/09)
Report menu – Add “Project Priority” Report Listing (11/23/09)
Work Order Form – Add popup selection for Project Priority and Project Type (11/23/09)
Add TYPE and PRIORITY Sort Options selections to Browse Selection screen (11/23/09)
Work Order Form – Add “Print Work Order” and “Print Work Order With Pictures” to popup menu (displayed with RIGHT CLICK on WORK ORDER page) – currently can be printed using PRINT button (11/23/09)
Work Order Report form – Add “Print Work Order with Pictures” report format (11/23/09)
Work Order Reports (Cost Comparison and Cost Comparison Summary) – Use Employee PAY RATE (rather than DWS Benefitted Rate) for ACTUAL Labor Cost. Benefit Percentages from System Variables form are added (02/27/10)
Work Order Status Reports added -Print Detail or Summary Status Reports including Estimate Costs (Pavement Management), Actual Costs (DWS), Payment to Vendors (Government Accounting), Receipts (Government Accounting), Invoiced and Payment Amounts (Accounts Receivable) (03/02/10)
Work Order Form (Estimate Detail) – Add button option to Update Estimate with CURRENT COSTS. This can be used for older projects/estimates that were not completed. All LABOR, EQUIPMENT and MATERIAL costs are updated. (04/28/10)
Work Order Form – Add F11 popup selection for Response Log ‘Work Order Number’ (05/02/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Maintenance menu – Add option to Change Work Order Number in all data files (07/14/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Add DATA ENTRY top menu option (05/21/12)
Data Entry Forms (do not minimize when popup selected). 05/17/21

Fleet Maintenance

Add option to change cost of selected part for selected date range (specifically fuel cost)
Add option to copy Standard Parts from another vehicle (Vehicle Master File) – Use Right Click menu option on Standard Parts page of Vehicle Master File form.
Job Reports – Add LABOR INSTRUCTIONS (1st 25 characters) selection range
Add PATH field for IMAGE FILE (with ability to browse for image file) and option to view image (Job file)
Add “Date” to Labor records – Job Entry
Add field for Flat Fee Charge in Job Entry (Service Call) – Modify Job Reports and Billing to include new charge
Fluid form – Add RIGHT CLICK with option to DUPLICATE RECORD
Employee form – Add RIGHT CLICK with option to DUPLICATE RECORD
Add Picture to Vehicle Master File
Add second picture (and caption fields) to Job File
Vehicle Master File – Change TIRE and LUBE Service Checks to VARIABLES (allow user to select Maintenance Codes to be checked)
Add FEMA RATE. New RATE will be used for FEMA REPORTS. If FEMA RATE is ZERO, RENTAL RATE will be used for FEMA REPORTS.
Two new Fluid Billing Reports added – Departmental Billing
Add QUANTITY ON HAND to Part Markup Screen (when GPI update is selected)
Browse Selection screens added for Maintenance Code File and Cost Table File
Add “Internal Code” sort option on Maintenance Code popup form so Maintenance Codes can be viewed in “Internal Code” order
All Report Options are now available in PDF format
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Add “Invoice Number” sort option to BROWSE – Job Entry
Add Supplier Name/Number to Part Popup screen
Job Entry – When Standard Part is added to Standard Part List, transfer the QUANTITY, along with the other information
Display Work Order page when SAVE is selected
Job Entry – Add QUANTITY when Standard Part is added to Standard Parts File
Work Order Report Modified (11-15-06) EXTENDED NOTES were previously over other information on the report
Vehicle Master File – Add RIGHT CLICK-DUPLICATE RECORD option (12-28-06)
Cost Table File – Add popup capability for Maintenance Code and Part (1-17-07)
Vehicle Master File Report – Summary with Gas Analysis – Add Downtime Hours, along with Downtime Cost
Several Fuel Import procedures added
Display ‘Qty On Hand’ On Parts Screen (Job Entry) when Part is added or changed
Add menu option to check and repair data files (03/12/07)
Add HELP button on HELP/ABOUT (03/12/07)
3/12/0 Add UNITS to popup display on PARTS PAGE of Job File when part is added or changed
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability 5/29/07
Job Entry – When ADDING new job, give operator to view other jobs for that vehicle – New menu option – RIGHT CLICK FROM WORK ORDER PAGE 07/07/07
Add Landscape Report option to Service Report by Hours and Service Report by Date (as is available on Service Report by Mileage) 08/07/07
Add ability to record known problems with vehicles (possibly checklist) – This information needs to be available when vehicle is serviced (Job Entry)…Added new NOTES form (Form 3a) for recording items to be checked when vehicle is serviced. RIGHT
CLICK FROM WORK ORDER PAGE will display Incomplete Entries and allow COMPLETION DATE to be entered. 08/08/07
System Variables form – Add option to Use A/R Invoice Number (Jobs/Fluid Billing) (08/30/07)
Vendor Reports – multiple modules – Print PHONE 1 (if not blank) rather than PHONE 2 when only one phone number is on report (11/06/07)
Job Entry – Retrieve Department Address (from Department File) Information when Vehicle Number is entered (11/13/07)
Fluid Billing – Add TRANSACTION NUMBER range to Report Selection Screen (12/12/07)
Fluid Billing – Add SUBTOTAL for OTHER transactions (not GAS or DIESEL) (02/18/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/19/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/19/08)
Parts Popup – Use F11 for STANDARD PARTS popup (03/12/08)
Add new NOTES Reports (Form 3A) to Vehicle Master File Reports (Incomplete or All Items) 04/10/08
Vendor Master File – Add ACTIVITY FLAG – default popups to active Vendors (04/16/08)
Vendor Master File – Add PREVIOUSLY KNOWN AS page to Data Entry Form (04/16/08)
Vehicle Master File Report – Summary with Gas Analysis – Add SUBTOTAL on MILES DRIVEN and GALLONS columns – Add DRIVER NAME to report (05/27/08)
Vehicle Master File – Add COST PER MILE (used by Daily Crew Worksheet) 06/05/08
Create Invoice Records – Job Entry – retrieve Account from Inventory Master File (PARTS) 06/13/08
Highlight the field where the cursor is located (07/15/08)
Vehicle Master File Report – Vehicle Information-Landscape – Add Special Code and Total Number of Vehicles (07/15/08)
Fuel Import menu – Add PRINT FUEL IMPORT REPORTS option (07/21/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/08/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/08/08)
Vehicle Master File – Add 2 BUDGET ACCOUNT fields- Vehicle Maintenance Account and Vehicle Fuel Account (10/08/08)
Vehicle Master File Report – Add Vehicle Account Report – Includes new Account fields (10/08/08)
Job Reports-Add BUDGET ACCOUNT Sort Option – Add subtotals by Sort Option (10/08/08)
Job Reports – Add Cost Summary Report format (10/08/08)
Fluid Reports-Add BUDGET ACCOUNT Sort Option- Add subtotals by Sort Option (10/08/08)
Job Entry – Browse Selection Screen – Add JOB NUMBER as Selection Range and Sort Order (10/08/08)
Job Reports – Report Selection Screen – Add JOB NUMBER as Selection Range and Sort Order (10/08/08)
Add Special Code Table File – Report option – Popup selections (10/08/08)
Add Vehicle Code Table File – Report option – Popup selections (10/08/08)
Job Entry – Browse screen – Add NOTES from Work Order Page to Browse screen (10/08/08)
Recalculate Maintenance Totals – Update Mileage and Hours if Job Entry is SAME date – previously only updated if Job Entry Date was more recent (10/08/08) OUND to 2 decimals
Department File – Add Fuel System Department Number – This number is used to obtain the Department Number used in Fleet Maintenance (01/25/09)
Job/Fluid Entry – Retrieve appropriate Account Number from Vehicle Master File – use this Account Number when adding records to Inventory Usage File (01/25/09)
Job/Fluid Entry – Add F12 popup option for selecting NO STOCK Inventory Receipt Items – These are items that are not stocked in the GPI Master File (01/25/09)
Work Order Report – Add Box around Notes field for easier viewing (01/25/09)
Add DATA ENTRY menu to Top Menu – This menu contains forms for Files previously found only on the File Menu (01/29/09)
Special Code Table File and Vehicle Code Table File – Expand DESCRIPTION field to 50 characters (0/30/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
Set flag of NON STOCK INVENTORY RECEIPT when selected from popup for Fleet Maintenance Work Order (Job) part. This flag eliminates the part for future popup selection (06/26/09)
Work Order (Job) Entry – Add ‘CHARGED DIRECTLY Y/N’ and ‘COMMENTS’ fields to PARTS page. These new fields are also new fields in the Inventory USAGE file, allowing previously billed items to be eliminated from the FIFO Usage Reports in Garage and Parts Inventory (06/26/09)
A/R Interface and Invoicing – Items that are flagged as CHARGED DIRECTLY are not included in the A/R Billing Interface. These items have already been billed or paid in another manner (06/29/09)
A/R Interface – Retrieve ‘Budget Account’ from Vehicle Master File (06/29/09)
Job File Reports – Add ‘INVOICE DATE’ range selection (07/02/09)
Job File Reports – Add INVOICE and SUMMARY INVOICE report options (07/02/09)
Work Order (Job) Entry – Labor page – Add Labor CUSTOM CLASSIFICATION field for categorizing Labor costs. The Custom Classification can be selected from the Custom Classification Table File (07/08/09)
Vehicle Cost Analysis Report – Include Labor CUSTOM CLASSIFICATION – previously LABOR could only have ONE classification (07/08/09)
Mechanics Analysis Reports – Add Custom Classification as PRIMARY and SECONDARY sort option (07/08/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09) (07/27/09-refined)
Parts Consumption Report – Added option to Include Parts NOT IN GPI Master File, Parts IN GPI Master File or ALL PARTS (09/15/09)
DOUBLE CLICK will now produce POPUP selection screens (10/19/09)
Vehicle Master File Reports – Add “COST PER MILE ANALYSIS” report (10/19/09)
System Update modified-Update MEM file (Labor) only if it is not current (12/04/09)
Job Entry – Retrieve MAINTENANCE CODE from Inventory Master File (for PARTS) (12/15/09)
Fluid Entry – Retrieve MAINTENANCE CODE from Inventory Master File (for PARTS) (12/15/09)
Job/Fluid Entry – Replace MAINTENANCE CODE with MAINTENANCE CODE from Inventory Master File ONLY WHEN MAINTENANCE CODE is BLANK (01/11/10)
Vehicle Master File – Expand COMMENTS field from 50 to 100 characters (02/15/10)
Inventory Master File – Increase field length of SUPPLIER’S ITEM NUMBER (18 characters) 02/19/10
Job Entry – Browse Previous Jobs – Add F1 to view PARTS, F2 to view Labor and F3 to view Outside Service (03/18/10)
Job Browse – Add F1 to view PARTS, F2 to view Labor and F3 to view Outside Service (03/18/10)
Vehicle Master File – DO not allow duplicate vehicle numbers to be entered (03/26/10)
System Variables Form – Add “Equipment Hours Entry” selection type – Choose TOTAL HOURS, HOURS USED or BOTH. If TOTAL HOURS is selected, entry is disable on HOURS USED. If HOURS USED is selected, entry is disabled on TOTAL HOURS. If BOTH is selected,. entry can be made in either field. (03/26/10)
Password Protection added (optional) for Job Entry. A password can be set to disable edit/delete on work orders with an Invoice Date (03/26/10)
Job Entry/Fluid Entry – Entry can not be made unless VALID vehicle entered (03/26/10)
Parts Consumption Reports – (Detail)-Add COMMENTS from Part Entry on Job (04/06/10)
Vehicle Master File Browse – Add FUEL VEHICLE # sort option (04/10/10)
Vehicle Fluid File Browse – Add DRIVER sort option (04/10/10)
When MARK UP percentage applied to Part Cost, ROUND to 2 decimals (04/28/10)
Job Entry – Check for Service Check entries on Work Order if Mileage or Hours are changed – Update Vehicle Master File with updated information (04/28/10)
Maintenance menu – Vehicle Maintenance – Change Vehicle Number – Make “Change Number in VEHICLE MASTER FILE” an option and do not allow duplicate number to be created in Vehicle Master File (05/14/10)
Maintenance menu – Vehicle Maintenance – Add new menu option – RETIRE Vehicle – This menu option will change the retired vehicle to a different number and update the Vehicle Master File record to RETIRED (History = “Y” and Fuel System Number = “RETIRED”) (05/14/10)
Add CONDITION to Vehicle Master File report selection screen (07/26/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Vehicle Master File- Standard Parts File – Add WARRANTY DATE, WARRANTY MILEAGE and COMMENTS for tracking warranties – Add new fields to Standard Parts Report (09/28/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
Service Checks modified – Each vehicle may now be checked for PM Check and FIVE optional service codes (02/15/11)
Service Check Reports modified – Operator can choose to run the reports for ALL, PM Check or any selected Maintenance Code Check. Vehicles will appear on the report only if the parameters (DAYS, MILES, HOURS) have been entered on the Vehicle Master File form (Service History Page) and the Service is due (02/15/11)
System Variables – Make Service Check Warning an OPTION – Target MILEAGE, DATE, HOURS only calculated if parameters are set up on Vehicle Master File (02/15/11)
Vehicle Service Reports – Add POPUP of Maintenance Code for report selection (02/15/11)
Vehicle Master File Reports – Add MAKE selection range and MAKE sort option (05/03/11)
Vehicle Master File – Add DATE RETIRED field (09/02/11)
Add TYPE table file for maintaining VEHICLE types (data entry/report). Add popup selection capability. (09/02/11)
Cost Per Mile Analysis Report- Add MAKE field (09/02/11)
Summary with Gas Analysis Report – Add MAKE field (09/02/11)
Work Order (RIGHT CLICK MENU) – Add option to print Standard Parts (09/02/11)
Departmental Billing (Jobs) – Add popup selection of Invoice Number (09/07/11)
Report Menu – Add separate Standard Parts Report option (standard report available on Vehicle Master File Reports). The new option will allow you to print an Inspection Report for Inventory Items carried with the vehicles. Create a Maintenance Code for these items and run the Inventory Report for that Maintenance Code. This will enable you to enter the inventory items on the Standard Parts Page of the Vehicle Master File form, using the Maintenance Code for INVENTORY (09/07/11)
Job Entry – Warning message modified for easier visibility (09/07/11)
Job Entry – Change GRIDS (Parts/Labor/Outside Service)-Highlight active line of grids and remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (10/28/11)
Cost Table File – Limit EQUIPMENT NUMBER length to ten characters – Cost Table File maintains MATERIALS and EQUIPMENT (10/28/11)
System Variables Form – Add ‘NONE’ as option for Warning Sound. This will eliminate error messages for date, mileage and hours during Job and Fluid entry. (09/14/12)
Vehicle Master File – Add RIGHT CLICK OPTION to print Vehicle Information with NOTES (09/25/12)
Maintenance Menu – Add RECALCULATE PART COST BASED ON FIFO – This menu option will update the part cost in the Fleet Maintenance Job File (Parts) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/1)
Maintenance Menu – Add RECALCULATE PART COST BASED ON FIFO – This menu option will update the part cost in the Fleet Maintenance Job File (Parts) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/12)
Vehicle Master File – Add STATE NUMBER, STATE HOURLY RATE and STATE RATE PER MILE (11/21/12)
Maintenance menu – Add UPDATE HOURS/MILEAGE IN FLUID FILE option. This option will update the BEGINNING HOURS/MILES, based on the prior record’s HOURS/MILES. (01/09/13)
Standard Job Entry Form Added – Standard Jobs (OIL CHANGE/TUNE UP…) can be entered in this file and selected during Job Entry for faster data entry. (06/14/13)
Job Entry – Add Button to Select STANDARD JOB. The Standard Job is set up with the appropriate Parts and Labor for a specific task. When selected, the Job Entry Form is populated with the Parts and Labor from the Standard Job. (06/14/13)
Vehicle Master File – TITLE field expanded from 10 characters to 20 characters (11/17/14)
Vehicle Cost Analysis Report – Add YEAR as SORT and SUBTOTAL option (11/18/14)
Maintenance Menu – Recalculate Maintenance Totals – Eliminate Overflow in Mileage field by replacing mileages > 999999 with 999999. Update LAST UPDATED field in Vehicle Master File (01/07/15)
Vehicle Master File – Add option to SORT BY mileage (01/07/15)
Vehicle Master File Reports – Add new report…One Line Landscape Report – VEHICLE/MAKE-MODEL/YEAR/MILEAGE/PARTS TOTAL/LABOR/OUTSIDE SERVICE/GRAND TOTAL/MILEAGE/HOURS/PURCHASE PRICE (01/07/15)
Parts View – Display Work Orders – Add QUANTITY (07/15/15)
Vehicle Master File – Add PDF page for attaching and viewing PDF files (08/12/15)
Job Entry – Add PDF page for attaching and viewing PDF files (08/12/15)
Cost Analysis Reports – Add Customer name, Address and Phone to top of report (09/29/15)
Fuel Import Browse – Added option to sort by DRIVER (10/23/15)
Vehicle Cost Analysis Report – Do not print GRAND TOTAL on separate page (Summary report) (01/28/16)
Job Entry – Parts Page – Add RIGHT CLICK menu option for adding SCANNED BARCODES-will accept unlimited scans and create part records on job-This was tested using ADESSO NuScan 4000 Bluetooth Barcode Reader (05/01/16)
Job Entry – Manufacturer Parts File scanned for SCANNED BARCODES. If found, correct Inventory Item is retrieved for parts scanned on job (05/06/16)
Job Entry – If Incomplete Notes, send prompt when Vehicle is entered (08/30/16)
Scanned Bar Code Field – Force UPPER CASE (09/07/16)
RIGHT CLICK PRINT OPTIONS – Job Entry Form – Add option to send to PRINTER, SCREEN, OR PDF (09/08/16)
System Variables Form – Add DEFAULT Labor Rate (regular and overtime) for Billing (10/31/16)
Job Entry Form – A/R Billing Interface – Add option to choose DEFAULT Labor Rate or mechanic’s rates (10/31/16)
Job Entry Form – A/R Billing Interface – Add option to add material mark up percentage to parts billing (10/31/16)
Job Entry Form – A/R Billing Interface – Add INVOICE DESCRIPTION (10/31/16)
Job Entry Form – Parts Pop Up – Add F9 pop up for selecting parts from Cost Table File/Inventory Master File…file not chosen on System Variables form (10/31/16)
Maintenance Menu – Add option to remove duplicate records from Standard Parts File (11/01/16)
Index Data Files – Sort Standard Parts File by Vehicle/Part so standard parts appear in part order in Inventory Master File (11/01/16)
Job Entry Form – Update cost of standard part when adding parts to standard parts file (if already there) 11/01/16
DATE field popup (calendar) – Change DEFAULT to current date (11/03/16)
Maintenance Menu – Retire a Vehicle – Add Option to Update Fixed Asset Inventory File for those that also have vehicles in Fixed Asset Inventory File (11/09/16)
Vehicle Master File – Added ‘Salvage Value’ field (07/07/17)
Vehicle Master File – Added ‘As Of’ date field for Present Value (07/07/17)
Maintenance Menu – Add option to recalculate ‘Present Value’ in Vehicle Master File (07/07/17)
Vehicle Master File Reports – Add Indiana County Highway Form No. 30-Equipment Depreciation Ledger as new report type (07/07/17)
Vehicle Cost Analysis Reports – Add Indiana County Highway Form No. 28C-Equipment Operating Expense- MVH Cost Distribution Ledger as new report type -Columns will consist of first 9 Custom Classifications – No. of Hours and No. of Miles retrieved from Daily Crew Worksheet, along with Daily Crew Worksheet Project. Description will be printed in Project Column for Fleet entries. (09/25 /17)
Job Entry – Add new Sort Order (Vehicle and Descending Date (newest first) to Browse (01/08/17)
Standard Job Entry – Add VEHICLE to form and option to PRINT Standard Work Order (Right Click from Work Order Page) 11/04/18
Vehicle Master File Reports – Selection Criteria Page – Print TOTAL PURCHASE PRICE on Selection Criteria Report (11/06/18)
Job Entry – Increase field length of PART DESCRIPTION (11/06/19)
Standard Job Entry – Increase field length of PART DESCRIPTION (11/06/19)
Job Entry – PARTS page – Add Right Click menu option to “Add All Non-Stock Parts for Vehicle to Job” – previously , you could only add one at a time (11/14/19)
Job Entry – Add ‘SELECT ALL PARTS’ button to Standard Parts Popup form. Click this button to add ALL Parts on the Standard Parts List to the Current Work Order (could previously select one at a time). (07/13/20)
Fluid Reports – Added CUSTOM SUMMARY REPORT – In addition to subtotaling on selected SORT field, subtotals are provided for VEHICLE SPECIAL CODE (can be used for OFF ROAD and ON ROAD) and VEHICLE CODE (CLASSIFICATION OF VEHICLE) (Vehicle Master File) (08/04/20)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)
Data Entry Forms (do not minimize when popup selected). 05/17/21
Job Entry – Retrieve RECEIPT QUANTITY when adding NON STOCK PARTS to job – previously, popup selection did not retrieve quantity and right click to add all non stock parts made all quantity one 06/10/21
Job Reports – Add Job Notes to Job File Report (Detail) 12/13/21
Job Entry – RIGHT CLICK MENU OPTION – Update Part Costs On This Work Order to Current Cost (09/15/22)
Vehicle Master File – Add TWO MORE Service Checks-Service History Page-Vehicle Master File (11/03/22)
Vehicle Master File – Add additional picture to PICTURES/NOTES page (08/15/23)

Garage and Parts Inventory

Vehicle Master File Browse – Add Supplier Information and Comments
Vehicle Master File Reports – Add Two Line Format report
Add EDIT/NO-EDIT preference to Inventory Master File Browse Selection Screen-Defaults to NO-EDIT
Add ‘Unit of Measure’ to Spot Check Report
All Report Options are now available in PDF format
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Create REPORTS and MAINTENANCE menus
Modify “Change Inventory Item” menu option – Add ability to update DWS Cost Table File and Fleet Cost Table File, along with all GPI files, A/R detail, DWS detail and Pavement Management detail.
Add “Change Inventory item Cost” menu option
Add menu option to check and repair data files (03/16/07)
Add HELP button on HELP/ABOUT (03/16/07)
Add SIGN, CULVERT, BRIDGE and GUARDRAIL numbers to Usage File (07/07/07)
Add SIGN, CULVERT, BRIDGE and GUARDRAIL numbers to Usage Report Selection
Screen (Also, allow these fields to be selected as Report Order) (07/07/07)
Add EMPLOYEE ID to Usage File – POPUP from Employee Rates File (07/09/07)
Add SIGN MAINT ID to Usage File – POPUP from Sign Maintenance File (07/09/07)
Add SIGN, CULVERT, BRIDGE, GUARDRAIL and EMPLOYEE ID to Browse Screen – Usage
Add SIGN, CULVERT, BRIDGE, and GUARDRAIL to Browse Selection Screen-Usage
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/23/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/23/08)
New File Added – Inventory LOCATION file (for tracking multiple Inventory Facilities) (02/23/08) – This file is used as popup for LOCATION field
System Variables – Add DEFAULT Inventory LOCATION with popup from new Inventory Location File (02/23/08)
Quote/Order/Receipt/Usage Entry – Store DEFAULT Inventory Location to LOCATION field when new entry is made (02/23/08)
System Variables – Change ‘Last P.O. Number’ to ‘Last Garage Requisition Number’ 02/23/08
Inventory Master File – Add Budget Account (02/23/08)
Inventory Master File Report – Add “Budget Account’ Sort Option – Add ‘Budget Account’ to complete report and Two Line Format Report (02/23/08)
Order Entry/Quote Entry/Receipt Entry – Budget Account is now retrieved from Inventory Master File (02/23/08)
Order Transaction File – Add Vehicle Number, Budget Account (02/23/08)
Order Reports – Add ‘Budget Account’ Range Selection and Sort Option (02/23/08)
Order Reports – Add SUBTOTAL on Sort By field (02/23/08)
Order Reports – Add SUMMARY Report Type Option (02/23/08)
Receipt Transaction File – Add Budget Account (02/23/08)
Quote Transaction File – Add Budget Account (02/23/08)
Quote Entry / Order Entry – Press F10 or RIGHT MOUSE CLICK to select Garage Requisition, Press F11 to assign next Garage Requisition – If Garage Requisition left blank, next Garage Requisition (System Variables) is assigned and Requisition Record is created in NEW Garage Requisition File (02/23/08)
Automated Ordering Form – Add GARAGE REQUISITION field that is used for all order records created. A Garage Requisition Number is assigned to all new Order records. Add BUDGET ACCOUNT and VEHICLE fields to data entry screen. Add VIEW ORDER RECORDS button to screen so only Items being ordered are displayed. Allow entry of new items on Automated Order form. Prompt Operator if Item is not currently in Inventory Master File-Item may be added to Inventory Master File OR operator may choose to NOT add Item to Inventory Master File (02/23/08)
Automated Receipt Form – Add Garage Requisition Sort Option (02/23/08)
Receipt Entry Form – RIGHT CLICK from Inventory Item – Add Select Order by Garage Requisition option, along with Select Order by Inventory Item option (02/23/08)
Receipt Entry Form – If Item is not selected from Order record, Prompt Operator if Item is not currently in Inventory Master File-Item may be added to Inventory Master File OR operator may choose to NOT add Item to Inventory Master File (02/23/08)
Order Entry Form – Prompt Operator if Item is not currently in Inventory Master File-Item may be added to Inventory Master File OR operator may choose to NOT add Item to Inventory Master File (02/23/08)
Order Browse – Add Vehicle and Budget Account fields 02/23/08)
Order Reports – Add GARAGE REQUISITION Report Type Option (02/25/08)
Usage Reports – Add Budget Account Range and Sort Option (03/17/08)
Add MASTER FILES, TRANSACTION FILES and AUTOMATED ORDERING/RECEIVING menu options to top menu (03/18/08)
Automated Ordering procedure modified – Add DISPLAY BLANK ORDER FORM button. This button will display the Automated Ordering Form without current Inventory Items (03/18/08)
Automated Ordering procedure modified – Add DEFAULT Supplier Number, Supplier Name and Supplier Phone for new Inventory Item records. The default will be used for all orders created without Supplier Information (03/18/08)
Transaction Files Entry – Change Date Default to Current Date on new entries (03/28/08)
MATERIAL POPUPS modified – Display appropriate popup form based on operator SORT option (Material, Type, Supplier, Description)) 04/01/08
Vendor Master File – Add ACTIVITY FLAG – default popups to active Vendors (04/16/08)
Vendor Master File – Add PREVIOUSLY KNOWN AS page to Data Entry Form (04/16/08)
Inventory Master File – Add “Culvert/Bridge/Sign/Guardrail Inventory Flag”. Select “Y” if Corresponding Inventory Record should be updated with MATERIAL. (04/17/08)
Update RETAIL COST with new cost when ACTUAL COST is replaced with new cost during Receipt Entry (05/09/08)
Highlight the field where the cursor is located (07/26/08)
Add ACTIVITY FLAG to Inventory Master File (10/01/08)
Maximize Automated Order and Receipt Date Entry Screens (10/01/08)
Receipt Reports – Add Summary Report Option – Add Subtotals for Sort by (10/01/08)
Automated Order Entry form – Add Category field (10/01/08)
Add INVENTORY TYPE selection range to Order and Receipt Transaction Browses (10/01/08)
Display INVENTORY TYPE in Browse screen (10/01/08)
All Browse Selection Screens modified – Default to NO EDIT in Browse Window – Add EDIT option to Selection Screens (10/01/08)
Inventory Reports – Enlarge CATEGORY field so all characters print (10/01/08)
Parts Popups modified – Default to display Active Inventory Items from Default Location – Add Button to “Display all Locations” and Button to “Display My Location” – Display only ACTIVE items (10/01/08)
Inventory Master File Browse – Add option to include Active/Inactive or All records – Defaults to ACTIVE (10/09/08)
New Reports added – Ledger Report (based on Posted Cost) and Ledger Report (based on FIFO) (Receipts/Usage/Adjustments with Running Balance) – Inventory Master File Reports 11/10/08
New Reports added – Ledger Report (based on Posted Cost), Ledger Report (based on FIFO) (Receipts/Usage/Adjustments with Running Balance) and Ledger Summary Report (FIFO) – Inventory Master File Reports 11/12/08
Receipt Transaction Browse – Add Account Code 12/10/08
Automated Order Data Entry Form – Retrieve ALL fields displayed from Inventory Master File 12/10/08
Inventory Master File Reports – Add Detail FIFO Usage Report and Summary FIFO Usage Report formats – These reports calculate the inventory cost based on Receipt entries (01/25/09)
Inventory Usage Browse – Add ‘Account’ Range and Sort option (01/25/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
Garage Requisition File added to TRANSACTION FILES menu. This file contains one record for each Garage Requisition. A GARAGE REQUISITION record is created when an ORDER is entered using the AUTOMATED ORDERING form and CAN BE created by assigning a new Requisition Number when entering orders using the ORDERS TRANSACTION FILE form. The Garage Requisition Number is used for tracking Garage Orders. Invoice Number and Invoice Amount may be entered in this file. Garage Requisition records can be selected in the Government Accounting System when entering Invoices (05/02/09).
Garage Requisition Reports added to TRANSACTION REPORTS menu. This report is a listing of Garage Requisitions (05/02/09).
The Garage Requisition Number can be selected from popup when entering QUOTES, ORDERS and RECEIPTS. When receipts are entered using the AUTOMATED RECEIVING form, the GARAGE REQUISITION NUMBER is retrieved from the ORDER record. Popup selection can be sorted by GARAGE REQUISITION NUMBER, VENDOR, DATE or ORDERED BY fields (05/02/09)
QUOTE ENTRY, ORDER ENTRY, RECEIPT ENTRY – When Garage Requisition is selected or entered, VENDOR NUMBER, VENDOR NAME, P.O. NUMBER, REQUISITION NUMBER and BUDGET ACCOUNT fields are retrieved from the Garage Requisition record (05/02/09).
RECEIPT ENTRY – Receipt entries contain the VEHICLE NUMBER (stored in the SHELF/BIN LOCATION field) when Inventory Item is NOT added to Inventory Master File (NO STOCK). Vehicle can be selected from POPUP (05/02/09).
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
Inventory Master File – Add PHYSICAL INVENTORY DATE and PHYSICAL INVENTORY QUANTITY (06/09/09)
Maintenance menu – Add Recalculate Quantity On Hand option – This option will recalculate the Quantity on Hand and Total Usage from the Inventory Transactions (Receipts/Usage/Adjustments) based on the Last Physical Inventory Date and Quantity (06/09/09)
Vendor Master File Browse – Add COMMENTS and ACCOUNT fields (06/24/09)
Recalculate procedure (Maintenance menu) – Save ORIGINAL QTY ON HAND and RECALCULATION DATE so we can print (new) Reconciliation Report. (06/24/09)
Reconciliation Report added – Print Items that have a Physical Value difference greater than a Selected Amount (06/24/09)
Automated Ordering Form – When NEW item is entered, and operator selects to ADD to Inventory, display Inventory Master File ADD screen (06/25/09)
Inventory Master File Browse – Add QTY ON HAND selection range (06/26/09)
Maintenance menu – Recalculate Quantity On Hand – Add INVENTORY ITEM/LOCATION range to be recalculated (06/26/09)
Inventory Master File Reports – Add option to ‘INCLUDE USAGE CHARGED DIRECTLY YES/NO’ on FIFO Usage Reports. This new options allows the operator to print reports without the Fleet Maintenance parts that were charged directly to the vehicle owner (06/26/09)
Receipt Browse – Add ‘SHELF/BIN OR VEHICLE’ and ‘ON JOB FLAG’ fields to Browse – ‘ON JOB FLAG’ is set to Y when NON STOCK INVENTORY RECEIPT is selected for Fleet Maintenance Work Order (Job). This flag eliminates the part for future popup selection (06/26/09)
Usage Browse – Add ‘CHARGED DIRECTLY Y/N’ field – This flag is set in Fleet Maintenance (Parts page) (06/30/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09 (07/27/09-refined)
Add ITEM CATEGORY table file so ITEM CATEGORY can be selected from popup-FORM/REPORT/POPUP (07/27/09).
Add ITEM TYPE table file so ITEM TYPE can be selected from popup- FORM/REPORT/POPUP (07/27/09).
Add ITEM SOURCE table file so ITEM SOURCE can be selected from popup- FORM/REPORT/POPUP (07/27/09).
Material Popup modified – Add new material or RIGHT MOUSE CLICK to edit existing material (09/09/09)
Usage Transaction Reports – Added option to Include Parts NOT IN GPI Master File, Parts IN GPI Master File or ALL PARTS (09/16/09)
Usage Reports – Add Sign, Culvert, Bridge and Guardrail Ranges to Selection Screen (09/16/09)
Usage Transaction Reports – Added CHARGED DIRECTLY range selection – Choose FROM ‘Y’ to ‘Y’ to include only items charged directly (10/02/09)
Usage data entry form – Add ‘CHARGED DIRECTLY?’ field – Initially added in Fleet Maintenance (parts page) (10/02/09)
Recalculate procedure modified – Recalculate only if there is a PHYSICAL DATE entered (10/07/09)
Recalculate procedure modified – Create ADJUSTMENT record (for difference between PHYSICAL QUANTITY and QTY ON HAND). Adjustment date in Adjustment File is the day before the PHYSICAL INVENTORY DATE (10/07/09)
Change Inventory Item Cost (Maintenance menu) – Add GPI RECEIPT FILE to list of files to be changed (10/07/09)
DOUBLE CLICK will now produce POPUP selection screens (10/19/09)
‘Supplier Name’ changed to ‘Vendor Name’ to be consistent with other modules (10/19/09)
Inventory Master File Reports – Add PHYSICAL INVENTORY REPORT – similar to SPOT CHECK REPORT (10/27/09)
Usage Transaction Reports – Choose Account from Usage File rather than Inventory Master File (11/24/09)
Inventory Master File Browse – Add INVENTORY SOURCE (11/25/09)
Maintenance menu – Add RECONCILE GPI RECEIPTS option – This procedure will create Receipt records for Items that have mismatched QTY ON HAND + QTY USED and QTY RECEIVED. The Receipt entries will be coded as “COMPUTER GENERATED”. (11/25/09)
Inventory Master File Browse modified – Add F1 to VIEW RECEIPT TRANSACTIONS, F2 to VIEW USAGE TRANSACTIONS and F3 to VIEW ADJUSTMENT TRANSACTIONS (12/03/09)
Inventory Master File – Add FLEET Maintenance Code field (12/15/09)
Inventory Master File REPORTS- Add ACTIVE/INACTIVE/ALL Selection (01/14/10)
Inventory Master File Reports – Add new report – Location Ledger Summary (FIFO) (02/01/10)
Inventory Master File Reports – Add total to Ledger Summary (FIFO) and total by Location if sorted by location (02/01/10)
Recalculate procedure modified – Create ADJUSTMENT record IF difference between PHYSICAL QUANTITY and QTY ON HAND is NEGATIVE. Create RECEIPT record IF difference between PHYSICAL QUANTITY and QTY ON HAND is POSITIVE). Retrieve appropriate cost from Receipt transactions (02/04/10)
Recalculate procedure – Add PHYSICAL INVENTORY DATE RANGE to be recalculated (02/01/10)
Inventory Master File Browse modified – Add Physical Inventory Date range to selection screen (02/04/10)
Maintenance menu – Add Physical Inventory submenu with options for Physical Inventory (02/04/10)
Inventory Master File – Add validation on Item and Location fields so duplicate records are not created (02/04/10)
Maintenance menu – Add TRANSFER INVENTORY menu option. The menu option will create a negative adjustment for the item/qty being transferred and a receipt (flagged as TRANSFER) for new item (02/13/10)
Recalculate procedure modified – Flag Receipt records that are created as ADJUSTMENTS (02/13/10)
Receipt Reports – Add option to choose RECEIPT OF STOCK ITEM/ RECEIPT OF NON STOCK ITEM/TRANSFER/ADJUSTMENT/ALL (02/13/10)
Inventory Master File Reports – Detail and Summary FIFO Usage Reports – Add option to Include CHARGED DIRECTLY, NOT CHARGED DIRECTLY or ALL Usage records (02/15/10)
Inventory Master File – Expand COMMENTS field from 50 to 100 characters (02/15/10)
Automated Ordering – Garage Requisition – Retrieve Account from Vendor Master File when creating Garage Requisition record (02/24/10)
Inventory Master File Browse – Add RECEIPT DATE and selection of Receipt Date range (03/26/10)
RECEIPT ENTRY – Added 2 new buttons 1.) Add/Update Vendor Master File – This button allows new vendor to be added and/or existing vendor to be updated. Vendor Master File is displayed so vendor information can be updated 2.) Update Vendor In GPI Master File – This button will allow you to update the default vendor stored in the GPI Master File (05/07/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (08/19/10)
Garage Requisition File – Change BROWSE SORT default to GARAGE REQUISITION NUMBER (08/19/10)
Inventory Master File – Retrieve Budget Code (Account) from Vendor File (09/15/10)Form 10 or Form 11. Add report option for changes made.
System Menu – Print List of PGS Tables menu option added (10/11/10)
Add ‘Create XLS file’ button on all report selection screens (11/26/10)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
Inventory Master File – Add fields to better describe road inventory (MUTCD Code, Back Color, Legend Color, Size, Sheeting, Blank Material, Sign Type) – Retrieve these fields from Sign MUTCD File.
Receipt Transaction File – Add fields to better describe road inventory (MUTCD Code, Back Color, Legend Color, Size, Sheeting, Blank Material, Sign Type) – Retrieve these fields from Sign MUTCD File.
Add new form for Inventory Master File – Inventory Master File-Road Inventory Only – This form contains only the inventory records that are flagged as ROAD INVENTORY. (04/29/11)
Inventory Master File Reports – Add MUTCD Code Selection Range (04/29/11)
Inventory Master File Browse – Add MUTCD Code Selection Range and Sort Option (04/29/11)
Inventory Usage Transaction File – Add SIGN ID Sort Option on Browse (09/08/11)
GPI Master File – increase field length of DESCRIPTION (09/08/11)
Inventory Usage Reports – Add Sign Usage Report format (09/09/11)
Inventory Master File – Do not allow change to QUANTITY ON HAND field. For NEW INVENTORY ITEMS, enter current quantity in QTY ON HAND-PHYSICAL INVENTORY. Quantity on Hand is updated programmatically from any inventory transaction. This will allow better control of inventory. (12/16/11)
Add Manufacturer’s Part Number Cross Reference File-GPI Master File (01/16/12)
Inventory Master File – Add NOTES page (01/16/12)
Inventory Master File – BROWSE – Add F4 option to View Manufacturer Parts Numbers (01/16/12)
Inventory Receipt Entry – Add F11 to select Part from Manufacturer Part File (01/16/12)
Automated Ordering Form – Update Inventory Master File SUPPLIER #, SUPPLIER NAME and SUPPLIER PHONE if changed on Order Form (05/29/12)
Maintenance Menu – Transfer Inventory – Make Qty On Hand the DEFAULT Qty to Transfer only when Qty to Transfer is zero (08/01/12)
Road Inventory Data Entry Form – Add PHYSICAL QUANTITY and PHYSICAL DATE so quantity on hand can be entered for new inventory item (08/16/12)
Receipt Entry – Retrieve Vendor Name when Vendor Number entered (11/26/13)
Receipt Entry – Add Shelf/Bin-Vehicle as Sort Option (11/26/13)
Inventory Master File Browse – Add option to allow editing QTY ON HAND … proper procedure is to use PHYSICAL INVENTORY MENU for changing qty on hand:) (12/13/13)
Receipt Entry – Add PDF page for attaching and viewing PDF files (12/05/14)
System Variables Menu Option added – Allow Change to QTY ON HAND? Select Yes to allow editing the QUANTITY ON HAND (11/17/14)
Receipt Entry – Do not update Shelf/Bin Location (field can also be used for specifying vehicle) if item exists in Inventory File (11/17/14)
Automated Receipt – ALWAYS update Inventory COST, based on current receipt cost (07/17/15)
Automated Ordering – Update Garage Requisition record with Order Total and Vendor Information – previously just created blank requisition record (10/15/15)
Inventory Master File – Add RIGHT CLICK menu option to print barcode label (CODE 128) (04/29/16)
Receipt Transaction Entry – Add SCANNED BAR CODE to data entry screen. If scanned item does not exist in Manufacturer’s Part List, it is added (05/06/16)
Receipt Transaction Entry – Store scanned bar code in upper case (05/10/16)
Garage Requisition Entry Form – Add RIGHT CLICK menu allowing 1. Display Order Records (Order Records may be DISAPPROVED by supervisor. When disapproved, qty on order is set to zero and total amount of requisition is updated.) 2. Print Requisition (Approved Orders will be printed on Requisition) (05/26/16)
Garage Requisition Entry Form – Add APPROVED BY and APPROVAL DATE fields…APPROVED BY is selected from Employee Rates File. If APPROVED BY is entered, Requisition is marked as COMPLETE. (05/26/16)
Garage Requisition BROWSE – Add Approval Date and Purchase Order Number SORT options-Allow selection of COMPLETED or INCOMPLETE Requisitions (05/26/16)
Order Form – Display APPROVED field (05/26/16)
Receipt Transaction File – Retrieve Part Number from Inventory Master File if BAR CODE IS SCANNED and BAR CODE already exists on Manufacturer Parts Page of Inventory Master File (08/09/16)
Usage Transaction File – Add SCANNED BAR CODE to data entry screen. Retrieve Part Number from Inventory Master File if BAR CODE IS SCANNED and BAR CODE exists on Manufacturer Parts Page of Inventory Master File (08/09/16)
Receipt Transaction File – Add popup for Item Category field (08/12/16)
Automated Ordering Form – Add SCANNED BAR CODE to data entry screen. Retrieve Part Number from Inventory Master File if BAR CODE IS SCANNED and BAR CODE exists on Manufacturer Parts Page of Inventory Master File (08/22/16)
Garage Requisition Form – Add SHIPPING CHARGE (08/24/16)
Garage Requisition Report – ADD TOTAL, SHIPPING CHARGES and GRAND TOTAL (08/24/16)
System Variables – Add option to allow editing QTY ON HAND – already done
Modify Scanned Bar Code Field on Receipt Transaction File, Usage Transaction File, Automated Ordering Form – If Bar Code not found in Manufacturer Parts File, look in Inventory Master File…could be bar code of original part – change background color of bar code field for easier identification (09/07/16)
RIGHT CLICK PRINT OPTIONS – Garage Requisition Form – Add option to send to PRINTER, SCREEN, OR PDF (09/08/16)
Garage Requisition Form and Report – Add Core Charges and Date Core Charges Returned fields (10/10/16)
Receipt Transaction File – If BAR CODE field is blank or Inventory Item has been selected, do not attempt to find part (10/31/16)
DATE field popup (calendar) – Change DEFAULT to current date (11/03/16)
Manufacturer Parts File – Add direct access to Manufacturer Parts File – new menu option to add Manufacturer Parts (linked to Inventory Master File) (11/21/16)
Inventory Master File Reports – Add Manufacturer Parts Report – Lists all Inventory Items and Associated Manufacturer Parts (11/21/16)
Manufacturer Parts Report – Prints only Manufacturer Parts (11/21/16)
Low Quantity Inventory Report modified – Additional filter added for selected records – MAXIMUM QTY must be > 0 (02/01/17)
Bar Code Labels – Added Custom 4″x2″ label (03/08/17)
Garage Requisitions Form – Populate APPROVED BY field with USERNAME when cursor placed in BLANK field (3/20/17)
Transaction Reports – Receipt Reports – Add Indiana County Highway Form No. 31B-Inventory Receiving Report as new report type (07/06/17)
Transaction Reports – Usage Reports – Add Indiana County Highway Form No. 31C-Report of Materials and Supplies Issued as new report type (07/06/17)
Inventory Master File Reports – Add Indiana County Highway Form No. 31A-Perpetual Inventory Record as new report type (07/06/17)
System Variables Form – Add option to Update Completion Date of Requisition when APPROVED (11/16/17)
Maintenance Menu – Physical Inventory – Enter Physical Inventory Counts – Procedure simplified…PHYSICAL INVENTORY DATE is entered once on Selection Screen. A new field added for entering new physical inventory counts. This field will be blank, rather than containing the previous count. The previous count will be displayed beside the new count (12/15/17)
Receipt Transaction File – Update Vendor Name/Number when Receipt entered (01/02/18)
Receipt Transaction File – Update Shelf/Bin Location when Receipt entered (04/23/18)
Reports – Auditor Reports – Add QTY ON HAND range selection to Report Selection Screen (11/14/19)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)
Data Entry Forms (do not minimize when popup selected). 05/17/21

DWS (Daily Crew Worksheet)

Project Report Selection screen modified-First page of selection screen changed to “Other Detail Values” so Date of Work is on first page
All Report Options are now available in PDF format
Project File – F11 will display popup for the file NOT CHOSEN on the System Variables Form (Material Popup (Cost Table File or GPI Master File) – Equipment Popup (Cost Table File or Vehicle Master File).
Reports – Add COMP HOURS @ OVERTIME RATE to LABOR TOTAL on all reports
Road Master File Reports – Add DISTRICT selection range
Worksheet Detail Entry- Add FUEL QTY and VEM MAINTENANCE CODE’-create Fluid Record in Fleet Maintenance, update Vehicle with Fuel Usage and Mileage.
Road Master File form – Add RIGHT CLICK with option to DUPLICATE RECORD
DWS Detail Screen – Display Employee Name, Equipment Description and Material Description
A/R Interface – Add option to Create SUMMARY A/R RECORDS.
Add CULVERT NUMBER, GUARDRAIL NUMBER, SIGN NUMBER and appropriate popups so culverts, guardrails and signs can be selected from appropriate files-DATA ENTRY.
Add CULVERT NUMBER, GUARDRAIL NUMBER, SIGN NUMBER and appropriate popups so culverts, guardrails and signs can be selected from appropriate files-REPORT SELECTION.
Browse Selection screen added for Cost Table File
DWS Browse – Add SPECIAL CODE as sort option (new index)
DWS Detail Reports – Add subtotal for Employee Regular, O.T. and Comp Hours
New Report Added – Worksheet Summary – Prints one record per worksheet with totals and MEMO
Modify FEMA Equipment Reports (use FEMA RATE, if not zero)-see Vehicle Equipment Maintenance modifications above
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Add popup selection of Work Orders (Pavement Management) on Browse and Report Selection screens (Work Order and Estimate Number fields)
Detail Records – Add the following fields to DETAIL SCREEN. These fields were previously available only on HEADER SCREEN: ESTIMATE #, PROJECT CODE, GUARDRAIL, CULVERT, SIGN, BRIDGE, PROJECT. ALSO ADDED FUEL INVENTORY ITEM, FUEL UNIT COST and LOG # (05/02/07)
Fuel Inventory Inventory Item can be maintained in Cost Table File OR Garage and Parts Inventory File. Garage and Parts Inventory Usage File will be updated if using Garage and Parts Inventory. (05/05/07)
Add link to Response Log – Select Work Order using F11 from Work Order field (F10 displays Work Orders in Pavement Management) OR F10 from new LOG # field (05/03/07)
Add Log # to Header and Detail screens (05/05/07)
Add Log # to Report Selection screen (05/05/07)
Move all new detail fields to Detail Page of Report Selection Screen (05/02/07)
New File – Project Code File (previously SPECIAL CODE on Header screen). This file can be used to track FEMA projects. Project Code exists on Header and Detail screen and this file is used by F10 popup on both screens. (05/05/07)
Enlarge Special Code field (Worksheet Header) Enlarged from 10 to 20 characters (05/02/07)
Add popup for Worksheet Number (Report Selection Screen)
Add Response Log popup for Work Orders in Response Log – Worksheet Entry – Press F11 from
Work Order field (05/02/07)
Increase field length of MATERIAL COST – needs to be 9,999,999.9999 (05/02/07)
Browse Selection Screen – Allow ROAD INFORMATION to be selected on popup
Add menu option to check and repair data files (03/09/07)
Add HELP button on HELP/ABOUT (03/09/07)
Add BRIDGE to Header screen (04/25/07)
Add new F10 popup for BRIDGE – now stored in Culvert/Bridge file (04/25/07)
Add ‘Excel Spreadsheet’ as report output option (along with PDF) (05/05/07)
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability
Maximize Project Form when opened (05/07/07)
A/R Interface – Invoice Transaction Record modified – Description 2 is now COMMENTS from DWS Header Record (05/08/07)
Project Entry – Force F10 when BRIDGE, CULVERT, SIGN or GUARDRAIL is entered or changed. Retrieve Road Location data from appropriate file when non-blank. (05/11/07)
Add new detail fields (ESTIMATE #, PROJECT CODE, GUARDRAIL, CULVERT, SIGN, BRIDGE, PROJECT and LOG #) to Detail Browse Selection screen (05/11/07)
DWS Project Report Selection screen – Add SORT and SUBTOTAL options for CULVERT, SIGN, GUARDRAIL, BRIDGE, ESTIMATE # and LOG # (05/11/07)
DWS Detail BROWSE modified – Pay Information, Odometer, Work Code-Part 1, Fuel Information added (05/22/07)
System Variables Form – Add selection of ‘Invoice Number’ or ‘Date’ for cursor positioning on Project Form (06/14/07)
DWS Entry – Update GPI Usage file with CULVERT, SIGN, BRIDGE and GUARDRAIL numbers (07/07/07)
DWS Entry – Update GPI Usage file with EMPLOYEE ID (07/09/07)
DWS Entry – RIGHT CLICK from SIGN NUMBER field will allow ADD/EDIT SIGN MAINTENANCE RECORD (7/09/07)
Add RIGHT CLICK on CULVERT # field to allow update to CULVERT record (08/13/07)
Add RIGHT CLICK on BRIDGE # field to allow update to BRIDGE record (08/13/07)
Add RIGHT CLICK on GUARDRAIL # field to allow update to GUARDRAIL record (08/13/07)
DWS Project Code File – Add BRIDGE, CULVERT, SIGN, GUARDRAIL NUMBERS and NOTES fields (09/11/07)
DWS Entry – Retrieve BRIDGE, CULVERT, SIGN and GUARDRAIL NUMBERS when PROJECT CODE selected from PROJECT CODE file (09/11/07)
Work Code Table File – Add ROAD SECTION INVOLVED selection of LENGTH, LENGTH*WIDTH-SURFACE or LENGTH*WIDTH-ROAD BED
DWS Entry – Add SPLIT on Detail for splitting hours between multiple road sections The Split is based on the ROAD SECTION INVOLVED selection in the WORK CODE TABLE
FILE – Right Click from DETAIL PAGE of PROJECT FORM to select ROAD SECTIONS TO BE INCLUDED IN SPLIT (09/11/07)
Add FEMA RATE/FEMA NUMBER//STATE RATE/STATE NUMBER to Cost Table File – Modify FEMA Equipment Report to use new rates (when FEMA RATE selected) (11/13/07)
Project Reports – Add Condensed Detail WITHOUT Employee Name Report (11/14/07)
DWS Entry – Display DESCRIPTION of WORK CODE in top right corner of screen when cursor leaves work code field (11/28/07)
Popup added for FROM LOCATION and TO LOCATION fields (reports and DWS entry) (12/05/07)
Maintenance Menu – Add option to Update DWS Pay Rates with Payroll Pay Rates (Employee Rates File) – This procedure will change the DWS Rates to the Payroll Rates when the Payroll Rates are not zero – The Payroll Rates can be updated in the Payroll Management System. (12/05/07)
ROAD MASTER FILE – Add STATE INVENTORY NUMBER and FEDERAL AID NUMBER fields (12/19/07)
ROAD MASTER FILE – Add RESURFACE DATE field (12/19/07)
Add Maintenance menu option to CHANGE EMPLOYEE IDENTIFIERS (01/10/08)
Project Form – Activate Page 1 of Worksheet when adding new worksheet (01/16/08)
Material Listing (Cost Table File) – Add Vendor, FEMA Number and FEMA Rate to report (01/30/08)
Material Listing (Cost Table File) – Add selection range for Product Code (02/01/08)
Retrieve SIGN, CULVERT, BRIDGE and GUARDRAIL NUMBERS from Work Order File (Pavement Management) when Work Order selected during DWS entry (02/11/08)
Road Master File Reports – Landscape Inspection Report added (02/11/08)
Retrieve FROM LOCATION, LOG POINT, SIGN, CULVERT, BRIDGE and GUARDRAIL NUMBERS from Response Log File when Work Order selected during DWS entry (02/13/08)
Project Entry – Update Response Log File ‘Completion Date’ and Pavement Management Work Order Completion Date with Daily Crew Worksheet Completion Date. (02/13/08)
Project/Detail Entry – When Bridge/Culvert entered, update Bridge/Culvert Inventory record (Last Repair/Replaced and Date-Last Update = Work Date, Material = Material, Condition = Excellent, Route, Road Name, Log Point, From and To Locations, Road Section, Township, Length and Log Point)( 02/18/08)
Project/Detail Entry – When Guardrail entered, update Guardrail Inventory record (Last Repair/Replaced = Work Date, Material = Material, Condition = Excellent, Route, Road Name, Log Point, From and To Locations, Township) (02/18/08)
Project/Detail Entry – When Sign entered, update Sign Inventory record (Last Repair/Replaced = Work Date, Sign Condition = Excellent, Route, Road Name, Log Point, Location, Township) (02/18/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/19/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/19/08)
Add menu option to change Township I.D. (02/25/08)
Road Master File BROWSE Selection modified – Add “Road Direction” selection range and “Road Direction/Section/Road Section” Sort Option (05/14/08)
Road Master File Report Selection modified – Add “Road Direction” selection range and “Road Direction/Section/Road Section” Sort Option (05/14/08)
Add EDIT/NO-EDIT preference to Road Master File Browse Selection Screen-Defaults to NO-EDIT (03/06/08)
SIGN POPUPS modified – Display appropriate popup form based on operator SORT option (Sign Number, Sign ID, Road Name or Route) 03/24/08
CULVERT/BRIDGE/GUARDRAIL/MATERIAL POPUPS modified to display new popups, based on the chosen SORT option (04/01/08)
Culvert/Bridge/Sign/Guardrail Inventory updated with DWS MATERIAL only if “Culvert/Bridge/Sign/Guardrail Inventory Flag”= “Y” in Inventory Master File (04/17/08)
New Road Master File Report Added – Custom One Line Format (05/14/08)
Project Entry Form – Detail Page – Add TOTAL EMPLOYEE HOURS and TOTAL EQUIPMENT HOURS (05/14/08)
DWS Project Browse – Add Default Employee to Browse Window (05/14/08)
Equipment Popup – Add ODOMETER to popup screen (05/14/08)
Data Index procedure modified – Update Header Date with Date of First Worksheet entry (06/03/08)
Cost Table File – Add COST PER MILE (06/05/08)
DWS Project Entry (Detail Page) and DWS Detail Entry – Add BEGINNING ODOMETER, COST PER MILE and TOTAL MILES. Along with Equipment Hours and Hourly Rate, you can now track Equipment Mileage and Associated Cost per Mile (06/05/08)
DWS Reports – Add Equipment ‘Mileage’ and ‘Mileage Cost’ to Reports (06/09/08)
DWS Detail Browse – Add Mileage, Mileage Cost (06/10/08)
Modify Recalculate Procedure to include new Mileage Cost (06/10/08)
Retrieve Equipment Costs From Vehicle Master File (Maintenance menu)-Get new Mileage Cost – This procedure will obtain the Hourly Rate and Cost Per Mile for DWS Entries that do not have an Equipment Cost (06/10/08)
Change Equipment Cost (Maintenance menu)- Allow new Mileage Cost to be changed also (06/10/08)
Create Invoice Records – Project Entry – retrieve Account from Inventory Master File (MATERIALS) (06/13/08)
DWS Project Header Page – Vendor Number/Vendor Name Popups – RIGHT CLICK or F10 displays VENDOR FILE, F11 displays Constituent Names File (06/17/08)
DWS Split procedure modified to include splitting the newly store EQUIPMENT MILEAGE (06/23/08)
Highlight the field where the cursor is located (07/03/08)
Worksheet Detail – Highlight every other line of worksheet (like a ledger) ( 07/03/08)
Sign Interface modified – Add RIGHT CLICK from Sign Popup to Edit Sign Master File Record. Add Button to create new Sign Master File Record. (07/26/08)
System Update procedure modified – Check for undefined variables in PGSMG2.MEM (used by Worksheet Detail page). Update MEM file only if it needs to be updated:) (07/28/08)
Worksheet Detail – Change the highlighting so only the current line is highlighted (07/31/08)
Snow Routes report – Add SECTION and SUBDIVISION to report (08/04/08)
Employee Rates Listing – Give option to print ACTIVE/INACTIVE/ALL employees (08/11/08)
Project Reports – Add EMPLOYEE NAME as sort option (currently EMPLOYEE ID is sort option) 9/16/08
Project Reports – Add Employee Payroll Report – prints total by Pay Type – can be used to verify Payroll before creating Payroll (09/16/08)
Project Entry / Detail Entry – Change default Sign Popup to Sign Popup by Sign Number (was Sign ID) (09/16/08)
Project Entry / Detail Entry – Display SIGN NUMBER and DESCRIPTION when cursor is located in Sign ID field (09/16/08)
Project Reports – ALL reports will now use the selected rates (from the FEMA Variables page) – These rates were previously only used by the FEMA reports (09/18/08)
Cost Table File – Change Comments field to MEMO – was 50 characters (09/29/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/09/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/09/08)
Work Code File – Add option to exclude work codes from Daily Crew Worksheet Pop up window (10/14/08)
Project Reports – Add 100 character Optional Heading (PDF/XLS Output page) that will print on all Reports (10/14/08)
Culvert/Bridge Pop Ups – Add Township field (10/14/08)
Culvert Update – Update YEAR MODIFIED (new field in Culvert File) with DWS entry date when culvert number entered on worksheet 10/21/08)
Maintenance Menu – Add CHANGE ROUTE and CHANGE ROAD NAME menu options. These procedures will change the route or road name from one value to another in all data files (10/28/08)
Sign Data Entry – Add COMMENTS field to new sign data entry form -Comments are displayed, along with Sign Number and Description when sign is specified in DWS entry. (10/29/08)
Pay Type Popup modified – Account Numbers are replaced only if Account Numbers are non-blank in Pay Type Table File (10/29/08) worksheet.
SUMMARY REPORTS – Add Road Length (with subtotals) when ROAD SECTION or ANY CHANGE IN ROAD LOCATION is chosen as the Subtotal option (11/07/08)
SUMMARY REPORTS – Add Road Length (with subtotals) when ROAD SECTION or ANY CHANGE IN ROAD LOCATION is chosen as the Subtotal option (11/07/08)
Determine method to track fuel cost to project when fuel imported from automated fuel system rather than entered in Daily Crew Worksheet – added COST PER MILE to Vehicle Master File and Cost Table File (2008)
ROAD MASTER FILE – Add ROAD HISTORY PAGE to maintain details for each record in Road Master File (Date, Accidents, Inspector, Work Order, Daily Traffic, Comments) (12/13/08)
Add CREW Table File (Form 9) to maintain CREWS (12/13/08)
Employee Rates File – Add DEFAULT Vehicle, Snow Route, Spreader, Material, Material Location, Work Code, Crew (12/13/08)
DWS Entry – Retrieve new default values (if non-blank) from Employee Rates File when Employee is entered on worksheet (12/13/08)
Add DATA ENTRY on Top Menu (12/13/08)
Maintenance menu – Change Township ID – Change Township in DWS detail records and Road Master File – Optionally, update Township in Township File (12/29/08)
Employee Rates File – Add DEFAULT TIME IN and TIME OUT for new Time Sheet Entry form (01/16/09)
Data Entry menu – Add IMPORT TIME SHEETS option – Imports Time entries from new Time Management System (01/16/09)
Project Entry – Add WORK ORDER and PROJECT CODE to list of fields that can be changed with GLOBAL CHANGE (right click) 01/16/09
Employee Rates File Browse – Add CREW selection range (03/17/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/05/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/17/09) (07/27/09-refined)
DWS Entry – Add COMPLETION DATE to Standard Header Page (currently on Caller Request Page) (2009)
Material Popup modified – Add new material or RIGHT MOUSE CLICK to edit existing material (09/09/09)
DWS Reports – Print Date Range Selection on Header page of reports (09/14/09)
DWS Entry – Retrieve SNOW ROUTE from Employee Rates File during entry (10/08/09)
DWS Entry – Add SNOW ROUTE sort option on Road Popup (10/08/09)
DOUBLE CLICK will now produce POPUP selection screens (10/18/09)
A/R Invoice Transaction – Invoice transaction record contains WORK ORDER field from Daily Crew Worksheet (10/27/09)
Project Entry – Retrieve MAINTENANCE CODE from Inventory Master File (for Fuel Inventory Item) (12/15/09)
Project Entry – Retrieve Work Order Number from Work Order File (Pavement Management) when Estimate Number is entered or selected (02/27/10)
Project/Detail Entry – Retrieve Maintenance Code for Fuel Inventory Item ONLY IF it is currently blank (03/24/10)
Employee Rates File – Add IN HOUSE benefit rate percentages (regular and overtime)
Maintenance Menu – Add option to recalculate DWS Rates as Payroll Rate plus FEMA benefit percentage (04/05/10)
Maintenance Menu – Add option to recalculate DWS Rates as Payroll Rate plus IN HOUSE benefit percentage (04/05/10)
DWS Reports – Add PAYROLL RATE as Employee Rate Selection on Report Selection Form (04/05/10)
Project Entry – Retrieve Sign, Culvert, Bridge and Guardrail LOCATION information (from Sign, Culvert/Bridge and Guardrail files respectively when Sign#, Culvert#, Bridge# or Guardrail# is entered on Project Code record and Project Code is selected on worksheet (04/27/10)
DWS Browse – Display memo on Browse screen (04/27/10)
DWS Entry – Make Equipment Hours DEFAULT to Employee Hours (04/27/10) – Made an option on System Variables Form (05/19/10)
Add SURFACE TYPE to road popup screens (04/27/10)
DWS Reports – Add PAYROLL RATE plus IN HOUSE BENEFIT PERCENTAGE as Employee Rate Selection on Report Selection Form (05/04/10)
Project Code File – Add “WORK ORDER” field to Project Code Form. Allow selection of Work Order from Response Log or Pavement Management. Retrieve WORK ORDER when PROJECT CODE entered in Daily Crew Worksheet. (05/11/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Project Reports – Add PROBLEM DESCRIPTION (Response Log) or PROJECT DESCRIPTION (Pavement Management) when report is sorted by Work Order (05/19/10)
System Variables Form – Make Equipment Hours DEFAULT to Employee Hours is now an OPTION in DWS ENTRY (05/19/10)
DWS Reports – Change District Default to ‘Detail Records’ (was Header Record) – Add Summary Page to One Line Detail Report (07/09/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Maintenance menu – Change Route – Add Date Range for change (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
Cost Table File – Add LEASE (Y/N), LEASE MILEAGE and LEASE END DATE (09/30/10)
DWS Reports – Add option to select LEASE (Y/N/ALL) for Equipment on Reports (09/30/10)
DWS Reports – Add FEMA Summary Sheet Report as new report type. This report lists totals for FORCE LABOR ACCOUNT, FORCE ACCOUNT EQUIPMENT, MATERIALS, RENTAL EQUIPMENT and TOTAL COST. (10/04/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Cost Table File – Add RENTAL (Y/N), RENTAL COST, INVOICE, CHECK NUMBER, PROJECT CODE, BEGINNING RENTAL DATE, ENDING RENTAL DATE (10/26/10)
FEMA Summary Report modified to use RENTAL field in Cost Table File rather than LEASE field for calculating RENTAL EQUIPMENT (10/26/10)
DWS Reports – FEMA Rental Equipment Summary Report format added (10/26/10)
Cost Table File Reports – Equipment Listing – Add option to select RENTAL, LEASE, FORCE ACCOUNT or ALL Equipment. Add PROJECT CODE range selection (10/26/10)
Project Entry/Detail Entry – Retrieve location information from Response Log when Work Order or Log # entered ONLY if it is not blank in Response Log file
(11/12/10)
Project Entry/Detail Entry – Retrieve location information from Work Order (Pavement Management) when Work Order or Estimate # entered ONLY if it is not blank in
Work Order Log file (11/12/10)
DWS Reports – Add Work Code Description (FROM and TO selections) and TOTAL AMOUNT to Selection Criteria Page (11/18/10)
Employee Popup – Add SORT by NAME, ID, EMPLOYEE NUMBER (01/13/11)
Project Code Popup – Add SORT by DESCRIPTION, PROJECT CODE (01/13/11)
Project Entry – Add RIGHT CLICK menu option to UPDATE RESPONSE LOG ACTIONS with Daily Crew Worksheet memo (PAGE 1 and PAGE 4 right click menus) (01/21/11)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
DWS Entry – Add COMP EARNED HOURS TOTAL on Detail page (02/05/11)
DWS Entry – Add HOURS/TOTAL HOURS USED fields to Detail page for Fleet Interface-Update HOURS in Vehicle Master File (02/05/11)
DWS Entry – Add LOCATION field to FUEL PART (Detail) for consistency (02/05/11)
DWS Entry – Update Sign Inventory record with REPLACEMENT information when DWS Material is Sign Inventory–>> DWS-ROAD INVENTORY INTERFACE (02/08/11)
Sign Maintenance entry – Add F10/F11 popups for PROJECT (02/10/11)
Report Selection – Add Vendor Name selection range to reports. Vendor Name can be used to track contract work (03/31/11)
Road Master File – Add RETRIEVE FROM LOCATION and RETRIEVE TO LOCATION buttons to data entry form. Add FROM PHYSICAL LOCATION and TO PHYSICAL LOCATION fields to data entry form. These fields can be populated using a GPS receiver. (06/09/11)
FEMA REPORTS – All FEMA Reports were updated to reflect the most current formats (07/26/11)
Cost Table File Updated – New fields CAPACITY, MOTOR (HP), Hours/Miles and FEMA RATE W/ Operator Added for New FEMA Report Layouts (07/26/11)
DWS Project File Browse – Add SORT by DEFAULT EMPLOYEE – This would be the DEFAULT EMPLOYEE on the Header Page (07/26/11)
DWS Entry – Do not update PAY TYPE (to default pay type) when cursor leaves EMPLOYEE field unless PAY TYPE is BLANK (08/11/11)
FEMA REPORTS – Add CERTIFIED BY, TITLE and DATE for report summary – Print variables if they are entered (09/02/11)
FEMA REPORTS – Labor and Equipment Reports will now begin with the first date ENTERED on the Selection screen rather than the first date of any work (09/02/11)
DWS Entry – Display UNIT OF MEASURE when cursor is on MATERIAL field (09/15/11)
DWS Browse – popup order of fields modified in SORT ORDER for easier selection of Work Order and Road Name (10/05/11)
DWS Project File Form – Remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (10/31/11)
Cost Table File – Limit number of characters in EQUIPMENT to ten to be consistent with EQUIPMENT NUMBER in all modules (10/31/11)
DWS Entry – Add SIGN NUMBER and HISTORY (Y/N) to Sign Maintenance form so Sign Master File record can be updated from Sign Maintenance entry (11/29/11)
Sign Popup – Display only ACTIVE (NOT HISTORY) records (11/29/11)
Payroll Reports – Rounding changed to match Payroll (12/29/11)
Road Master File Reports – Add ROAD SECTION Report Order option (01/17/12)
Cost Table File – Increase field length of DESCRIPTION field (02/27/12)
Maintenance Menu – Added option to Globally Change Route Number. This option will add leading zeros to numeric Route Numbers so field length is consistent and
will sort numerically (03/03/12)
Maintenance Menu – Change Township ID – Change procedure so ALL files used by ALL PGS modules are updated – previously only DWS files were updated (03/19/12)
Maintenance Menu – Change Route Number – Allow upper and lower case characters to be entered (04/25/12)
Add Issue II reports (Equipment Usage Report and In Kind Contributions Time Reporting Record)
Sign Maintenance – Minor adjustments made to data entry form so it is consistent with Sign Maintenance (allow sign number to be assigned) (07/26/12)
Maintenance Menu – Add RECALCULATE MATERIAL COST BASED ON FIFO – This menu option will update the material cost in the Daily Crew Worksheet Detail File (Materials) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/12)
Maintenance Menu – Add RECALCULATE MATERIAL COST BASED ON FIFO – This menu option will update the material cost in the Daily Crew Worksheet Detail File (Materials) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/12)
Cost Table File – Add STATE RATE PER MILE (11/21/12)
DWS Project Reports – Add Issue II reports (Equipment Usage Report and In Kind Contributions Time Reporting Record) (11/21/12)
DWS Project Reports – Add option to select STATE RATE for Equipment Rate (FEMA/OPW Variables page) 11/21/12
DWS Entry – Header Page – Retrieve BRIDGE, SIGN, CULVERT and GUARDRAIL NUMBER when PROJECT CODE is entered – (previously only retrieved when PROJECT CODE selected from popup) (11/21/12)
Employee Rates File – Do not allow duplicate Employee ID (02/14/13)
Summary Reports – When SUBTOTAL ON “Any Change In Road Location”, include ROAD NAME and ROUTE in the SUBTOTAL (03/14/13)
Project Summary and Project Detail Reports – When SUBTOTAL ON “Any Change In Road Location”, include ROAD NAME, ROUTE and Length in the SUBTOTAL (03/15/13)
Maintenance Menu – Add Road Location Submenu (03/15/13)
Add option to SPLIT LOCATION for entire worksheet – COMMAND BUTTON on Worksheet Detail Page allows selection of road sections for worksheet split. All labor, equipment and material costs will be divided among selected road sections based on LENGTH, LENGTH*WIDTH-ROAD SURFACE or LENGTH*WIDTH-ROAD BED. The Work Code determines the type of SPLIT. (04/29/13)
Project Entry – Add option to menu displayed with RIGHT MOUSE CLICK – PRINT WORKSHEET (05/06/13)
Maintenance menu – Add option to change Employee Pay Type for a selected employee and date range (07/31/13)
Project Report Selection screen modified-First page of selection screen changed to “Other Detail Values” so Date of Work is on first page
All Report Options are now available in PDF format
Project File – F11 will display popup for the file NOT CHOSEN on the System Variables Form (Material Popup (Cost Table File or GPI Master File) – Equipment Popup (Cost Table File or Vehicle Master File).
Reports – Add COMP HOURS @ OVERTIME RATE to LABOR TOTAL on all reports
Road Master File Reports – Add DISTRICT selection range
Worksheet Detail Entry- Add FUEL QTY and VEM MAINTENANCE CODE’-create Fluid Record in Fleet Maintenance, update Vehicle with Fuel Usage and Mileage.
Road Master File form – Add RIGHT CLICK with option to DUPLICATE RECORD
DWS Detail Screen – Display Employee Name, Equipment Description and Material Description
A/R Interface – Add option to Create SUMMARY A/R RECORDS.
Add CULVERT NUMBER, GUARDRAIL NUMBER, SIGN NUMBER and appropriate popups so culverts, guardrails and signs can be selected from appropriate files-DATA ENTRY.
Add CULVERT NUMBER, GUARDRAIL NUMBER, SIGN NUMBER and appropriate popups so culverts, guardrails and signs can be selected from appropriate files-REPORT SELECTION.
Browse Selection screen added for Cost Table File
DWS Browse – Add SPECIAL CODE as sort option (new index)
DWS Detail Reports – Add subtotal for Employee Regular, O.T. and Comp Hours
New Report Added – Worksheet Summary – Prints one record per worksheet with totals and MEMO
Modify FEMA Equipment Reports (use FEMA RATE, if not zero)-see Vehicle Equipment Maintenance modifications above
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Add popup selection of Work Orders (Pavement Management) on Browse and Report Selection screens (Work Order and Estimate Number fields)
Detail Records – Add the following fields to DETAIL SCREEN. These fields were previously available only on HEADER SCREEN: ESTIMATE #, PROJECT CODE, GUARDRAIL,
CULVERT, SIGN, BRIDGE, PROJECT. ALSO ADDED FUEL INVENTORY ITEM, FUEL UNIT COST and LOG # (05/02/07)
Fuel Inventory Inventory Item can be maintained in Cost Table File OR Garage and Parts Inventory File. Garage and Parts Inventory Usage File will be updated if using Garage and Parts Inventory. (05/05/07)
Add link to Response Log – Select Work Order using F11 from Work Order field (F10 displays Work Orders in Pavement Management) OR F10 from new LOG # field (05/03/07)
Add Log # to Header and Detail screens (05/05/07)
Add Log # to Report Selection screen (05/05/07)
Move all new detail fields to Detail Page of Report Selection Screen (05/02/07)
New File – Project Code File (previously SPECIAL CODE on Header screen). This file can be used to track FEMA projects. Project Code exists on Header and Detail
screen and this file is used by F10 popup on both screens. (05/05/07)
Enlarge Special Code field (Worksheet Header) Enlarged from 10 to 20 characters (05/02/07)
Add popup for Worksheet Number (Report Selection Screen)
Add Response Log popup for Work Orders in Response Log – Worksheet Entry – Press F11 from Work Order field (05/02/07)
Increase field length of MATERIAL COST – needs to be 9,999,999.9999 (05/02/07)
Browse Selection Screen – Allow ROAD INFORMATION to be selected on popup
Add menu option to check and repair data files (03/09/07)
Add HELP button on HELP/ABOUT (03/09/07)
Add BRIDGE to Header screen (04/25/07)
Add new F10 popup for BRIDGE – now stored in Culvert/Bridge file (04/25/07)
Add ‘Excel Spreadsheet’ as report output option (along with PDF) (05/05/07)
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability
Maximize Project Form when opened (05/07/07)
A/R Interface – Invoice Transaction Record modified – Description 2 is now COMMENTS from DWS Header Record (05/08/07)
Project Entry – Force F10 when BRIDGE, CULVERT, SIGN or GUARDRAIL is entered or changed. Retrieve Road Location data from appropriate file when non-blank. (05/11/07)
Add new detail fields (ESTIMATE #, PROJECT CODE, GUARDRAIL, CULVERT, SIGN, BRIDGE, PROJECT and LOG #) to Detail Browse Selection screen (05/11/07)
DWS Project Report Selection screen – Add SORT and SUBTOTAL options for CULVERT, SIGN, GUARDRAIL, BRIDGE, ESTIMATE # and LOG # (05/11/07)
DWS Detail BROWSE modified – Pay Information, Odometer, Work Code-Part 1, Fuel Information added (05/22/07)
System Variables Form – Add selection of ‘Invoice Number’ or ‘Date’ for cursor positioning on Project Form (06/14/07)
DWS Entry – Update GPI Usage file with CULVERT, SIGN, BRIDGE and GUARDRAIL numbers (07/07/07)
DWS Entry – Update GPI Usage file with EMPLOYEE ID (07/09/07)
DWS Entry – RIGHT CLICK from SIGN NUMBER field will allow ADD/EDIT SIGN, MAINTENANCE RECORD (7/09/07)
Add RIGHT CLICK on CULVERT # field to allow update to CULVERT record (08/13/07)
Add RIGHT CLICK on BRIDGE # field to allow update to BRIDGE record (08/13/07)
Add RIGHT CLICK on GUARDRAIL # field to allow update to GUARDRAIL record (08/13/07)
DWS Project Code File – Add BRIDGE, CULVERT, SIGN, GUARDRAIL NUMBERS and NOTES fields (09/11/07)
DWS Entry – Retrieve BRIDGE, CULVERT, SIGN and GUARDRAIL NUMBERS when PROJECT CODE selected from PROJECT CODE file (09/11/07)
Work Code Table File – Add ROAD SECTION INVOLVED selection of LENGTH, LENGTH*WIDTH-SURFACE or LENGTH*WIDTH-ROAD BED DWS Entry – Add SPLIT on Detail for splitting hours between multiple road sections The Split is based on the ROAD SECTION INVOLVED selection in the WORK CODE TABLE FILE – Right Click from DETAIL PAGE of PROJECT FORM to select ROAD SECTIONS TO BE INCLUDED IN SPLIT (09/11/07)
Add FEMA RATE/FEMA NUMBER//STATE RATE/STATE NUMBER to Cost Table File – Modify FEMA Equipment Report to use new rates (when FEMA RATE selected) (11/13/07)
Project Reports – Add Condensed Detail WITHOUT Employee Name Report (11/14/07)
DWS Entry – Display DESCRIPTION of WORK CODE in top right corner of screen when cursor leaves work code field (11/28/07)
Popup added for FROM LOCATION and TO LOCATION fields (reports and DWS entry) (12/05/07)
Maintenance Menu – Add option to Update DWS Pay Rates with Payroll Pay Rates (Employee Rates File) – This procedure will change the DWS Rates to the Payroll Rates
when the Payroll Rates are not zero – The Payroll Rates can be updated in the Payroll Management System. (12/05/07)
ROAD MASTER FILE – Add STATE INVENTORY NUMBER and FEDERAL AID NUMBER fields (12/19/07)
ROAD MASTER FILE – Add RESURFACE DATE field (12/19/07)
Add Maintenance menu option to CHANGE EMPLOYEE IDENTIFIERS (01/10/08)
Project Form – Activate Page 1 of Worksheet when adding new worksheet (01/16/08)
Material Listing (Cost Table File) – Add Vendor, FEMA Number and FEMA Rate to report (01/30/08)
Material Listing (Cost Table File) – Add selection range for Product Code (02/01/08)
Retrieve SIGN, CULVERT, BRIDGE and GUARDRAIL NUMBERS from Work Order File (Pavement Management) when Work Order selected during DWS entry (02/11/08)
Road Master File Reports – Landscape Inspection Report added (02/11/08)
Retrieve FROM LOCATION, LOG POINT, SIGN, CULVERT, BRIDGE and GUARDRAIL NUMBERS from Response Log File when Work Order selected during DWS entry (02/13/08)
Project Entry – Update Response Log File ‘Completion Date’ and Pavement Management Work Order Completion Date with Daily Crew Worksheet Completion Date. (02/13/08)
Project/Detail Entry – When Bridge/Culvert entered, update Bridge/Culvert Inventory record (Last Repair/Replaced and Date-Last Update = Work Date, Material = Material, Condition = Excellent, Route, Road Name, Log Point, From and To Locations, Road Section, Township, Length and Log Point)( 02/18/08)
Project/Detail Entry – When Guardrail entered, update Guardrail Inventory record (Last Repair/Replaced = Work Date, Material = Material, Condition = Excellent,
Route, Road Name, Log Point, From and To Locations, Township ) (02/18/08)
Project/Detail Entry – When Sign entered, update Sign Inventory record (Last Repair/Replaced = Work Date, Sign Condition = Excellent, Route, Road Name,
Log Point, Location, Township ) (02/18/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/19/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/19/08)
Add menu option to change Township I.D. (02/25/08)
Road Master File BROWSE Selection modified – Add “Road Direction” selection range and “Road Direction/Section/Road Section” Sort Option (05/14/08)
Road Master File Report Selection modified – Add “Road Direction” selection range and “Road Direction/Section/Road Section” Sort Option (05/14/08)
Add EDIT/NO-EDIT preference to Road Master File Browse Selection Screen-Defaults to NO-EDIT (03/06/08)
SIGN POPUPS modified – Display appropriate popup form based on operator SORT option (Sign Number, Sign ID, Road Name or Route) 03/24/08
CULVERT/BRIDGE/GUARDRAIL/MATERIAL POPUPS modified to display new popups, based on the chosen SORT option (04/01/08)
Culvert/Bridge/Sign/Guardrail Inventory updated with DWS MATERIAL only if “Culvert/Bridge/Sign/Guardrail Inventory Flag”= “Y” in Inventory Master File (04/17/08)
New Road Master File Report Added – Custom One Line Format (05/14/08)
Project Entry Form – Detail Page – Add TOTAL EMPLOYEE HOURS and TOTAL EQUIPMENT HOURS (05/14/08)
DWS Project Browse – Add Default Employee to Browse Window (05/14/08)
Equipment Popup – Add ODOMETER to popup screen (05/14/08)
Data Index procedure modified – Update Header Date with Date of First Worksheet entry (06/03/08)
Cost Table File – Add COST PER MILE (06/05/08)
DWS Project Entry (Detail Page) and DWS Detail Entry – Add BEGINNING ODOMETER, COST PER MILE and TOTAL MILES. Along with Equipment Hours and Hourly Rate, you can now track Equipment Mileage and Associated Cost per Mile (06/05/08)
DWS Reports – Add Equipment ‘Mileage’ and ‘Mileage Cost’ to Reports (06/09/08)
DWS Detail Browse – Add Mileage, Mileage Cost (06/10/08)
Modify Recalculate Procedure to include new Mileage Cost (06/10/08)
Retrieve Equipment Costs From Vehicle Master File (Maintenance menu)-Get new Mileage Cost – This procedure will obtain the Hourly Rate and Cost Per Mile for DWS
Entries that do not have an Equipment Cost (06/10/08)
Change Equipment Cost (Maintenance menu)- Allow new Mileage Cost to be changed also (06/10/08)
Create Invoice Records – Project Entry – retrieve Account from Inventory Master File (MATERIALS) (06/13/08)
DWS Project Header Page – Vendor Number/Vendor Name Popups – RIGHT CLICK or F10 displays VENDOR FILE, F11 displays Constituent Names File (06/17/08)
DWS Split procedure modified to include splitting the newly store EQUIPMENT MILEAGE (06/23/08)
Highlight the field where the cursor is located (07/03/08)
Worksheet Detail – Highlight every other line of worksheet (like a ledger) (07/03/08)
Sign Interface modified – Add RIGHT CLICK from Sign Popup to Edit Sign Master File Record. Add Button to create new Sign Master File Record. (07/26/08)
System Update procedure modified – Check for undefined variables in PGSMG2.MEM (used by Worksheet Detail page). Update MEM file only if it needs to be updated:) (07/28/08)
Worksheet Detail – Change the highlighting so only the current line is highlighted (07/31/08)
Snow Routes report – Add SECTION and SUBDIVISION to report (08/04/08)
Employee Rates Listing – Give option to print ACTIVE/INACTIVE/ALL employees (08/11/08)
Project Reports – Add EMPLOYEE NAME as sort option (currently EMPLOYEE ID is sort option) 9/16/08
Project Reports – Add Employee Payroll Report – prints total by Pay Type – can be used to verify Payroll before creating Payroll (09/16/08)
Project Entry / Detail Entry – Change default Sign Popup to Sign Popup by Sign Number (was Sign ID) (09/16/08)
Project Entry / Detail Entry – Display SIGN NUMBER and DESCRIPTION when cursor is located in Sign ID field (09/16/08)
Project Reports – ALL reports will now use the selected rates (from the FEMA Variables page) – These rates were previously only used by the FEMA reports (09/18/08)
Cost Table File – Change Comments field to MEMO – was 50 characters (09/29/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/09/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/09/08)
Work Code File – Add option to exclude work codes from Daily Crew Worksheet Pop up window (10/14/08)
Project Reports – Add 100 character Optional Heading (PDF/XLS Output page) that will print on all Reports (10/14/08)
Culvert/Bridge Pop Ups – Add Township field (10/14/08)
Culvert Update – Update YEAR MODIFIED (new field in Culvert File) with DWS entry date when culvert number entered on worksheet 10/21/08)
Maintenance Menu – Add CHANGE ROUTE and CHANGE ROAD NAME menu options. These procedures will change the route or road name from one value to another in all data files (10/28/08)
Sign Data Entry – Add COMMENTS field to new sign data entry form -Comments are displayed, along with Sign Number and Description when sign is specified in DWS entry. (10/29/08)
Pay Type Popup modified – Account Numbers are replaced only if Account Numbers are non-blank in Pay Type Table File (10/29/08) worksheet.
SUMMARY REPORTS – Add Road Length (with subtotals) when ROAD SECTION or ANY CHANGE IN ROAD LOCATION is chosen as the Subtotal option (11/07/08)
SUMMARY REPORTS – Add Road Length (with subtotals) when ROAD SECTION or ANY CHANGE IN ROAD LOCATION is chosen as the Subtotal option (11/07/08)
Determine method to track fuel cost to project when fuel imported from automated fuel system rather than entered in Daily Crew Worksheet – added COST PER MILE to
Vehicle Master File and Cost Table File (2008)
ROAD MASTER FILE – Add ROAD HISTORY PAGE to maintain details for each record in Road Master File (Date, Accidents, Inspector, Work Order, Daily Traffic,
Comments) (12/13/08)
Add CREW Table File (Form 9) to maintain CREWS (12/13/08)
Employee Rates File – Add DEFAULT Vehicle, Snow Route, Spreader, Material, Material Location, Work Code, Crew (12/13/08)
DWS Entry – Retrieve new default values (if non-blank) from Employee Rates File when Employee is entered on worksheet (12/13/08)
Add DATA ENTRY on Top Menu (12/13/08)
Maintenance menu – Change Township ID – Change Township in DWS detail records and Road Master File – Optionally, update Township in Township File (12/29/08)
Employee Rates File – Add DEFAULT TIME IN and TIME OUT for new Time Sheet Entry form (01/16/09)
Data Entry menu – Add IMPORT TIME SHEETS option – Imports Time entries from new Time Management System (01/16/09)
Project Entry – Add WORK ORDER and PROJECT CODE to list of fields that can be changed with GLOBAL CHANGE (right click) 01/16/09
Employee Rates File Browse – Add CREW selection range (03/17/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/05/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/17/09) (07/27/09-refined)
DWS Entry – Add COMPLETION DATE to Standard Header Page (currently on Caller Request Page) (2009)
Material Popup modified – Add new material or RIGHT MOUSE CLICK to edit existing material (09/09/09)
DWS Reports – Print Date Range Selection on Header page of reports (09/14/09)
DWS Entry – Retrieve SNOW ROUTE from Employee Rates File during entry (10/08/09)
DWS Entry – Add SNOW ROUTE sort option on Road Popup (10/08/09)
DOUBLE CLICK will now produce POPUP selection screens (10/18/09)
A/R Invoice Transaction – Invoice transaction record contains WORK ORDER field from Daily Crew Worksheet (10/27/09)
Project Entry – Retrieve MAINTENANCE CODE from Inventory Master File (for Fuel Inventory Item) (12/15/09)
Project Entry – Retrieve Work Order Number from Work Order File (Pavement Management) when Estimate Number is entered or selected (02/27/10)
Project/Detail Entry – Retrieve Maintenance Code for Fuel Inventory Item ONLY IF it is currently blank (03/24/10)
Employee Rates File – Add IN HOUSE benefit rate percentages (regular and overtime)
Maintenance Menu – Add option to recalculate DWS Rates as Payroll Rate plus FEMA benefit percentage (04/05/10)
Maintenance Menu – Add option to recalculate DWS Rates as Payroll Rate plus IN HOUSE benefit percentage (04/05/10)
DWS Reports – Add PAYROLL RATE as Employee Rate Selection on Report Selection Form (04/05/10)
Project Entry – Retrieve Sign, Culvert, Bridge and Guardrail LOCATION information (from Sign, Culvert/Bridge and Guardrail files respectively when Sign#,
Culvert#, Bridge# or Guardrail# is entered on Project Code record and Project Code is selected on worksheet (04/27/10)
DWS Browse – Display memo on Browse screen (04/27/10)
DWS Entry – Make Equipment Hours DEFAULT to Employee Hours (04/27/10)
Made an option on System Variables Form (05/19/10)
Add SURFACE TYPE to road popup screens (04/27/10)
DWS Reports – Add PAYROLL RATE plus IN HOUSE BENEFIT PERCENTAGE as Employee Rate Selection on Report Selection Form (05/04/10)
Project Code File – Add “WORK ORDER” field to Project Code Form. Allow selection of Work Order from Response Log or Pavement Management. Retrieve WORK ORDER when PROJECT CODE entered in Daily Crew Worksheet. (05/11/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Project Reports – Add PROBLEM DESCRIPTION (Response Log) or PROJECT DESCRIPTION (Pavement Management) when report is sorted by Work Order (05/19/10)
System Variables Form – Make Equipment Hours DEFAULT to Employee Hours is now an OPTION in DWS ENTRY (05/19/10)
DWS Reports – Change District Default to ‘Detail Records’ (was Header Record) – Add Summary Page to One Line Detail Report (07/09/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Maintenance menu – Change Route – Add Date Range for change (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
Cost Table File – Add LEASE (Y/N), LEASE MILEAGE and LEASE END DATE (09/30/10)
DWS Reports – Add option to select LEASE (Y/N/ALL) for Equipment on Reports (09/30/10)
DWS Reports – Add FEMA Summary Sheet Report as new report type. This report lists totals for FORCE LABOR ACCOUNT, FORCE ACCOUNT EQUIPMENT, MATERIALS, RENTAL EQUIPMENT and TOTAL COST. (10/04/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Cost Table File – Add RENTAL (Y/N), RENTAL COST, INVOICE, CHECK NUMBER, PROJECT CODE, BEGINNING RENTAL DATE, ENDING RENTAL DATE (10/26/10)
FEMA Summary Report modified to use RENTAL field in Cost Table File rather than LEASE field for calculating RENTAL EQUIPMENT (10/26/10)
DWS Reports – FEMA Rental Equipment Summary Report format added (10/26/10)
Cost Table File Reports – Equipment Listing – Add option to select RENTAL, LEASE, FORCE ACCOUNT or ALL Equipment. Add PROJECT CODE range selection (10/26/10)
Project Entry/Detail Entry – Retrieve location information from Response Log when Work Order or Log # entered ONLY if it is not blank in Response Log file (11/12/10)
Project Entry/Detail Entry – Retrieve location information from Work Order (Pavement Management) when Work Order or Estimate # entered ONLY if it is not blank in
Work Order Log file (11/12/10)
DWS Reports – Add Work Code Description (FROM and TO selections) and TOTAL AMOUNT to Selection Criteria Page (11/18/10)
Employee Popup – Add SORT by NAME, ID, EMPLOYEE NUMBER (01/13/11)
Project Code Popup – Add SORT by DESCRIPTION, PROJECT CODE (01/13/11)
Project Entry – Add RIGHT CLICK menu option to UPDATE RESPONSE LOG ACTIONS with Daily Crew Worksheet memo (PAGE 1 and PAGE 4 right click menus) (01/21/11)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
DWS Entry – Add COMP EARNED HOURS TOTAL on Detail page (02/05/11)
DWS Entry – Add HOURS/TOTAL HOURS USED fields to Detail page for Fleet Interface-Update HOURS in Vehicle Master File (02/05/11)
DWS Entry – Add LOCATION field to FUEL PART (Detail) for consistency (02/05/11)
DWS Entry – Update Sign Inventory record with REPLACEMENT information when DWS Material is Sign Inventory–>> DWS-ROAD INVENTORY INTERFACE (02/08/11)
Sign Maintenance entry – Add F10/F11 popups for PROJECT (02/10/11)
Report Selection – Add Vendor Name selection range to reports. Vendor Name can be used to track contract work (03/31/11)
Road Master File – Add RETRIEVE FROM LOCATION and RETRIEVE TO LOCATION buttons to data entry form. Add FROM PHYSICAL LOCATION and TO PHYSICAL LOCATION fields to data entry form. These fields can be populated using a GPS receiver. (06/09/11)
FEMA REPORTS – All FEMA Reports were updated to reflect the most current formats (07/26/11)
Cost Table File Updated – New fields CAPACITY, MOTOR (HP), Hours/Miles and FEMA RATE W/ Operator Added for New FEMA Report Layouts (07/26/11)
DWS Project File Browse – Add SORT by DEFAULT EMPLOYEE – This would be the DEFAULT EMPLOYEE on the Header Page (07/26/11)
DWS Entry – Do not update PAY TYPE (to default pay type) when cursor leaves EMPLOYEE field unless PAY TYPE is BLANK (08/11/11)
FEMA REPORTS – Add CERTIFIED BY, TITLE and DATE for report summary – Print variables if they are entered (09/02/11)
FEMA REPORTS – Labor and Equipment Reports will now begin with the first date ENTERED on the Selection screen rather than the first date of any work (09/02/11)
DWS Entry – Display UNIT OF MEASURE when cursor is on MATERIAL field (09/15/11)
DWS Browse – popup order of fields modified in SORT ORDER for easier selection of Work Order and Road Name (10/05/11)
DWS Project File Form – Remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (10/31/11)
Cost Table File – Limit number of characters in EQUIPMENT to ten to be consistent with EQUIPMENT NUMBER in all modules (10/31/11)
DWS Entry – Add SIGN NUMBER and HISTORY (Y/N) to Sign Maintenance form so Sign Master File record can be updated from Sign Maintenance entry (11/29/11)
Sign Popup – Display only ACTIVE (NOT HISTORY) records (11/29/11)
Payroll Reports – Rounding changed to match Payroll (12/29/11)
Road Master File Reports – Add ROAD SECTION Report Order option (01/17/12)
Cost Table File – Increase field length of DESCRIPTION field (02/27/12)
Maintenance Menu – Added option to Globally Change Route Number. This option will add leading zeros to numeric Route Numbers so field length is consistent and will sort numerically (03/03/12)
Maintenance Menu – Change Township ID – Change procedure so ALL files used by ALL PGS modules are updated – previously only DWS files were updated (03/19/12)
Maintenance Menu – Change Route Number – Allow upper and lower case characters to be entered (04/25/12)
Add Issue II reports (Equipment Usage Report and In Kind Contributions Time Reporting Record)
Sign Maintenance – Minor adjustments made to data entry form so it is consistent with Sign Maintenance (allow sign number to be assigned) (07/26/12)
Maintenance Menu – Add RECALCULATE MATERIAL COST BASED ON FIFO – This menu option will update the material cost in the Daily Crew Worksheet Detail File (Materials) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/12)
Maintenance Menu – Add RECALCULATE MATERIAL COST BASED ON FIFO – This menu option will update the material cost in the Daily Crew Worksheet Detail File (Materials) and GPI Usage File, based on FIFO. The cost is calculated from Receipt entries. (10/11/12)
Cost Table File – Add STATE RATE PER MILE (11/21/12)
DWS Project Reports – Add Issue II reports (Equipment Usage Report and In Kind Contributions Time Reporting Record) (11/21/12)
DWS Project Reports – Add option to select STATE RATE for Equipment Rate (FEMA/OPW Variables page) 11/21/12
DWS Entry – Header Page – Retrieve BRIDGE, SIGN, CULVERT and GUARDRAIL NUMBER when PROJECT CODE is entered – (previously only retrieved when PROJECT CODE selected from popup) (11/21/12)
Employee Rates File – Do not allow duplicate Employee ID (02/14/13)
Summary Reports – When SUBTOTAL ON “Any Change In Road Location”, include ROAD NAME and ROUTE in the SUBTOTAL (03/14/13)
Project Summary and Project Detail Reports – When SUBTOTAL ON “Any Change In Road Location”, include ROAD NAME, ROUTE and Length in the SUBTOTAL (03/15/13)
Maintenance Menu – Add Road Location Submenu (03/15/13)
Add option to SPLIT LOCATION for entire worksheet – COMMAND BUTTON on Worksheet Detail Page allows selection of road sections for worksheet split. All labor, equipment and material costs will be divided among selected road sections based on LENGTH, LENGTH*WIDTH-ROAD SURFACE or LENGTH*WIDTH-ROAD BED. The Work Code determines the type of SPLIT. (04/29/13)
Project Entry – Add option to menu displayed with RIGHT MOUSE CLICK – PRINT WORKSHEET (05/06/13)
Maintenance menu – Add option to change Employee Pay Type for a selected employee and date range (07/31/13)
DWS Header Browse – Add ROAD SECTION SORT BY option (11/02/13)
DWS Contractor Costs – Add CONTRACTOR COSTS form. Right Click menu option will create A/R record in A/R Management or A/P Invoice record in Government Accounting. PDF Invoice from Contractor can be viewed on form. (11/11/13)
DWS Reports modified to include Contractor Costs – Reports modified are SUMMARY, PROJECT SUMMARY and PROJECT DETAIL (11/11/13)
DWS entry – Create Labor record in Fleet Maintenance for Labor Hours when LABOR is selected as VEM MAINTENANCE CODE – Detail Page Of Project File Form or Detail File Form (11/11/13)
DWS Entry – Display Employee Name, Equipment Make and Material Description during entry (11/22/13)
DWS Project Form Browse – Add Selection Screen with Sort Option (01/02/14)
DWS Detail File Browse – Add WORK ORDER as Sort Option (01/08/14)
DWS FEMA Summary Report – Add CONTRACT COSTS (from new Contractor Costs form) 01/13/14
Maintenance Menu – Add option to Fix DWS Worksheet Number…Worksheet Number may need to be reset IF Index Data Files run from old installation after updating data from a new installation (03/14/14)
System Update – Update length of Worksheet Number to 10 digits… for old installations when worksheet number was 5 digits (03/14/14)
FEMA Force Account Equipment Record report – Left justify TOTAL COST (last field on report). Some printers cutting off digits. (03/20/14)
DWS Reports – If Material Description is not found in Material File of Choice, Check Other File when printing Material Description on Reports…(Inventory Master File and Cost Table File) 07/15/14
DWS Reports – If Equipment Description is not found in Equipment File of Choice, Check Other File when printing Equipment Description on Reports…(Vehicle Master File and Cost Table File) 07/16/14
DWS Reports – Change Formatting on Reports so PDF files are easier to read 07/16/1
Project Code File Form – Add validation for unique project code (11/06/14)
Worksheet Entry – Expand Employee Regular and Overtime Hours to 999.99 (was 99.99) (11/18/14)
Material Listing – Add option to print Memo (02/01/15)
DWS Project File Form – Allow scrolling on Detail page when not in Edit mode – Scrolling previously required Edit mode (03/23/15)
DWS Detail Reports – Add Contractor Costs (04/13/15)
DWS Detail File Browse – Allow editing of employee rates (06/09/15)
DWS Project File, DWS Detail File and DWS Contractor Costs File – DESCENDING DATE ORDER added to Browse (06/09/15)
DWS Project Code File Report – Add DATE range selection – Add line between projects on report (07/29/15)
System Variables – Add Default Material Percentage Markup (for billing) 12/22/15
A/R Interface – Add material markup percentage – retrieve unit of measure for equipment and materials – include DWS mileage cost (12/22/15)
Reports – Add Road Master File Report Type (Basic Report) contains ROUTE, ROAD NAME, ROAD SECTION, CLASS, SURFACE TYPE, LENGTH (01/05/16)
System Variables – Add Default Labor Billing Rate (Regular and Overtime Rates) 01/19/16
A/R Interface – Add option to bill Labor at DWS Rates or Default Billing Rates (System Variables) 01/19/16
A/R Interface – Add option to select Road Section range when creating billing records (02/22/16)
A/R Interface – Add option to add INVOICE DESCRIPTION – Invoice Description is added to Invoice Transaction Record (MEMO FIELD) (04/07/16)
Maintenance Menu – Add option to Change Project Code in Detail File for selected date range (10/19/16)
Road Master File Pop Up – Modified so Township is not replaced if already entered (10/19/16)
System Variables Form – Add DEFAULT EMPLOYEE (11/01/16)
Employee Pop Up – Disable Employee Pop Up if DEFAULT EMPLOYEE exists (11/01/16)Project Code File – Add ROAD SECTION and TOWNSHIP (11/07/16)DWS Entry – Do not overwrite equipment hours with ENDING – BEGINNING IF equipment hours are entered (11/07/16)
DWS Reports – Add SECTION as PRIMARY SORT option (11/28/16)
System Variables Form – Add DEFAULT WORKSHEET NUMBER – When assigned, program will display only DWS Time Entry Form and will allow access to only one worksheet and one employee-Created for time entry by employees (12/10/16)
DWS Time Entry menu – Change logic from 12/10/16 – Limit Time Entry menu when DEFAULT EMPLOYEE entered (abandon default worksheet). Time Entry menu will allow entry in Project Form or Detail Form format – Employee is limited to only entries for default employee (12/18/16)
DWS Project File – Add PRINT TIME SHEET option (12/18/16)
DWS Project Reports – Print MATERIAL’S SUPPLIER, along with DESCRIPTION when SORT or SUBTOTAL by Material (02/15/17)
DWS Project Reports – Add SURFACE WIDTH to Project Reports when subtotal is ANY CHANGE IN ROAD LOCATION (02/15/17)
Employee Rates File – Add (X)DOT regular and overtime percentage (04/20/17)
DWS Reports – Add option to print reports with PAYROLL RATE Plus (X)DOT Percent and DWS RATE Plus (X)DOT Percent (04/20/17)
DWS Project Reports – Add Indiana County Highway Form No. 28A-Cost Distribution Ledger – Allocated Costs as new report type (07/05/17)
DWS Entry – Replace Equipment Ending Hours with Equipment Beginning Hours plus Equipment Hours (if Equipment Ending Hours is not entered). Vehicle Master File is updated with Equipment Ending Hours (08/15/17)
DWS Cost Table File – FEMA 2017 Equipment and Rates can be added to your Cost Table File or Vehicle Master File…https://www.fema.gov/media-library-data/1504646556623-5df6d34cb30e72f6821337472903d310/2017_FEMA_Schedule_of_Equipment_Rates_508_FINAL.pdf 09/14/17
Project Reports-Add Indiana County Highway Form No. 29-Employee’s Time Allocation Record – This report lists one employee per page with hours broken down by Work Code in Fourteen Day Columns. (10/02/17)
Work Code Table File – Add Flag for “Construction, Reconstruction, or Maintenance of Highways” – Used by new Report – Employee’s Time Allocation Record (10/03/17)
Work Code Popup Selection Screen – Add new Highway Flag (10/09/17)
Maintenance Menu – Add option to Create A/R Records – A/R records could previously only be created from the Worksheet. PROJECT CODE, WORK ORDER and TOWNSHIP ranges added to Selection Screen (12/12/17)
DWS Entry – When Equipment Hours default to Employee Hours, add OVERTIME HOURS (12/13/17)
Work Code Table File – Added Custom Code so DWS Reports could be SORTED/SUBTOTALED by CATEGORY/CLASS…Will be used by Indiana Customers for Annual Report (04/04/18)
DWS Reports – Add SORT and SUBTOTAL by CATEGORY and CLASS (04/04/18)
DWS Reports – Retrieve and Print Caller Instructions from Response Log File when Log Number OR Work Order Number chosen as SORT or SUBTOTAL (04/19/18)
Category Table File and Classification Table File Added – These new files eliminate the redundancy in the Voucher Custom Code File – Category and Classification can be selected separately by using the F11 key for the popup in the Voucher File (Accounting) and the Work Code File (Daily Crew Worksheet) and on Report Selection Screens. The Voucher Custom Code File has been left in place for the present time. This file contains the Category AND Classification. The category and classification can now be selected in the Voucher Custom Code File from the new files. The categories and classifications will be retrieved from the Voucher Custom Code File during the System Update process (when the files are initially added). The descriptions of the Categories and Classifications will be retrieved from the new table files. If the records do not exist in the new files, the Voucher Custom Code File descriptions will be used…This will enable all files to be used, if desired. (04/24/18)
DWS Reports – Add additional options for Labor Rate on reports (Including FEMA REPORTS)- you can now select DWS Rate + IN HOUSE PERCENTAGE and DWS RATE + FEMA PERCENTAGE…Note…Use Payroll Rate as DWS RATE (Employee Rates File) if you have the need to run reports based on actual rate of pay. DWS RATE is stored in DWS Detail File and can be used with all benefit percentages for reports. If you use the Payroll Rate as the DWS Rate, the rate will always reflect the actual pay rate at the time of work. The reports can then be run with the benefit percentages. (05/26/18)
Road File pop up – Always retrieve Township when it is not blank in Road Master File (07/20/18)
FEMA Labor and Equipment Reports – Right justify last column for easier reading (09/07/18)
FEMA Reports – Enlarge HEADING fields (09/10/18)
DWS Report Selection – Add CATEGORY and CLASS selection ranges (Work Location Values Page) – These new fields will allow grouping of Work Codes 09/20/18
Project Entry – Make EMPLOYEE NAME the default sort order for EMPLOYEE pop up (09/27/18)

Employee Rates File – Add FEMA REGULAR and OVERTIME RATE, (X)DOT REGULAR and OVERTIME RATE and IN HOUSE REGULAR and OVERTIME RATE (for those who do not use benefit percentages) 10/19/18
DWS Reports – Allow selection of FEMA RATES, (X)DOT RATES and IN HOUSE RATES 10/19/18
DWS Reports – Print PROJECT DESCRIPTION, along with PROJECT when SORT or SUBTOTAL on Project Code (11/08/18)
DWS Reports – Add PAY TYPE as SORT/SUB TOTAL 1/24/19
Worksheet Report – Add TOTAL REGULAR and OVERTIME HOURS (03/14/19)
DWS Reports – Change DEFAULT beginning log numbers to negative numbers (03/15/19)
DWS BROWSE – Add Default Employee Selection Range (03/15/19)
Maintenance menu – Add option to export DWS Detail File to Excel with Date Range Selection (04/26/19)
Maintenance menu – Road Location Maintenance – Update DWS Detail File with Road Information – Add beginning and ending log point to fields updated (08/26/19)
DWS Entry – Store Work Code Description in VENDOR NAME field of Detail File (08/30/19)
Employee Rates File – Add RATE DATE for those using this file without Payroll. Payroll update should populate RATE DATE, along with RATE (09/20/19).
System Variables Form – Add OPTION to UPDATE VEHICLE HOURS in Fleet Maintenance – previously, hours WERE updated (09/24/19)

Project Entry/Detail Entry – Retrieve RATE and OVERTIME RATE from Pay Types File (Payroll) when PAY TYPE is changed if RATE in Pay Types File is not zero. Do not change RATES when cursor leaves EMPLOYEE FIELD if PAY TYPE is different than PAY TYPE in Employee Rates File. (12/11/19)
Daily Crew Worksheet Reports – Add EMPLOYEE PAYROLL DETAIL report. This report prints one page per employee and is always sorted by Employee and Pay Type (with subtotals) (12/11/19)
Daily Crew Worksheet Entry – Change EMPLOYEE RATE and EMPLOYEE OVERTIME RATE to ZERO if UNPAID pay type is selected (04/22/20)
System Variables form – Add FRINGE BENEFIT and OVERHEAD percentages (05/12/20)
Maintenance menu-CREATE A/R RECORDS – Retrieve Township from Project File – Change ENDING PROJECT DEFAULT to BEGINNING PROJECT – make PROJECT the INVOICE NUMBER (if not entered) – Retrieve Road Name from Road Master File and add to Invoice Transaction Records – Create Fringe Benefit and Overhead A/R records (if percentages are entered on System Variables). (05/12/20)
Project Code File – Add COMPLETION DATE to data entry form and Project Listing Report and Date Range Selections to Browse and Report Selection Screen (06/24/20)
DWS Export – Maintenance menu – Add PROJECT CODE range selection and include Employee Name in Export File (10/12/20)
DWS Export – Maintenance menu – Add option to CONTINUE WITH COPY for those experiencing security issues when starting Excel within Softworks programs (10/14/20)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)
Road Reports – Add popup for SURFACE TYPE (02/13/21)
Project Reports – Increase the length of subtotal fields so more information is displayed (04/29/21)
Data Entry Forms (do not minimize when popup selected). 05/17/21

DWS Project Entry Form – Remove A/R Transaction File from list of files open when form is open to address A/R Speed Issue when Daily Crew Worksheet Project Form is open (11/06/21)
Cost Table File – Add Activity Flag – Modify Browse Selection Screen and Report Selection Screen to include activity selection – Modify popups so only active records are displayed (03/14/22)
Condensed Detail Reports – Stretch Road Name Field so complete field is printed (03/14/22)

Sign Management

Browse Selection Screen added to Sign Form
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Create REPORTS menu
Add four PATH fields and captions for IMAGE FILES (with ability to browse for image files). Images are displayed on PICTURES page.
Print pictures on Sign Master File Reports containing MEMOS
Add menu option to check and repair data files (03/27/07)
Add HELP button on HELP/ABOUT (03/27/07)
Disable SELECT PICTURE buttons until EDIT is selected
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability 5/02/07
Replace Sign Material Usage File with Garage and Parts Inventory Usage File 7/09/07
Update Inventory Master File with Sign Usage (Sign Master File/Sign Maintenance) 7/09/07
Maintenance menu – Add option to Assign Sign Numbers for records with blank sign Numbers (09/10/07)
Sign Master File Reports – Add two new report types – 1) Inspection Report for recording Inspection information and 2) Maintenance Report for recording Maintenance information (02/12/08)
Sign Master File Reports – Add selection of Post Condition and Visibility (02/12/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/12/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/12/08)
Expand PROJECT field (16 characters) to match Pavement Management and Response Log Work Order/Project field – Add popup capability for selecting work orders (02/12/08)
Add SIGN ID as Sort option on Sign Browse and Report Selection screens (03/19/08)
Highlight the field where the cursor is located (07/26/08)
Sign Master File Form – Retrieve Road Information from Road Master File when Route or Road Section is entered (07/26/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/14/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/14/08)
Sign Master File – Add MUTCD Code 2 (and DESCRIPTION), MUTCD Code 3 (and DESCRIPTION), TOURING ROUTE, BEGINNING POINT, BREAKAWAY and BEGINNING POINT fields (10/21/08)
Sign Master File Reports – Add Landscape 2 report format as Report Option (10/21/08)
Add LATITUDE and LONGITUDE fields for GIS tracking (12/17/08)
DATA ENTRY menu option added to TOP MENU – This menu contains data entry forms found on the FILE/OPEN menu (01/30/09)
Maintenance form – Add BROWSE selection screen for selecting record in Browse window (01/30/09)
Inspection form – Add BROWSE selection screen for selecting record in Browse window (01/30/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
Sign Reports – Add ROAD DIRECTION selection range (10/02/09)
Sign Reports – Add ROAD DIRECTION sort order (10/02/09)
Sign Reports – Add LANDSCAPE 3 FORMAT report (10/02/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Sign Reports – Add LANDSCAPE 4 Report Format (2/22/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
Sign Master File – Add Inventory Item-Materials page (GPI Replacement sign) – so DWS entry knows when sign is replaced (02/08/11)
Sign TYPE Table file added (data entry form/report/popup selection) added (02/11/11)
Sign TYPE field increased from 10 to 30 characters (02/11/11)
Sign Report Selection Screen – Added selection range for MAINTENANCE DATE, REPLACEMENT DATE and REFLECTIVITY CONDITION (02/14/11)
MATERIAL TYPE, COLOR, SUPPORT TYPE, MANUFACTURER, MAINTENANCE RESPONSIBILITY, CLASSIFICATION Table files added (data entry form/report/popup selection)
added (02/18/11)
Sign Legend File – MATERIAL TYPE field added, COLOR and SIZE field lengths extended (02/18/11)
Sign Legend File – POPUP selection of MATERIAL TYPE and COLORS added (02/18/11)
Sign Master File – Display MATERIAL TYPE from Sign Legend File when cursor is on Sign LEGEND (02/18/11)
Sign Master File- CLASSIFICATION, NUMBER OF SIGNS, NUMBER OF POSTS fields added. MAINTENANCE RESPONSIBILITY, COLORS, MANUFACTURER, SUPPORT field lengths extended (02/18/11)
Sign Master File – POPUP selection of COLORS, SUPPORT, MANUFACTURER, MAINTENANCE RESPONSIBILITY and CLASSIFICATION added (02/18/11)
Sign Master File/Inspection Entry/Maintenance Entry – modified to update Summary Page as entry in Daily Crew Worksheet 04/01/11
Sign Inspection Entry – Add HOURS and LABOR AMOUNT for two employees (04/02/11)
Drive By Inspection Entry – Add HOURS and LABOR AMOUNT for two employees (04/02/11)
Reports – Add Sign Inspections Labor Report (04/02/11)
Maintenance menu – Add option to “Add missing Roads to Road Master File”. This option will create records in the Road Master File for Route/Road Names found in the Sign Master File (04/02/11)
Sign Master File – Inspection page – Add HOURS/LABOR AMOUNT/INSPECTOR 2/HOURS FOR INSPECTOR 2/LABOR AMOUNT FOR INSPECTOR 2 (04/04/11)
Size Table File – POPUP selection for Sign Size (04/29/11)
Sign Master File – Add BLANK MATERIAL field (04/29/11)
Sign Legend File – Renamed to MUTCD Code File – Add SIGN TYPE field (04/29/11)
System Variables Form – Add GPS RECEIVER PORT for use with GPS Receiver (04/29/11)
System Variables Form – Add GPS RECEIVER BAUD RATE for use with GPS Receiver (04/29/11)
Add new form for Inventory Master File – Inventory Master File-Road Inventory Only – This form contains only the inventory records that are flagged as ROAD INVENTORY. (04/29/11)
Sign Master File – GPS page – Add BUTTON for retrieving LATITUDE and LONGITUDE (04/29/11)
Sign Master File – Rearrange Page 1 of form for easier viewing/data entry – Add picture (04/29/11)
Sign Master File – New Browse Sort Order – Road Name/Side of Road (04/29/11)
Sign Master File – Materials Page – Add F11 for SIGN INVENTORY POPUP – Signs in Consumable Inventory (04/29/11)
Sign Maintenance Entry Form – Materials Page – Add F11 for SIGN INVENTORY POPUP – Signs in Consumable Inventory (04/29/11)
Add Consumable Inventory Menu – Inventory Master File, Usage, Receipts – This is an abbreviated version of Garage and Parts Inventory (04/29/11)
MUTCD Code File – Add picture (06/03/11)
MUTCD Code File popup – Add option to sort by DESCRIPTION or MUTCD Code (05/03/11)
Sign Master File – Add picture of standard sign (based on MUTCD Code) (05/03/11)
Sign Master File – When SIGN NUMBER is changed, prompt operator to save original sign as history. If saved, the original sign number is saved as history with the original sign number and a comment regarding the change (05/06/11)
MUTCD Code File – Add BROWSE SELECTION SCREEN and standard browse features (05/06/11)
Pictures of all signs in 2009 Manual on Traffic Control Devices available for display on Sign form and MUTCD form (05/19/11)
Sign Master File – GPS page – Add selection and display of sign image – If the photo is geo-coded, LATITUDE, LONGITUDE and DATE will be retrieved from photo and stored in Sign record (05/22/11).
Sign Master File – GPS page – Add REVERSE GEO-CODING when geo-coded photo is selected and when Latitude and Longitude Values are retrieved using GPS
Receiver. This feature will store the Road Name and Physical Address for the Latitude and Longitude values of the sign. (05/31/11)
Maintenance menu – Add option to create Sign Master File records from geo-coded photos. This option will create a Sign Master File record for every picture contained in the selected picture folder (05/31/11)
Sign Master File – Add thumbnail GPS picture to front screen so MUTCD code can easily be selected with visual picture (05/31/11)
Maintenance menu – Add option to Reverse Geo-Code Sign records. This option can be used to retrieve the Physical Address of a Sign when Latitude and Longitude
have been recorded and there is no Physical Address in the Sign record (06/01/11)
Sign Master File – Add COMMENTS field so additional description can be entered (Ex. Actual Street Name if MUTCD description is STREET NAME) (06/07/11)
Sign Master File – Added ACTIVE/INACTIVE/ALL selection to Browse (06/14/11)
Sign Replacement Form Added-This form quickens entry for sign replacements (06/30/11)
Sign Popup modified – Add MUTCD sort option-Display only active Signs (History <> Y) (06/30/11)
Sign Master File Browse – Add REPLACEMENT DATE range selection (07/25/11)
Sign Index – Add Maintenance function to update ROUTE/ROAD NAME in Usage File for Usage records with a Sign Number (07/25/11)
Sign Master File Reports – One Line Format – Add TOTAL SIGNS (07/25/11)
Inventory Usage Transaction File – Add SIGN ID Sort Option on Browse (09/08/11)
Inventory Usage Reports – Add Sign Usage Report format (09/09/11)
Sign Master File Browse – Add LATITUDE and LONGITUDE (10/17/11)
MUTCD Listing – Add picture to report (11/27/11)
Sign Usage Report – Add MUTCD Code Sort option and TOTAL REPLACEMENTS to reports (11/27/11)
Sign Master File Browse – Add ROAD SECTION Selection Range and ROAD SECTION Sort Option (11/27/11)
Sign Master File – When Sign Replacement (New sign added on Materials page), overwrite SIZE, SHEETING and BLANK MATERIAL with values in GPI ONLY if they are blank in Current Sign record (11/27/11)
Sign Master File – RIGHT CLICK – Add Duplicate Record option added (11/27/11)
Sheeting Table File – Add LIFETIME EXPECTANCY (YEARS) to form, popup and report (11/29/11)
Sign Master File Reports – Add REPLACEMENT DUE selection range. This value is calculated by adding the LIFETIME EXPECTANCY (Sheeting Table File) to Installation Date/Replacement Date to determine Date Replacement Required (12/17/11)
Sign Master File – Summary Page – Display REPLACEMENT DUE (12/17/11)
Sign Master File – GPS page – Add TIME. Time is retrieved from the geocoded photo (02/17/12)
Maintenance menu – Add option to globally change MUTCD CODE. Corresponding picture is copied to match new MUTCD code. (02/23/12)
Sign Maintenance – Add Sign Number. If changed, prompt operator to save original sign as history. If saved, the original sign number is saved as history with the original sign number and a comment regarding the change (07/26/12)
Road Inventory Data Entry Form – Add PHYSICAL QUANTITY and PHYSICAL DATE so quantity on hand can be entered for new inventory item (08/16/12)
Maintenance Menu – Add option to create picture records from pictures and option to match picture records to Sign Master File Records-This option makes it easier to match pictures to EXISTING Sign Master File Records, adding LATITUDE/LONGITUDE values and address to Sign Master File from new pictures (09/06/12)
Report Menu – Add option to print new sign picture records (09/06/12)
Sign Master File Browse – Add SORT BY GPS DATE/TIME (09/20/12)
Work With Pictures menu added – Maintenance menu (09/22/12)
Sign Master File – Add RIGHT CLICK option (Sign Number) to choose Inactive sign as sign replacement (11/29/12)
Sign Master File Browse – Add preference back to Browse – was previously removed (01/30/13)
Maintenance Report Selection – Added Sign ID to allow maintenance to be printed for selected sign range (01/30/13)
Maintenance Menu – Add option to delete Sign Master File records for selected MUTCD code (02/05/13)
Maintenance Menu – Add menu option to update Sign Master File and GPI Master File with sign fields from MUTCD File (02/05/13)
Sign Master File Reports – Add SHEETING TYPE selection range (04/19/13)
Sign Maintenance Reports – Add Sign Description to reports (05/13/14)
Sign Work Table File – Add UPDATE REPLACEMENT DATE IN SIGN MASTER FILE flag. When flag is set to Yes, the Replacement Date in the Sign Master File will be updated for this type of work…typically REPLACE SIGN 07/17/15)
Sign Maintenance Browse Form – Add MAINTENANCE DATE and EMPLOYEE as SORT BY options (07/17/15)
Sign Inspection Browse Form – Add INSPECTION DATE and INSPECTOR as SORT BY options (07/17/15)
Sign Master File Form – Update Sign Master File with Replacement information when Maintenance entry added with Sign Work containing new REPLACEMENT flag set to Yes (07/17/15)
Sign Master File, Maintenance, Sign Replacement Forms modified for better speed performance (worked ok when files were local, but slow when data on server) 10/07/15
Sign Master File – Add Legend Reflectivity (11/14/17)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)

Culvert/Bridge Management

Browse Selection Screen added to Culvert Form
Add four PATH fields and captions for IMAGE FILES (with ability to browse for image files). Images are displayed on PICTURES page.
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Add Culvert Popup to Report Selection screen (Culvert #)
Add option to print pictures on existing reports
Create REPORTS menu
Change Application name to Culvert/Bridge Inventory Management (4/24/07)
Change ‘Culvert Number’ to ‘Structure Number’ (4/24/07)
Change ‘Diameter’ to ‘Size’ (4/24/07)
Add ‘Sufficiency Rate’ and ‘Sufficiency Date’ fields
Increase field length of ‘Shape’
Disable SELECT PICTURE buttons until EDIT is selected
Add Flag field to distinguish between CULVERT and BRIDGE records (4/24/07)
Modify DWS popups to get appropriate records (CULVERT or BRIDGE) (4/24/07)
Add HELP button on HELP/ABOUT (03/28/07)
Add menu option to check and repair data files (03/28/07)
Browse/Report Selection screens modified – Add option to choose to include BRIDGES, CULVERTS or All RECORDS (4/24/07)
Add ‘Excel Spreadsheet’ as report output option (along with PDF) 4/27/07
Display ‘PRESS F10 for POPUP’ in status bar for fields that have popup capability 4/27/07
Increase MATERIAL field length (from 10 to 18) to match MATERIAL in GPI 7/24/07
Add numeric DIAMETER field (previously used SIZE field (character)) 7/24/07
Allow MATERIAL to be selected from GPI Master File – F10 from MATERIAL field 7/24/07
Maintenance menu – Add option to Assign Structure Numbers for records with blank structure numbers (09/10/07)
Culvert Reports – Add selection of LENGTH (02/15/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/15/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/15/08)
Highlight the field where the cursor is located (07/26/08)
Culvert Master File Form – Retrieve Road Information from Road Master File when Route or Road Section is entered (07/26/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/14/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/14/08)
Add ODOT Culvert Inventory Report (2 new pages on form) with drop down selections for Ohio customers (10/20/08)
New Report – State of Ohio Department of Transportation Culvert Inventory Report (CR-87) added as report option (10/20/08)
Add SIZE as a Sort Option on Reports (10/20/08)
Add LATITUDE and LONGITUDE fields for GIS tracking (12/17/08)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/12/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master
File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
Culvert Master File – Add REPAIR COST field (09/28/10)
Culvert-Bridge Master File Reports – Add ‘Culvert Evaluation Report’ report type. This report is similar to the OPWC Culverts Form (09/28/10)
Culvert-Bridge Master File Reports – Add ‘Bridge Evaluation Report’ report type. This report is similar to the OPWC Bridge Form (09/28/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
Culvert Master File – Add REPAIR COST field (09/28/10)
Culvert-Bridge Master File Reports – Add ‘Culvert Evaluation Report’ report type. This report is similar to the OPWC Culverts Form (09/28/10)
Culvert-Bridge Master File Reports – Add ‘Bridge Evaluation Report’ report type. This report is similar to the OPWC Bridge Form (09/28/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Add CR-86 (Culvert Inspection Form) and Report added. RIGHT CLICK to print Inspection Report from data entry form or print from Report menu. (12/03/10)
Culvert Inspection Summary Report added (12/03/10)
Culvert Master File – GPS page – Add BUTTON for retrieving LATITUDE and LONGITUDE (04/29/11)
Add ‘Shape Description’ field (original shape field) – populate this field (when blank) with ‘Shape Description’ from Shape code popup (ODOT form (1-29)) (07/12/11)
Index procedure modified – update Latitude and Longitude degrees, minutes and seconds fields by using decimal Latitude and Longitude values (07/12/11)
Index procedure modified – update YEAR BUILT field with YEAR of Installation Date (07/12/11)
Culvert Inspection form modified – Allow updates to Culvert Master File fields (previously displayed only) 07/12/11
Culvert Inspection form – Add SHAPE description field (07/12/11)
Culvert Inspection form – Add RETRIEVE GPS LOCATION button so Latitude and Longitude values (and physical address) can be retrieved using GPS receiver (07/12/11)
Maintenance Menu – Add REVERSE GEO-CODE menu option. This option will attempt to find the physical address of any record containing LATITUDE and LONGITUDE values. Internet connection is required (07/13/11)
Maintenance menu – Add option to create Culvert Master File records from geo-coded photos. This option will create a Culvert Master File record for every picture contained in the selected picture folder (02/07/12)
Culvert Master File – Add ENDING LATITUDE/LONGITUDE (08/16/13)
Data Entry menu – Add option to Import Inspection records (08/16/13)
Culvert-Bridge Master File – Add PIPE, along with CULVERT and BRIDGE as Structure Type Selection (09/17/14)
System Variables Form – Add GPS RECEIVER BAUD RATE and GPS RECEIVER PORT (01/13/15)
Culvert Shape Table File added – Popup for Shape added to Culvert File, Report Selection and Browse Selection forms (03/26/15)
Culvert Form – Add PDF page for attaching and viewing PDF files (08/14/15)
Maintenance Menu – Add menu options for changing Structure Numbers of Culvert and Bridges (02/16/16)
Culvert/Bridge File – Add 3 more pdf attachments to PDF TAB – There can be a total of 4 (05/10/18)
Culvert/Bridge File – Add Township as Sort Order on Browse (05/22/18)
Culvert Master File – Add ACTIVE/INACTIVE Flag (08/03/20)
Culvert Master File Browse – Add Active/Inactive Flag Selection – Default to Active (08/03/20)
Culvert Reports – Add Active/Inactive Flag Selection – Default to Active (08/03/20)
Culvert Popup – Show only Active Records (08/03/20)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)

Guardrail Management

Add System Option to Scan Data Files
All Report Options are now available in PDF format
Add Browse Selection Screen
Add MAIL TO option for e-mailing current record
Add Guardrail Number to Guardrail File – Add LAST GUARDRAIL NUMBER to System Variables form so Guardrail Number can be assigned during data entry
Add four picture locations and four picture captions
Add option to print pictures on existing reports
Create REPORTS menu
Add HELP button on HELP/ABOUT (03/30/07)
Add menu option to check and repair data files (03/30/07)
Disable SELECT PICTURE buttons until EDIT is selected
Maintenance menu – Add option to Assign Guardrail Numbers for records with blank guardrail numbers (09/10/07)
Add Date Last Repaired/Replaced field (02/15/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/15/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/15/08)
Highlight the field where the cursor is located (07/28/08)
Guardrail Master File Form – Retrieve Road Information from Road Master File when Route or Road Section is entered (07/28/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/14/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/14/08)
Add LATITUDE and LONGITUDE fields for GIS tracking (12/17/08)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/12/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Guardrail Master File – GPS page – Add BUTTON for retrieving LATITUDE and LONGITUDE (04/29/11)
Maintenance Menu – Add REVERSE GEO-CODE menu option. This option will attempt to find the physical address of any record containing LATITUDE and LONGITUDE values. Internet connection is required (07/13/11)
Maintenance menu – Add option to create Guardrail Master File records from geo-coded photos. This option will create a Guardrail Master File record for every picture contained in the selected picture folder (03/01/12)
Data Entry menu added to top menu (06/13/12)
Guardrail File – Add ENDING LATITUDE and ENDING LONGITUDE (05/02/17)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)

Payroll Management

All Report Options are now available in PDF format
Add option to Archive and Retrieve Inactive Employees
Add option to remove a single Payroll (all transaction records)
Add one line report containing Employee Pay Rates
Overtime Analysis Report – Print Separate totals for Regular and Miscellaneous Wages
Add option to change Employee Number
Add “Commercial Driver License Number” and “Expiration Date” fields to Employee Master File with reporting/browsing capabilities for Expired Licenses.
Employee Master File Browse – Add Anniversary Date (MM/DD) range selection and CDL Expiration Date range selection – Add new fields to browse screen
Add “Other Wages” column to Payroll Transactions Detail screen (grid) – This will allow longevity pay and other types of pay that do not involve hours to be added to the Period Gross. The Regular Account of the selected Pay Type will be used for interfacing with the Government Accounting System.
Modify programs to include “Other Wages” described in line above.
Maintenance Menu – Add option to Delete all Transactions for a Selected Pay Period
Maintenance Menu – Add option to Create EXPORT file for a Selected Pay Period. This file will be used as the Import File For Harris (formerly Manatron) Auditor’s Payroll Package
Add Base Rate/Longevity Rate to Employee Master File
Color Code Lines by Pay Type so Sick and Vacation hours can be spotted easily
Add Department File to this Module
System Variables form – Add option to change BONUS title (Pay Type) to PERSONAL
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Maintenance Menu – Add option to Clear Offered Overtime Hours (Employee Master File)
Employee Master File Reports – Add new report type – CDL List
‘Create New Payroll Transactions’ procedure modified. If PAY TYPE is changed in daily
Crew Worksheet, PAY RATES are retrieved from Employee Master File.
Employee Master File Reports – Change default to ACTIVE employees (11/20/06)
Time Sheet/Attendance Reports and Time Analysis Reports modified to include OTHER WAGES (11/16/06)
Add field for DATE OF LAST PHYSICAL-Employee Master File (12/01/06)
Add CELL PHONE field-Employee Master File (12/01/06)
Change Employee Numbers (Maintenance Menu) – Add Check for Duplicate Employee Number (done 12/15/06)
Employee Master File Reports – Add new report (Accrued Vacation and Sick Leave)
Add menu option to check and repair data files (03/13/07)
Add HELP button on HELP/ABOUT (03/13/07)
Time Analysis Reports – Add REGULAR PAY RATE as SORT BY and SUBTOTAL ON option.
Balance of Time-Sick and Vacation With SS# – New Balance of Time Report with Social Security Numbers
Employee Master File Reports – Add “Anniversary Date” as SORT BY option (0516/07)
Create New Period Transactions – Make “Retrieve Pay Rates from Employee Master File when Pay Type record not found in Employee Rate File” an OPTION – This will
allow you to link PAY RATE to DWS Identifier rather than Pay Type. (05/22/07)
Leave Request Form – Add Right Click menu option to print Leave Request (06/15/07)
Select Random Employees – Add option to select ACTIVE/INACTIVE/ALL Employees with a default of ACTIVE (08/10/07)
Reformat Maintenance menu (Add File Maintenance menu) (08/10/07)
Increase field length of hours to accommodate vacation and sick pay off.( 08/10/07)
Add “DAY OF WEEK” for each Date in the Pay Period to ‘Detail Page’ of Payroll Transaction Form (08/29/07)
Change RATES to ZERO when COST CATEGORY is UNPAID (11/19/07)
Add new report – Employee Master File Reports – Sick, Vacation & Compensation Time Summary (11/20/07)
Employee Master File – Added BASED ON FACTOR DATE and DATE OF NEXT INCREASE fields If fields are NON BLANK, sick and vacation earned will be calculated ONLY when DATE PAID is within these dates – RECALCULATE procedure modified to use new date fields (11/20/07)
Add TAXABLE FRINGE BENEFIT PER PERIOD to Employee Master File (01/15/08)
Payroll Transaction File – Retrieve Taxable Fringe Benefit from Employee Master File – New Fringe Benefit Amount displayed on Summary Page (01/15/08)
Employee History Reports – New Report added – ‘Payroll Received-Balance Verification’ – prints one line per employee – includes total hours and balances (01/17/08)
Employee Master File – Add YTD Taxable Fringe Benefit – modify programs to include this new YTD amount (01/28/08)
Wage and Time Reports – Add Payroll Worksheet format (01/28/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/07/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/07/08)
Add OPTION for allowing update-Employee Master File Browse Selection Screen (02/07/08)
Create New Pay Period Transactions – When retrieving Employee Leave Records, create additional record for Standard Pay Type if Total Requested Leave Hours is less than Employee Standard Hours per Day (02/07/08)
Payroll Transaction File – Replace old YRS/DAYS of service calculation with new calculation that reports exact number of years, months and days (02/14/08)
Employee Master File Reports – Add ‘Compensated Absences Payable Form’ – contains sick, vacation, comp and personal hours and values (03/07/08)
Employee Master File Reports – Add PAY TYPE to Employee Rates Listing (03/13/08)
Add EMERGENCY CONTACT information to Employee Master File Form -NOTES page (04/18/08)
Add New Report Format – Employee Master File Reports – Employee Emergency Contact Listing (04/18/08)
Add ‘NEXT BASED ON FACTOR DATE’ (from 11/20/07) to BROWSE and REPORT SELECTION SCREENS (04/18/08)
Create New Pay Period Transactions – Add BROWSE button for Employees with Factor Increase (04/18/08)
Employee Master File Reports / Wage and Time Reports – Include Middle Initial on Sort by Name (05/29/08)
Employee Master File Reports – Print Middle Initial, along with First and Last Name (06/12/08)
Highlight the field where the cursor is located (07/17/08)
Comp Earned Calculations modified – If Pay Type is ‘SP COMP’, COMP EARNED is calculated at straight time. All other Comp Hours are multiplied by value on System Variables form. (09/03/08)
Time Analysis Reports – Add Comp Analysis Report. This report includes only Comp Earned and Comp Used Hours. (09/03/08)
Employee History Reports – Add new report format “Payroll Ledger” (10/12/08)
Payroll Transaction File – Add CHECK AMOUNT and WARRANT # fields- printed on Payroll Ledger (10/12/08)
Payroll Transaction File Browse – Add CHECK AMOUNT and WARRANT # fields to browse screen (10/12/08)
Pay Type Popup modified – Account Numbers are replaced only if Account Numbers are non-blank in Pay Type Table File (10/29/08)Form – Retrieve and Update value when entering new employee in Employee Master File Index procedure modified – Delete any duplicate employee numbers found (03/06/09)
Employee Master File Reports – Balance of Time – Used and Balance Report – Add EARNED, along with USED and BALANCE (03/09/09)
Reports – Modify WORK FILE NAME assignment – Some reports used old method for assigning work file name – possible error on fast computers (04/13/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/11/09)
Pay Type (SP COMP) calculates COMP at straight time, regardless of day (07/14/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/17/09) (07/27/09-refined)
Employee Master File – Add RETIREMENT/TERMINATION DATE field (08/05/09)
Employee Master File Reports – Add selection range for RETIREMENT/TERMINATION DATE (08/05/09)
Payroll Transaction File – Update Employee Master File if Termination Date Entered (08/05/09)
Payroll Transaction File – Add AUTOFILL to Pay Types field (09/18/09)
Time Analysis Report – Add SORT and SUBTOTAL option on PAY DATE (10/01/09)
System Update – Check MEM files – Update if they are not current (10/01/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Time Analysis Reports – Add OTHER WAGES to Summary and Detail Reports (03/16/10)
Add Autofill for PAY TYPE field (03/31/10).
Pay Types Table File – Add Y/N flag for ‘Vacation Time Earned?’ and Y/N flag for ‘Sick Leave Earned?’ – Change sick and vacation earned calculations so Pay Type Table File is evaluated (05/06/10)
System Variables – Change TIME EARNED options. Pay Types Table File now contains options for SICK and VACATION EARNED. For each Pay Type, choose whether the REGULAR and/or OVERTIME hours entered for the PAY TYPE should be included when calculating SICK OR VACATION time EARNED. COMP EARNED hours can now be included in Sick OR Vacation EARNED calculation by selecting the appropriate options on the System Variables Form (05/06/10)
Employee Master File Reports – Add EMPLOYEE CLASS LISTING (Employee Name, Class, Class Date, Hire Date, Seniority Date) 05/25/10
Employee Master File Reports – Add CLASS Sort Option (05/25/10)
Add ‘Create XLS file’ button on most report selection screens (07/01/10)
Add DATA ENTRY menu option to Top Menu (07/01/10)
Data Entry menu – Add ‘Time Clock’ File – This file can be CREATED by NEW Time Clock Module. This menu option allows maintenance of the Time Clock File. (07/01/10)
Report menu – Add ‘Time Clock’ Report options (07/01/10)
Maintenance menu – Import Time Clock Transactions – Add NEW Time Clock Layout for Softworks’ Time Clock File. This menu option will create the Payroll Transaction File from the Time Clock File. (07/01/10)
Time Clock Entry System released. The Time Clock File created by this system can be maintained and imported into the Payroll Management System (07/01/10)
Maintenance/File Maintenance – Add menu option to RESET HOLIDAY BALANCES. This option will allow the operator to reset LAST YEAR ENDING BALANCE and/or CURRENT HOLIDAY BALANCE (07/05/10)
YEAR END – Save LAST PAYROLL PAY DATE in Employee Master File so we know the date of LAST YEAR ENDING BALANCES (07/07/10)
YEAR END – Add option to RESET HOLIDAY BALANCES. This will allow the operator to reset LAST YEAR ENDING BALANCE and/or CURRENT HOLIDAY BALANCE (07/07/10)
Add NEXT AVAILABLE EMPLOYEE NUMBER to System Variables Form – Retrieve and Update value when entering new employee in Employee Master
File-Press F10 or DOUBLE MOUSE CLICK to assign next number (08/02/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (08/10/10)
YEAR END – Add option to RESET PERSONAL/BONUS BALANCES. This will allow the operator to reset LAST YEAR ENDING BALANCE and/or CURRENT PERSONAL/BONUS BALANCE (09/04/10)
Maintenance/File Maintenance – Add RESET PERSONAL/BONUS BALANCES. This option will allow the operator to reset LAST YEAR ENDING BALANCE and/or CURRENT PERSONAL/BONUS BALANCE (09/04/10)
Employee Master File – Add ‘EXPECTED YTD GROSS’ field (for reference)- Year To Date Totals page (09/28/10)
System Menu – Print List of PGS Tables menu option added (10/11/10) transaction.
Time Analysis Reports – Add option to SORT / SUBTOTAL on EMPLOYEE NAME (01/11/11)
Employee History Reports – Add ENDING TRANSACTION DATE to selection screen so report can be printed to exclude dates within a Pay Period (01/13/11)
Comp Time Analysis Report Added – Report includes BEGINNING BALANCE, USED, UNUSED (since date of Beginning Balance), EARNED, ENDING BALANCE and COMP HOURS PAYABLE (> variable number entered on Report Selection screen) 02/19/11
Employee Master File Reports – Add ENDING TRANSACTION DATE to selection screen so report can be printed to exclude dates within a Pay Period (03/04/11)
YEAR END – Add LAST PAY DATE so year end can be run with correct year end balances after pay periods for the new year have been entered. (03/25/11)
Payroll Transaction File-Highlight active line of detail page (10/26/11).
Payroll Transaction File-Remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (10/28/11)
Payroll Master File – Highlight active line of grids and remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (10/28/11)
Report added – Time Analysis – Regular Comp Analysis – Prints COMP USED, REGULAR COMP EARNED (not SP COMP), COMP SURRENDERED. This is a Custom Report where PAY TYPE <> SP COMP is used to designate COMP EARNED with an expiration date. SP COMP PAY TYPE does not have an expiration date. (12/01/11)
Display warning if Transaction Entry will cause Employee Balances to be Negative (02/02/12)
Add Report – Employee Contact Listing – NAME/ADDRESS/PHONE/CELL (02/02/12)
Maintenance menu – Add option to update all NAME fields to UPPER CASE (02/27/12)
Employee History Report – Add Option to Age Service Time from Hire Date or Seniority Date (02/27/12)
Employee History Report – NAME sort changed to name maintained in Employee Master File (not Payroll Transaction File NAME) (03/12/12)
Report menu – Added “Employee Rate History Report” (04/01/12)
Index Procedure – SORT Pay Rate History by DATE (04/19/12)
Employee Master File Reports-Add HEALTH PLAN LISTING (05/04/12)
Maintenance Menu – Add option to update Payroll Transaction File Employee Name with Employee Name from Employee Master File (08/13/12)
Banker’s Rounding (Yes/No) added to System Variables – If YES is selected, employee’s wages will be calculated based on Banker’s Rounding – Arithmetic Rounding is used by most reports in this system. If you use Banker’s Rounding for calculating wages, a custom Wage and Time Report may need to be added (if this report is required) (10/03/12)
Maintenance menu – File Maintenance – Change Account Codes – Procedure modified so Accounting Data Location (Payroll System Variables Form) is used for Popups and Changes (11/09/12)
Sick, Vacation & Compensation Time Report – Added EMPLOYEE AGE (as of end of year) to report (03/07/13)
Payroll Export added – for CMI (Dayton, Ohio) (06/24/13)
Expand TIMESHEET NUMBER field (from 99999 max to 9999999999 max) (7/11/13)
Employee History Report – Print only last 4 digits of social security number (05/06/14)
Time Analysis Reports – Add “Average Hours Per Week” Report for Affordable Care Act (11/17/14)
Employee History Report – Print 3 decimals on EARNED Sick, Vacation, Comp Time (11/18/14)
Maintenance Menu – Export Payroll Transactions – Export added for Software Solutions VIP Payroll System (03/20/15)
Employee History Reports – Add Auditor Number (07/28/15)
Employee Master File Reports – Employee Listing – Add OTHER WAGES to report and print only last 4 digits of social security number (08/17/15)
Banker’s Rounding logic added to Time Sheet/Attendance Reports, Reports by Accounting Budget Code and “Create Accounting Voucher Records” (01/28/16)
Employee Listing- Add Grand Total For Wages (02/01/16)
Maintenance Menu – File Maintenance – Add option to update RATES in Payroll Transaction File (using PAY TYPE) (08/01/16)
Export procedure for Software Solutions modified – Always Code Overtime as Pay Code “O” – previously had to be different pay type (11/02/16)
Export procedure for Software Solutions modified – Include COMP EARNED as Pay Code “COMPEARNED” at zero RATE (11/17/16)
Export procedure for Software Solutions modified – Change OVERTIME Pay Code to “OVERTIME” (was ‘O’) and OVERTIME RATE to REGULAR RATE (11/29/16)
Export procedure for Software Solutions modified – POLINE is always 1 – program previously incremented number for voucher entries on same p.o. (11/02/17)
Balance of Time Reports – Added Balance of Time-Sick-Vacation-Comp-Overtime (04/20/18)

Payroll Export – Added Export for MUNIS 11/21/18
Payroll Transaction Entry – Send WARNING when Personal Time Balance is Negative (09/12/19)
Maintenance Menu – File Maintenance – Update Employee Rates File with Employee Master File Rates – Update Rate Date – Update Rates only if Rate Date is more current than Employee Master File Rate Date (09/20/19)

Pay Types File – add REGULAR RATE, OVERTIME RATE and RATE DATE. (12/11/19)
Payroll Transaction File – Retrieve RATE and OVERTIME RATE from Pay Types File when PAY TYPE is changed if RATE in Pay Types File is not zero. (12/11/19)
Maintenance Menu – File Maintenance – Add ‘Update Pay Rates by Percentage’ menu option. This option will update the pay rates in the Pay Types File by a selected percentage. The pay rates will also be updated in the Employee Master File and the Employee Rates File. Do not use this option if your pay rates are not in the Pay Types File. (12/11/19)
Maintenance Menu – File Maintenance – Add ‘Update Employee Master File Pay Rates with Pay Types File Rates’ menu option. This option will update the pay rates in the Employee Master File with the Rates in the Pay Types File, based on PAY TYPE. Do not use this option if your pay rates are not in the Pay Types File. (12/11/19)
Time Sheet/Attendance Reports – Add ONE EMPLOYEE PER PAGE Report Format (12/11/19)
Create Payroll From Daily Crew Worksheet – Change EMPLOYEE RATE and EMPLOYEE OVERTIME RATE to ZERO if PAY TYPE is UNPAID (04/22/20)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/21/20)
Employee Master File – Add EMAIL field – “Notes” page 01/15/21
Employee Maintenance Form Report and Employee Contact Listing – Add EMAIL field 01/15/21
Employee Master File (Balances page) – Added two new fields (VACATION EARNED DURING THE PREVIOUS ANNIVERSARY PERIOD and VACATION USED SINCE LAST ANNIVERSARY). These fields are both calculated and will be updated when Payroll Transactions are entered and when totals are recalculated (08/25/21)
Employee Master File Reports – Added “BALANCE OF TIME-ATHENS”. This custom balance of time report includes VACATION USED SINCE LAST ANNIVERSARY and VACATION EARNED DURING PREVIOUS ANNNIVERSARY PERIOD (08/25/21)
Employee History Reports – Custom Format – Add (Bonus/Personal) columns (11/01/22)
Employee Master File – Add CDL MEDICAL CERTIFICATION DATE (11/18/22)
Reports/Employee Master File Reports/CDL Listing – Add CDL MEDICAL CERTIFICATION DATE (11/18/22)
Payroll Transaction File Form – Enlarge totals (and change color) at bottom of form for easier viewing (04/21/23)
Retrieve Payroll Master File Records – Modify employee number popup so Archived Master File is used for selecting employee (05/15/23)
Employee Master File – Change AUDITOR NUMBER field from NUMERIC to ALPHANUMERIC (10/19/23)

Payroll Transaction File – If PAY GRADE (Employee Master File) is 99, prompt the operator to override COMP EARNED with STRAIGHT HOURS rather than default on System Variables form (10/29/21)
Employee Master File Reports- Add new report – Balance of Time with MAX (12/13/21)
Payroll Transaction File – Enlarge Font on TOTALS (05/19/22)

Government Accounting

All Report Options are now available in PDF format
Expand length of CHECK NUMBER field from 10 to 20 characters
Add ability to print a receipt during Receipt entry
Previous Year Transaction Files will contain ALL previous years transactions
P.O. Browse – Allow editing of voucher and invoice records
Expand ‘Description’ field in all files
Fund Master File – Add MEMO field for extended comments
New Reports – Transaction History Detail and Transaction Summary Report
Add ‘Print Vouchers’ and ‘Print Purchase Orders’ as Report Options (previously printed during entry
Add Ability to Print Purchase Orders and Vouchers from menu options as well as during data entry
System Variables Form – Press F10 to select YOUR Custom Forms (P.O./Voucher/Receipt)
Vendor File – Add ‘Account Number’ field to Vendor Master File
System Variables Form – Add TAX ID NUMBER
New Vendor Report added – Ohio Tax Exempt Certificate
System menu – Add Printer Selection screen. This screen will allow you to select the appropriate printer for printing your VOUCHERS and PURCHASE ORDERS.
Voucher Entry – Right Click Option Added – ADD ANOTHER VOUCHER TO THIS PURCHASE ORDER, ADD ANOTHER PAYMENT TO THIS VOUCHER or PRINT VOUCHER options available from current menu.
Validate Unique P.O. Number
Print Remittance Address (if entered) on Vouchers and Purchase Orders; otherwise print Vendor Address
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
Select DEFAULT PRINTERS modified – Data File that stores the printers now resides in PROGRAM FOLDER (NOT DATA FOLDER) so each user can set different printer
Maintenance menu – Add File Maintenance – First option on new menu is “Update Invoice Records with Voucher Information”. This option will add Payment Date to Invoice records that may be missing if Payment Date was entered in Browse screen of Voucher records.
Voucher Entry – Right Click to Add Voucher options modified – Clear Departmental
Breakdown fields and Comments
Departmental Breakdown popup modified – Default to Description Sort Order – Add option to switch Sort Order (Department Code or Description)
P.O. Cancellation – Include Vendor Name on Cancellation record.
Invoice Entry – Added character portion of Vendor Number to Invoice record.
Display message when F10 popup pressed and cursor is not in TEXT BOX field (previously caused error) 11/30/06
Voucher Entry – Add RIGHT CLICK option to Add Another Voucher on the same Date.
This can replace the SAVE/ADD selections and maintain the Transaction and Payment Dates for a new entry when entering vouchers.
Transfer Report and Browse Selection screen – Add F11 popup option for Receipt Account Master File
Do not allow Purchase Order Number to be changed after vouchers have been entered – Check was previously only on Account Code field
Add Recalculate YTD Totals for Previous Year – This procedure will recalculate the totals for a previous year and retrieve purchase order and voucher records for that year from the active data files (02/05/07)—>>> How to Remove Previous Year Transactions from Active Files
Add Browse menu options for Previous Year Expenditure Master File and Receipt Master File – This will allow you to view Previous Year Budget (these records were not saved prior to 2005)
Voucher Transaction Reports – Add Total Cancellations, Total Expenditures and Total Paid (Current + Carryover)
Add menu option to check and repair data files (03/07/07)
Add HELP button on HELP/ABOUT (03/08/07)
Update Invoice Payment Date during EXIT from Voucher Data Entry form (03/27/07)
Maintenance/File Maintenance – Add new option to DELETE ACCOUNT INFORMATION
Invoice Entry from Voucher form – Position cursor on SEL field when new Invoice entered (06/23/07)
Invoice Entry from Voucher form – Make ACCOUNT,PO,DATE PAID,PAYMENT AMOUNT and VOUCHER fields READ ONLY on Invoice Entry Screen (07/02/07)
Vendor Master File – Add COMPLIANCE DATE field for tracking Compliance to House Bill 694 (Ohio) (08/08/07)
Vendor Master File Reports- Add New Report Format (Landscape). This format has new Compliance Date field (08/08/07)
Add Maintenance Option to update Payment Date (Vouchers) for selected Transaction Date – Also flag vouchers as ‘P’aid (08/08/07)
P.O. popup (Voucher and Invoice Entry) – Change sort/selection default to VENDOR NAME leave option to sort by P.O. NUMBER 08/08/07
Invoice Entry – Maintain DATE when entering vouchers (08/09/07)
Invoice Entry – Add RIGHT CLICK option to duplicate record (08/09/07)
Invoice Entry – Add POPUP for Voucher – Retrieve Voucher Information (08/09/07)
Invoice Entry – Add option to add purchased items to Fixed Asset Inventory (08/09/07)
Invoice Entry – Give warning if same Invoice Number entered for same Vendor (08/09/07)
Purchase Order Entry and Voucher Entry – Allow Vendor Master File Record to be updated (Address page). This will allow Account Number to be entered during Voucher and Purchase Order entry. (08/09/07)
System Variables Form – Add screen size option (8/30/07)
Add COMPLIANCE DATE to Vendor pop ups (11/27/07)
Budget Summary With Encumbrances Report – Subtract Prior Year Excess from BUDGET, UNEXPENDED BALANCE and UNENCUMBERED BALANCE columns. Prior Year Excess is the balance amount from previous year purchase orders that was transferred back to the account. Include TRANSFERS OUT in Appropriation column, rather than DEBIT column (11/30/07)
Transaction History and Transaction History Summary Report – Include total for TRANSFERS on subtotal lines of report (11/30/07)
P.O. Popup – Add ACCOUNT NUMBER sort order button (01/05/08)
Carryover P.O. Cancellation Record (Voucher 99999999999) TRANSACTION DATE changed from P.O. Transaction Date to Cancellation Date (01/15/08)
CASH REPORTS – Add new report format (Financial Breakdown)-Prints summary amount and percentage of Incoming/Outgoing funds (01/26/08)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (01/26/08)
Make BACKGROUND COLOR different for fields with available POPUP (01/26/08)
Vendor Reports – Change collating sequence of sorted fields so lowercase letters are merged with uppercase letters (02/27/08)
Voucher Entry – Add popup from WORK ORDER field (Pavement Management or Response Log)( 03/05/08).
Receipt Transaction Entry – Add popup from WORK ORDER field (Pavement Management or Response Log) (03/05/08).
Purchase Order Entry – Add popup from WORK ORDER field (Pavement Management or Response Log) (03/05/08).
Invoice Transaction Entry – Add popup from WORK ORDER field (Pavement Management or Response Log) (03/05/08).
Vendor Master File – Add ACTIVITY FLAG – default popups to active Vendors (04/16/08)
Vendor Master File – Add PREVIOUSLY KNOWN AS page to Data Entry Form (04/16/08)
Expenditure Master File – Add ACTIVITY FLAG – default popups etc. to active Accounts (04/17/08)
Receipt Account Master File – Add ACTIVITY FLAG – default popups etc. to active Accounts (04/17/08)
Add Activity Code Selection (default to Active) to Receipt and Expenditure Master File Browse Selection screens
Budget Transaction Reports – Include only ACTIVE Accounts (04/17/08)
Add option to Increase Purchase Order Amount (rather than change amount) so Date Of Increase can be tracked. Date added to P.O. Detail page of P.O. form. Budget reports now look at P.O. Detail File. If Date of P.O. Detail is greater than the ending date of the report, the encumbrance will be reduced by the amount (qty*price) of that P.O. Detail entry. (04/29/08)
Voucher Entry – Add check during entry for duplicate amount to same vendor – Display message if duplicate entries exist (04/30/08)
Invoice Entry – Change Initial Default Date to Current Date (05/14/08)
Highlight the field where the cursor is located (07/16/08)
Voucher Entry – Add “DATE” to information that must match for new Duplicate Entry (07/16/08)
Expenditure/Receipt Account Master File – Make Activity Flag “Y” on new entries (07/16/08)
P.O. Popups modified – When Sort Order modified, display ‘Sort Order’ field first on popup so navigation is faster (07/28/08)
Voucher Transaction Reports – Add WORK ORDER sort and subtotal options, as well as popup ability from Response Log or Pavement Management Work Order Files (08/14/08)
Receipt Transaction Reports – Add WORK ORDER sort and subtotal options, as well as popup ability from Response Log or Pavement Management Work Order Files (08/14/08)
Voucher/P.O./Receipt Entry – Display FIRST page when ADD selected – previously, current page displayed (11/20/08)
Vendor Master File Reports – Add new report format (One Line Format 1) (12/09/08)
Standard Budget Report – Add page break at SORT 1 (typically this is FUND) (12/09/08)
Transfer Transaction Entry Form – Make DEFAULT ‘FROM ACCOUNT’ an Expenditure Account (12/09/08)
Cash Reports – Add Option To Include TRANSFERS on Reports (Defaults to NO) – Previously, TRANSFERS were included (01/09/09)
Index procedure modified – Remove duplicates (if any) in Expenditure Account Master File and Receipt Account Master File (03/04/09)
Maintenance menu – Recalculate YTD Totals for a Previous Year – This procedure was modified so that a YEAR must be selected – previously ran for BLANK year (04/07/09)
IMPORT menu added – This new menu contains an option for importing PURCHASE ORDER RECORDS and an option for importing VOUCHER RECORDS. These options are currently designed for Harris Accounting Export Files. (04/27/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original
value when you exit the program (04/28/09)
Invoice Data Entry – Add GARAGE REQUISITION field to data entry form. GARAGE REQUISITION can be selected from Garage Requisition File (05/03/09).
Invoice Reports – Add GARAGE REQUISITION sort option (05/03/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
Invoice Data Entry – Add option to create receipt record in Garage and Parts Inventory – Update Inventory Master File. Use RIGHT MOUSE CLICK and select menu option to create GPI Receipt (06/10/09)
Invoice Data Entry – Add LOCATION to Invoice Detail record (06/09/09)
Invoice Data Entry – Detail page – Add popup from Garage and Parts Inventory Master File (06/10/09)
Maintenance menu – Recalculate YTD Totals for a Previous Year – Create records in Previous Year Expenditure and Receipt Account Master Files for Accounts (if not present). These records were not saved prior to 2004 and must be present to run some of the Previous Year Reports. (06/09/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09) (07/27/09-refined)
Receipt Transaction File – Increase DESCRIPTION fields from 40 to 60 characters (09/09/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Add Autofill for Account field – Invoice, Voucher, Purchase Order, Receipt, Appropriation Adjustment entry forms (05/04/10)
Invoice Entry – Detail page – Retrieve Item cost and description from Inventory Master File (GPI) if it exists (05/06/10)
Voucher Entry – Keep PAYMENT DATE (like TRANSACTION DATE) when multiple entries are made (05/06/10)
Add ‘Create XLS file’ button on all report selection screens (06/03/10)
P.O. Report added – P.O.Report using Invoices-Portrait (07/06/10)
Voucher Browse – Add WORK ORDER selection range (07/20/10)
Receipt Transaction Browse – Add WORK ORDER selection range (07/20/10)
Purchase Order Transaction Browse – Add WORK ORDER selection range (07/20/10)
Invoice Transaction Browse – Add WORK ORDER selection range (07/22/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (08/17/10)
Voucher Entry – Retrieve Budget Code (Account) from Vendor Master File (09/15/10)
Purchase Order Entry – Retrieve Budget Code (Account) from Vendor Master File (09/15/10)
Receipt Entry – Retrieve Budget Code (Account) from Vendor Master File (09/15/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Receipt Transaction Report – Add Account Description when sorted by Account – print complete COMMENTS field (11/11/10)
Cash Balance Report – Add option to print WITH or WITHOUT Receipt Detail (11/15/10)
Appropriation Adjustment Auditor Report – Prints APPROPRIATION REDUCTION report for negative adjustments and ADDITIONAL APPROPRIATION report for positive adjustments (12/30/10)
Voucher Browse-add Departmental Codes and Amounts to Browse screen. Add option to sort by first departmental code (01/07/11)
Purchase Order/Voucher/Invoice Entry – Return to PAGE 1 when record is SAVED (01/21/11)
Voucher Transaction Reports – Added ONE LINE PORTRAIT format (01/26/11)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
Voucher Entry – Display invoices, beginning at top (rather than bottom) of list (02/14/11)
Previous Year Browse (Expenditure and Receipt Master File) – Remove DELETE flag so records can not be deleted (05/17/11)
Add Menu Option-Maintenance/File Maintenance menu – Change Vendor Number – This procedure will change the vendor number in the Vendor Master File and all files that store the vendor number (09/12/11)
Voucher Entry – Enlarge COMMENTS field (09/12/11)
Voucher Entry – Enlarge INVOICES field (09/12/11)
Voucher Transaction Reports – Add CARRYOVER, CURRENT, or ALL selection (09/27/11)
Invoice Reports – Include CREDIT entries on UNPAID report until there is a PAYMENT AMOUNT (credit was applied to voucher) 10/29/11
Invoice Entry – Detail Page – Add VEHICLE and ‘STOCK?’ fields. This will allow GPI RECEIPT records to be created for parts ordered for a particular vehicle. If you do not want the part added to the Inventory Master File, choose “N” for ‘STOCK?’. The part can then be selected from NON-STOCK RECEIPTS (F12 in Fleet) when the vehicle is serviced. (11/12/11)
All Files with Grids – Highlight active line of grids and remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (11/18/11)
Year End Close – Modifications made for Open Purchase Orders. 1. Do not set PREVIOUS YEAR FLAG to “YES” unless there is a CARRYOVER AMOUNT. 2. Move Open Purchase Order records to PREVIOUS YEAR when Purchase Order has been CLOSED. When CLOSED, there is an AUTHORIZATION DATE and the P.O. Type is “C”. Click DELETE to CLOSE a Purchase Order. The flags will be set for you. (01/03/12)
Invoice Entry – Do not allow Invoice to be duplicated until it is saved (01/06/12)
Maintenance menu – Add option to update Invoice records with Previous Year Payments – This was added to move Invoice records to Previous Year Files if Budget was
closed and associated invoice records had not been updated correctly with payment information (due to bug that was fixed 1/20/11)
Popups modified – If PREVIOUS YEAR selected on reports, PREVIOUS YEAR Accounts are displayed, rather than CURRENT Accounts (02/10/12)
Maintenance menu – Change Account Codes – Add F11 popup for Receipt Account Codes (03/12/12)
Maintenance menu – File Maintenance – Add option to remove duplicate Voucher entries (03/28/12)
Maintenance menu – File Maintenance – Add option to change FUND (11/09/12)
Recalculate YTD Totals for a Previous Year – Include recalculation for Appropriation Adjustments (04/24/13)
Previous Year Reporting – Add option to include all previous years (voucher reports) (05/10/13)
Budget Summary With Encumbrances Report – Remove redundant duplication of Account Number line to shorten report (06/28/13)
Budget and Cash Report Selection Screen – Change default date range to current month (06/28/13)and Popup
Invoice Entry – Add Fleet Maintenance Code to DETAIL record. Add RIGHT MOUSE CLICK option to CREATE FLEET MAINTENANCE PART ENTRY. This option will link a part on an invoice to Fleet Maintenance without the need to enter the part on a Job in Fleet Maintenance. The part will be added to Inventory unless flagged as NO STOCK on the invoice detail record. A Receipt and Usage record will be created for the part. (11/08/13)
Invoice Entry – Duplicate Record – Do not duplicate Account, Purchase Order, Voucher, Payment Amount and Payment Date (11/22/13)
Invoice Entry – Do not allow Invoice to be selected if Invoice Date is after P.O. Date and P.O. was selected (11/25/13) – Make this a WARNING. Click OK to select (12/09/13)
Voucher Transaction Reports-Schedule of Claims Reports – Print PAYMENT and TRANSACTION DATE ranges in report title (12/11/13)
Invoice Entry _ Detail Page – Add RIGHT CLICK menu option to add record to Cost Table File – Daily Crew Worksheet (DWS) (03/19/14)
Purchase Order, Voucher, Invoice Data Entry Forms – disable grids unless in EDIT mode (03/19/14)
Cash Reports – Add option to include Appropriation Adjustments (09/12/14)
Invoice Transaction Reports – Add INVOICE DETAIL report format (11/18/14)
Voucher Print – Add Voucher #68 for Indiana Complete Print on a Duplex Printer – eliminate turning the form over (01/23/15)
Invoice Browse – Add F2 to view Invoice Detail (02/05/15)
Previous Year – Invoice Browse – Add F2 to view Invoice Detail (02/05/15)
Reports – Standard Budget Report and Budget Summary with Encumbrances – Add commas to dollar amounts (04/08/15)
Invoice Entry – Add PDF page for attaching and viewing PDF files (04/21/15)
Budget Reports – Add option to Treat Appropriation Adjustments as Transfers (some offices use Appropriation Adjustment entries for Carryover) 05/28/15
P & L Budget Comparison Report – Add currency formatting (07/06/15)
Receipt and Appropriation Adjustment Transaction Reports – Add DATE as last sort (08/12/15)
Reports – Add commas to dollar amounts on all remaining reports where space allows (08/18/15)
System Variables – Add option to receive WARNING if Invoice Date is Prior to Purchase Order Date (11/20/15)
Voucher Entry- Assign Unique Voucher ID to each voucher record – Update PAID invoices with this ID to more accurately associate invoices with vouchers (01/31/16)
Voucher Entry – Allow up to 16 departmental codes to be entered – previously limited to 8 (03/22/16)
Budget Summary With Encumbrance Report – Cosmetic changes made so Outstanding Purchase Order Amount Lines up with Outstanding Encumbrance (04/11/16)
Purchase Order Entry – Allow selection of APPROVED/UNPROCESSED GARAGE REQUISITIONS. Update Garage Requisition and associated order records with Purchase Order and Account- Mark Garage Requisition as COMPLETE. (05/26/16)
Purchase Order Entry – Add Shipping Charges and Core Charges to Garage Requisition when Garage Requisition Retrieved (10/10/16)
Invoice Entry – Add Shipping Charges and Core Charges to Garage Requisition when Garage Requisition Retrieved (10/10/16)
Cash Reports – Add Date Range Selection to top of Reports (11/02/16)
Cash Reports – Cosmetic Improvements – Format dollar values (11/02/16)
Invoice Transaction Reports – Add VEHICLE as SORT OPTION (12/02/16)
Expenditure Account Master File – Add IN Unallocated Cost Category Field (A-F) for grouping expenses on County Highway Form No. 28B-Cost Distribution Ledger-Unallocated Costs (07/06/17)
Expenditure Account Master File – Add IN Allocated Cost Category Field (A-E) for grouping expenses on County Highway Form No. 28A-Cost Distribution Ledger-Allocated Costs (07/07/17)
Voucher Transaction Reports – Add Indiana County Highway Form No. 28B-Cost Distribution Ledger-Unallocated Costs as new report type (07/06/17)
Voucher Transaction Reports – Add Indiana County Highway Form No. 28A-Cost Distribution Ledger – Allocated Costs as new report type (07/07/17)
Transaction Reports – P.O. Reports – Add P.O. Detail Report showing P.O. Adjustments (08/22/17)
Voucher Entry – Retrieve Remittance Address from Vendor Master File (if it exists) 08/29/17
Expenditure Account Popup Selection Screen – Add new Allocated and Unallocated Category fields (10/09/17)
Voucher Export-Software Solutions-modified so vendor number is five digits with leading zeroes (10/23/17)
Vendor Name Popup – Add option to SORT/SELECT by Vendor Name OR “Previously Known As” (12/12/17)
Cash Balance Report – Add UNAPPROPRIATED BALANCE to report (04/16/18)
Category Table File and Classification Table File Added – These new files eliminate the redundancy in the Voucher Custom Code File – Category and Classification can be selected separately by using the F11 key for the popup in the Voucher File (Accounting) and the Work Code File (Daily Crew Worksheet) and on Report Selection Screens. The Voucher Custom Code File has been left in place for the present time. This file contains the Category AND Classification. The category and classification can now be selected in the Voucher Custom Code File from the new files. The categories and classifications will be retrieved from the Voucher Custom Code File during the System Update process (when the files are initially added). The descriptions of the Categories and Classifications will be retrieved from the new table files. If the records do not exist in the new files, the Voucher Custom Code File descriptions will be used…This will enable all files to be used, if desired. (04/24/18)
Cash Balance Report – Make new UNAPPROPRIATED BALANCE information optional on report (07/20/18)
Indiana Voucher Report – New DUPLEX form (#75) – Printer should be set up to print 2 sided – Binding – Right/Long Edge – Landscape This voucher assumes first 4 characters of account = fund and account starts in position 6 of the Account field. (08/04/18)
Indiana Voucher Report – New DUPLEX form (#76) – Printer should be set up to print 2 sided – Binding – Right/Long Edge – Landscape (08/09/18)
Previous Year Files – Invoices – Display PDF file location (10/10/18)
Expenditure Account Master File – Enlarge TYPE field from 3 to 10 characters (will accommodate Indiana LOCATION) 11/06/18
Expenditure Account Master File Popup – Add sort options for ACCOUNT, DESCRIPTION and TYPE (11/06/18)
Voucher Entry – Display warning if entry made for duplicate VENDOR and INVOICE (11/06/18)
Voucher Entry – Enlarge COMMENTS field from 100 to 200 characters (11/06/18)
Vendor Master File Report – Include only ACTIVE vendors (01/11/19)
P.O. popup selection – If ACCOUNT has been entered, display only purchase orders for that account (12/01/19)
1099 Report – Add Vendor Number (01/30/20)
Vendor Master File Report – Add ACCOUNT sort option for reports (06/25/20)
REPORT ENGINE – We have changed the report engine in this module so reports (screen and printer) will render correctly when the computer display settings are greater than 100% (HIGH DPI). Assuming there are no issues, we will update all modules with this modification. (12/16/20)
Data Entry Forms (do not minimize when popup selected). 05/17/21
Invoice Transaction File – Increase field length of DESCRIPTION and COMMENTS (10/28/21)
Vendor File – Add Voucher Custom Code…If entered, voucher entries for the vendor will default to that Custom Code (12/27/21)
Maintenance menu – Remove duplicate vouchers – Add VOUCHER NUMBER to index used – some duplicates were not found (05/17/23)

Fixed Asset Inventory

Add “Location” field
Reports – Add SORT/SUBTOTAL for new “Location” field
Add “Active/Inactive” flag for each record
Add “Activity Flag” selection range on Browse and Report Selection screens
Add ASSET NUMBER to several reports
Add two PATH fields and captions for IMAGE FILES (with ability to browse for image files). Images are displayed on PICTURES page.
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Create REPORTS menu
Add menu option to check and repair data files (03/16/07)
Add HELP button on HELP/ABOUT (03/16/07)
User File added to System (09/18/07)
Browse Selection screen added to Stock Inventory File (09/18/07)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/19/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/19/08)
Vendor Master File – Add ACTIVITY FLAG – default popups to active Vendors (04/16/08)
Vendor Master File – Add PREVIOUSLY KNOWN AS page to Data Entry Form (04/16/08)
Highlight the field where the cursor is located (07/28/08)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/12/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Vendor Master File Data Entry – Expand COMMENTS field to 80 characters – Display NOTES field on page 1 (01/26/11)
Add TYPE table file for maintaining INVENTORY types. Add popup selection capability.
Address Management (Visual Foxpro 9.0 )
Table files added for popup selection-School District, Fire District, Mail Route, Subdivision, Voting Precinct, Utilities and EMS District can now be selected from popup lists maintained by this system.
Add “Owner Last Name” selection and sort options to Address File Browse Selection
Address Master File – Add Right Click menu option for creating duplicate record. Create a duplicate record of another address and change the house
number for fast data entry.
Increase field length of House Number field (10 characters)
MAIL ROUTE – Add CITY, STATE, ZIP, TWP to this file and make it available for POPUP selection (MAIL ROUTE and CITY fields) (05/17/07)
Add menu option to check and repair data files (03/28/07)
Add HELP button on HELP/ABOUT (03/28/07)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/26/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/26/08)
Highlight the field where the cursor is located (07/28/08)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Fixed Asset Inventory File Form – Add PDF page for attaching and viewing PDF files (12/18/14)
Maintenance Menu – Add option to Update PRESENT VALUE in Fixed Asset Inventory File (as of selected date) (12/18/14)
Fixed Asset Inventory Reports – Add selection range for PRESENT VALUE (01/20/16)

A/R-Receipt Management

A/R Aging Report -Exclude ONLY ZERO BALANCES – Positive OR Negative Balances should be included
Invoice Form – Add RIGHT CLICK menu option to PRINT INVOICE
Invoice Report – Reformat Invoice so standard window envelope can be used – USE DOUBLE WINDOW #9 ENVELOPE (3 7/8″ X 8 7/8″)
Walk-In Entry – Allow unlimited items to be entered for walk in sale – create separate form for walk-ins.
Add Constituent Names File to ‘File’ menu so file can be maintained in A/R System – file is currently maintained in Response Log module
Add option to print Constituent Names File Reports and Labels
Payment Entry – Allow entry of A/R Identifier and Check Number on Open/Selected Invoices page
Right Click from Account Fields to display Account DESCRIPTION (Payment and Walk-In data entry screens)
Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Maintenance Menu – Add option to Update Pay In Number for a selected date
Payment Browse/ Walk In Browse – Add Pay In Number Selection Range and Sort Option
Add menu option to check and repair data files (03/27/07)
Add HELP button on HELP/ABOUT (03/27/07)
A/R Report Selection Screen – Add popup capability for Account Number (Government Accounting System-Receipt Master File)
Receipt Ledger Reports – Add COLUMN NAME option (FUND, ACCOUNT or NONE) 11/01/07
Walk-In Form – Add FOR and SHORT COMMENT for printing on Receipt 11/01/07
Generic Receipt – Walk Ins – Add Company Name, (new FOR and SHORT COMMENT fields from data entry form) 11/01/07
Invoice/Statement Reports – Add Phone and Fax (from System Variables) 12/07/07
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/20/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/20/08)
Statement Reports – Add “Include Balances > 0” option to report selection screen (03/25/08)
A/R Master File Popup modified – Display appropriate popup form based on operator SORT option (06/06/08)
Account Popup – F10 or Right Mouse Click to select – If Account Exists, Right Mouse Click displays Description of Account (06/13/08)
Generic Incident Invoice – Add Invoice Message (System Variables form) beside Company Name (06/13/08)
Highlight the field where the cursor is located (07/28/08)
System Variables-Add DEFAULT LOCATION (for materials as in GPI) (10/09/08)
Part Popups- Add 2 buttons (DISPLAY JUST MY LOCATION and DISPLAY ALL) (10/09/08)
A/R Master File Popup – Add CURRENT BALANCE to fields displayed (04/08/09)
Invoice Transaction Browse – Add DATE as Sort Option (04/0809)
Archive and Retrieve procedures modified – Select Payment records that match payment amount of invoice records – Add A/R Identifier Range Selection for archiving and retrieving (04/10/09)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/09/09)
System Variables – Release Owner Name so it can be changed (06/10/09)
Invoice Entry – Add popup selection for Daily Crew Worksheet Cost Table File for Item (Materials) 7/14/09
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/15/09) (07/27/09-refined)
Invoice Transaction Reports – Add Total Quantity and Total Cost – Reports previously only contained subtotals on balances (07/20/09)
Invoice Entry – Add popup selection for Daily Crew Worksheet Cost Table File for Item (Equipment) 7/20/09
Invoice Entry – Add popup selection for Daily Crew Worksheet Employee Rates File for Item (Employee) 7/20/09
A/R Master File – Add option to Select from Vendor File – F10 from Company Name (07/21/09)
Payment Transaction Reports – Add ACCOUNT range selection (07/21/09)
Receipt Reports – Add ACCOUNT range selection (07/21/09)
Invoice Transaction Reports – Add ACCOUNT range selection and ACCOUNT SORT/SUBTOTAL options (07/21/09)
Increase field length of COMMENTS for Invoices and Payments from 30 to 60 characters (also have NOTES field) (07/21/09)
Statement Reports – Add Report (Aging) Date (09/08/09)
Payment Entry – Add COMMENTS field to Receipt Transaction File in Government Accounting System (09/09/09)
Payment Entry – Update ADDRESS fields in Receipt Transaction File (Government Accounting System) with A/R Master File Address (09/15/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Invoice Transaction BROWSE form – Add WORK ORDER NUMBER (10/27/09)
Payment Entry – Retrieve WORK ORDER from INVOICE record (03/01/10)
Add Default Account Number to A/R Master File Form – Use as default account during Invoice and Payment Entry (04/13/10)
A/R Master File Reports-A/R Aging Report-Add new report format that lists Open Invoices after Summary of each Account (04/13/10)
A/R Master File Browse modified – Add F1 to VIEW INVOICE TRANSACTIONS or F2 to VIEW PAYMENT TRANSACTIONS (04/20/10)
Work Order Status Reports added -Print Detail or Summary Status Reports including Estimate Costs (Pavement Management), Actual Costs (DWS), Payments to Vendors (Government Accounting), Receipts (Government Accounting), Invoiced and Payment Amounts (Accounts Receivable) (05/03/10)
Detail Receipt Reports – Print Name/Company name for WALK IN sales. Print RECEIVED FOR from WALKIN summary if line items not entered (08/17/10)
Detail A/R Ledger Reports – Print Name/Company name for WALK IN sales. Print RECEIVED FOR from WALKIN summary if line items not entered (08/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (08/17/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
Walk-In Entry – When creating Receipt Transaction record in Government Accounting, use COMPANY NAME, along with FIRST and LAST NAME if COMPANY NAME entered on Walk In (11/11/10)
A/R Master File Reports – Add A/R Aging Report With MEMO. This report will print the MEMO (Notes) form the A/R Master File (11/15/10)
Invoice Entry – Retrieve ITEM DESCRIPTION from Inventory Master File (GPI) (11/30/10)
Walk-In Report menu option added – Summary and Detail Report available (01/17/11)
Maintenance menu – Recalculate Balances – Added option to select A/R Identifier or Company Name range to be selected (02/20/11)
Maintenance menu – Added new menu option (ADD INTEREST CHARGES) – Enter the INTEREST PERCENT and NUMBER OF DAYS (interest). An INTEREST CHARGE will be added for the selected accounts. The interest amount will be calculated on the A/R amount over the SELECTED NUMBER OF DAYS OLD (02/20/11)
Payment Entry – If CREDIT MEMO selected, do not create Receipt Record in Government Accounting System (05/05/11)
Invoice Entry – Increase field length of DESCRIPTION fields to 100 characters (09/06/11)
Invoice Entry – Replace DESCRIPTION 2 with COMMENTS from Inventory Master File (GPI) if Item found (09/06/11)
All Files with Grids – Highlight active line of grids and remove DELETE FLAG from GRIDS so records can not be deleted by clicking DELETE FLAG (11/30/11)
A/R Ledger Reports and Statements – Print CREDIT MEMO rather than PAYMENT when Credit Memo selected on Payment form (04/15/16)
Payment Entry – Make DESCRIPTION 1 of Government Accounting Receipt Entry COMMENTS from A/R Payment Entry…Description 2 is PREVIOUS “A/R Payment…” message…These two fields were switched so entered COMMENTS shows on Cash Reports in Government Accounting System (01/09/18)
Payment Entry – Add POPUP for selecting INVOICE to PAY. Payment will be applied to matching INVOICE (07/16/20)
Data Entry Forms (do not minimize when popup selected). 05/17/21

Time Management

The Time Management System is an optional, add-on module that works with the Daily Crew Worksheet System.
This system provides a simplified Time Sheet Entry system that uses the default values set up in the Employee Rates File. Time Sheets can be entered, viewed and printed. These Time Sheets can then be IMPORTED into the Daily Crew Worksheet System. If the Time Sheet contains a SNOW ROUTE, the employee’s time, vehicle time and mileage, spreader time and mileage and material usage will be split among the road sections for the snow route.
Scheduling can also be done using this system. A foreman can create, maintain and print a daily schedule for his crew using the default values in the Crew Table File and the Employee Rates File. Reports can be printed by Work Location, Crew, Vehicle, Employee or Work Code.
Add RIGHT CLICK menu (Page 1) with options to create duplicate schedules and make global change on schedule (12/07/09)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)

Ohio Crash Statistics

Add System Option to Scan Data Files
Add MAIL TO option for e-mailing current record
All Report Options are now available in PDF format
Add menu option to check and repair data files (04/10/07)
Add HELP button on HELP/ABOUT (04/10/07)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/26/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/26/08)
Highlight the field where the cursor is located (07/28/08)
Import Procedure modified – a few fields in TRACTAPE file are now right justified – Import Procedure will left justify these fields (08/27/08)
Give option to turn CAPS LOCK ON when using program (System Variables) – Select setting on System Variables menu – CAPS LOCK value will return to original value when you exit the program (04/28/09)
When PRINT is selected from SCREEN REPORT, prompt for pages to print (06/12/09)
All Forms – Remove formatting of numeric fields when editing. Decimal does not have to be entered (07/27/09)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)
OH-1 FORM Modified to match updated form (11/02/12)
OH-1 Import (from ODPS) modified to match new file layout (11/02/12)
Add Date Entry Menu (11/02/12)
OH-1 Import (from ODPS) modified to retrieve ROUTE NUMBER. ROUTE NUMBER also stored in ROAD NAME field if there is no road name. (11/09/12)
OH-1 Browse – Add DATE and REPORT NUMBER sort options (11/09/12)

Address Management

Table files added for popup selection-School District, Fire District, Mail Route, Subdivision, Voting Precinct, Utilities and EMS District can now be selected
from popup lists maintained by this system.
Add “Owner Last Name” selection and sort options to Address File Browse Selection
Address Master File – Add Right Click menu option for creating duplicate record. – Create a duplicate record of another address and change the house number for fast data entry.
Increase field length of House Number field (10 characters)
MAIL ROUTE – Add CITY, STATE, ZIP, TWP to this file and make it available for POPUP selection (MAIL ROUTE and CITY fields) (05/17/07)
Add menu option to check and repair data files (03/28/07)
Add HELP button on HELP/ABOUT (03/28/07)
Along with F10 popup, Add RIGHT MOUSE CLICK popup option (02/26/08)
Make BACKGROUND COLOR different for fields with available POPUP (02/26/08)
Highlight the field where the cursor is located (07/28/08)
DOUBLE CLICK will now produce POPUP selection screens (10/24/09)
Road Master File – Increase field length of CLASS field (now 20 characters) – Add CLASS TABLE FILE Form/Report – Add POPUP selection of CLASS in Road Master File Form and Report Selection (05/17/10)
System Menu – Add EXPORT TABLES TO EXCEL menu option. This menu option will create an Excel XLS file for a selected Visual Foxpro table. (09/04/10)
Road Master File – Add REPAIR COST field (09/21/10)
Road Master File Reports – Add ‘Road Evaluation Report’ report type. This report is a replica of the OPWC Summary Form (09/21/10)
Road ‘Surface Type’ Table File/Report/Popup capability added so Surface Type field will be consistent (09/21/10)
Road Master File – Add FROM and TO LONGITUDE and LATITUDE fields (09/21/10)
System Menu – Print List of PGS Tables menu option added (10/11/10)

Programs added to PGS in 2011 to assist with GPS functionality:

1. ZylGPSReceiverAX 3.11 ActiveX Control

ZylGPSReceiverAX is an ActiveX control that communicates with a GPS receiver.

It returns latitude, longitude, altitude, speed, heading and many other parameters of the position.

This control works with any NMEA 0183 compatible receiver connected to one of the serial ports.You can use it also with USB, IrDA and Bluetooth devices, because these devices have a driver that redirects the input from the USB, IrDA or Bluetooth port to a virtual serial port (you can check it in System/Device Manager/Ports). If your USB device is not provided with such a driver, then use a USB controller whose vendor provides a virtual serial port driver, such as FTDI or use a USB/RS-232 adapter.

This program was purchased to retrieve latitude and longitude information from a GPS receiver. It is currently used by Sign Management, Guardrail Management, Culvert-Bridge Management, Daily Crew Worksheet, Response Log, Pavement Management and Accident Statistics.

2. VISCOM lmage Viewer ActiveX 8.0

Image viewer CP is a simple and easy ActiveX OCX control to creates, crop, displays, edits, flips, resizes and rotates image, photo and graphic. It supports BMP, GIF, ICO, JPEG, JPEG 2000, PCX, PNG, PSD, TIFF, WMF, WBMP, TGA, PGX, RAS, PNM, and others and can convert between them. Images can be printed to printer. Moreover, it provides some helpful source code sample includes Access, Delphi, VB, VB.net, VFP and Web Page.

With Image viewer CP, you can convert the images between several popular formats, output the images in greyscale, retrieve and set images to clipboard and picture box, save and restore the specified location of the images, provide a value-added function called “Map System helper” which help you to develop an application that involved with electronic map creation or map-related function, support keyboard or mouse wheel scrolling images. It is compatible with any programming language that supports ActiveX (ASP, Access, Delphi, Visual Basic, Visual C++, Visual Foxpro, .Net,PowerBuilder etc.)

* Read, write EXIF image information. Including TIFF tags, GPS tags.

This program was purchased to retrieve latitude and longitude information from images. It is currently used by Sign Management, Guardrail Management, Culvert-Bridge Management and Response Log.