Page History: Sales Margin Report
Compare Page Revisions
Page Revision: Fri, 22 May 2015 15:34
Default Menu Location
Reports >> Sales Force >> Sales Margin Report
Click here for screenshotGeneral Description
Sales Margin Report screen allows users to generate detail sales report either by period or by date range. When generating a report, users can either generate a report for a specific customer by entering a customer code or leaving a blank in the "Customer Number" field to generate a general report for all the customers.
Fields/Filters
By Period or
By Date Range: Options to choose a report type
Month: Month for the report (Require only if the "By Period" is selected)
Year: Year for the report (Require only if the "By Period" is selected)
Beginning Date: Beginning date for the report (Require only if the "By Date Range" is selected)
Ending Date: Ending date for the report (Require only if the "By Date Range" is selected)
Customer Number: Customer code
Item Number: Item code
Sort By: Options for report generation
Standard Report Fields(Headers)¶
CompanyDate RangeCustomer- 'Customer : ' + alltrim(gc_cust)
Item Number- 'Item: ' + alltrim(gc_item)
Warehouse- 'Whse: ' + alltrim(gc_plant)
Standard Report Fields(Line Items Detail)¶
Order NumberCustomer NameCustomer No.Invoice No.Invoice DateSales PriceStandard CostProfitGroup Footer
Total for customer- 'Total For customer - '+alltrim(CUSTOMER)
Sales PriceStandard SalesProfitSummary
