If you implement custom fields in your Inventory Records, like Invoice, Quotes, the values will be deleted during any workflows and you couldn’t interact with this values from Workflow Designer before version 600.0825.
With this version, you could create a file named “InventoryFields.inc.php” directly into the “extends” directory.
This file will not be overwritten during updates of the module.
In this file you could configure the fields you create and want to keep during Workflows.
This file MUST have the following structure.
Because this file will be included during every Workflow execution in the Inventory Modules, you should proceed with caution.
Every Error in this file could make it impossible to execute any workflows.
<?php
/**
* You need to enter the following php structure
*
* return array(
* 'tableCol' => array('inventoryField' => 'FieldNameWithoutProductIndex', 'label' => 'Label of this field'),
* );
*/
// Example:
return array(
'test' => array('inventoryField' => 'testCol', 'label' => 'Testvalue'),
);| tableCol | This is the name of the column in the vtiger_inventoryproductrel table. Won’t be used to read from database , but will be a good and unique name |
| Testvalue | The label of this field, which will be shown on task configurations |
| FieldNameWithoutProductIndex | This is the Key of the value in the ProductsArray. You use this value in the “getAssociatedProducts” function |
This structure will make it possible to also set this fields if you create an Invoice in an Workflow.