Skip to Content

Import Export Inventory Report

by
Odoo
v 16.0 Third Party 1329
Download for v 16.0 Deploy on Odoo.sh
Versions 16.0 17.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
• Invoicing (account)
Lines of code 773
Technical Name imex_inventory_report
LicenseLGPL-3
Websitehttps://github.com/longvm91/odoo-custom-modules/tree/16.0/imex_inventory_report
Versions 16.0 17.0

Imex Inventory Report

Inventory Report with total initial, qty in, qty out, balance.

  • Change logs:
    1.3.1
    - Now you have new "View Details" button if you selected only one product
    - You can view the details report from tree view when you click the search button on each row.

  • Filter wizard:
    - If leave location blank mean select all internal locations
    - If leave category blank mean select all categories
    - If leave product blank mean select all category's products (if category set) or select all storable products (if category not set)
    - If start date blank mean period start from 1900-01-01
    - If end date blank mean period end date is today
    • filter wizard filter wizard filter wizard

  • View report:
    • report all products

  • View details report:
    • report all products

  • Print report:
    • print report pdf

    group_location cases
    case 1: location set
     => count internal transfer and group by location
     1.1: group_location = True
      => select all child_of location
     1.2: group_location = False
      => select only location_id
    case 2: location not set
     => select all internal locations
     2.1: group_location = True
      => count internal transfer and group by location
     2.2: group_location = False
      => not count internal transfer and neither group by location

  • Group by location example counted internal transfers:
    • group by location example

  • Not group by location example din't count internal transfers:
    • not group by location example

    If you have questions, don't hesitate, leave comment or feel free to contact me Jason

    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, please use the developer contact information. They can usually be found in the description.
    Thanks the module
    by
    Jose C
    on 8/28/24, 11:15 AM

    But i have same problem with duplicated lines, just find testing in incoming product. One line duplicate 6 times. In Odoo show me just one. Please fix this. I add a sample of the duplicated lines

    Date Reference Partner Source Location Price In Out Balance Amount
    Initial 0 0
    6/4/2024 JM/OUT/09898 (S13692) JM 0.27 0 10 -10 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0 2,000.00 0 1,990.00 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0 2,000.00 0 3,990.00 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0 2,000.00 0 5,990.00 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0 2,000.00 0 7,990.00 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0 2,000.00 0 9,990.00 -2.7
    4/6/2024 JM/IN/00106 (P00612) partner Partners/Vendors JM 0.09 2,000.00 0 11,990.00 177.3

    by
    Jose C
    on 8/28/24, 11:08 AM


    by
    Foresight Solutions
    on 8/19/24, 7:11 AM

    The IMEX inventory report is very useful as it provides details not readily available in default Odoo report.

    But we are having a bad experience of having duplicate transaction lines (for transactions with the same reference) and we are unable to get help on this.

    by
    Foresight Solutions
    on 8/19/24, 7:07 AM

    This report is very useful as it provides details in a format not readily available in default Odoo.

    However, we experienced a case of duplicates in same transaction lines with same transaction reference and we are unable to locate any help for this issue.

    by
    Kevin Cordon
    on 7/26/23, 5:43 PM

    hi nice to meet you
    your module is very good
    add the columns to it; barcode, default_code

    Re:
    by
    Jason Vu
    on 7/26/23, 10:57 PM Author

    Hi Kevin, 

    Thank you for using and feedback