1.2.1. Dashboard > Part number manager: Management of requests for LinkDB entries

To enable the new workflow there are two settings in erpcustom.cfg:

  • [VARS]
    PARTREQUEST_CREATE=YES

    -> A request is created when an ERP number is assigned (Add to link database [Add to link database] ).

    You can create the option for one role or for all roles, but in any case deactivate the role for the Admin role.

  • PARTREQUEST_UPDATE_STATE=STATECOL:released

    Specify here which column should be set to which value when a request is approved.

    If you assign another part to the request, the originally requested ERP number will be deleted (if it has not already been approved).

p.s. you also have to make sure that the default value of the state field is something like pending or not released, e.g. by defining it as the default DB value. And for the admin role, it could be set to released, by setting it as the default value (or invisible value) in the userdialog definition.

Example: Certain user groups may create and release data records directly and others must submit a request.

PARTREQUEST_CREATE(USER)=Yes
PARTREQUEST_CREATE(KeyUser)=No 

If a request is started with Add to link database as default user, the user should see that a request is being started.

-> "Request has been sent" is displayed.

The whole process also works with:

erp_export_ts=$CADENAS_SETUP/scripts/erp/erp_export_ts.vbb