Hello all,
I have a custom field, similar to stock item description in the stock items screen and I am looking to fetch the value from the custom field to my PO screen under the details tab. I have a new field added under the details tab & now want to display in this. How can I do that?
Thanks in advance.
Best answer by Nilkanth Dipak
Hi
You are adding code to the DAC extension, this is not right. You can add custom fields to the DAC extension and not write an logic.
this code you need to add to the the graph. i.e. public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
You need to extend POOrderEntry graph and add logic to transfer fields values from one screen to another.
public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
{
protected void POLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
{
var row = (POLine)e.Row;
if (row == null) return;
// Fetch the custom field value from the InventoryItem
InventoryItem inventoryItem = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
.Select(Base, row.InventoryID);
InventoryItemExt inventoryItemExt = inventoryItem.GetExtension<InventoryItemExt>();
if (inventoryItemExt != null)
{
POLineExt rowExt = PXCache<POLine>.GetExtension<POLineExt>(row);
rowExt.UsrCustomField = inventoryItemExt.UsrCustomField;
}
}
}
+10Hi
You can use following code snippet to achieve the same.
protected void POLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
{
var row = (POLine)e.Row;
if (row == null) return;
// Fetch the custom field value from the InventoryItem
InventoryItem inventoryItem = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
.Select(Base, row.InventoryID);
InventoryItemExt inventoryItemExt = inventoryItem.GetExtension<InventoryItemExt>();
if (inventoryItemExt != null)
{
POLineExt rowExt = PXCache<POLine>.GetExtension<POLineExt>(row);
rowExt.UsrCustomField = inventoryItemExt.UsrCustomField;
}
}Hope, it helps!
FYI: This code works only when you updating the Inventory ID field from POLine.
Hi
You can use following code snippet to achieve the same.
protected void POLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
{
var row = (POLine)e.Row;
if (row == null) return;
// Fetch the custom field value from the InventoryItem
InventoryItem inventoryItem = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
.Select(Base, row.InventoryID);
InventoryItemExt inventoryItemExt = inventoryItem.GetExtension<InventoryItemExt>();
if (inventoryItemExt != null)
{
POLineExt rowExt = PXCache<POLine>.GetExtension<POLineExt>(row);
rowExt.UsrCustomField = inventoryItemExt.UsrCustomField;
}
}Hope, it helps!
FYI: This code works only when you updating the Inventory ID field from POLine.
Hello
+10Hi
You are adding code to the DAC extension, this is not right. You can add custom fields to the DAC extension and not write an logic.
this code you need to add to the the graph. i.e. public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
You need to extend POOrderEntry graph and add logic to transfer fields values from one screen to another.
public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
{
protected void POLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
{
var row = (POLine)e.Row;
if (row == null) return;
// Fetch the custom field value from the InventoryItem
InventoryItem inventoryItem = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
.Select(Base, row.InventoryID);
InventoryItemExt inventoryItemExt = inventoryItem.GetExtension<InventoryItemExt>();
if (inventoryItemExt != null)
{
POLineExt rowExt = PXCache<POLine>.GetExtension<POLineExt>(row);
rowExt.UsrCustomField = inventoryItemExt.UsrCustomField;
}
}
}
Hi
You are adding code to the DAC extension, this is not right. You can add custom fields to the DAC extension and not write an logic.
this code you need to add to the the graph. i.e. public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
You need to extend POOrderEntry graph and add logic to transfer fields values from one screen to another.
public class POOrderEntry_Extension : PXGraphExtension<POOrderEntry>
{
protected void POLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)
{
var row = (POLine)e.Row;
if (row == null) return;
// Fetch the custom field value from the InventoryItem
InventoryItem inventoryItem = PXSelect<InventoryItem,
Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
.Select(Base, row.InventoryID);
InventoryItemExt inventoryItemExt = inventoryItem.GetExtension<InventoryItemExt>();
if (inventoryItemExt != null)
{
POLineExt rowExt = PXCache<POLine>.GetExtension<POLineExt>(row);
rowExt.UsrCustomField = inventoryItemExt.UsrCustomField;
}
}
}
Hey
can you let me know what is the base graph that I shall select?
+10Hi
Have you added custom field in the Inventory item DAC which you needed to pass to the POLine?
Hi
Have you added custom field in the Inventory item DAC which you needed to pass to the POLine?
Yes, it is in other pkg
+10Then, you need to give reference of that package to include the InteventoryItemExt DAC. i.e. using AnotherPackageNamespaceName.
Then, you need to give reference of that package to include the InteventoryItemExt DAC. i.e. using AnotherPackageNamespaceName.
What if I add it under same pkg with your above code?
+10It will helpful to you, if you add custom field of InventoryItem DAC to the same package, So you do not need to give another package reference.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
