Power BI 2.4 - Release notes
Changes to the templates related to the cost price changes for stock valuation introduced in LS One release 2021:
- The existing reports Inventory and Stock Taking are updated to use the calculated cost per item and store: Last Purchase Price, Weighted Average or Manual depending on the settings in the LS One database used as the source for the report.
- New columns are added in the Inventory report: Unit and Value.
- The existing column Cost Price is changed to show the cost price per inventory unit.
This column's previous content (quantity * cost price) is now displayed in the new Value column. - The column Available in the Inventory report is renamed to Quantity on Hand.
- A new report Stock Value is added, showing the total value of the inventory on hand.
You will find more information about the changes in cost calculations in the LS One 2021 release notes on stock valuation.
Other changes:
- The Inventory report is updated to exclude voided transactions when calculating the average sales price.
- The Stock Taking report is updated to handle multiple stock counting journals with the same name.
The following power BI templates are now available for the different versions of LS One:
LS One | Power BI template |
---|---|
Release 2021 | Version 2.4 |
Release 2020.1 | Version 2.3 |
Release 2020 and older | Version 2.2 |
Inserted: | January 2021 |
Version: | LS One 2021 and later |