Skip to main content
Solved

How to copy custom field creating child orders action ?

  • July 25, 2023
  • 5 replies
  • 227 views
  • Translate All

Forum|alt.badge.img

User Description custom filed copy data create child order action click

 

Best answer by Rajginoya

@Rajginoya Have you tried with the InventoryID field updated event and verified?

 

public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
{
#region Event Handlers

public SelectFrom<SOLine>.View SolineView;

protected void _(Events.RowUpdated<SOLine> e)
{
SOLine row = e.Row;
SOLine oldrow = e.OldRow;
if (row !=null)
{
if (row.BlanketNbr == null)
return;
SOLineExt solineext = row.GetExtension<SOLineExt>();
SOLineExt oldsolineext = oldrow.GetExtension<SOLineExt>();
if (oldsolineext.UsrUserDescription == null && solineext.UsrUserDescription == null)
{
if (row.BlanketNbr != null)
{
var SolineItems = SolineView.Select()
.Where(item => item.GetItem<SOLine>()
.OrderNbr == row.BlanketNbr).Where(item => item.GetItem<SOLine>()
.LineNbr == row.BlanketLineNbr);
foreach (SOLine line in SolineItems)
{
if (line.LineNbr == row.BlanketLineNbr)
{
solineext.UsrUserDescription = line.GetExtension<SOLineExt>().UsrUserDescription;
}
}
}
}
}

}
#endregion

}

 

View original

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20

Hi @Rajginoya  Blanket Order and its Child Order reference details are available in the SOBlanketOrderLink table.

 

For the above requirement, Please write a simple query to check if this line belongs to child Order or not, if yes, you can fetch the User Description from the Blanker Order line and assign it to the Child Order line.

 

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 25, 2023

  

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 25, 2023

Hi @Rajginoya  Blanket Order and its Child Order reference details are available in the SOBlanketOrderLink table.

 

For the above requirement, Please write a simple query to check if this line belongs to child Order or not, if yes, you can fetch the User Description from the Blanker Order line and assign it to the Child Order line.

 

 

Which Event Call?

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@Rajginoya Have you tried with the InventoryID field updated event and verified?

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • July 27, 2023

@Rajginoya Have you tried with the InventoryID field updated event and verified?

 

public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
{
#region Event Handlers

public SelectFrom<SOLine>.View SolineView;

protected void _(Events.RowUpdated<SOLine> e)
{
SOLine row = e.Row;
SOLine oldrow = e.OldRow;
if (row !=null)
{
if (row.BlanketNbr == null)
return;
SOLineExt solineext = row.GetExtension<SOLineExt>();
SOLineExt oldsolineext = oldrow.GetExtension<SOLineExt>();
if (oldsolineext.UsrUserDescription == null && solineext.UsrUserDescription == null)
{
if (row.BlanketNbr != null)
{
var SolineItems = SolineView.Select()
.Where(item => item.GetItem<SOLine>()
.OrderNbr == row.BlanketNbr).Where(item => item.GetItem<SOLine>()
.LineNbr == row.BlanketLineNbr);
foreach (SOLine line in SolineItems)
{
if (line.LineNbr == row.BlanketLineNbr)
{
solineext.UsrUserDescription = line.GetExtension<SOLineExt>().UsrUserDescription;
}
}
}
}
}

}
#endregion

}

 

Translate