Import Invoices from Excel in Odoo
Import Customer Invoice, Vendor Bill, Credit Note, Debit Note from Excel
This app will allow you to import Invoices / Vendor Bills / Debit-Credit Notes from excel into Odoo.
Main Features:
- This module will allow you to import Customer Invoices from excel.
- This module will allow you to import Vendor Bill from excel.
- This module will allow you to import Credit Note from excel.
- This module will allow you to import Debit Note from excel.
- Make sure you have xlwt Python libarary installed.
- Sample Excel is available inside sample folder in module.
- For more details please see below screenshots and video.
Wizard Filter
- Filters:
- Type
-
- Customer Invoice ==> If Selecting Customer Invoice Option you will be Importing Customer Invoices.
- Vendor Bill ==> If Selecting Vendor Bill Option you will be Importing Vendor Bill.
- Credit Note ==> If Selecting Credit Note Option you will be Importing Credit Note.
- Debit Note ==> If Selecting Debit Note Option you will be Importing Debit Note.
- Invoice Stage Option
-
- Draft Invoice ==> If Selecting Import Draft Invoice with Invoice Stage Option Importing Invoices in Draft State.
- Validate Invoice ==> If Selecting Validate Invoice Automatically with with Invoice Stage Option Importing and Validating Invoices automatically.
- Import Product By
-
- Name ==> If Selecting Import Product By Name than Search Product with Name.
- Code ==> If Selecting Import Product By Code than Search Product with Code.
- Barcode ==> If Selecting Import Product By Barcode than Search Product with Barcode.
-
Following fields can be Import From Excel Column.
- INVOICE_ID :Â Invoice Id
- PARTNER :Â Partner/Customer/Vendor Name
- INVOICE DATE :Â Date of Invoice or Bill
- PRODUCT :Â Product Name or Code or Barcode
- DESCRIPTION :Â Description of Product
- QUANTITY :Â Quantity
- UNIT PRICE :Â Price Unit of Product
- DISCOUNT :Â Discount
- TAX :Â Multiple Tax are Seperated by Comma
- ANALYTIC ACCOUNT :Â Analytic Account
- ANALYTIC TAGS :Â Multiple Analytic Tags are Seperated by Comma.
- NOTES :Â Comment