Program Description
This program can be found on the System Manager Miscellaneous menu (LMSY-1-7-22). This is a new program in Rev 14 that will allow you to upload Contract (Special) pricing from an ASCII tab delimited Text file into The La Crosse System. The file must only have 2 fields in it. These are item number and price. The price needs to have the decimal point in it and 4 decimal positions. The file will need to be saved as a tab delimited ASCII file called BUY.TXT.
If the operating system is SuperDOS, the file must be transferred to SuperDOS as in ASCII format (not Binary format) and placed in 5:15.
If the operating system is NT, the file must be copied into the data directory.
If the operating system is Unix, the file must be sent FTP into the data directory in ASCII format (not Binary format). Please contact LMS Support if you have any questions on how to do this.
The file should look similar to this in Microsoft Excel:
Prompts:
Enter The Buying Group Or End
Enter the buying group that should be used when creating the special pricing records.
Enter The Start Date
Enter the starting date that the special pricing will be in effect.
Enter The Expiration Date
Enter the expirating date for the special pricing.
Do You Wish To Remove Dashes - From Item Numbers ? (Y/N)
If you are receiving the file from a vendor, there may be dashes in the Item Number field. If you have those items in your system without dashes, you will need to answer this question Y to remove dashes. If you have dashes in your item numbers, answer this question N for no.
Do You Wish To Remove Slashes / From Item Numbers ? (Y/N)
If you are receiving the file from a vendor, there may be slashes in the Item Number field. If you have those items in your system without slashes, you will need to answer this question Y to remove the slashes. If you have slashes in your item numbers, answer this question N for no.
Continue (Y/N)
Answer Y to continue loading data. Enter N to cancel and return to the menu.
The program will go through the Contract (Special) pricing file and delete any records that already exist for the buying group entered. It will then load the new information from the file. A report will print out showing invalid items that are in the file that are not in your item file (ITEM) or item association file (ITEMASS.IX).