What is the relation between SOLine and SOLineSplit

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.

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?

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