Storing/refreshing a "JIT" calculated value in a Grid cell

I've been tasked with creating a stock replenishment form to help keep our stockroom levels at preset levels. I have a Form with an IDO that extends (but not replaces) SLItemWhses. The stock room sets the minimum QOH and the maximum QOH for each item's Rank 1 location. The "Refill location" is being pulled from SLItemLocs based on filter criteria determined by the stock room manager. What I'm trying to figure out how to do is to fill in the "Restock Qty" based off of the available QtyOnHand in the location shown. Depending on QtyOnHand, the value would either be: all on hand, the difference between rank 1 on hand and maximum or zero if none is available.

How would I store the calculated value in the Grid cell? Both the "Refill Loc" and "Restock QTY" are unbound properties in my IDO.

Find more posts tagged with

Syteline Development

Accepted answers

All comments

Rees Howel

You might be better off adding Derived Properties to your extended IDO to do the calculation for location and quantity . That can then populate the grid directly when the form loads or filter is removed.

Populating the grid is one thing, but what were you planning to do with the result set?

l9_configcolors.pdf

Stephen Cena

The results were going to be used in a Pick List type report. I was looking to allow the users to possible change a location from where stock is replenished from. However, this feature was deemed unnecessary for this project.

I was thinking either a Derived Field or using an IDO Extension Class method to do the calculation as well.

If the From Location changed, then the amount of inventory to process will change. It would be either pull all stock from the location to reach the max refill level, pull all stock even if it can't hit the refill level or don't pull anything id its unavailable in the location.

Stephen Cena

As the need for this in my current project has been removed, I have stopped looking into how to do this. Based on what I know up to now, I think the best solution would be to create an IDO Extension Class and then make the Grid value a call to the IDO method.

Copyright © 2025 Infor. All rights reserved.