Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Create Tree View with exisiting fields in Accounting

Subscribe

Get notified when there's activity on this post

This question has been flagged
accountingcontactsvendor
2 Replies
2751 Views
Avatar
Kevin

Hi, I'm trying to create a new tree view with vendor invoice information, but the information displays all the accounting entries of the 'account.move' model and I only want vendor invoices. I also want to export the information to xslx.
This is my xml code.

Thanks.



id="view_libro_compra" model="ir.ui.view">
name="name">Libro de iva compra
name="model">account.move
name="arch" type="xml">

string="Libro compra">
name="currency_id" invisible="1"/>
name="empty_field"/>
name="invoice_date"/>
name="name" string="Número de correlativo"/>
name="document_nrc"/>
name="partner_id" string="Nombre"/>
name="empty_field"/>
name="empty_field"/>
name="amount_untaxed" widget="monetary" options="{'currency_field': 'currency_id'}"/>
name="amount_tax" widget="monetary" options="{'currency_field': 'currency_id'}"/>
name="empty_field"/>
name="amount_total" widget="monetary" options="{'currency_field': 'currency_id'}"/>
name="empty_field"/>







id="action_purchase_order_new" model="ir.actions.act_window">
name="name">Libro de iva compra4
name="res_model">account.move
name="view_mode">tree
name="view_id" ref="view_libro_compra"/>


id="menu_purchase_order_new"
name="Libro de iva compra4"
parent="account.menu_finance_payables"
action="action_purchase_order_new"/>


0
Avatar
Discard
Avatar
Kevin
Author Best Answer

I was able to solve the related fields and you are right, they are done with Python so the fields I need are already in the new tree view, the only thing I need is to add a filter that only shows the data from the vendor invoice.

Do you have any idea how to solve it?

Thanks

0
Avatar
Discard
Avatar
Mohammad Ahsan Maqbool
Best Answer

Hi,
As far I know related field works in Python not in xml so either you need to create a new field in account.move model if you want to move forward with python related as follows

partner_vat = fields.Char('res.partner', related='partner_id.vat')

Or Either you can call it in xml file like this if the field you are looking for is with Many2one relation like in account.move partner field is with a relation of many2one so you can try it with following method and get all of its related table values 

name="partner_id.vat"/>



See if this will resolve your issue

If my answer help you please up vote 
If not clear or not solved let me know I will assist you
Thanks

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Enter vendor bill without a product
accounting vendor
Avatar
Avatar
Avatar
2
Dec 24
2069
ERREUR le champ "hide_peppol_fields" n'existe pas dans le modèle "res.partner" Apres migration de base 15 vers v17 via odoo upgrade
accounting contacts upgrade
Avatar
Avatar
Avatar
3
May 25
2456
I odoo 1 can i have field to enter vendor Bank name and Branch Solved
accounting payment vendor
Avatar
Avatar
2
May 24
2938
Error in Payment Followup
accounting contacts odoo16features
Avatar
Avatar
1
Mar 24
1979
Contacts as Vendors
filter contacts vendor
Avatar
Avatar
Avatar
Avatar
3
Mar 24
5335
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now