Solved

PO Selector for Custom Form

  • 25 August 2021
  • 1 reply
  • 102 views

Userlevel 3
Badge +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")]
[PO.RefNbr(typeof(Search2<POOrder.orderNbr,
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> { }
#endregion

 

icon

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

View original

1 reply

Userlevel 7
Badge +17

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

Hope this helps!!

 

[PXSelector(typeof(Search<SOOrder.orderNbr,Where<SOOrder.orderType,Equal<SOOrderTypeConstants.quoteOrder>>>), 
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),
typeof(SOOrder.invoiceNbr)})]

 

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