Stock Analysis Report | Stock By Location

by
Odoo

41.18

v 14.0 Third Party 19
Required Apps Inventory (stock)
Sales (sale_management)
Invoicing (account)
Lines of code 1050
Technical Name stock_positioning_report
LicenseAGPL-3
Websitehttp://www.gybitsolutions.com
Also available in version v 11.0 v 9.0 v 13.0 v 10.0 v 8.0 v 12.0
You bought this module and need support? Click here!
Required Apps Inventory (stock)
Sales (sale_management)
Invoicing (account)
Lines of code 1050
Technical Name stock_positioning_report
LicenseAGPL-3
Websitehttp://www.gybitsolutions.com
Also available in version v 11.0 v 9.0 v 13.0 v 10.0 v 8.0 v 12.0
Note: This module is successfully works in Community Editions only.

Stock Positioning Analysis Reports

This product helps to show Stock Positioning Analysis with measure by
Quantity On Hand, Incoming QTY, Outgoing QTY, Forecast QTY(Saleable)
of the Products/Product variants Group by available stock locations.

(A) Pivot View of Products(Tabular Report)

Menu Path : Inventory > Stock Positioning Reports > Products
User can see Stock Positioning Analysis with measure by OnHandQTY, IncomingQTY, OutgoingQTY, ForcastedQTY of the Products Group by available stock locations.
Note : User must have to reload this page to get accurate Stock Qty.

(F) Pivot View of Product Variants(Tabular Report)

Menu Path : Inventory > Stock Positioning Reports > Product Variants
User can see Stock Positioning Analysis with measure by OnHandQTY, IncomingQTY, OutgoingQTY, ForcastedQTY of the Product Variants Group by available stock locations.
Note : User must have to reload this page to get accurate Stock Qty.

(B),(C),(G),(H)

Menu Path : Inventory > Stock Positioning Reports > PDF : Excel Stock Positioning Report
User can also print Stock Positioning Analysis Reports in two formats.
   1) PDF format,
   2) Excel format.

User can apply filters like Report Type, Products, Product Variants.

Wizard Explanations:

(1) Report Type: By default Report Type set as Product Variants. User can change it.
  IF user want to print report for Products (templates), Please select Products option.
  IF user want to print report for Product Variants, Please select Product Variant option.
  If Report Type == Products, Products field will be visible at below of Report Type.
  If Report Type == Product Variants, Product Variants field will be visible at below of Report Type.
(2) Products: Only visible if Report Type == Products selected.
  User can select multiple products here. It helps to print data for particular products.
  If products assigned here, then only selected Product's data will be print in report. If user want all products data, please leave it blank.
(3) Product Variants: Only visible if Report Type == Products Variants selected.
  User can select multiple product variants here. It helps to print data for particular products variants.
  If product variants assigned here, then only selected product variants data will be print in report.
  If user want all product variants data, Please leave it blank.
(4) Print Excel: Report will print in Excel format.
(5) Print PDF: Report will print in PDF format.

(B) PDF report for Products from Wizard : Filters available.

Here we assign Report Type is Products and do not assign products in Products block.
Report will print all Products Data.

Let's print report.


With Filters

Report Type = Products and add a product in Products block. Now Report will print with selected Products only.
Please refer below Layout.

(C) Excel report for Products from Wizard : Filters available.

Report Type = Products and do not assign products in Products block. Report will print all Products Data.

Let's print report.


With Filters

Report Type = Products and add multiple products in Products block. Now Report will print with selected Products only.
Please refer below Layout.

(G) PDF report for Product Variants from Wizard : Filters available.

Here we assign Report Type is Product Variants and do not assign products in Product Variants block.
Report will print with all Product Variants Data.

Let's print report.


With Filters

Report Type = Product Variants and add multiple variants in Product Variants block.
Now Report will print with selected Variants only. Please refer below Layout.

(H) Excel report for Product Variants from Wizard : Filters available.

Report Type = Product Variants and do not assign products in Product Variants block.
Report will print with all Product Variants Data.

Let's print report.


With Filters

Report Type = Product Variants and add multiple variants in Product Variants block.
Now Report will print with selected Variants only. Please refer below Layout.

(D) Table View in Products Form view.

*User can view product's on hand quantity, incoming quantity, out quantity, forecast quantity Group by available stock locations.

(E) PDF Report from Products Form View.

*User can print Pdf report for a Product just by click on Positioning Report PDF Button. So user can get pdf report with a single Click.
Please refer Pdf Layout.

(I) Table View in Product Variants Form view.

User can view product variants on hand quantity, incoming quantity, out quantity, forecast quantity Group by available stock locations.

(J) PDF Report form Product Variants Form View.

User can print Pdf report for a product variant just by click on Positioning Report PDF Button. So user can get pdf report with a single Click.
Please refer Pdf Layout.

Need help?

:: Contact for this module, maintenance, for any question, need support or request for the new features ::

Website Contact Us Services More Apps

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.
There are no ratings yet!
by
agharaafat@outlook.com
on 3/14/21, 7:49 AM

I need to know, by this app i can get the pending purchased quantity, i mean the difference between what PO and what i  actually receipt?

the same with what ordered and what i actually delivered?

Re:
by
Anand Patel
on 3/15/21, 12:50 AM Author

Hi Agharaafat,
This app has all the incoming and outgoing qty which includes all the inventory operations like Delivery Order(from Sale Order), Incoming Shipment(Purchase Order), and also other warehouse related operations including manufacturing effects on the warehouse. So yes it shows all together in Incoming Qty and Outgoing Qty. 

In your case you need it specifically for the What you have ordered and what you have delivered for Sale Order. And same way for the Purchase Order but that feature is not included in this app.

You can let us know if you are interested to develop that feature.

Write us email on gybitsolutions@gmail.com

Thanks.