PO Selector for Custom Form

  • 25 August 2021
  • 1 reply

Userlevel 1

I have created a custom form which captures inventory id and supplier, based on those selections, I need to have a PO number selector which shows the relevant PO number. How can I modify this code snippet, because at the moment it shows all PO Numbers.

 #region PONumber
[PXDBString(50, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "PO Number")]
LeftJoinSingleTable<Vendor, On<POOrder.vendorID, Equal<Vendor.bAccountID>,
And<Match<Vendor, Current<AccessInfo.userName>>>>>,
Where<POOrder.orderType, Equal<Optional<POOrder.orderType>>,
And<Vendor.bAccountID, IsNotNull>>,
OrderBy<Desc<POOrder.orderNbr>>>), Filterable = true)]
public virtual string PONumber { get; set; }
public abstract class pONumber : PX.Data.BQL.BqlString.Field<pONumber> { }



Best answer by Naveen B 27 August 2021, 04:57

View original

1 reply

Userlevel 7
Badge +10

Hi @TharidhiP  Below code is sample selector example, where we can load all the QT type orders. 

Hope this helps!!


new Type[] { typeof(SOOrder.orderNbr), typeof(SOOrder.orderDate), typeof(SOOrder.customerID), typeof(SOOrder.customerID_Customer_acctName)
, typeof(SOOrder.customerLocationID), typeof(SOOrder.status), typeof(SOOrder.curyOrderTotal), typeof(SOOrder.customerOrderNbr),



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 — 2020  Acumatica, Inc. All rights reserved