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