Difference between revisions of "Customer Sales Analysis Report"
From Adjutant Wiki
(Created page with "__NOTOC__ ==Default Menu Location== Reports >> Sales Force >> Customer Sales Analysis Report [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Sales Force\Customer Sales An...") |
|||
| Line 4: | Line 4: | ||
Reports >> Sales Force >> Customer Sales Analysis Report | Reports >> Sales Force >> Customer Sales Analysis Report | ||
| − | [ | + | [[File:Screenshot_2024-10-29_140441.png]] |
==General Description== | ==General Description== | ||
Latest revision as of 13:05, 29 October 2024
Default Menu Location
Reports >> Sales Force >> Customer Sales Analysis Report
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
Ext Price
- price*qty2bill
Margin
- (price-cost)*qt
Summary
- price*qty2bill
- (price-cost)*qt