Skip to Content

Agentry complex table search calculated field


I have the following requirement and I'm not sure how to solve it better. For a given material I have two fields: Available quantity and pending transfer.

In the complex table search field, the user should see a single value: the result of quantity minus pending transfer. Is there a way to achieve this?

Using a list tile view with update rule is not a valid option since there are too many values in the complex table. The best I could think is to ignore the "pending transfer" field and do the needed changes to always have the available quantity up-to-date, but it breaks a bit the standard "Vehicle Stock" add-on for Work Manager 6.4 way of working.

Kind Regards,

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Feb 17, 2017 at 02:50 PM

    Please keep in mind that your complex table data is based on the last time you synchronized with the backend. Since that time someone else may have consumed some of the quantity. I would probably implement this by showing the available quantity and including a validation rule to warn if the resulting quantity will be less than zero.


    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Bill,

      This shouldn't be a problem since in theory the storage location is specific for the user vehicle trunk, so in general nobody except him will be executing goods movements for it. This is what I've done at the end, not sure if consider it a correct answer:

      - The vehicle stock works using a collection which is a subset of the Complex Table displayed in a Tile List View. Since this is a collection it can then properly show the calculated quantity with an update rule.

      - My scenario is that I want to use the same CTStock complex table for Order Components Add/Edit/Clear that work with a complex table search field and not with a tile list view. So to do that I modified the standard vehicle stock transfers to not update the "Pending Transfer" field for the complex table and always leave it to zero, but instead update the quantity directly since it is valid for my single user storage location. Then the component add/edit also updated the complex table.

      Kind Regards,

      Marçal Oliveras