Navigation¶

• Adjutant Wiki Home
  

• CRM Wiki
  

• AFI Wiki
  

• Categories
• All Pages
• Create a new Page
  

• Administration
• File Management
  

• Login/Logout
• Consultant Guide
• Your Profile
• Create Account
  

Quick Search
»


Advanced Search »

Sales Order Report

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

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