View source for Plugin: BX Service Document Status Validator

*'''Maintainer:''' [[User:Diego.ruiz|Diego Ruiz]] - [[User:TBayen|Thomas Bayen]] - [[User:CarlosRuiz|Carlos Ruiz]] - [http://www.bx-service.com BX Service GmbH]
*'''Sponsor:'''  [http://www.bx-service.com BX Service GmbH]
*'''Status:''' Stable, used in production with release 7.1 and above
*'''License:''' [http://www.gnu.org/licenses/gpl-2.0.html GPLv2]
*'''Sources:''' [https://github.com/bxservice/de.bxservice.docstatusvalidator GitHub]
*'''Video tutorial:''' [https://youtu.be/4Q6i1OOpIDI Document Status Validator in iDempiere]

== Description ==
The goal of the plug-in is to allow the user to create validations on document status changes with SQL conditions. When one of the conditions is fulfilled, an error message is shown to the user explaining what to do to be able to change the document status.

It adds an extra layer of control over the document status changes. It lets you catch potential errors and mistakes before updating the doc status instead of having to fix them afterward.

== Configuration ==
Log in to iDempiere as System or with an Administrator role and navigate to the 'Document Status Validation' window.

[[File:DocStatusValidation.jpg]]

In the above example, a condition is created to forbid the preparation of orders with a Grand Total > 1000 €.

The SQL Where accepts SQL code, or context variables, such as: '@DateOrdered@' >' @#Date@'.

Fields:
{| class="wikitable"
|-
! Column Name !! Description
|-
| Name || Condition Name. It is used for reference
|-
| Message || Translatable message that will be shown to the user in an error dialog when the condition is fulfilled.
|-
| Sequence || When there’s more than one condition for the same document. The sequence specified in which order the conditions are evaluated.
|-
| Table || List of tables with document status.
|-
| Event Model Validator || Event that triggers the validation
|-
| SQL Where || SQL condition that is evaluated. Fill with fully qualified names.
|}

When more than 1 condition for the same document is fulfilled, the error message shows all the messages from those conditions that must be addressed. 

[[Category:Available_Plugins|BX]]
[[Category:BX_Service_Plugins]]