View source | Discuss this page | Page history | Printable version   

ManualDoc:PE5BE98DCF4514A18B571F21183B397DD

The cost is calculated as as sump 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.

Contents

Changes introduced since PR17Q1 Release

Parameters window

NewParameterWindow.png

Output window

ValuestockReportOutput.png

Persisted Information (Introduced since PR17Q1 Release)

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

Before, this report calculated the Stock and it's valuation by adding up this information from the Warehouse Transactions. But, by doing so, this Report was not able to escalate.

Now, 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. More information can be found in the Open Close Period Section.

The information will be persisted until the first not closed Period. By doing so, it is possible to avoid to loop 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.

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

ValuestockReportSchedule.png

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.

Retrieved from "http://wiki.openbravo.com/wiki/ManualDoc:PE5BE98DCF4514A18B571F21183B397DD"

This page has been accessed 1,078 times. This page was last modified on 21 November 2016, at 10:29. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.