Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Sales Margin Report

Compare Page Revisions



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


Page Revision: Fri, 22 May 2015 15:34



Default Menu Location

Reports >> Sales Force >> Sales Margin Report

Click here for screenshot

General 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)

Company

  • company

Date Range

  • gd_passdate

Customer

  • 'Customer : ' + alltrim(gc_cust)

Item Number

  • 'Item: ' + alltrim(gc_item)

Warehouse

  • 'Whse: ' + alltrim(gc_plant)

Standard Report Fields(Line Items Detail)

Order Number

  • sono

Customer Name

  • CUSTOMER

Customer No.

  • custno

Invoice No.

  • invno

Invoice Date

  • invdate

Sales Price

  • extstot

Standard Cost

  • gc_costlabel

Profit

  • profit

Group Footer

Total for customer

  • 'Total For customer - '+alltrim(CUSTOMER)

Sales Price

  • cextstot

Standard Sales

  • cstcost

Profit

  • profit

Summary

  • textstot
  • tstdcost
  • tprofit


Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions