Skip to main content
Answer

What is the relation between SOLine and SOLineSplit

  • August 3, 2024
  • 4 replies
  • 185 views

Forum|alt.badge.img

I’m trying to understand the relation between SOLine and SOLineSplit. Especialy what is the logic behind setting IsAllocated true or false. If I see a record in SOLineSplit with IsAllocated true what it really says.

Thank you

Best answer by DipakNilkanth

Hi @oshadhat83,

In Acumatica, the SOLine and SOLineSplit tables represent sales order lines and their respective inventory splits. The IsAllocated field in SOLineSplit indicates whether the split line has been allocated inventory. If IsAllocated is true, it means that specific inventory has been reserved or allocated to fulfill that split line, preventing it from being available for other orders or purposes, usually for items that require strict inventory control. on the other side, if IsAllocated is false, the split line does not have reserved inventory, which typically occurs for non-stock items or when the inventory is not yet available for allocation.

4 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi @oshadhat83,

In Acumatica, the SOLine and SOLineSplit tables represent sales order lines and their respective inventory splits. The IsAllocated field in SOLineSplit indicates whether the split line has been allocated inventory. If IsAllocated is true, it means that specific inventory has been reserved or allocated to fulfill that split line, preventing it from being available for other orders or purposes, usually for items that require strict inventory control. on the other side, if IsAllocated is false, the split line does not have reserved inventory, which typically occurs for non-stock items or when the inventory is not yet available for allocation.


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 3, 2024

Hi @oshadhat83,

In Acumatica, the SOLine and SOLineSplit tables represent sales order lines and their respective inventory splits. The IsAllocated field in SOLineSplit indicates whether the split line has been allocated inventory. If IsAllocated is true, it means that specific inventory has been reserved or allocated to fulfill that split line, preventing it from being available for other orders or purposes, usually for items that require strict inventory control. on the other side, if IsAllocated is false, the split line does not have reserved inventory, which typically occurs for non-stock items or when the inventory is not yet available for allocation.

Thank you @Dipak Nilkanth. I need your help to understand below please:

I have a question about one scenario I’m looking at now. Is this IsAllocated is marked as true or false automatically. Since in my scenario in SOLineSplit it is not marked the IsAllocated true but it has enough Qty at hand. I check this qty in Inventory warehouse tab.

Please refer the below images:

Inventory:

I’m confused here can you please help me to get this straight.


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 4, 2024

Hi @oshadhat83,

In Acumatica, the SOLine and SOLineSplit tables represent sales order lines and their respective inventory splits. The IsAllocated field in SOLineSplit indicates whether the split line has been allocated inventory. If IsAllocated is true, it means that specific inventory has been reserved or allocated to fulfill that split line, preventing it from being available for other orders or purposes, usually for items that require strict inventory control. on the other side, if IsAllocated is false, the split line does not have reserved inventory, which typically occurs for non-stock items or when the inventory is not yet available for allocation.

Thank you @Dipak Nilkanth. I need your help to understand below please:

I have a question about one scenario I’m looking at now. Is this IsAllocated is marked as true or false automatically. Since in my scenario in SOLineSplit it is not marked the IsAllocated true but it has enough Qty at hand. I check this qty in Inventory warehouse tab.

Please refer the below images:

Inventory:

I’m confused here can you please help me to get this straight.

Any one has any comment on this?

 


jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • August 5, 2024

Hi @oshadhat83 ,

The system generates splits based on inventory locations.  Did you check the Qty is available for the particular location?

Also, verify if there have been any recent inventory adjustments or transfers that could impact the allocation process