Sales Order Report

Default Menu Location

Reports >> Order Entry >> Sales Order Report

General Description

Sales Order Report screen generates information on an open sales order.

Fields/Filters

Date Range: Time frame for the report

Customer: Customer code

Item: Item code

SO Type: Sales Order Type

Sales Person: Sales Person for the report

Account Manager: Account manager for the report

Warehouse: Warehouse location

Sort By: Report preference

Report Style: Report preference

Status: Report status

BOL status: Bill of Lading status

Standard Report Fields(Page Header)

Company

lc_company

Date Range

' As of ' + dtoc(date())
'( ' + lc_para + ' )'

Group Header

Customer

alltrim(company) + ' ( ' + alltrim(custno) + ' )'

Standard Report Fields(Line Items)

Order Date

iif(isnull(sodate),"",sodate)

Order Number

sono

S/P

sp

Load Date

iif(isnull(estdateh),"",estdateh)

Order Value

qtyord * price

Ship Value

qtyshp * price

Open Value

(qtyord-qtyshp) * price

Group Footer

Total

qtyord * price
qtyshp * price
(qtyord-qtyshp) * price

Summary

Report Total

qtyord * price
qtyshp * price
(qtyord-qtyshp) * price

Additional Report Fields for Customization