Installation: EM200-13
Table of Contents Introduction Discounting and Miscellaneous Charges Software License Agreement...............................3 LectroCount Data Management System..............4 Installation............................................................6 Navigation and Operation....................................8 Cash.500.............................................................22 Volume.500.........................................................22 MiscTran.500.........................................
Software License Agreement Read this license carefully. You agree that by using the itemized software package, you have agreed to the software license terms and conditions. This agreement constitutes complete and entire agreement between you and Liquid Controls with respect to this product. 1. Liquid Controls hereby grants to Licensee a nonexclusive license to use DMS Office, DMSMenu, LCP File Server, DMS Delivery, and LCRHost Software (hereinafter referred to as “Licensed Software”) 8. Termination.
LectroCount Data Management System LectroCount Data Management System DMSMenu LCRHost DMS Delivery LCP File Server DMS Office Program LCP File Server: Allows access to files from the DMS Module via other computer systems in a manner similar to that of Windows® Explorer. Files on other devices that are running LCP File Server are also accessible. The LectroCount DMS is a “Data Management System.
LectroCount Data Management System A vehicle delivery system typically includes the following components: Metering System The metering system is typically mounted to the back or side of a delivery vehicle to measure the product being delivered. Components of this system can include the meter, electronic register, strainer, air eliminator, and control valve. DMS Module The DMS Module provides connections for the printer, the DMS Lap Pad, electronic registers, and a USB flash memory device.
Installation Software Installation Installation Requirements • • • • • • 10 Mbytes free hard drive space (minimum) 64 Mbytes RAM (minimum) 200 MHz Pentium style processor (or faster) Windows NT, 2000, or XP operating system CD-ROM Drive USB Flash Memory Device Run Window Startup Insert the CD-ROM. The setup program should automatically launch. If the automatic launch fails: 1. 2. 3. 4. 5. Click Start. Click Run. Click Browse and search the CD-ROM Drive. Click SETUP.EXE and click on Open.
Installation Choose Destination Location Installs DMS Office into a folder on your hard drive or network. You can use the default settings, or you can choose a custom folder. Enter that folder here. Click Next> to advance to the Setup Type window (Install 4). Setup Type Selects the type of installation. Leave the selection on the default Typical and click Next> to advance to the Setup Complete window (Install 5).
Navigation & Operation DMS File Conversion & Transfer Although DMS Office has several applications, its main function is as a data capture program. DMS Office prepares, loads, and reads files for transfer between DMS Delivery and your back office business management software. Using DMS Delivery, drivers retrieve the dispatch information from the USB Flash Memory Device before beginning their routes. When drivers finish their routes, they copy the transaction files (.
Navigation & Operation DMS Office Main Window Shown on the right, the Main Window provides access to all of DMS Office’s tools. Starting at the top, there are three drop down menus (File, Configure, and Help), a toolbar, fourteen Edit File buttons (.500 files - pg. 11), two File Generation buttons (LCLoad and LCRead - pg. 18), and a status bar. These menus and buttons are visible in most windows.
Navigation & Operation Help Menu Help Topics Opens Help files Not Active April 2007 About DMSOffice Help Menu Displays version and copyright information Configuration Tax Print Ticket Copy to USB About DMSOffice Copy from USB Help Toolbar Tax Print Prints active document Opens the Tax Configuration Window Not Active April 2007 About DMSOffice Configuration Help Copy Files to USB Ticket Copy Files From USB Opens Source and Destination Window Displays version and copyright information
Navigation & Operation .500 Windows LCLoad converts ASCII text files and distributes the data into .500 files. .500 files can be opened, viewed, and edited in DMS Office. To open .500 files, click the corresponding button to the left of the white page or choose the Open command from the file drop down menu. Each .500 file display window has a white page which displays existing records and their field values. Below the white page, there are three buttons: New, Edit, and Delete.
Set Up Quick Start Before running DMS Delivery, there are vital DMS Office tasks that must be completed. These tasks are listed below in their requisite sequence. After the steps are completed, you can run DMS Delivery; however, Liquid Controls recommends that you carefully read this manual and adjust DMS Office’s settings to suit your exact needs before transferring files to DMS Delivery. 1. DATA FILE FORMAT • Pg. 13 Generate ASCII text files using your back office software. 2.
Set Up Data File Format Record Types In order to interface with and pull data from your back office software, DMS Office needs the dispatch data to be in an ASCII text file format. ASCII text files can be generated by your back office software. The Totalizer Record and the Dispatch Records are generated by the back office software and converted into .500 files by LCLoad for transfer to DMS Delivery. ASCII text files are divided into records, and records are divided into fields.
Set Up Source and Destination Window The Source and Destination window assigns a location in the hard drive or network for DELLOAD.DAT and DELREAD.DAT. The Source for text dispatch file is the location of the ASCII text file generated by the back office software for DMS Office (DELLOAD.DAT). The Destination for text delivery file is the location of the DMS Office generated ASCII text file for the back office software (DELREAD.DAT).
Settings and Security Config.500 The Config.500 file defines driver interface parameters. They can be changed in the Config Record window. Add to Inventory Checked Driver-entered product inventory added to the current product inventory value. Unchecked Driver-entered product inventory overwrites the current product inventory value. Cash Discount Before Tax Checked Cash discounts applied before taxes are calculated. Unchecked Cash discounts applied after taxes are calculated.
Settings and Security Config.500 Price Protected Checked DMS Office checks for price protection in Driver.500 records. Unchecked DMS Office does not check for price protection in Driver.500 records. Simultaneous Delivery The Price Protected box in Config.500 and the Price Protection in Driver.500 must both be checked to prohibit the driver from changing the price.
Settings and Security Driver.500 The Driver.500 file maintains driver roster information. Drivers can be added, assigned passwords, and prohibited from changing prices. All drivers must be given a Driver # and a Name. Password and Price Protection are optional. Driver Number Enter a unique alphanumeric value <= 10 characters. Name Enter a unique alphanumeric value <= 28 characters. Password Enter a unique alphanumeric value <= 10 characters. Price Protected The Login Method option in Config.
File Transfer LCLoad DMS File Transfer LCLoad converts an ASCII text file, generated by the back office software, into .500 formats for DMS Delivery. To launch LCLoad, simply click the LCLoad button or click LCLoad in the File drop down menu. LCLoad searches the folder designated in the Source for dispatch file (LCLoad) field of the Source and Destination Window for the ASCII text file (DELLOAD.DAT).
Customer Accounts Customer.500 The Customer.500 file contains basic customer ID information. LCLoad populates these fields using data from DELLOAD.DAT, but records can be added and edited using DMS Office. City, State, and Zip fields will be populated if the Parse Address field is checked in the Config.500 file before LCLoad was run. Dispatch.500 The Dispatch.500 file defines the delivery parameters for each account. LCLoad populates these fields using data from DELLOAD.
Customer dispatch.500 Tax Code The default tax code for the current account. Any entry must match a tax code in the TaxCode.500 file. CustAcct.500 The CustAcct.500 file contains customer billing information. LCLoad populates these fields using data from DELLOAD. DAT. Access # The current customer’s access number. Balance The current account balance. Past Due Amount (30 days) Any amount more than 30 days overdue. Not Active April 2007 Delivery Type This field is not used.
Customer Tank.500 Product Code The product code of the product stored in the tank. Any entry must match a product code from the Product.500 file. Volume Discount Code Volume discount code defined in the Volume.500 file. Any entry must match a volume discount code from the Volume.500 file. Cash Discount Code Cash discount code defined in the Cash.500 file. Any entry must match a cash discount code from the Cash.500 file.
Discounts and Miscellaneous Charges Cash.500 The Cash.500 file defines cash discounts based on timely payment. LCLoad populates these fields using data from DELLOAD.DAT, but records can be added and edited with DMS Office. The Cash Discount Code must be included in the Tank Record to be applied to transactions. There are three intervals available for discount settings. # of Days in Interval The number of days after delivery in which the customer can pay their bill and receive a discount.
Discounts and Miscellaneous Charges MiscTran.500 The MiscTran.500 file defines charges applied independent of delivery. The driver can choose which Miscellaneous Transaction Record to apply in DMS Delivery. These records must be created in DMS Office and loaded to DMS Delivery. Name A description of the transaction. Enter an alphanumeric label <= 22 characters. Code A transaction code used to identify the miscellaneous transaction in DMS Delivery. Enter an alphanumeric code <= 8 characters.
Product Configuration Product Configuration DMS Office’s Product.500 and FuelType.500 label and configure products, so DMS Delivery can properly receive meter readings from the LCR-II. LCLoad creates a product record for every unique product code found in DELLOAD.DAT’s records and enters them into Product.500. FuelType.500 is manually populated with DMS Office. Product.500 and FuelType.500 must be set up after running LCLoad and before launching DMS Delivery. LCR-II, Fueltype.
Product Configuration Product Configuration Auxiliary Output 1 Not Active April 2007 Auxiliary Output 2 Not Active April 2007 Inventory Inventory used during the current shift. FuelType.500 A FuelType.500 record defines a group of products with the same LCR-II calibration setting. The Fuel Type Code is manually set in Product.500 to assign products the correct LCR-II calibration. Code Enter a numeric value <= 255. This is the value Product.500 enters into Fuel Type Code.
Product Configuration Map from Product to LCR Calibration If the Map from Product to LCR Calibration box is checked in the Source and Destination window, you must assign products’ LCR-II calibrations differently. LCLoad still creates a list of products and assigns codes and generic descriptions, but aligning the products to the correct LCR-II calibration is done in the Product.500 not FuelType.500. In fact, the FuelType.500 window will be eliminated from the button list. Product.
Tax Configuration Tax Configuration There are three tax-related .500 files: CfgTax.500, Tax.500 and TaxCode.500 These files label and structure tax values from DELLOAD.DAT for use in DMS Delivery. Any changes to these files must be made before running LCLoad. LCLoad and taxes Tax.500 and TaxCode.500 are created by LCLoad using data from CfgTax.500 and DELLOAD.DAT field values. Tax.500 records specify single taxes, and TaxCode.500 records combine single taxes to form tax structures.
Tax Configuration CfgTax.500 The CfgTax.500 defines and labels the tax fields in the DELLOAD.dat records. There are 9 fields in the CfgTax.500 file that correlate directly to the 9 fields in DELLOAD.dat fields (N16 to N24). The Tax Type (chosen from a drop down menu) fields and the Label (entered as an alpanumeric value) fields can be edited to suit specific tax structures. CfgTax.500 must be completed before running LCLoad.
Ticket Configuration Module Ticket Configuration Module The Ticket Configuration Module (TCM) of the DMS Office program defines and configures delivery ticket printouts for DMS Delivery. To launch TCM, click on the TKT button of the toolbar or select the Ticket command under the Configure drop down menu. There are three types of windows in TCM: the main ticket window, the ticket configurator window, and the record text window.
Ticket Configuration Module Ticket Configurator Windows Ticket Configurator Windows organize and add items to the DMS Delivery print out. New Opens a blank record text window. If there are existing records, the newest record will be printed last. Edit Opens an existing record text window for editing. To choose a record, click inside the Order field of that record. Delete Deletes an existing record text window. To choose a record, click inside the Order field of that record.
Ticket Configuration Module Record Text Windows Pad length The space between the label and the value. Each line is left justified, label first. (To right justify the value, enter a value equal to the Maximum label length.) Field is last on this ticket line? Checked The following record will be printed on the next line. Unchecked The following record will be printed on the same line as the current record. The last line in a section (Header, Trailer, etc.
Ticket Configuration Module Header Field Types Trailer Field Types Customer State The Trailer Record Text window contains Field Types not included with the Header Field Types. Customer state as it is found in the customer database (If the address was parsed when LCLoad was run.) Delivery Tax lines Customer Zip Values taken from the Tax.500 file. The labels used in Tax.500 file will be printed on the ticket. Customer zip code as it is found in the customer database.
Ticket Configuration Module Addendum Field Types Miscellaneous Field Types The Addendum Record Text window contains Field Types not included with the header or trailer Field Types. The Miscellaneous Record Text window contains Field Types not included with the header, trailer or addendum Field Types. Grand Total Due Misc. Tran. # Amount due for current delivery. The sale # for miscellaneous transactions tracked separately from deliveries. Percent Full Percent of tank with product. Misc. Tran.
APPENDIX
Appendix Data File Format The first section of the appendix includes examples of ASCII text files and tables describing each field. Examples from page 36 to 41 (one type of Totalizer Record and four types Dispatch records) are generated by the back office software for DMS Office. These files make up DELLOAD.DAT which LCLoad converts to .500 files for DMS Delivery.
Appendix Standard Totalizer Record - LCLoad Field Name Example Field Number Field Type Record Type 1 (Totalizer) H1 Integer Number of Numeric Fields in the Record 31 H2 Integer Number of Alphabetic Fields in the Record 4 H3 Integer 0 (New) N1 Integer RAM Card Indentifier 0 N2 Integer Unit Identifier 0 N3 Integer Truck Number 0 N4 Integer Miles Driven from Start of Shift Until Now 0 N5 Floating Current Odometer Reading 0 N6 Floating Total Net Delivered Volume (this shi
Appendix Standard Dispatch Record - LCLoad Field Name Example Field Number Field Type Record Type 5 (No Preset) H1 Integer Number of Numeric Fields in this record 17 H2 Integer Number of Alphabetic Fields in this record 8 H3 Integer 140012 N1 Integer Product Code 2 N2 Integer End Use Code 0 N3 Integer Preset Amount 0 N4 Preset 0.907 N5 Floating Category 1 Tax (Expressed as % of Subtotal) 0.0 N6 Floating Category 1 Tax (Expressed as $ per Unit Volume) 0.
Appendix Dispatch Record with BEGINNING BALANCE - LCLoad Field Name Example Field Number Field Type Record Type 5 (No Preset) H1 Integer Number of Numeric Fields in this record 18 H2 Integer Number of Alphabetic Fields in this record 8 H3 Integer 140012 N1 Integer Product Code 2 N2 Integer End Use Code 0 N3 Integer Preset Amount 0 N4 Preset 0.907 N5 Floating Category 1 Tax (Expressed as % of Subtotal) 0.0 N6 Floating Category 1 Tax (Expressed as $ per Unit Volume) 0.
Appendix Dispatch Record with EXTENDED DRIVER INSTRUCTIONS - LCLoad Field Name Example Field Number Field Type Record Type 46(No Preset) H1 Integer Number of Numeric Fields in this record 17 H2 Number of Alphabetic Fields in this record 10 H3 Integer Access Number Integer 140012 N1 Integer Product Code 2 N2 Integer End Use Code 0 N3 Integer Preset Amount 0 N4 Preset 0.907 N5 Floating Category 1 Tax (Expressed as % of Subtotal) 0.
Appendix Dispatch Record with BEGINNING BALANCE and EXTENDED DRIVER INSTRUCTIONS - LCLoad Field Name Example Field Number Field Type Record Type 46 (No Preset) H1 Integer Number of Numeric Fields in this record 18 H2 Integer Number of Alphabetic Fields in this record 10 H3 Integer Access Number 140012 N1 Integer Product Code 2 N2 Integer End Use Code 0 N3 Integer Preset Amount 0 N4 Preset 0.907 N5 Floating Category 1 Tax (Expressed as % of Subtotal) 0.
Appendix Standard Totalizer Record - LCRead Field Name Example Field Number Field Type Record Type 1 (Totalizer) H1 Integer 0 (New) N1 Integer 13532 N2 Integer Unit Identifier 27 N3 Integer Truck Number 15 N4 Integer 90.7 N5 Floating Current Odometer Reading 83145.6 N6 Floating Total Net Delivered Volume (this shift) 2315.6 N7 Floating Total Gross Delivered Volume (this shift) 2389.
Appendix Standard Delivery Record - LCRead Field Name Example Field Number Field Type Record Type 6 (Scheduled) H1 Integer Access Number 140012 N1 Integer Gross Volume 175.34 N2 Floating Net Volume 172.3 N3 Floating Average Temperature During this Delivery 52.3 N4 Floating Ticket Number 48365 N5 Integer Sale Number 48365 N6 Integer Operator Number 26 N7 Integer Product Code 2 N8 Integer End Use Code 0 N9 Integer 83137.5 N10 Floating 0.
Appendix Delivery Record With BEGINNING BALANCE - LCRead Field Name Example Field Number Field Type Record Type 6 (Scheduled) H1 Integer Access Number 140012 N1 Integer Gross Volume 175.34 N2 Floating Net Volume 172.3 N3 Floating Average Temperature During this Delivery 52.3 N4 Floating Ticket Number 48365 N5 Integer Sale Number 48365 N6 Integer Operator Number 26 N7 Integer Product Code 2 N8 Integer End Use Code 0 N9 Integer 83137.5 N10 Floating 0.
Appendix Delivery Record with EXTENDED DRIVER INSTRUCTIONS - LCRead Field Name Example Field Number Field Type Record Type 47 (Scheduled) H1 Integer Access Number 140012 N1 Integer Gross Volume 175.34 N2 Floating Net Volume 172.3 N3 Floating Average Temperature During this Delivery 52.3 N4 Floating Ticket Number 48365 N5 Integer Sale Number 48365 N6 Integer Operator Number 26 N7 Integer Product Code 2 N8 Integer End Use Code 0 N9 Integer 83137.5 N10 Floating 0.
Appendix Delivery Record with BEGINNING BALANCE AND EXTENDED DRIVER INSTRUCTIONS - LCRead Field Name Example Field Number Field Type Record Type 47 (Scheduled) H1 Integer Access Number 140012 N1 Integer Gross Volume 175.34 N2 Floating Net Volume 172.3 N3 Floating Average Temperature During this Delivery 52.
Appendix Delivery Record with EXTENDED DRIVER INSTRUCTIONS - LCRead See page 44 for table “47”,”140012”,”175.34”,”172.3”,”52.3”,”48365”,”48365”,”26”,”2”,”0”,”83137.5”,”0.7”,”0.907”,”156.28”,”0”,”0.05”,”2.7”,”0”,”1.25”,”0”,”0”,”0”,”0”,”12.84” ,”10”,”100.72”,”269.84”,”19.84”,”250”,”1”,”-10”,”97.23”,”LX-13A2 “,”04/17/95”,”08:27:49”,”04/17/95”,”08:41:31”,” ”,” ”,” ”[CR/LF] Delivery Record with beginning balance AND extended driver instruction - LCRead See page 45 for table “47”,”140012”,”175.34”,”172.3”,”52.
Appendix DMS Version Compatibility DMS Office 1.00 1.01 1.01 1.01 1.02 1.03 1.04 1.04.03 1.04.04 1.05 1.06 1.06.01 1.07 1.07.01 1.08 1.08.01 1.08.02 1.08.02 1.11 DMS Delivery 1.00 1.01 1.02 1.03 1.04 1.05 1.06 1.06.05 1.06.06 1.07 1.08 1.08.01 1.09 1.09.01 1.10 1.10.01 1.10.02 1.10.08 1.11 Common Error Messages Parameter Error File not Found Record format does not match the file. A software upgrade with old files can cause this error.
Appendix Batch Files By creating batch files in DOS, the transfer of files back and forth between DMS Delivery and the back office software can be reduced to a one click process. LC3 (Liquid Controls previous data management system) was run in this manner. Command Line Parameters ================================================================== ====== CONSOLE APPLICATION : DMSLCLoad ================================================================== ====== This application can be invoked by a batch file.
Appendix This application can be invoked by a batch file. Error messages and diagnostic messages will be printed to “DMSLCRead.txt”. This file will be created in the same folder that the application is in. This program can be called in three ways. For the examples below, it is assumed that the executable is in the following folder: c:\DMS\ 1) The simplest method of calling this program: c:\DMS>DMSLCRead The program attempts to convert c:\DMS\COMPTRAN.TRN and c:\DMS\TOTALS.TRN into c:\DMS\DELREAD.DAT.
Appendix Sample Batch File Rem -------------------------------------------------------------Rem The following assumes that the batch file is located in C:\DMS\ Rem -------------------------------------------------------------Rem --------------------------------------------------Rem Copy the file from the network to the local folder. Rem --------------------------------------------------if exist H:\DMS_FILES\DELLOAD.DAT copy H:\DMS_FILES\DELLOAD.DAT *.
105 Albrecht Drive Lake Bluff, IL 60044-2242 1.800.458.5262 • 847.295.1050 Fax: 847.295.1057 www.lcmeter.com © 2007 Liquid Controls Pub. No.
