header7

Reports

Open Order Report by Vendor

 

This report is very similar to the Open Order by Customer Report.   It allows you to select a starting vendor number, ending vendor number, sort option, salesman number, customer number, order range, branch code, WIP status codes, order type codes, ship date status codes, date type, earliest date, latest date, include all line items, include order attachments, include POs, include order notes, double space report, page break by vendor, orders without vendor, print acknowledged orders, and show only orders containing items with negative availability.

 

This report prints the vendor #, vendor name, salesman number, order number, enter date, ship date, customer name, first line item number, item description, quantity, branch code, WIP status code, order type code, vouched complete, and invoiced complete. 

 

This report has been modified to allow you to only print items that have a negative availability.  Open Order Report by Vendor lists the vendor name, number, salesman, order number, customer name, entered date, ship date (denoted by an asterisk if it is required), item description and WIP (work-in-process) code.  If the order has been acknowledged by the supplier, an (A) will appear next to the ship date.  This report allows you to specify a vendor range, start and end date, and the first three lines of the order note pad for each order if requested.

 

This report has been modified to allow you to have up to 15 WIP Codes, and also allow you to pick up a range of order #s.

 

Open Order Report by Vendor - O/L 4

 

 

 

DPU751

 

 

 

RECORD USED AND FILE NAME

AVAILABLE CRITERIA

INFO DISPLAYED (IN  COLUMN SEQUENCE)

SORTS BY

Open Order Header Notepad - UD01N

Start-End Vendor Number (Individual, Range, or All)

Ven # (Vendor Number)

By Date=Date Order

Open Order Detail - UD02

Sort Options (Date, Customer Number, Order Number,

Name (Vendor Name)

Entered

Open Order Detail Notepad - UD01N

Salesman Number, Group by Salesman)

Sls No. (Salesman Number)

 

Open Order Detail PTD - UD02P

Salesman Number (Individual or All)

Our Order #

By Customer Number=

Inventory Item Master File - UD71

Customer Number (Individual or All)

Dates (Includes Entered Date, Ship Date,

Customer # then

 

 

R=Ship Date Messages,

date entered

 

Order Range (Range or All)

A= Acknowledged Orders)

 

 

Branch Code (Individual or All)

 

 

 

WIP Status Codes (Up to 15 or All)

Customer Name

By Order Number=

 

Order Type codes (Up to 10 or All)

Item Number

Customer # then

 

Ship Date Status (Up to 10 messages or All)

Description

Order Number

 

Date Type (E-Entered, V-Vendor or C-Customer)

Quantity

 

 

Earliest-Latest Date

B=Branch Code

By Salesman Number=

 

Include All Line Items (Y/N)

WS=WIP Status

Salesman Number

 

Include Order Attachments (Y/N)

OT=Order Type

 

 

Include POs (Y/N)

VC=Vouched Complete (* if Yes)

By Group by Salesman=

 

Include Order Notes (Y/N)

IC=Invoiced Complete (* if Yes)

Page Break by

 

Double Space Report (Y/N)

 

Salesman Number

 

Page Break by Vendor (Y/N)

 

then by Customer

 

Orders without Vendors (Y/N)

 

Number

 

Print Acknowledged Orders (A-Acknowledged, N-Not

 

 

 

Acknowledged, B-Both)

 

 

 

Show only Orders with Negative Availability (Y/N)