Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
4685
Weergaven
Payment terms are defined in the table account_payment_term (model account.payment.term)
Customers are defined in the table res_partner (model res.partner)
The payment terms for a Customer are defined in the table ir_property (ir.property)
Joining them together and pulling out what you want would involve SQL like this:
select res_partner.name, account_payment_term.name from res_partner,ir_property,account_payment_term where res_partner.id = right(ir_property.res_id,length(res_id)-12)::integer and right(ir_property.value_reference,length(value_reference)-21)::integer = account_payment_term.id and left(ir_property.value_reference,20) = 'account.payment.term'
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden| Gerelateerde posts | Antwoorden | Weergaven | Activiteit | |
|---|---|---|---|---|
|
50% now, 50% in 45 OR 10% discount
Opgelost
|
|
3
apr. 23
|
1763 | |
|
3
jul. 15
|
7648 | ||
|
0
apr. 15
|
3194 | ||
|
0
dec. 21
|
2089 | ||
|
Default payment terms
Opgelost
|
|
6
aug. 21
|
24784 |
