SOLine to SOLineSplit Relations

  • 13 January 2023
  • 1 reply

Userlevel 5

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 ...


Best answer by Leonardo Justiniano 20 January 2023, 21:46

View original

1 reply

Userlevel 6
Badge +5

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.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved