Trying to add SOLineSplit.IsAllocated field to a GI but seems to always be blank.
Best answer by BenjaminCrisman
View originalTrying to add SOLineSplit.IsAllocated field to a GI but seems to always be blank.
Best answer by BenjaminCrisman
View originalHi
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
Hi
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:
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?
For me the sOOrderType and sOOrderNbr fields are blank.
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.
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.
For me the sOOrderType and sOOrderNbr fields are blank.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.