Skip to main content
Solved

What is the relation between SOLine and SOLineSplit


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 Nilkanth Dipak

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.

View original
Did this topic help you find an answer to your question?

4 replies

Nilkanth Dipak
Semi-Pro I
Forum|alt.badge.img+10

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
  • 10 replies
  • August 3, 2024
Dipak Nilkanth wrote:

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
  • 10 replies
  • August 4, 2024
oshadhat83 wrote:
Dipak Nilkanth wrote:

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
  • 702 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings