Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
creationproduct.productVendorBills
2 Vastaukset
2948 Näkymät
Avatar
Thomas Guénard

Hello fellow odoers

Vendor invoices are documents received with a pdf format; they include a significant number of product lines; some of these products being new ones (not yet created) for our odoo database.

these invoices correspond to our PO cart validated on vendor website on sundays and products and related invoice are received on next tuesday; all products can be sold to end customers on same tuesday.

We need to be fast to create new products and make them available for sale

So far NO automatic creation process exist with Odoo - except thru importing with a csv file or excel file -; which we use currently; but this is time consuming and prone to errors (eg pdf to excel process and then import).


Does any of you already solve this operationnal need with an adhoc developpment?

Any other idea?

Thanks in advance


Avatar
Hylkää
Thomas Guénard
Tekijä

current way for importing vendor bills from pdf
Tabula (opensource) from pdf to csv
edit csv as needed
export csv as pdf
odoo import pdf as invoices > creation of invoice object

expect that odoo import will create new products!

Avatar
Jainesh Shah(Aktiv Software)
Paras vastaus

Hello Thomas Guenard,

You can import xlsx or CSV files when selecting the option for
"When a value cannot be matched ==> Create new values."

if you select "create new values" to create a product in odoo when importing the file.

I hope this will help you.

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

Avatar
Hylkää
Thomas Guénard
Tekijä

yes I know it
first step is to get from pdf a satisfying file to import

Avatar
Tapha LY
Paras vastaus

Another option could be to use an optical character recognition (OCR) tool to extract data from the PDF invoices and then use that data to create new products in Odoo. This will be faster than manual data entry and less prone to errors compared to importing data from a CSV or Excel file.

You can also look into third-party apps available in the Odoo App Store that can assist with this process.

It is important to thoroughly test any custom development or third-party apps before implementing them in your production environment to ensure they meet your business needs and do not cause any unintended consequences.

Avatar
Hylkää
Thomas Guénard
Tekijä

I tried the OCR by Odoo; so far seems not so easy for invoices with 3 pages of lines
Tabula software gives better results

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Adding amount_currency field with Studio Ratkaistu
VendorBills
Avatar
Avatar
1
huhtik. 23
797
Report for product.template
product.product
Avatar
Avatar
1
toukok. 21
7648
How to print Barcode Labels with price from pricelist?
product.product
Avatar
Avatar
5
elok. 16
6544
How to have data from product.template in product.product object
product.product
Avatar
Avatar
1
heinäk. 15
8768
How add field to product view in odoo 17
product.product xpath
Avatar
Avatar
Avatar
Avatar
4
marrask. 25
4208