| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Sales (sale_management) • Discuss (mail) |
| Lines of code | 867 |
| Technical Name |
import_invoice_app |
| License | OPL-1 |
| Versions | 11.0 12.0 13.0 14.0 15.0 16.0 17.0 |
App for Import Customer Invoice and Vendor Bill from Excel/csv
Adding data is important for any system with this app in odoo will helpful for easy to import multiple customer invoice and vendor bill from csv and xls file into odoo accounting module.
Import Invoice from XLS/CSV
Import customer invoice,vendor bill,customer refund(credit note),vendor refund from xls/csv file.
Import customers/vendors
Options like customer name,internal reference and external id is provided to choose customer/vendor for invoice/vendor bill.
Import Products
Options like product name,internal reference,barcode and external id is provided to choose products for invoice/vendor bill.
Validate Invoice/Vendor Bill
An option is provided to validate invoice/vendor bill which is imported from file.
Invoice Sequence
Options is provided for sequence either you want to use default sequence or custom sequence from file for invoice/vendor bill.
Invoice Line Account
Provided options to choose account from product or from the file for the invoice lines.
Import With Analytic Account
Import invoice with analytic account from xls or csv file.
Skip Validation
User can skip validation for invalid data from file because of this other correct data will be imported and you can get log of incorrect data of file.
Import Multiple Invoice Lines
User can import multiple invoice lines for one invoice/vendor bill.
Description
Import Customer Invoice and Vendor Bill from CSV and XLS
Import customer invoice and vendor bill from csv and xls file , Provided many options like : invoice option, customer option, product option, sequence option, account option, analytic account option to import invoice and vendor bills.
Example of XLS and CSV Format
- If user want to search product or customer by name then select name in product search and customer search.
- If user want to search product by barcode then select barcode in product search .
- If user want to search product and customer by internal reference then select internal reference in product search and customer search.
- If user want to search product or customer by external id then select external id in product search and customer search.
Make your xls and csv files as per given example to import invoice with analytic account.
Make your xls and csv files as per given example to import invoice.
| Field | Description |
| Invoice | Invoice sequence. |
| Customer | Customer Name. |
| Delivery Add | Delivery address name. |
| Payment Terms | Payment terms name. |
| Date | Invoice date(mm/dd/yyyy). |
| Sales Person | Sales person name. |
| Sales Team | Sales Team Name |
| Journal | Journal Name. |
| Fiscal Potion | Fiscal Potion name. |
| Product | Product Name. |
| Description | Product description. |
| Account | Account for invoice line. |
| Qty | Product Quantity. |
| Uom | Unit of Measure for product. |
| Price | Product price for invoice. |
| Tax | Name Of the tax. |
| Analytic Account | Analytic Account Name. |
| Analytic Tags | Analytic Tags Name. |
Imported Invoice
This is the invoice which is imported by given example file.
Import Customer Invoice and Vendor Bill from CSV and XLS
Import customer invoice and vendor bill from csv and xls file, Provided many options like : invoice option, customer option, product option, sequence option, account option, analytic account option.
Skip Validation or Restrict Validation
If user select skip validation option and import file contains wrong data then wrong data will be skipped and remains correct data will imported from file, user can see validation logs for incorrect data.
Our Services
Get In Touch
You will get 60 Days free support in case any bugs or issue.
For any query or support contact us without hesitation on
edgetechnologies.odoo@gmail.comOdoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module