Does the SOLineSplit.IsAllocated field work on a GI?

Hi @jwarren! I think for this issue the problem is that the field is probably calculated, and so it might require a simple calculation and applied Schema field to work.

Try using an expression like =iif([SOLineSplit.IsAllocated]=1, 1, 0) 

Next use the SOLineSplit.IsAllocated field as the schema in the next field over to make sure it recognizes it as a checkbox

Hey Ben,

Have set it up as such:

But getting same results:

@jwarren I would double check the joins you are using in the GI then because it appears for me when I use the table by itself with no expression, and the DAC Schema shows it is not a virtual field, so it should be presentable in the GI:

Chances are this is getting lost somewhere in the relations.

I would peel back some relations and deactivate them to see when the IsAllocated field populates again and start adding relations back until you are certain you spot the relation which, when active, causes the IsAllocated to drop off.
It might also be a good idea to just toss the SOLineSplit table into a GI by itself and make sure it is accurately showing on its own too

Thanks - I will give that a shot.

Here are my relations - spot anything blatant that could be cause?

Suggest you use the Schema Browser to check things like this.

https://help.acumatica.com/dacBrowser/PX.Objects.SO/SOLineSplit

It’s not a virtual field so should display in a GI. 

You are missing LineNbr in your join to SOLine - Schema Browser should also make this apparent.

Right - actually had the Linenbr in there but cut off in my screenshot.

That’s it Ben.

This is what has solved it for me. The SOordertype, SOorderNbr, and SOLineNbr fields were providing blanks. Once I updated these as you suggested it now shows as expected.

Meant to give you best answer but clicked wrong comment…

Jack