Vendor Sales Reporting System File Upload Help Table of Contents



Download 22.93 Kb.
Date conversion14.12.2016
Size22.93 Kb.


Vendor Sales Reporting System - File Upload Help

Table of Contents




Table of Contents 1

File Upload Overview 2

Login Screen – Contract Sales Worksheet 3

Enter Sales Data into Excel File 6

Save file as Text (Tab-delimited) file. 7

Example of Saved Tab-delimited File 8

Selecting File Import Option 10

Uploading a file 11

Processing Uploaded Sales File 12

Successful File Upload and Processing 13

Error Uploading Report File 16


Contact Information:

For questions, call ?


File Upload Overview


Quarterly contract sales data can now be reported using a tab-delimited file upload.

The tab-delimited file can be created by:



  • Using the Excel Contract Sales Reporting Worksheet available on the Contract Sales Reporting System login page and saving as a tab-delimited file (recommended)..

  • A tab-delimited file created from vendor database or IT department.

The sales file only needs 3 columns in the following order for the upload process.

  • DES Customer #: These are the customer numbers currently on the Contract Sales Reporting Worksheet.

  • Customer Name: This is used as a reference for any processing errors.

  • Sales Amount: Sales dollars rounded to the nearest dollar.

The file upload option is available on the “Select Contract & Reporting Period” screen. If the Import sales from file option is selected, you will be able to select your file from your personal computer or network drive. After the file has been uploaded and processed, you will be able to review, edit and submit the sales report.

Login Screen – Contract Sales Worksheet


The Contract Sales Reporting Worksheet can be found on the Login Screen (Figure 1). The worksheet lists all customer/organizations to be used as a tool to gather customer/organization sales data offline before logging on and reporting sales.

  1. To create a tab-delimited file using the Excel Contract Sales Reporting Worksheet, go to to the Contract Sales Reporting System login page and choose the link to the Contract Sales Reporting Worksheet.

Figure 1. Contract Sales Reporting System Login Screen.



Sales Reporting Worksheet

  1. Choose the appropriate Reporting Year and Report Quarter, and then click View Report.

  2. To export the report to an Excel document, click the dropdown box, Select a format.

  3. Choose Excel, and then click Export (Figure 2).

Figure 2. Contract Sales Reporting Worksheet.



  1. A File Download dialog box will appear. Choose Save (Figure 3).

    1. Note: The document may take some time to load.

Figure 3. File Download dialog box.




  1. Rename, choose a location to save the document and then click Save (Figure 4).


Figure 4. Save As dialog box.


Enter Sales Data into Excel File




  1. Open the saved Excel file and enter your sales data in the appropriate column (Figure 5).

    1. To import the document, it must be in the format displayed in Figure 5.

    2. The columns with Customer Number, Customer Name and Sales are required.

    3. Sales amounts must be entered to the nearest dollar.

Figure 5. Enter sales data into saved Contract Sales Reporting Worksheet Excel file.


Save file as Text (Tab-delimited) file.




  1. After you have completed entering your sales data, save the Excel file as a Text (Tab delimited) file.

    1. Choose File

    2. Choose Save As

    3. Rename and choose a location to save the document.

    4. Change the Save as type to Text (Tab delimited) (Figure 6).

    5. Click Save (Figure 6).

Figure 6. Save As dialog box, displaying Save as type as Text (Tab delimited) file.


Example of Saved Tab-delimited File


Figure 7 displays an example of a tab-delimited file saved from the Contract Sales Reporting Worksheet.

Figure 7. Example of a tab-delimited file saved from the Contract Sales Reporting Worksheet.


Selecting File Import Option




  1. Login to the Contract Sales Reporting System (Figure 1).

  2. Click the dropdown boxes to select the appropriate Reporting Year and Reporting Quarter (Figure 8).

  3. Check Import sales from file, then click Next (Figure 8).

Figure 8. Contract Sales Reporting System after login.


Uploading a file




  1. Click Browse, then locate and select the Text (Tab delimited) file (Figure 9).

  2. Click Upload File to upload (Figure 9).

Figure 9. Uploading a file.


Processing Uploaded Sales File




  1. If the file is sucessfully uploaded, the process sales button will appear (Figure 10).

    1. If the file did not load, see instructions for Error Uploading Report File.

  2. Click Process Sales to begin processing.

    1. Note: The sales processing may take a few minutes. Please wait for message to confirm that the upload processing is complete. Please do not attempt to navigate to other screens whilt the file is being processed.

Figure 10. Processing uploaded sales file.


Successful File Upload and Processing




  1. After processing the sales file, as message will provide status and processing information (Figure 11). At this time, the sales data has been uploaded and processed. You must still review and submit the sales report.

  2. Click Review Sales (Figure 11).

Figure 11. Successful file uploading and processing message from importing sales data.



Review Sales Screen




  1. Review your sales data. Use the buttons below to review, edit and submit your sales report (Figure 12).

  2. Click Submit Sales Report, to complete your sales reporting.

Figure 12. Contract Sales Reporting System review sales.


Error Uploading Report File




  1. If a file fails to import correctly, an error message will appear. The following are possible reasons the file failed to upload and process correctly:

    1. File is not saved in a tab-delimeted file. Re-save file in proper tab-delimited format and repeat file import process.

    2. File is not in the proper format of Customer #, Customer Name and Sales. Reformat the file and repeat import process.

    3. Sales amount data not in correct format. Open file in Excel, right click on sales amount column and select Format Cells. Select Number from the category options and change decimal places to zero. Click Ok. Save file again in tab-delimited format. Repeat file import process.

Figure 13. Contract Sales Reporting System import sales file error message.



| Page



The database is protected by copyright ©dentisty.org 2016
send message

    Main page