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

Page History: Comparative Sales Report

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Fri, 29 May 2009 16:41

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header) Standard Report Fields(Line Items) Summary

Default Menu Location¶

Reports >> Sales Force >> Comparative Sales Report

General Description¶

Comparative Sales report screen allows users to generate a comparison report for selected month and year to the year before. A report could be a comparison sales report for the company and among its customers or it could be a comparison of the sales teams within the company.

Fields/Filters¶

Month: Selected month for the report

Year: Selected month for the year

Order Type: Selected Sales Order type

Priority: Priority code

Customer: Customer code

Order By: Comparison could be between the customer or the sales team

Sales Person: Salesperson for the report

Account Manager: Account Manager for the report

Standard Report Fields(Page Header)¶

Selected Month and Year

• cmonth(ctod(gd_passdate)) + "/" +alltrim(str(year(ctod(gd_passdate))))
  

Order Type

• gc_ordertype
  

Order Status

• gc_orderstat
  

Customer

• gc_customer
  

Standard Report Fields(Line Items)¶

Cust No

• custno
  

Customer Name

• Customer
  

Sales

• month1
  

Sales

• month2
  

Sales

• month3
  

Sales

• month4
  

Sales

• month5
  

Sales

• month6
  

Prior Year Sales

• prioryr
  

Calendar Year's Sales

• ytd
  

Calendar Year's Month Avg

• mavg
  

Summary¶

• month1* month2* month3* month4* month5* month6* prioryr* ytd