PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Collapse]Orders
     Mass printing
    [Expand]Mass Print Orders
     ER Diagram for Order Documents
    [Expand]Purchase orders
    [Expand]Sales Orders
    [Expand]Order Planning
    [Expand]Create purchase orders
    [Expand]Picking List
    [Collapse]Sales Order Report
      Orders Report - by Carrier
      Orders Report - Detalied by dispatch Date
      Order report Detailed by delivery priority
      Orders Report - Material Requirements - with Stock
      Orders report – by Persons Responsible
      Orders report – Summary by Subjects and Items – by Date
      Order Report -Delivery
      Orders report – Summary by Consignees
      Orders Report detailed (Serial Number)
      Examples of Sales Order Reports
      Save Sales Order Report Template
      Deactivating Unused Criteria
      Orders Report - Detailed
      SQLEXP - Customer Address in the Sales Order Report
      Orders Report - Detailed by Delivery Date
      Orders Report - Detailed by Serial Numbers
      Orders Report - Chronologically
      Orders Report - Summary by Items
      Orders Report - Material Requirements
      Orders Report - Summary by Subjects
      Orders Report - Summary by Subjects and items
      Orders Report - Linked Documents
      Orders Report - by Clerks
     [Expand]Difference between Ordered and Dispatched
     Purchase Order Report
     Izpis UPN
    [Expand]Special Payment Orders
    [Expand]Browse Orders
     Creating Orders in a Foreign Currency
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 374.9872 ms
"
  552 | 710 | 336069 | Updated
Label

Examples of Sales Order Reports

Examples of Sales Order Reports

         

 

000001.gif You can save all below listed examples of report types as templates and then just reuse them (for more information about saving order templates see Save current as template, for general information about designing and saving templates see Templates menu).

Example1: Overview of the Total Number of Ordered Items for a Customer in a Certain Period

You would like to see what your customers ordered in a particular time period (i.e. from 11.5.07 to 16.5.07).

Report processing:

  • Report Type: Select the Summary by items report. This report will separate different items, but will sum up quantities of the same item.
  • Report criteria: First, select all document types in the Document Type section. In the Order Date From field, enter 11.5.07. In the (Order) Date To field, enter 16.5.07. In the Valid section select the All option, because you are interested in all orders. Select all statuses in the Status section, because status is not important in this type of report.

The report will display all items that customers ordered in the particular period. The program will also calculate the quantity and value of dispatched items for each item.

Example 2: Overview of Non-Dispatched Orders

This example is related to the Example 1. You would like to see what your customer ordered in a particular time period (i.e. from 11.5.07 to 16.5.07), but did not buy.

In purchase order repots you can use this report type to check orders you have created and confirmed. However, goods were not yet delivered.

Report processing:

  • Report Type:  Select the Summary by items report. This report will separate different items, but will sum up quantities of the same item.
  • Report criteria: It starts the same as in Example 1. First, select all document types in the Document Type section. In the Order Date From field, enter 11.5.07. In the (Order) Date To field, enter 16.5.07. In the Valid section select the All option, because you are interested in all orders. Select all statuses in the Status section, because status is not important in this type of report. Select the Only Where Ordered and Delivered Qty Differ option, and the order will not include any items (or quantities) that have already been delivered.

You will see that this report type will print only items that are only partially or non-dispatched.

This report type can also be used for: Additional report criteria for an example: Field/Value
to check all non-dispatched sales orders non
to check ordered and confirmed orders, but non-dispatched items for a customer Status/Confirmed
to check ordered and confirmed orders, but non-dispatched items for all customers Status/Confirmed, Customer/blank
to plan the sale of items for the next time period Valid/Validity, Customer/blank
to check the proportion of orders by individual items Valid/All, Customer/blank
to check the proportion of orders by groups of items Valid/All, Customer/blank, Category/select

The report will display all items that customers ordered in the particular period. The program will also calculate the the number of dispatched items.

000001.gif This report type cannot be use to check material requirements, because it does not include ordered items that can be used in BOMs!

Example 3: Overview of Material Requirements

The Material Requirements report type will print all items that you need for the dispatch of confirmed orders in a certain period (i.e. 1.1.07” do “31.12.07).

Report processing:

  • Report Type: Select the Order report - material requirements report type. Unlike in other report types, the prices for the quantity of used goods are defined with the purchase price from the Items register.
  • Report criteria: First, select all document types in the Document Type section. In the Deliver-By From field, enter 1.1.07. In the (Deliver-By) Date To field, enter 31.12.07. Select the Confirmed status in the Status section, because you are interested which material do you need for confirmed order. Select the Materials in BOMs option, this way in the report will be included also materials you require for compound items. This report type has by default selected the Only Where Ordered and Delivered Qty Differ option, and it does not appear on the screen.

Example 4: Overview of Market Segments

You can analyze, how many orders have come from resellers, institutions and end-users in a certain period.

Report processing:

  • Report Type: Select the Order report - summary by subjects report. You are probably interested in your biggest customers in a certain market segment.
  • Report criteria: First, select all document types in the Document Type section. In the Order Date From field, enter 1.1.07. In the (Order) Date To field, enter 31.03.07. In the Valid section select the All option, because you are interested in all orders. Select all statuses in the Status section, because status is not important in this type of report. Do not select the Only Where Ordered and Delivered Qty Differ option. In the Customer Type field select the ID of the customer type you are observing.

If you report ordered and dispatched quantities, and then repeat the procedure by different customer types, you will receive in few minutes a market overview of you orders, percentages of realizations by individual segments and even percentages of realizations by subjects.

This report type can also be used for: Additional report criteria for an example: Field/Value
to check market allocations the same as in the example 4
to check subjects with maximum number of order and the best realization quota Customer Type/blank
to check customers through financing Customer/select, Consignee Type/select group
to check subjects with the highest difference between ordered and dispatched Customer Type/blank, Only Where Ordered and Delivered Qty Differ/checked

Example 5: Overview of Clerk Performance

You can analyze, which clerk has received or created the maximum number of orders and has the highest realization quota in a certain period (i.e. first quarter of 2007).

Report processing:

  • Report Type: Select the Order report - by clerks report type.
  • Report criteria: First, select all document types in the Document Type section. In the Order Date From field, enter 1.1.07. In the (Order) Date To field, enter 31.03.07.


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!