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 - 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 ...

• Feature - New Summary Area for Open Orders by Customer / Fill Back Orders by Customer Report

  Release date: 5/26/2017 You may now optionally print new totals in the grand total area of the Open Orders by Customer / Fill Back Orders by Customer report. Three Global Setup flags have been added to Global Setup -> Cop-Func -> Print ...

• How to Find All Open Sales Orders

  Release Date: 04/24/2025 Version: 8.x & Up Q - I am inquiring if there is a way in Elliot to find out all the open Sales Orders. We are trying to see if there are any orders that have not been closed yet and also have visible of all of the items that ...