Sales Order Report

Modified on Tue, 07 Jun 2016 12:21 by tpaeglis — Categorized as: Order Entry, Reporting and Report Sets

Table of Contents [Hide/Show]

Default Menu Location
General Description
Fields/Filters
Standard Report Fields(Page Header)
Group Header
Standard Report Fields(Line Items)
Group Footer
Summary
Additional Report Fields for Customization

Default Menu Location¶

Reports >> Order Entry >> Sales Order Report

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

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¶