|
|
|
|
Material Movements
Material Movements
Material Movements
The
calculation of material movements is a low-level report of all movements with items in the Goods
module.
| An important feature of this
calculation is that all goods movements are valuated using the valuation
price. |
Once this option is selected, a form will appear where you can select the
criteria for the report:
| Report type |
Select the report type that can be displayed by double clicking the name of
the report type or by clicking the report icon. You may choose among
- Detailed - displays every material
movement, equipped with the number and date of the document, amount,
price for valuation and transaction value. This is why it is suitable
for shorter control surveys, for a smaller array of items. This is also
the only report of the material movements calculation, where all the
amounts are displayed always with a positive number - inputs as well as
outputs. This is why the calculation of amount of this calculation is
NOT equivalent to the actual stock!! The report is also similar.
- By subjects -
displays the
amount and value upon the valuation price, summed upon customers and
suppliers from documents of inputs and outputs of goods, where the
subjects are sorted by the alphabetical order.
- By departments
- the data is summed upon the departments form document lines,
included in the calculation.
- By cost drivers
- the data is summed upon the cost drivers from the document
lines, included in the calculation.
- Summary - By primary suppliers -
displays
the reconcilliated balance of the material movements with an individual
item, grouped by primary supplier from the
items register.
- Summary - By category - the data is
summed upon the code of the primary classification of the item from the
document lines, included in the calculation.
- Summary - By ID - the data in this
calculation is summed upon the ID of the item from the document
lines, included in the calculation.
- Summary - By code with start and end state
- very useful for overview of stock situation for a certain time
period, because it shows the table display the starting state on the day
of the beginning of the time period, sum of all receiving of goods in
the time period, sum of all outputs of goods in the time period and the
stock state at the end of the time period. MANDATORY use the starting
and final date of the packing slip for the period limiting criteria. A
similar result is returned by the reports:
- Summary - By warehouses -
displays the amount and the value upon the valuation price, summed upon
the receiving warehouse (from the receiving documents) or the issuing
warehouse (from the documents of goods issues).
- Summary - By subjects - the
reconciliated balance of the material movements with an individual
partner and item, grouped by supplier from the document of receiving or
customer from the document of issue.
- Summary - By item types -
the data is summed by item types of items
from the document lines, entered in the calculation.
- Summary - By item types -
the
data is summed upon the item type of the items from the document
lines included in the calculation. The material movements are so
summed on nine possible item types (P, B ,A, C, K, M, E, S, U).
- Wizards - in this part of the menu, the user reports are
included, which are created with the help of the
SQL-I
and select the display in the material
movements calculation for it
|
| Document types |
Mandatory select
types of documents, for which you wish to create the calculation. The
program will offer all document types of the Goods module
(record types of documents are not on the list!).
Select them by checking them.
|
Item types
|
Check all types of items for which you wish to display the material
movements report. By default the
items of type S and U are excluded.
| |
Item
|
The ID of the item, for which you are surveying the material movements.
If this field is left empty, the program will include all items. The
partial code can be entered in the field, which has to be equipped with the
% sign. | |
Name |
the report can further be limited upon
the name of the item, as entered in the document line and is not necessary
same as the name form the item register
(see also lines of issue)!
|
External ID
| the report can be limited upon
the supplier's ID of the item, entered in the
Items register. |
Category
| the report can be limited with
the classification of the item. The data about the category is included in
the items register .
| Secondary
classification
| the report can
be limited to the secondary classification of the item. Also the data about
the secondary classification is included in the items register.
| | Warehouse |
the report can be limited to an individual warehouse.
| Customer/Supplier
| limit the overview to an individual customer or
supplier from the document.
| | 3rd party |
the overview can be limited to an individual 3rd party from the documents
(for example, receiver of goods, forwarding agent and similar)
| Department
| the overview can be limited to an individual
department from the document lines, for
which you wish to see the overview of material movements.
| | Cost driver |
the overview can be limited to an
individual cost driver from the document
lines.
| | Issuing department |
the overview can be limited to an individual issuing
department from the document header of the
inter-warehouse transfer. See also Transfer among
warehouses. | |
Issuing cost driver |
the overview can be limited to an
individual issuing cost driver from the header
of the document of the inter-warehouse transfer. See also
Transfer among warehouses. |
| Primary supplier |
the overview can be limited to the primary supplier of the
item. The data about the primary supplier is entered in the
items register. |
| Clerk |
for the limiting criteria also the clerk that is marked on the documents can
be used.
| From date (packing slip)
| The starting date of the document, which should be
included in the calculation. For the calculation of the material movements
the packing slip date is the only suitable date criteria for the
calculation. Date of the packing slip is crucial (with the issues)
or the date of the receiving note (with the purchases).
|
| To date (packing slip) |
The final date of the document, that should be included in the calculation.
For the calculation of the material movements, the packing slip date is the
only date criteria for the calculation. The date of the packing slip is
crucial (with the issues) or the date of the receiving note (with the
purchases).
|
| From date (invoice) |
The starting date of issue or receiving of the invoice. This criteria is
used only for the control reports.
|
| To date (invoice) |
The final date of issue or receiving of the invoice. This criteria is used
only for the control reports.
|
Linked doc. 1
|
che calculation can be limited to an individual linked
document (for example, the order form) |
| Date from |
the report can be limited according to the
starting date of the linked document 1, which should be taken in
consideration by the calculation |
Date to
|
the report can be limited according to
the final date of the linked document 1, which should be taken in
consideration by the calculation |
| Linked doc. 2 |
the calculation can also be limited upon
the second linked document. |
| Date from |
the report can be limited according to the starting date of
the linked document 2, which should be taken in consideration by the
calculation |
| Date to |
the report can be
limited according to the final date of the linked document 3, which should
be taken in consideration by the calculation |
| with the double click on the name of the report or with the
click on the icon for printing in the task bar you display the calculation
of the material movements according to the selected criteria. |
|
|
For general description of the task bar functions see
Task Bar. |
|
|
Just as in every other window, the setting of templates may
be helpful here. For adequate settings of templates in this form see
Templates settings.
|
|
|
For simpler selecting from the document types
and types of items, the shortcut form the menu of the mouse right click can be
used (see Basics - Multiple confirmation entry).
|
|
|
Just as with all filtering of data it is also
the case with the calculations, that the empty field includes all values in the
calculation, while the entered field only includes the documents and lines that
correspond to the entered data!
With the use of wildcards, the filter can be set also a bit broader (see
Basics - Wildcards). |
|
|
|
|