Hello,
When I import purchase orders from an Excel sheet, the PO number changes automatically and takes a different sequence number generated by Odoo.
I’m using Odoo [17].
Thanks in advance.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello,
When I import purchase orders from an Excel sheet, the PO number changes automatically and takes a different sequence number generated by Odoo.
I’m using Odoo [17].
Thanks in advance.
In Odoo 17, the purchase order number stores in the "name" field. To import your own PO numbers, make sure your Excel file includes the PO numbers under the "name" column.
If this still doesn’t work, check if there’s any custom code or module that overrides the PO numbering sequence.
Ensure you have a column name (or Order Reference) in your import file.
This simplified import structure will in fact have you import your Purchase Orders with a 'custom' PO number:
id | name | partner_id |
My PO-No: 00001 | Vendor A | |
My PO-No: 00042 | Vendor B |
Hi,
In Odoo 17, purchase order numbers are always generated by the system’s sequence, so they change automatically when you import POs. If you want to keep your supplier’s PO reference, you should use the Vendor Reference field (partner_ref) instead of trying to override the PO number. Overwriting the name field is technically possible but not recommended, as it can break Odoo’s numbering consistency.
Hope it helps
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrirePublications associées | Réponses | Vues | Activité | |
---|---|---|---|---|
|
1
mars 15
|
6620 | ||
|
3
juin 25
|
1090 | ||
|
0
juil. 24
|
1039 | ||
|
1
juin 23
|
2579 | ||
|
1
août 25
|
1825 |