What is it?
Analyze and understand customer sales patterns. Generate graphs and charts that easily identify customer product mix. Then use this information to provide your customers with value-added data to help them manage and improve their business. Raceway versions, release dates & details
Download/Install Raceway (please first read Installation Prep, below)
Pre-requisites for installing Raceway: Laptop/Desktop running Windows 98 or higher. For efficiency, account packages should supply Raceway with data. Data entered by hand doubles the work if an accounting package already exists. All modern day accounting packages have export features.
Raceway needs five pieces of information (i.e. fields/columns):
1) Profile ID - unique text field - maximum 15 characters
2) Profile Name - text field - maximum 50 characters
3) Product Code - unique text field - maximum 30 characters
4) Date of Sale - dd/mm/yyyy format
5) Number of Units Sold - text - number
The export can be in one of the following formats:
Text file (*.txt)
CSV file (comma separated variable, *.csv)
Excel spreadshhet (can be converted to a CSV file)
Probably the most common accounting package among Raceway users. Potential Raceway users who are using QuickBooks can modify the Sales Report - Sales by Customer - Details Report using the following fields: Name, Account#, Data, Item, Qty.
The second most common accounting package amongst Raceway users. We have plenty of Raceway users who currently export from Peachtree. The steps below create an export file from PeachTree for import into Raceway6.5 and Raceway7.0:
Click File from the top Menu Bar
Click/Highlight Import/Export - an Import/Export panel will appear
Click/Highlight Accounts Receivable Icon
Click/Highlight Sales Journal Icon (may have a customized name other than Sales Journal)
Click Export Button a panel will appear containing three TABS Filter, Layout and Options
Click the Layout tab
Click the Deselect All Button
Click/Check the following fields in the Show column:
Customer ID/Profile ID
Customer Name/Profile Name
Item ID/Product Code
Date/Date of Sale
Quantity/Number of Units Sold
Click the Options tab
Click the Import/Export File button. This will bring up the familiar file browser.
Browse to C:\data\Raceway\Export (the Export folder may need to be created, which can be done in the browser)
Take the default name SALES.CSV
Check the checkbox Overwrite Without Asking or whatever checkbox is appropriate
Subsequent exports should rename the file to something relevant i.e. SALESJan07toMay08.csv
Click the OK button to run the export. Once completed the file is now ready for importing into Raceway. The Save button saves the export settings to a template for later use.
We currently have two Raceway users using CounterPoint account software.
UPDATE - One user deemed CounterPoint economically unfeasible (i.e. paying consultants) and has since converted to QuickBooks.
Homegrown Accounting Packages
We have several Raceway users who export data from their custom written accounting packages on machines as big as an IBM AS400. Any software that can export a text file or csv file.
Questions or Installation Assistance
Trinh Huynh, IT Manager
Barry Rosenberg, Network Engineer