21.78

v 15.0 Third Party 1
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Purchase (purchase)
Discuss (mail)
Lines of code 936
Technical Name loyal_inventory_valuation_reports
LicenseAGPL-3
Websitehttp://www.loyalitsolutions.com
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Purchase (purchase)
Discuss (mail)
Lines of code 936
Technical Name loyal_inventory_valuation_reports
LicenseAGPL-3
Websitehttp://www.loyalitsolutions.com
Loyal-logo

Detailed Inventory Valuation Report

This module allows us to get the detailed inventory valuation report. This includes the inventory valuation from Purchase, Sales and Manufacturing Modules. All the movements in the stock including inventory adjustments inventory transfers, unbuild orders valuations will be available in this report. All these can be based on company, warehouses, locations, product and product category

Key Highlights!

  • Can anlayze the inventory valuation with a single report
  • Can easily filter the inventory valuation based on warehouses
  • Can use the module functionality in multicompany environment
  • Can monitor the valuation from a single report
  • This involves the advanced feature for getting inventory valuation of unbuild orders
  • Identifies the product valuation in sales, purchase, manufacturing
  • Without any additional configuration we can monitor the stock movement

Overview


Companies use inventory valuation, a type of accounting, to determine the value of unsold inventory items when generating their financial statements. By default, Odoo have an Inventory valuation report but the data is limited. So, we have created a new detailed inventory valuation report which will be displaying the opening stock,the issued quantity,recieved quantity,closing stocks and their corresponding values.

Example with screenshots


  • Example with detail steps are given below:

Configuration

01

Let’s consider an example with a new product named Ace A1 Plus Smartphone with no stock moves. Make sure the product is a storable product

02

Go to the Inventory Module - Reporting and Choose the menu ‘Inventory Valuation report’

03

Then a Wizard will be appeared in the screen where you can choose the options based on the requirements. From the wizard you can choose the warehouse, company,location, filter by product or product category, Start period, end period, Summary, and can filter by specific products name if needed

04

In the below image we have choosen the warehouse, company, location, start period, end period and our product name

05

We can download the inventory valuation report as Excel.The image of the excel file downloaded is shown below. As there are no stock moves no other values are shown

06

Now we have purchased 1500 units of the product

07

So in the inventory valuation report the receiving quantity and its corresponidng value and closing stock and its closing values are updated

08

Now We have sold 500 units of our product

09

So in the inventory valuation report the issued quantity and its corresponidng value and closing stock and its closing values are updated

10

Now I have transferred 100 units from WH to WH2(Internal Transfer)

11

Now the image shown below is the inventory valuation report from the WH. In which the product moved and its corresponding value is shown as negative and its corresponding changes are made in the closing stock and its value

12

Now the image shown below is the inventory valuation report from the WH2

13

Now for the same product we have updated the BOM with new components and purchased the components

14

Now manufactured 100 units of Ace A1 Smartphone and hence consumed the BOM components

15

Now in the inventory valuation report, you could see the MO quantity, its components its corresponding values. Also the closing stock is changed respectievely

16

Now we have unbuild 50 quantities of ACE A1 Plus smartphone

17

Now in the report you could see the unbuild MO and Unbuild components and their corresponding values

18

Now we have made an inventory adjustment i.e., updated 1000 Ace A1 Plus Smartphone to the WH

19

Now in the report inventory adjustment of the difference i.e., 50 units have been updated and you can see that in the closing stock the value is 1000 units

20

Now when the date is changed to the next date the opening stock is updated as the closing stock of the previous day

Suggested Products


Our Services


Odoo Customization

Odoo Implementation

Odoo Integration

Odoo Support

Hire Odoo Developers

Our Industries


Odoo Industry

Manufacturing

Manage the entire process of Manufacturing with an ERP.

Odoo Industry

Trading

Grow your Trading business with Odoo

Odoo Industry

Retail

Run your Retail outlets.

Odoo Industry

POS

Easy Billing. Easy Management

Odoo Industry

CRM

Handle the entire process with a simple software

Odoo Industry

Warehouse Management

All In One Warehouse Management Application

Odoo Industry

Education

Easy and complete solution for Education Management.

Odoo Industry

Service Management

Keep track of services and invoice accordingly.

Need Any Help?


Do you have any query ? Do you need any support from our side ? We are happy to assist you

Email us

support@loyalitsolutions.com / info@loyalitsolutions.com

Contact Us

www.loyalitsolutions.com


Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.