ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Utility
DrillDown Icon Sales Management
DrillDown Icon Sales Order Mgmt
DrillDown Icon Sales Order Management
DrillDown Icon Customer Sales Order Status
DrillDown Icon Open Sales Order List
DrillDown Icon Customer Follow-up
DrillDown Icon Customer Rolodex
DrillDown Icon Upload New Sales Orders
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .......
DrillDown Icon Add - Upload a New SO
DrillDown Icon RMA Management
DrillDown Icon Sales Price List Information
DrillDown Icon Order Configurator (OPTIONAL Module)
DrillDown Icon Customer Quotations (OPTIONAL Module)
DrillDown Icon Customer Information (CI)
DrillDown Icon Sales Representitive Information (SR)
DrillDown Icon Inventory Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon eManEx
DrillDown Icon ManEx Minutes for All Modules
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Add - Upload a New SO
Enter Sales Mgt/Sales Order Management/Upload New Sales Orders

NOTE: If user wants the system to auto approve and/or auto acknowledge when uploading Sales Order from the XL file, the auto approve and auto acknowledgement boxes must be checked in the Sales Order Setup module.

 

Locate XL File to Upload

This message will appear.  This message is for user to verify the number of recorrds being loaded from the import sheet.  User may depress "YES" to continue the upload or "NO" to abort the upload.

 
 

If system does not find any problems with the template the user will be prompted the following message that the SO Upload was complete



If the system finds any problems with template the user will be prompted the following message and exception XL file will be created in the SO Exception XL directory on the server.

Depress OK and user will receive the message (shown below) that the "SO Upload was not complete" and system will abort.

If any of the information is missing from the required fields in the first row of the XL file, user will receive the following message. 
 

Depress OK and user will receive the message (shown below) that the "SO Upload was not complete" and system will abort.

Note:  Even though user has the SO's set to auto, you can NOT upload a SO without something in this column and all other required fields..  Something has to be entered in this column along with all other required fields so the system can distinguish one so line item from another SO line item on a different SO.  If there is no data in this column or the other required fields the program will think the rest of the spreadsheet is also blank. SO Upload will group per change in Sonum field (it will then use the Sonum field as a reference to change).   If manual SO numbering is setup:  SO Upload will group per change in Sonum field (it will then use the Sonum field as a reference to change) when uploaded system will use SO numbers entered  in XL spreadsheet.   
The user will be prompted the following message that the SO Upload was not complete and system will abort.  

 

 

 

Article ID: 2953