|
Makes sure that the two specified files have the same Next Number stored in them. |
|
|
Makes sure all the specified files belong to the same data set by reading date/time stamp written to the file using the STAMP program. |
|
|
Copies the Next Number values from KSTRN001.MRG. |
|
|
Changes the name of a file to a name representing the current date. |
|
|
Extracts transactions into the file KSTRN001.MRG so they can be imported with the Storemrg program. |
|
|
Reads the current inventory data file and then writes QOH information to a file named 'KSIL#.DAT' were # is the store number. |
|
|
Reads the current inventory data file and then writes Qty On Order information to a file named 'KSIL#.DAT' were # is the store number. |
|
|
Simple scheduler that can run other programs automatically at a pre-set time of day. |
|
|
Stamps the specified files with the current Date/Time by writing a serialized representation of the Date/Time the utility was run to the first record of each file. Used with Chkstamp. |
|
|
Merges the existing transactions from the merge file KSTRN001.MRG (created by the EXTRACT.EXE utility) |
|
|
Runs the Update Inventory function from the Store-Link module. |
|
|
Update Qty reads the file UPDQTY.DAT and then adds each Qty back into QOH. |
|
|
Warehouse Merge will read in the transaction file KSTRN001.MRG and create Sales Orders out of any invoice with a line item comment that contains any of the strings entered in the file WHMERGE.TXT or WHMERGE2.TXT. |
CHKNUM FILE1 FILE2
If the Next Number in each file is different, then the program will return an error.
DOS Error Levels:
0 = OK - Next Number is SAME in both files .
1 = Number in First file is HIGHER than in Second File
2 = Number in First file is LOWER than in Second File
3 = Bad/Missing FileNames
4 = Bad Files (size <2048 or not a multiple of 128)
The program writes the results to the file CHKNUM.LOG.
Example (test customer files before copying them):
CHKNUM DATA\KSCST.DAT DATA\HOLD\KSCST.DAT
IF ERRORLEVEL 1 GOTO BAD
:GOOD
COPY DATA\HOLD\KSCST*.DAT DATA\KSCST*.DAT
GOTO EXIT
:BAD
ECHO Bad set of files, not copied.
:EXIT
Example (test inventory files before copying them):
CHKSTAMP DATA\KSINV*.DAT
IF ERRORLEVEL 2 GOTO BAD
:GOOD
COPY KSINV*.NEW *.DAT
GOTO EXIT
:BAD
ECHO Bad set of files, not copied.
:EXIT
Supports the standard Keystroke command line switches.
It also supports the following special switches :
/M - Merge directory, follow this switch with the location of the KSTRN001.MRG file.
Changes the name of a file to a name representing the current date.
The syntax is:
DATENAME FileName1 FileName2 where FileName1 is the file to be renamed and filename2 is the mask to name the file to. Note that the mask must be entered with an * in it where the * will be replaced with YYMMDD (e.g. DATENAME KSTRN001.MRG *.MRG will rename the file KSTRN001.MRG to 990423.MRG).
EXTRACT.EXE / WEXTRACT.EXE:
/M : Merge Directory - put the name of the directory that contains the merge file after this switch. (/M C:\DATA)
/NOLOCK : Don't update transaction lock date.
/NODISPLAY : Don't display status.
/FORCEDATE : Save End Date of Extract even if before last Extract's End Date.
Start= : Starting Date - put the date to mark as the start of the extracted period after this switch. (Start=04/10/00)
End= : Ending Date - put the date to mark as the end of the extracted period after this switch. (End=05/26/00)
StartTime= : Starting Time - put the time to mark as the start of the extracted period after this switch. (StartTime=05:30a)
EndTime= : Ending Time - put the time to mark as the end of the extracted period after this switch. (EndTime=18:15)
Extract= : List of characters that define what to extract (see Supported Categories below). Default is Extract=CV1WQO5RYyA0T9
Include= : Add additional characters to list of categories to extract. (e.g. Include=s to extract serial numbers)
Exclude= : Remove characters (Don't Extract) from list of categories to extract. (e.g. Exclude=C to not extract customers)
/NOCUST : Don't extract new/changed customers *(OLD use EXCLUDE=C instead)*
/NUMBERS : Extract serial numbers from inventory.
StartStore= : Starting Store Numberl.
EndStore= : Ending Store Number.
StartReg= : Starting Register Number.
EndReg= : Ending Register Number.
StartClerk= : Starting Clerk Number.
EndClerk= : Ending Clerk Number.
StartTrans#= : Starting Transaction Number *(not supported by all categories).
EndTrans#= : Ending Transaction Number *(not supported by all categories).
The Extract=, Include=, and Exclude= parameters accept a string of one or more characters that define what types of data to extract. These are as follows:
Supported Categories = CV1WQO5RYyA0T9s 's-Not on by default C=Customer, F=Contacts, V=SalesInvoice, 1=SalesOrder, W=Layaway, Q=Quote , Y=SalesPayment O=PurchaseInvoice, 5=PurchaseOrder, R=ReservedOrder, y=PurchPayment A=ROAPayment, 0=Variance, T=TimeClock, 9=Audit, s=SerialNumbers (Off by default), ~=Clerk Passwords (Off by default) (Note that when a password is extracted, only the Password, Password Changed, and Password Expires field are updated and not the rest of the clerk's information. Also, Storemrg will only merge in this information if the clerk's current Password Last Changed field is older than the one being merged in).
NOTE:
Supports the standard Keystroke command line switches.
Note:
STORE= 'Followed by the Store Number to use.
USAGE: KSSCHDLR Time
Examples:
To stamp the inventory files enter:
STAMP DATA\KSINV*.DAT
To stamp all Keystroke Database and Transaction files enter:
STAMP DATA\KS*.DAT
STOREMRG.EXE / WSTORMRG.EXE:
NOTE:
/M : Merge Directory - put the name of the directory that contains the merge file after this switch. (/M C:\DATA)
/NOP : No Pause - Eliminates warning prompts.
/NOINV : No Inventory - do not add new inventory.
/NONEXTNUMS : No Next Nums - do not update Next Number on transactions. (Customer Next Number is always updated. Use COPYNUM.EXE to restore it). This should be used when merging in both directions for stores that enter data in the same data set but at 2 locations.
Extract= : List of characters that define what to type of records to merge in (see Supported Categories below).
Default is Extract=CV1WQO5RYyA0T9
Include= ; Add additional characters to list of categories to merge. (e.g. Include=s to merge serial numbers).
Exclude= : Remove characters (Don't Merge) from list of categories to merge in. (e.g. Exclude=C to not merge customers).
/SALESONLY : Do not include purchase transactions. (same as EXCLUDE=OR5y).
/NOCUST : Do not add new customers. *(OLD use EXCLUDE=C instead)*.
/NOVAR : No Variances. *(OLD use EXCLUDE=0 instead)*.
/NOTIMECLOCK : No Time Clock entries. *(OLD use EXCLUDE=T instead)*.
/NOAUDIT : No Audit entries. *(OLD use EXCLUDE=9 instead)*.
/NUMBERS : Merge in Serial Numbers. (Erases all current serial numbers then adds back in those from merge file).
Start= : Only merge transactions after this date.
End= : Only merge transactions before this date.
StartTime= : Only merge transactions after Start date and this time.
EndTime= : Only merge transactions before End date and this time.
StartStore= : Starting Store Number
EndStore= : Ending Store Number
StartReg= : Starting Register Number
EndReg= : Ending Register Number
StartClerk= : Starting Clerk Number
EndClerk= : Ending Clerk Number
StartTrans#= : Starting Transaction Number *(not supported by all categories).
EndTrans#= : Ending Transaction Number *(not supported by all categories).
The Extract=, Include=, and Exclude= parameters accept a string of one or more characters that define what types of data to merge in. These are as follows:
Supported Categories = CV1WQO5RYyA0T9s 's-Not on by default C=Customer, F=Contacts, V=SalesInvoice, 1=SalesOrder, W=Layaway, Q=Quote, Y=SalesPayment, O=PurchaseInvoice, 5=PurchaseOrder, R=ReservedOrder, y=PurchPayment, A=ROAPayment, 0=Variance, T=TimeClock, 9=Audit, s=SerialNumbers (Not on by default), ~=Clerk Passwords (Off by default) (Note that when a password is extracted, only the Password, Password Changed, and Password Expires field are updated and not the rest of the clerk's information. Storemrg will only merge in this information if the clerk's current Password Last Changed field is older than the one being merged in).
Supports all the standard Keystroke command line switches.
/D : Data Directory and location of UPDQTY.DAT
/E : Extension for data files (including UPDQTY.DAT)
Note: the comments to match ARE case sensitive .
/D : Directory to save both KSTRN001.WHM and UPDQTY.DAT files
/M : Merge Directory - put the name of the directory that contains the file KSTRN001.MRG after this switch. (/M C:\DATA)
END OF LIST
Copyright © 1988 - 2010 Specialized Business Solutions | (800) 359-3458
|