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 »

Daily Sales by Salesperson

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Group Header 1: SP    Group Header 2: accmgr Standard Report Fields(Line Items)    Group Footer 3: sono    Group Footer 2: accmgr    Group Footer 1: SP Summary Additional Report Fields for Customization

Default Menu Location¶

Reports >> Order Entry >> Daily Sales by Salesperson

Click here for screenshot

General Description¶

Daily Sales by Salesperson screen generates a report for a specific time frame and a specific salesperson requested.

Fields/Filters¶

Beginning Date: Beginning date for the report

Ending Date: Ending date for the report

Sales Person: Salesperson for the report

Exclude Zero Dollar Lines To omit zero dollars in the report

Standard Report Fields(Page Header)¶

Company

• company
  

Date Range

• mday1
• mday2
  

Detail or Summary

• iif(ll_summ = .t., '(Detail)', '(Summary)')
  

Group Header 1: SP¶

Salesperson

• sp
  

Group Header 2: accmgr¶

Account Manager

• accmgr
  

Standard Report Fields(Line Items)¶

SO#

• sono
  

Sales Amount

• Sales Amount
  

Item/Cust no

• item
  

Description

• substr(descrip,1,20)
  

Qty Sold

• qtyord
  

Unit Price

• price*(100-disc)/100
  

Group Footer 3: sono¶

SO#

• sono
  

Sales Amount

• sales amount
  

Cust No

• CUSTNO
  

Group Footer 2: accmgr¶

Account Manager

• accmgr
  

Sales Amount

• sales_amount
  

Group Footer 1: SP¶

Salesperson

• sp
  

Sales Amount

• sales_amount
  

Item

• item
  

Summary¶

Sales Amount

• sales_amount
  

Item

• item
  

Additional Report Fields for Customization¶