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

Page History: Customer Sales Analysis Report

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, 29 May 2009 15:51

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¶