Keystroke POS Software - Support Utilities

Below is a list of Support Utilities included with Keystroke Advanced POS and a description of what each one does.

CHGNUMS.EXE	Renumber Inventory Stock Numbers or Customer Numbers.
CONVPTG.EXE	Price Tag File Conversion.
COPYCLK.EXE	Copy Time Clock Data.
DELTRANS.EXE	Mass Delete Transactions.
DELUTIL.EXE	Delete Utility.
HEADER.EXE	Transaction File Header Program.
IMPALTIC.EXE	Alternate Inventory Codes Importer.
IMPORTAR.EXE	Accounts Receivables Customer Balances Importer.
KSBACKUP.EXE	Data Backup Program.
KSRESTOR.EXE	Data Restore Program.
REMDUPES.EXE	Duplicate Transaction Remover.
UDPRICE.EXE	Update Price Fields.
UPCCOST.EXE	Update Parent Child Costs.

Change Nums is an executable Keystroke Program which will read in, pack, and renumber either the Inventory or Customer Database. It will also update old tansactions to reflect the new Customer and Inventory Numbers.

The numbers are assigned based on the starting number specified and the location of the record within the database file. Note that the physical location of the records within the file can be manipulated before hand through the use of the Importer Module.

This program supports the standard Keystroke command line switches but usually only the /D switch is used (data directory switch).

CHGNUMS.EXE will update the following databases:
Matrix Items (KSMTX.DAT)
Alternate Inventory Codes (ALTIC.DAT)
Variances in Progress (VAR*.DAT)
Scripts (KSSCRPT.DAT)
Productions (KSPRD*.DAT and KSTEM.DAT)
Store Transfers (KSSTR*.DAT)
Customer Contacts (KSCON*.DAT)
Contract Pricing files (CP*.DAT)
Photo files (PHOTOS\*.DAT)
Alternate Transaction Files (KSTRHOLD.DAT, KSTRREC.DAT, etc.)

Note: If changing inventory numbers, after it is complete, pack Alternate Inventory Codes, Matrix Items, Scripts, and Product Templates.

LOG FILE: The program will write a log file (CHGINV.LOG or CHGCST.LOG) listing the numbers that were changed. The file will list the old number, followed by a Tab character followed by the New number. It only list numbers that were changed to a new number and not those that stayed the same or were no longer in use. The information is appended to the existing file, so delete the file first if you only want current information in it. Also, you can run CHGNUMS with TITLE=0 and/or HEADER=0 to eliminate the text at the top of the file. This allows the log file to be read into another program as a Tab delimited data file.

CHANGE NUMBERS ABOVE parameter (default is 0): This number marks a limit that preserves numbers at and below its level. For example, if you don't want inventory items numbered 1 to 1000 to be changed, set this number to 1000. Then only items numbered 1001 and higher will be changed. Note that the program will still change deleted items (their history is changed to number 0). If you want to just change the history of deleted items to 0 so that their stock numbers can be reused and don't want to change the number on any existing items, then set the Change Numbers Above parameter to 99999.

READ CHANGES FROM FILE parameter: If this is on, then instead of renumbering the database sequentially, the program will read in the Old/New number combinations from the file CHGNUMS.TXT This file can be in just about any delimited format as long as each record has the Old number field first, followed by a delimiter, followed by the New Number field second. The delimiter will usually be a Space, Comma, or Tab, but can also be any non-numeric character(s). The log files generated by CHGNUMS are supported. To use these files, copy CHGINV.LOG (or CHGCST.LOG) to CHGNUMS.TXT before running the program. If a log file is used, then the program will search for the last set of changes in the file and use those (since the log file can hold more than one set of changes).

When READ CHANGES FROM FILE parameter is on, the Starting New Number parameter is ignored. However, the Change Numbers Above paramter is still used (i.e. the program won't change a record if its current number is below the Change Numbers Above value).

When READ CHANGES FROM FILE parameter is used, it is possible to create duplicate Customer/Inventory numbers. So you need to make sure that the changes to be made are compatible with the data set that is being updated (no numbering conflicts). However, this is also a feature of the program that can be used to merge two or more Customer or Inventory records together. For example, if you have a customer listed in your database twice (e.g once as Customer Number 212 and again as 3076), you remove 3076 and assign his history to 212 by creating CHGNUMS.TXT with a single line of 3076 212 in it. Running CHGNUMS on Customers, with Read Changes from File turned on, will cause customer 3076 to become 212. You will then have 2 customer numbers 212 in your database. Use the Record Delete function in the Database Manager to delete the one you don't want. You will then end up with customer 3076 out of your customer list and all of its history attached to customer 212.

Example of a 2 column delimited file:
3076 212 (will change customer number 3076 with 212)
5097 213 (will change customer number 5097 with 213)
10575 214 (will change customer number 10575 with 212)

SCRIPTS: The program will not update Scripts that are Select Item from Range and the range is By StockNumber. These scripts will remain with the old stock number range which may no longer be valid. This type of script is not recommended in the first place. But if you have any, they can corrected manually by editing the script after ChgNums has been run.

Converts old price tag forms (.PTG) to the new format (.TAG). The old file must be in the FORMS\ directory and the new file will be in the REPORTS\ directory.

Do not place a path or file extension on the OldTag filename, the program will do it for you (FORMS\OLDTAG.PTG).

Field Text in the new forms is limited to 30 characters. If the old form was using more than 30 in a single entry, then the rest of the text will be place in the Heading field for that line.

Only supported switch is the name of the file to be converted. Only 1 file can be converted at a time. (e.g. CONVPTG 1WIDE).

Copies the time clock information from the file KSCLK.TMP to the file KSCLK.DAT, the times are only copied if they are newer than the present times.

Supports the standard Keystroke command line switches and the following special switches:

/M - Merge directory, follow this switch with the location of the KSCLK.TMP file.

Deletes sales and purchase transactions that match the specified criteria. Both a Start Date (START=) and Ending Date (END=) must be specified. Changes are recorded in the DELTRANS.LOG file in the Data Directory.

Supports all the standard Keystroke command line switches as well as the following special switches:

TYPE= : two characters which match the Hot Keys on the export function used in the Configuration Manager, but only Sales Transactions and Purchase Transactions are supported. Valid Types are for Sales are: TYPE=SA, TYPE=SB, ... TYPE=SL. Valid Types for Purchase Transaction are: TYPE=PI, TYPE=PO, TYPE=PR.

Filter= : the filter number followed by the condition which is enclosed in quotes. The number is found in the file DOC\Filters.doc
Under Sales Transactions or Purchase Transactions (e.g Filter=2">100 and <200" will delete Transaction Numbers between 100 and 199). If using multiple filters, all filters must match.

/NOINV : No Customer - do not update Customer amounts (or Vendors on Purchase transactions).

Provides special data file maintenance routines that are not available in the standard Keystroke program. This special tool originally was used to force deletion of problem payments (mark with an X to delete). Now many "Update" functions have been added, such as resetting Customers’ oldest open invoice date to force the program to recalculate AR.

Supports the standard Keystroke command line switches as well as the following special switches.

/G - Go to function. This switch will automatically run the specified function. Specify the function by entering the Highlighted Hotkey from the menu in the program. (e.g. Update-Open Orders is /GPO). Not all functions are supported due to security concerns.

/NOP - NO Pause - Will not stop to ask if you really want to run the selected function.

***This program should only be used with the help of a Keystroke Technical Support Specialist***.

Supports the standard Keystroke command line switches as well as the following special switch:

FILE=filename - Where filename is the first five letters of the type of file to view (e.g. FILE=KSSTR for Store Transfers).

Imports Alternate Inventory Codes into Keystroke (also Alternate Customer and Vendor Codes). The file to be imported must be in ASCII delimited format where the first field is the new Alternate Code and the second field identifies the existing item in Keystroke.

DBCODE= The database to import into.
I=Inventory (default), C=Customer, V=Vendor

/C - What to look up by:
For Inventory: N=Stock Number, D=Description, C=Product Code, L=Class, M=Manufacturer
For Customers and Vendors: N=Customer/Vendor Number, C=Code

/F - Filename (including path) of file to be imported (default is ALTCODES.TXT located in the program directory).
The default is to look up each inventory item by Stock Number. Use /C to specify a different field to search by.

/I - ID First - switches the order of the fields. The first field identifies the exiting item in Keystroke and the second field is the new Alternate Code. (This is the order that Keystroke exports Alternate Codes in).

Imports Accounts Receivables Customer Balances into Keystroke by creating a Balance Forward invoice for the balances contained in the ASCII delimited file CUSTBAL.TXT.

The first field in this file is the Customer Code (unless changed by a switch), the second field will be total balance, any other fields will be balances for previous periods.

Note that the the balances from previous periods are optional and the amount posted to the current period will be the total minus these other fields.

The default is to look up each customer by Customer Code and the date for each period will be the last date of the prior month.

Uses ZIP.EXE to make a backup of all changed files (those with attribute A turned on) in the Current directory and all directories below it to the specified location. (Use the ATTRIB +A *.* /S to turn on the attribute on all files if first if you want to back up everything).

LICENSE INFO:

KSBACKUP uses ZIP.EXE from Info-ZIP. Info-ZIP software (Zip, UnZip and related utilities) is freely distributed under the Info-ZIP license and can be obtained as source code or executables from various anonymous-ftp sites, including ftp://ftp.info-zip.org/pub/infozip (or view www.Info-ZIP.org or the files in the Keystroke DOC\Info-Zip directory).

The program will create three files in the specified destination. YYMMDD.ZIP, YYMMDD.LST, and LASTBACK.TXT. YYMMDD will be the date of the backup (a dash followed by a character may be added if a backup already exists for the current date). The .ZIP file is the backup and the .LST file is a list of all the files that were backed up. LASTBACK.TXT will hold information about the last backup performed.

The file NOBACK.LST in the current directory can be used to enter the names of files you do not want to back up (list each file on a separate line, wild cards can be used (e.g. *.TMP).

The syntax is KSBACKUP Z:\. Note that you can only specify the destination for the backup and that the source is always the current directory and those below it. Also, the file name will be created for you.

Supports only the following special switches:
PAUSE=1 : program will pause before performing backup.
RESETATTRIB=1 : the Attribute flag on files backed up will be cleared.
CHECKLAST=1 : program will stop if last backup has not been restored. This switch should only be used when using the backup to transport files between two locations (store/home).
PASSWORD= : follow with the password required to restore the files. PASSWORD=* will cause the program to stop and ask for the password. If this is used, ZIP will encrypt the backup file and it will be unreadable without knowing the password.

Note: Because KSBACKUP.EXE uses ZIP.EXE, it is recommended to place the files ZIP.EXE and UNZIP.EXE in the C:\WINDOWS directory.

SAMPLE BATCH FILE:
The below lines will backup the C:\KEYSTROK\DATA files to C:\KSBACK folder:
REM Backup data using KSBACKUP.EXE
C:
CD\KEYSTROK\DATA
ATTRIB *.DAT +A /S
..\KSBACKUP.EXE C:\KSBACK RESETATTRIB=1
CD\KEYSTROK

SAMPLE NOBACK.LST FILE (optional and usually placed in the DATA\ directory and tells KSBACKUP.EXE to exclude these files):
*.TMP
*.ZIP
ISA*.DAT
DSA*.DAT
IPA*.DAT
DPA*.DAT

KSRESTOR will restore all files stored in a backup made with KSBACKUP.EXE to the current directory structure. It will check the file LASTBACK.TXT to find the name of the last backup file and will then ask if you want to restore it. The program will then call UNZIP to restore the files.

The program will ask for a password. If one wasn't used to create the backup then just enter anything and the program will continue.

The only switch supported is the path where the backup file is located.

LICENSE INFO:

KSRESTOR uses UNZIP.EXE from Info-ZIP. Info-ZIP software (Zip, UnZip and related utilities) is freely distributed under the Info-ZIP license and can be obtained as source code or executables from various anonymous-ftp sites, including ftp://ftp.info-zip.org/pub/infozip (or view www.Info-ZIP.org or the files in the Keystroke DOC\Info-Zip directory).

When run from a Scheduled Task, it is recommended to use the following startup switches: "/NOP /NODISPLAY". This will run the program without pausing and without loading the Graphical User Interface or Toolbars. Note that any errors will not be displayed. In addition, if this executable is part of a batch file, it is recommended to use the START /WAIT command so that this process will complete before another process starts (e.g. START /WAIT KSEXPORT.EXE /NOP /NODISPLAY ...).

Remove Duplicates deletes any duplicate Sales Invoices or ROA payments. It works the same as if each was deleted manually. The program was mainly designed to be used when the same set of sales data was accidentally merged more than once (through either the STOREMRG or RECMRG programs). Note: the transactions must be exactly duplicated (which can really only happen through a merge function). If the same transaction was simply entered twice they would not be duplicates as far as this program is concerned since the Time Stamps would never be the same.

A log file is created in the data directory (REMDUPES.LOG) that records when this program was run and what records were deleted.

Supports all the standard Keystroke command line switches as well as the following special switches:

/NOINV - No Inventory Updates - Will not update the QOH, etc. as duplicates are removed. This should be used when the duplicates were created by running STOREMRG /NOINV.

/NOCUST - No Customer Updates - if this is used then the program will not update the Customer's Amount Due and Total Purchased fields as duplicates are removed. This should be used when the duplicates were created by running STOREMRG /NOCUST.

START= - If used, the default date will come from this switch, if it is not used, then the program will use "-1M" (= 1 month ago).

/NOP - No Pause. If used, the program will not confirm the starting date but will display the confirmation screen for 5 seconds before proceeding. Pressing [Esc] while the confirmation screen is up will cancel the program.

Update Price Fields is used to update the price fields on inventory items using the specified Price Table (formulas). This is the same as the Search & Update Price function in the Database Manager, except it uses Filters instead of the Search screen to specify which items to update.

Note: To update more than one price field or to use different tables/dates with different items, set up a batch file to run this utility more than once, where each time it will update a different field and/or set of items. Also, remember that items with a blank Price Code field can not be updated via price formulas.

Supports all the standard Keystroke command line switches as well as the following special switches:

PriceTable= : Enter the single character Code that identifies the Price Table to use (default is PriceTable=$)

Update= : Enter either P/S/L/1/2/3/W/A/C for basePrice / Saleprice / Listprice / level1 / level2 / level3 / Webprice / Avgcost / lastCost (default is Update=P).

Filter= : put the filter to be used after this switch. The format is the filter number followed by the condition which is enclosed in quotes. The number is found by the position of the field in the Filter Field list on the Inventory Database Report. (e.g Filter=3">100 and <200" will update items whose stock number is between 100 and 200). More than one filter switch can be used. If more than one is used, all must match.

Update Parent Child Costs updates the Last and Average Cost of items that have a Parent/Child relationship. It updates the Last Cost field of each Child to match that of the Parent (taking into account the Order Multiplier).

It also updates the Average Cost of the items by first recalculating the Average Cost of the parent after rolling all the (QOH+QtyOnLayaway+QtyAllocatd) and Average Cost from its children up into it and then resetting the Average Cost of each Child to match.

Note that the Filters apply (and are checked on) only the main parent (an item that has children but no parent). Children of a Parent that matches the filter will be updated even if the Child itself does not match the filter.

Supports all the standard Keystroke command line switches as well as the following special switches:"

Filter= : put the filter to be used after this switch. The format is the filter number followed by the condition which is enclosed in quotes. The number is found by the position of the field in the Filter Field list on the Inventory Database Report. (e.g Filter=3">100 and <200" will update items whose main parent's stock number is between 100 and 200). More than one filter switch can be used. If more than one is used, all must match.

Keystroke Support Utilities

Copyright © 1988 - 2023 Specialized Business Solutions | 800.359.3458
Keystroke is a trademark of Specialized Business Solutions. | All other products are trademarks or registered trademarks of their companies.

Keystroke Support Utilities

Copyright © 1988 - 2023 Specialized Business Solutions | 800.359.3458 Keystroke is a trademark of Specialized Business Solutions. | All other products are trademarks or registered trademarks of their companies.

Copyright © 1988 - 2023 Specialized Business Solutions | 800.359.3458
Keystroke is a trademark of Specialized Business Solutions. | All other products are trademarks or registered trademarks of their companies.