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 - Current Revision


Page Revision: Thu, 29 Nov 2018 13:45



Default Menu Location

Reports >> Sales Force >> Sales Margin Report

Image

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

FAQ

Q: Why is an AR invoice not displaying on this report?

A: This report only includes AR invoices where the underlying sales order is closed.


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