Skip to content

Analysis Tools

Overview

This section describes the windows related to warehouse reports in Etendo. These are:

Pareto Product Report

Material Transaction Report

Stock Report

Stock History

Valued Stock Report

Product Movements Report

Pareto Product Report

Introduction

Pareto Product Report distributes products into three classes (A, B or C) according to the cost value that each product inventory has in the warehouse. Based on this classification the frequency of counting cycle can be decided (e.g. A products are counted weekly, B products monthly and C products yearly).

Following distribution is used: A products represent 80% value of the warehouse, B - 15% and C- 5%.

Info

The classification is based on the cost of the product. That is why it is needed to have a Costing Rule validated and the Material Transaction costs of the product calculated up to date.

Parameters window

Currency field defines currency in which all monetary values (like Cost, Value) of the report are shown. Field is defaulted to the system currency.

Warning

Please note that Conversion Rate to the report Currency should be specified for the report to work.

Update ABC button fills in ABC field (updates value if the record exists or creates new record otherwise) of Org. Specific tab of the Product window for the organizations of the report output.

Sample Report Output

Material Transaction Report

Columns to note:

  • Quantity: is the current stock of the product (Quantity on Hand) in the warehouse selected.
  • Value: that is the sum of all the material transaction costs of the product.
  • Cost: this cost is calculated as the ratio between the product value and the product quantity above
  • Percentage: that percentage is the ratio between the product value and the Total Value of the warehouse (which is the sum of all report lines).

Persisted information

Aggregated information calculated for the Valued Stock can be used. Please refer to the  Valued Stock Report documentation for more details about how to generate the aggregated information.

Note

Exactly as for the Valued Stock Report, the Pareto Product Report can also be launched without aggregated data. However, this feature is specially useful in high volume environments when you experience performance issues launching the report.

Material Transaction Report

Material Transaction Report lists all documents (outgoing shipments and incoming receipts) grouped by Business Partner and document. For each document number data, product, warehouse, bin and quantity are shown.

Window Parameters

Information on this report can be filtered using movement date, business partner, warehouse and project. Reports can be generated on HTML and PDF format.

Material Transaction Report

Sample Report Output

Material Transaction Report

Stock Report

Stock Report shows a stock level of all products (that have quantity on hand different from zero) and their location (warehouse and storage bin) grouped by product category. For each row product, quantity, unit, attribute, shelves, column, height and warehouse.

Parameters window

The outcome of this report can be filtered by using movement date, product category, product and warehouse locators.

Material Transaction Report

The outcome of this report can be viewed in HTML and PDF format.

Shelves (x), Column (y), Height (z) fields correspond to Row (X), Stack (Y) and Level (Z) of the Storage Bin.

Sample Report output

Material Transaction Report

Stock History

Info

To be able to include this functionality, the Warehouse Extensions Bundle must be installed. To do that, follow the instructions from the marketplace: Warehouse Extensions Bundle. For more information about the available versions, core compatibility and new features, visit Warehouse Extensions - Release notes.

This is a read-only window in which the user is able to consult the daily stock. This functionality updates the daily information collected by the process in Background which was previously created for this purpose.

The Stock History window is filled only by the background process "Create Stock History". It can be programmed from the 'Request Processing' window, where it can be assigned for which role and organization it is executed, and the periodicity with which it is executed.

Info

Check the Technical documentation about Stock History to extend the process to calculate the registers for the daily stock history.

No data will be displayed in the window until search filters are applied to the window. Once the filters are applied, click the button on the right to complete the process.

The window shows the following fields from which the user is able to filter and get the needed data: - Stock date - Product - Attribute set value - Warehouse - Storage Bin - Quantity on hand - Reserved QtY - Allocated Quantity - Quantity in draft transaction

This functionality includes a process to close the stock and save the historical information.

Valued Stock Report

Introduction

Valued Stock Report shows the stock for a particular warehouse as well as the value of the stock.

The cost is calculated as a sum of the cost of each material transaction of the product in the warehouse. The cost of the product transactions is calculated by the Costing Server process.

Parameters Window

Material Transaction Report

  • Organization: This field allows the user to select among  Organizations of type "Legal with Accounting" and "Generic".
  • Warehouse: If the selected organization is "Generic", then lists all warehouses that belong to it, else if the organization is "Legal with accounting" then no warehouse is displayed to be selected.
  • Date: The report is going to show information up to the selected date.
  • Consolidated Warehouse: If checked the information of the stock will be consolidated at Organization Level, otherwise, the information will be broken down by Warehouse.
  • Product Category: Allows to show information of only the Product Category selected.
  • Currency: Defines currency in which all monetary values (like Cost, Valuation) of the report are shown.

Warning

Please note that Conversion Rate to the report Currency should be specified for the report to work.

Output Window

Material Transaction Report

  • Product: Name of the Product.
  • Quantity: Stock of the Product on the selected date.
  • Unit : Unit in which the stock is measured.
  • Unit Cost: Cost of each particular unit. Ii is the result of dividing the Valuation between the Stock.
  • Valuation: Valuation of the Stock. It is calculated by adding up all the valuations of each transaction that has happened in the Warehouse.
  • Actual Average/Standard Algorithm Cost: Current Average/Standard Cost, the latest calculation of it's value.
  • Actual Average/Standard Algorithm Valuation: Valuation of the Stock based on the Actual Average/Standard Cost. Ii is the result of multiplying the Stock by the Actual Cost.

Persisted Information

This step is not necessary in order to launch the Report. However, if there are performance problems, this can help to greatly improve the performance of the Report.

It is possible to aggregate information that allows for faster queries. This information is aggregated for each Closed Accounting Period, that means that accounting periods must be defined and, at least some of them, must be in a Closed or Permanently Closed Status.

The information will persist until the first not closed Period. By doing so, it is possible to avoid looping through many records. However, no information will be aggregated after the first closed period and this can result in a non optimal performance of the report if it needs to retrieve plenty of information.

Info

In order to use this functionality it is necessary to schedule the Background Process named Generate Aggregated Data Background. This can be done through the Process Request Window.

Material Transaction Report

Info

It is recommended to schedule it daily, at a moment when the System does not have plenty of activity. It will aggregate data only when a new Period is Closed or Permanently Closed.

Limitations

By aggregating the information per each Closed Period, it is not possible to keep the date of each Transaction. So, when the Report is launched for a different Currency, all that information will be converted at the Period's Closing Date. This can result in minor discrepancies with the previous version due to conversions between currencies at different dates.

Product Movements Report

Product Movements Report shows all receipts, shipments, moves and physical inventories grouped by Transaction Type and Business Partner. For each row, document number, date, description, locators and quantity are shown.

Parameters Window

The outcome of this report can be filtered using movement date, product, attribute and business partner.

Additionally, the user can include or exclude these documents:

  • Shipment/Receipt
  • Physical Inventory
  • Inventory Movements
  • and Production.

Product Movements Report

Sample Report Output

Product Movements Report