Customer Sales Analysis Report

Modified on Fri, 29 May 2009 15:52 by kyimin — Categorized as: Sales Force

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%

Group Footer 1: custno¶

Ext Price

price*qty2bill

Margin

(price-cost)*qt

Summary¶

price*qty2bill

(price-cost)*qt

Additional Report Fields for Customization¶