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

• ARSLMMNT Accounts Receivable Salesman File Maintenance

  Salesman File Maintenance Application Overview You will use the Salesman File to keep a file of all of the salespersons you employ. There are many places in the Accounts Receivable package where this file is very useful. Here are a few of them. When ...

• All of a Sudden COP Open Order Report Takes Forever to Complete

  Q - I have been running COP / Reports / Order Status Reports / Open Order Report / All Items / By Customer Sequence. A couple of weeks ago, this report's run time all of a sudden jumped exponentially (like from 10 seconds before it was done to, now, ...

• Change - Sync Order Addresses in Customer Change Program

  Release Date: 3/2/2018 In the customer change program called by Sales Desk or Order Entry, if the setup field 20 below is "Y," and any of the address fields are changed, the Sync Orders program will be called to update orders with the new address. ...

• Btrieve Error 025 on COP Open Order by Salesman Report

  Q - When I run COP -> Reports -> Open Order by Salesman Report, I receive Btrieve Error 025. What causes this error? See sample screen below: A - Typically this is caused by a work file usage conflict. This means another user is in the middle of ...