Solved

Additional columns to the Location column lookup of the Sales Orders form

  • 8 September 2023
  • 2 replies
  • 78 views

Hi community! 

I am trying to add extra columns to the Location lookup on the Details tab of the Sales Order form. 
I tried the following, but it is showing only the new columns and removing the original ones 

    public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
{
#region CacheAttached
[PXMergeAttributes(Method = MergeMethod.Merge)]
[SOLocationAvail(typeof(SOLine.inventoryID), typeof(SOLine.subItemID), typeof(SOLine.costCenterID), typeof(SOLine.siteID), typeof(SOLine.tranType), typeof(SOLine.invtMult))]
[PXCustomizeSelectorColumns(
typeof(PX.Objects.IN.INLocation.locationCD),
typeof(PX.Objects.IN.INLocationStatus.qtyAvail),
typeof(PX.Objects.IN.INLocationStatus.qtyOnHand),
typeof(PX.Objects.IN.INLocationStatus.active),
typeof(PX.Objects.IN.INLocation.receiptsValid),
typeof(PX.Objects.IN.INLocation.salesValid),
typeof(PX.Objects.IN.INLocation.transfersValid),
typeof(PX.Objects.IN.INLocation.projectID),
typeof(PX.Objects.IN.INLocation.taskID),
typeof(PX.Objects.IN.INLocation.primaryItemID),
typeof(PX.Objects.IN.INLocation.primaryItemClassID))]
public virtual void SOLine_LocationID_CacheAttached(PXCache sender) { }
#endregion
}


Could someone help me keep the original columns? 
Thanks!

icon

Best answer by Zoltan Febert 9 September 2023, 02:56

View original

2 replies

Thanks @zfebert56, that solved the problem! 

Userlevel 6
Badge +3

Hi @acalvo06,

You need to use INLocationStatusByCostCenter with this selector, INLocationStatus doesn’t work here.

    public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
{
#region CacheAttached
[PXMergeAttributes(Method = MergeMethod.Merge)]
[SOLocationAvail(typeof(SOLine.inventoryID), typeof(SOLine.subItemID), typeof(SOLine.costCenterID), typeof(SOLine.siteID), typeof(SOLine.tranType), typeof(SOLine.invtMult))]
[PXCustomizeSelectorColumns(
typeof(PX.Objects.IN.INLocation.locationCD),
typeof(PX.Objects.IN.INLocationStatusByCostCenter.qtyAvail),
typeof(PX.Objects.IN.INLocationStatusByCostCenter.qtyOnHand),
typeof(PX.Objects.IN.INLocationStatusByCostCenter.active),
typeof(PX.Objects.IN.INLocation.receiptsValid),
typeof(PX.Objects.IN.INLocation.salesValid),
typeof(PX.Objects.IN.INLocation.transfersValid),
typeof(PX.Objects.IN.INLocation.projectID),
typeof(PX.Objects.IN.INLocation.taskID),
typeof(PX.Objects.IN.INLocation.primaryItemID),
typeof(PX.Objects.IN.INLocation.primaryItemClassID))]
public virtual void SOLine_LocationID_CacheAttached(PXCache sender) { }
#endregion
}

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved