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 »

Customer Sales Analysis Report

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

Default Menu Location¶

Reports >> Sales Force >> Customer Sales Analysis Report

Click here for screenshot

General Description¶

Customer Sales Analysis Report screen generates an analyzed report for customers by different salesperson.

Fields/Filters¶

Customer ID: Customer code

Start Date: Beginning date for the report

End Date: Ending date for the report

Sales Person: Sales person for the report

Item: Item code

Standard Report Fields(Page Header)¶

Company

• lc_company
  

Report

• lc_report
  

Date Range

• lc_date
• lc_spf
  

Group Header 1: custno¶

Sales for Customer

• alltrim(custno) + " / " + alltrim(company)
  

Standard Report Fields(Line Items)¶

Invoice Date

• iif(isnull(invdate),'',invdate)
  

Invoice #

• invno
  

Item Number

• item
  

Slsprs

• alltrim(sp)
  

U/M

• unit_pur
  

Qty Ship

• qty2bill
  

Ext Price

• price*qty2bbill
  

Margin

• price-cost
  

GM%

• gm
  

Group Footer 1: custno¶

Ext Price

• price*qty2bill
  

Margin

• (price-cost)*qt
  

Summary¶

• price*qty2bill
  

• (price-cost)*qt
  

Additional Report Fields for Customization¶