Change – Add Salesman No. to Open Order Report by Customer, Change CSV Order of Fields

Release date: 6/24/16

For COP --> Reports, --> Order Status Reports, --> Print, --> Open Order report/All Items if field "1. By Item, Cat, Customer or Ship-to?" is C and field "18. Show QTYAVAILBYCOMP Attrib Info ?" is N, the Open Orders by Customer report will print.

A new "Salesman No." column is added.

In addition to the report change, the following changes have been made to the CSV file.

1. Switched the WO# and the Loc fields.

2. Moved the Cus field (work order customized) to the last column following the engineering change lvl.

3. Added the new salesman (1) field where the Cus field is currently. Named it "Slm."

The following is the new order for the CSV file:

Cust#    
Name  
Order#    
Loc    
Slm    
PO#    
EntDate    
Request    
Promise    
Order    
BO    
Item#    
Item Desc 1    
Item Desc 2    
P/M    
Cat    
WO#    
UM    
OH    
Alloc    
BO    
OnOrd    
Avail    
Excess    
ATP(35)      
Weight    
Cost    
Price    
Disc%    
ExtCost    
ExtPrc    
Margin    
Margin%    
Vend#    
ENG CHG LVL   
Cus

Modified Programs: CP06P2

DLM

• Related Articles

• CPOPNSSN Customer Order Processing Open Orders by Salesman Report

  Open Orders by Salesman Report Application Overview This report featuring only open orders can be used as a sales analysis auditing tool, measure productivity, and as a customer service tool. You can print the report for a single salesman or a range ...

• Feature - Mass Change Salesman Utility

  Release date: 1/17/2017 A new Mass Change Salesman utility has been added to Global Setup, Utilities, and A/R Utilities. This utility can assist in situations where a salesperson has left the company and their customers are reassigned to a new ...

• Feature - Open Order By Salesman Report CSV and Item Type Support

  Release Date: 12/2/25 Version: 8.5 and Above This feature adds CSV support to the Customer Order Processing-> Report-> Open Order By Salesman Report. A new option to limit the report output to show either purchased, manufactured, or all items has ...

• Feature - Order Salesman Change Event

  Release Date: 7/18/18 A new event has been added that will notify the user if a salesman number on an order is changed from the default salesman in Add Mode or if the salesman number is changed in Change Mode. This event is available from Customer ...

• Salesman Security

  Released Date: 08/30/2017 Sometimes your organization may use outside sales representatives. These reps, often, are not your real employees. In many cases, they represent multiple vendors' products. If you choose to let them access your Elliott ...