Welcome Guest, you are in: <root>AFIweb • Login

Page History: Sales Order Report

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, 22 May 2015 15:35

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

Click here for screenshot

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¶