Sales Order Report
Sales Order Report
Sales Order Report
If using simple, but very efficient calculations you can manage important
business data, search for important data for accounting and truly improve the
overall overview of the company functioning with the help of a modern
information system.
If you use the Sales Order Report
module, you can report following data:
- Material requirements – overviews of orders by customer;
- Overviews of orders by item;
- Overviews of orders by clerk.
1. Creating sales order reports
In the Orders menu choose Sales order reports.
1.1 Select Report types
First, select the report type. By
this selection the form of the displayed report will be set, and with a double click
on the report name or with a click on the (Report)
button
it will be
directly displayed
You can select among following report types:
Items prices in summery overviews (Summary by items) are
calculated as quotient of value and amount.
1.2 Select Items types
Select all items types, for which you want to report receiving bills.
Selected items types are the checked one.
All Items types can quickly be
selected or deselected by right-clicking in the selection list and selecting the
appropriate option from the additionally available menu:
1.3 Select Document type
It is requested to select Document types,
by which sales orders were recorded and for which you want to create
reports/calculations (recorded only document types are not on the
list!).
You select them by checking the box in front of the wanted document type.
 |
All items and document types can quickly be selected or
deselected by right-clicking in the selection list and selecting the appropriate
option from the context menu (see Basics - Multiple
selection list).
|
|
|
For general information on its functions see
Taskbar. |
1.4 Select Restriction criteria
In the Sales order reports following restriction criteria are available:
Item - a report can be
restricted by an individual item ID, the orders are
being checked for. Item ID is an information included in the
order line.
Name - a report can be
restricted by the name of an item. Item Name is an information included in the
order line.
Prim. categ. - a report
can be restricted by the primary category of an item, that is information
included in the Items register | General panel. Primary category ID
is included in the Category register.
Sec. categ. - a report
can be restricted by the secondary category of an item, that is information
included in the Items register |General panel. Secondary category
ID is included in the Category register.
Customer - a report can be restricted by
the 1st person of the order. Customer are included
in the subjects register | Customer panel.
Customer type - a report can be restricted by
the subject type of the 1st person. Subject types
are included in the Subjects register | customer
panel.
Country - a report can be restricted by
the customers country.
Information on the country, the transaction was created with is included in the
subjects register by which the transaction was created.
Consignee - a report can be restricted by
the 2nd person of the order. The 2nd person or the
consignee is included in the subjects register.
Consignee type - a report can be
restricted by the subject type of the 2nd person.
Information on the subject type is included in the subjects register
| customer panel.
Country - a report can be
restricted by the country of the consignee who will
receive goods. Information on the country the transfer took place with is
included in the subjects register.
Department
- a report can be restricted by the department from the
subjects register as being entered in the order
lines.
CIS - a report can be
restricted by the CIS ID
(Classification of Institutional Sectors) of customers. CIS ID is included
in the subjects register.
The use of wildcard characters is allowed.
Meaning, i.e. "S.1%" is for a domestic subjects, "S.2%"
is for a subject from abroad, "S.211%" is for a partner from the EU,
etc.
Cost Ctr.
- a report can be restricted by the cost center from the order lines.
Clerk
- a report can be restricted by the sales clerk from the
employee/subjects register, as
being entered in the
sales order value section.
Linked doc. 1 - a report can be restricted by
the individual first linked document (i.e. sales order).
From - a report can be restricted by the start date of the linked doc. 1.
To - a report can be restricted by the end date of the linked doc. 1.
Linked doc. 2 - a report can be restricted
by the second linked document.
From - a report can be restricted
by the start date of the linked doc. 2.
To - a report can be restricted
by the end date of the linked doc. 2.
Order date from - set in the
Order date from field the beginning date of the period for the order receiving, the report shall be made
for.
Date to - se in the Date to
field the ending date of the period for the order
receiving, the report shall be made for.
Delivery deadl. from - set in
the Delivery deadl. from field the
beginning date of the period for the
deliver deadline
of the order, the report shall be made for.
Date to - set in the Date to
field the end date of the period for the
deliver deadline of the order, the report shall be made for.
Validity
- a report can be restricted by the validity date
of an order.
Convert to currency
- select the currency, the order shall be
expressed in (meaning the currency the order shall be converted to). Included in
the report will be all orders in accordance with previously entered criteria,
however, orders will be converted to the currency selected in this field at the
conversion rate of the bank - price list, valid on
the date o the order confirmation.
For currency
- set the report filter to the currency from
orders. Included in the report will be only in the selected currency created
orders. If you do not select the filter, all orders regardless to the entered
currency will be reported and they will be converted to the
primary currency at the conversion rate of the
bank - price list, valid on the date o the order confirmation
(see Covert to currency field).
Delivery - report can be restricted by
the delivery term included in the delivery methods
register as being entered in the sales orders header.
Materials in BOMs - the
Materials in BOMs
field is a restriction criterion according to which the program is including
materials in bills of materials. This function is available only in the
Order report - Material requirements.
Values of this report type is a purchase price.If Materials in BOMs
box is checked, the materials in bills of materials will be included in the
order report, if the box is unchecked they will, however, not be included.
If the Difference between ordered and dispatched qty only
box
is checked, are that orders excluded from the report:
- where the whole ordered quantity was already dispatched to the
customer and/or
- which are selected as finished.
When Difference between ordered and dispatched
report type is selected, the Only Where Ordered and
Delivered Qty Differ
box selected by default and does not appear on
the screen.
Read stock in primary warehouse
box
is checked if the program shall for the report preparation look after the
stock of an individual item in the primary warehouse.
This information is included in the Order report - summary by items on stock!
A report can also be restricted by the validity of the order:
- All (valid orders) or
only
- Valid (orders) (that
are orders with the order validity date
greater than the current date)
- Non-valid (orders)
(that are order with the order validity
date less than the current date).
A report can also be restricted by the
status of the order.
By default are chosen statuses which affect the available stock (predefined:
confirmed).
If double-clicking the report type name or by selecting the report type and
then with a click on the Report
button, the program
will show the selected report.
|
|
Default filter criteria: all valid orders, with status that affects the
available stock (see the picture).
Document types for the report need to be selected each time when reporting or
you can save them as template. |
|
|
As being the case in all report types,
blank field will include all values while defined field will include only
documents and lines corresponding to the entered information!
By using wildcard characters you can set the filter in a more extensive
way (see Basics - Wildcard characters). |
2. Creating sales orders reports
First, enter desired report criteria (restrictions by document types, dates,
order statuses, etc.). Selected criteria will be displayed in the report header.
Report of some information can also be restricted by selecting suitable
checkboxes in the Program parameters | General.
In the first column of the report header is the sales order Number
from the
sales order header, in the next column is the Date
the sales order was created and the Customer
the name of the customer (1st person) from the
sales order header as well. Next is
the Item where the items ID from
the
sales order line is shown. It is followed by
the Items Name and the U/M
(Unit of measurement) from the
sales order line as well.
Ordered
In the Price column is the price of an item from the
sales order line minus any possible discount
apparent from the sales order lines as well.
In the Quantity column is the ordered quantity from the
sales order lines.
In the Value column is the product of the values in previous two fields (price *
quantity).
It is the value, excluding VAT.
Realized
In the Quantity column is the quantity of issued goods from deliveries, which
count as realized orders.
In the Value column is the product of values in the Price
and Quantity (realized section)
fields (price *
quantity [realized section]). It is the price, excluding VAT.
It is not the actual sale price, but (because of the difference of the
ordered and dispatched value) the value of the dispatched quantity
evaluated by the price from the order.
Remaining
In the Quantity column is the ordered quantity
minus realized quantity
In the Value
column is the ordered value minus/less relieved value. It is the value of
non-delivered goods after the deduction of the discount and before VAT,
evaluated by the price from the order.
|
|
By selecting the Difference between ordered and dispatched qty only
checkbox you define whether:
- the entire extent of orders under other selected criteria is
important, supplemented by the entire extent of issues. In the report are
included also orders that are completely realized and the issue balance
(the difference) is equal to 0.
- the part of the order that was only partially dispatched under other
selected criteria will be reported.
Order balance for the delivery does not change according to the
checkbox, what changes is the number of records the program uses.
Compare to report: Orders report -detailed-
difference only.
|
If you have defined serial numbers as well, when entering the order, the
program will report all data to be on the Order report
- detailed and also defined serial numbers of the order.
When using the Order report - delivery
the program will report all sales orders by the delivery method from the
delivery methods as entered
in the sales order header.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
Issue balance does not change by the checkbox value, the number of reports
the program is including in the report does, however.
In the header of the report are selected report criteria (restriction
to document types, dates,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
First is the order Number from the
sales order header, next column is the Date
the sales order was created and the Customer
the name of the customer (1st person) also from the
sales order header.
In the first column of the report header is the sales order Number
from the
sales order header, in the next column is the Date
the sales order was created and the Customer
the name of the customer (1st person) from the
sales order header as well. Next is
the Item where the items ID from
the
sales order line is shown. It is followed by
the Items Name and the U/M
(Unit of measurement) from the
sales order line as well.
In the Ordered section is the value of the order excluding VAT.
In the Dispatched section is the
realized or dispatched value excluding VAT.
In the Difference section is the Ordered
value minus Dispatched value.
In the Delivery section are all
sales orders according to the delivery method from the register of
delivery methods as entered
in the sales order header.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
In the header of the report are selected report criteria (restriction
to document type, date,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
Item is from the sales order lines, item Name is
from the items register.
Ordered
In the Price column is the average sales price of this item less discount
and excluding VAT (compare Order report - detailed).
The price value is a product of ordered quantity value and the ordered
quantity. In the Quantity column is the
sum of ordered quantity for this item. In the Value
column is the sum of values of the ordered quantity for this item.
Dispatched
In the Quantity
column is the sum of realized quantities for this item.
n the Value
column is the sum of values of the realized quantity for this item,
evaluated by the price from the sales order. It is not the actual purchase price
of the items, but (because of the comparability of ordered and dispatched quantity)
the value of issued quantity, evaluated by the price from the sales order.
Difference
In the Quantity column is the
value of ordered quantity minus realized quantity.
In the Value column is the value
of ordered value minus realized value.
It is the value of non-dispatched
items less in the order approved discount and before VAT, evaluated by the
price from the sales order.
Order balance for the delivery does not change according to the
Difference between ordered and dispatched qty only 
checkbox, what changes is the number of records the program is including
while reporting.
Compare to report:
Summary by items - difference only.
|
|
Item prices in summary reports are calculated as a product
of the summed up values and summed up quantities.
|
|
|
In reports of this type is the
Difference between ordered and dispatched qty only  box
automatically checked - selected,
and because of that it does not display on the screen. In this report
type are important only orders that are with regard to other selected
criteria only partially dispatched or relieved. |
In the header of the report are selected report criteria (restriction
to document type, date,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
Item is from the sales order lines, item Name is
from the items register.
In the Quantity column, if:
- items from the sales order lines: entire non-dispatched quantity (ordered
minus realized)
- items from the sales order BOMs: required
quantity of materials according to not yet dispatched quantity.
In the Price column is the items
price expressed as gross purchase price
from the purchase calculations of the items register.
In the Value column is the
product of the quantity and price (quantity * price). This is the purchase price
of the item or material according to the purchase
calculation of the items register.
If the Materials
in BOMs
box is checked,
the program will also report materials included in the
order BOMs of items of the own manufacturing.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
Issue balance does not change by the checkbox value, however, the number of reports
the program is including in the report does and through this the balance of
made transfers as well (value of orders and the value of already dispatched
orders).
In the header of the report are selected report criteria (restriction
to document types, dates,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes). In the Customer
column
the name of the customer (1st person) that is also from the
sales order header.
In the Ordered column is the
entire value of in the report included orders (value of ordered quantity). It is
the value after the deduction of discounts and excluding VAT.
In the Dispatched column are
summed up values of realized orders, evaluated by the price from the order.
It is not the actual sale price of the items, but (because of the
comparability of ordered and dispatched quantity) the value of dispatched items,
evaluated by the price from order.
In the Difference column is the
value of the difference between the ordered less realized value. It is the value
of non-dispatched items after the deduction of discounts and excluding VAT,
evaluated by the price from order.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
Issue balance does not change by the checkbox value,
however, the number of reports
the program is including when dispatching does.
Compare to report:
Summary by subjects and items - difference
only.
In the header of the report are selected report criteria (restriction
to document types, dates,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
In the Subject section
information is sorted and summarized in the end by the name of the customer (or 1st
person) from the sales order header.
In the Item column is the ID of
the item from the sales order lines. In the Name
column is the item's name from the items register.
Ordered
In the Price column is the average sales price of this item less discount
and excluding VAT (compare Order report - detailed).
The price value is a product of ordered quantity value and the ordered
quantity. In the Quantity column is the
sum of ordered quantity for this item. In the Value
column is the sum of values of the ordered quantity for this item.
Dispatched
In the Price column is the average sales price of this item less discount
and excluding VAT (compare Order report - detailed).
The price value is a product of ordered quantity value and the ordered quantity.
(cena je samo en stolpec za vse
razdelke, ZATO BI BILO MOGOČE BOLŠE OMENITI PRI IDENTU IN NAZIVU) In the Quantity
column is the sum of realized (sold) quantities for this item.
n the Value
column is the sum of values of the realized quantity for this item,
evaluated by the price from the sales order. It is not the actual purchase price
of the items, but (because of the comparability of ordered and dispatched quantity)
the value of issued quantity, evaluated by the price from the sales order. It is
not the actual sales value of the items, but (because of the comparability of
ordered and dispatched quantity) the value of dispatched items, evaluated by the
price from order.
Difference
In the Quantity column is the
value of ordered quantity less realized quantity.
In the Value column is the value
of ordered value less realized value. It is the value of non-dispatched
items less in the order approved discount and before VAT, evaluated by the
price from the sales order.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
Issue balance does not change by the checkbox value,
however, the number of reports
the program is including when dispatching does.
In the header of the report are selected report criteria (restriction
to document types, dates,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
Order
In the Order section is the Number
of the order, it is followed by the number of the order Line,
Date of the order, Customer, Item
or item ID from the order lines, Name
of the item, and the Quantity from
the order line.
Work orders
in the Work orders section
is the Number of the work order
that is linked to the order, Prod. deadl.
(Production deadline) and Planned qty
(planned quantity) from the work order as well, and Issued qty
also from the work order.
Packing slip
In the Packing slip section is
the Number of the packing slip or
the account for the realization of the order, number of the Line,
the Date and the issued Quantity,
all from the packing slip or the account for the realization.
If not selecting the
Difference between ordered and dispatched qty only
box,
you set that:
- all orders according to other selected criteria are important
including all issuing orders. In the report are included completely
realized orders and the issue balance (difference) is equal to 0.
If selecting the
Difference between ordered and dispatched qty only 
box,
you set that:
- only the part of the order under other selected criteria only
partially dispatched is important.
Issue balance does not change by the checkbox value,
however, the number of reports
the program is including when dispatching does.
In the header of the report are selected report criteria (restriction
to document types, dates,
order status etc.). The report can be restricted also by some information
you can define in Program parameters | General
(some checkboxes).
In the Clerk section reports are
sorted and than summarized according to the clerk,
who is signed on the order.
In the Pricing level section is
the second criteria for sorting and than summarizing the pricing level
from the sales order.
In the Customer section is the
name of the customer (1st person) from the sales order
header.
Ordered
In the Ordered section is the
total value of the orders (value of ordered quantity). It is a value after
possible discounts are deducted and excluding VAT.
Dispatched
In the Dispatched section is the
summed up value of realized orders, evaluated by the price from the order.
It is not the actual sale price of the items, but (because of the
comparability of ordered and dispatched quantity) the value of dispatched
items, evaluated by the price from order.
Difference
In the Difference section is the
value of ordered quantity less realized quantity (order qty - dispatched qty) . It is the value of non-dispatched
items less in the order approved discount and before VAT, evaluated by the
price from the sales order.
In this group of report are simplified reports the reports described above.
The include less information and are therefore more transparent.
|
|
In reports of this type is the
Difference between ordered and dispatched qty only 
box
automatically checked - selected,
and because of that it does not display on the screen. In this report
type are important only orders that are with regard to other selected
criteria only partially dispatched or relieved.
|
|
|
Default filter criteria: all valid orders, with status that affects the
available stock (see the
picture).
Document types for the report need to be selected each time when reporting or
you can
save them as template. |
|
|
As being the case in all report types,
blank field will include all values while defined field will include only
documents and lines corresponding to the entered information!
By using wildcard characters you can set the filter in a more extensive
way (see Basics - Wildcard characters). |
Related topics: