Skip to content

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


Feedback and Knowledge Base