Skip to main content

Building a GI that will (among other things) show whether an item on a Sales Order is Allocated.

 

I’ve linked SOLine to SOLineSplit and I’m attempting to bring in SOLineSplit.IsAllocated field, but not getting expected results.

 

Here are Table Relations:

The allocated box on the GI is blank.

But the allocated box is in fact checked within Line Details of item on the Sales Order.

Here is the Results grid:

Not sure what I’m missing - if my relations and data links are incorrect or if I’m bringing in incorrect field ...

Hi @jwarren 

For each SOLine you can have more than 1 SOLineSplit. What is happening is your are getting the last SOLineSplit that might not be allocated. I suggest to group SOLineSplit and get MAX(iSAllocated) field in your GI.

Hope this points you in the right direction.

Reply


Terms & ConditionsCookie settings