Skip to Content
Menú
This question has been flagged
1 Respondre
7124 Vistes

please Help meee!
When I "Enter Promotion or Coupon" has been error "Missing required fields on accountable sale order line" 

Avatar
Descartar
Best Answer

Hello,

The SQL constraint shown is defining a check constraint named "accountable_required_fields" for the sale order line model in Odoo.

The purpose of the constraint is to ensure that any sale order line that is considered "accountable" (i.e. requires certain information to be recorded for proper accounting) has all the necessary fields filled in.

The constraint consists of three parts:

  1. A name for the constraint: 'accountable_required_fields'

  2. The check itself: "CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom IS NOT NULL))". This check specifies that either the "display_type" field must not be null or both the "product_id" and "product_uom" fields must not be null.

  3. An error message to display if the constraint is violated: "Missing required fields on accountable sale order line."

Thanks & Regards,



CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209
Email: info@candidroot.com
Skype: live:candidroot
Web: https://www.candidroot.com
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat

Avatar
Descartar
Related Posts Respostes Vistes Activitat
1
de nov. 21
2341
0
de nov. 20
3303
1
de des. 21
3932
1
de juny 21
2476
0
de maig 21
2346