I have custom fields on Sales order header. I want the fields active and mandatory only when order type is “XR”. Please assist how i can achieve that in Acumatica customization. The fields will be invisible if order type is any other
Best answer by Giri K
View original
Create Extension graph for SOOrderEntry and add below code
public virtual void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler)
{
Base.Document.View.RequestRefresh();
if (baseHandler != null)
baseHandler(cache, e);
var row = (SOOrder)e.Row;
if (row == null)
return;
if(row!=null)
{
//SOOrderExtension is Extension DAC for SO Header table
SOOrderExtension soExt = row.GetExtension<SOOrderExtension>();
if (row.OrderType=="XR")
{
PXUIFieldAttribute.SetVisible<SOOrderExtension.FieldName>(cache, null, true);
PXDefaultAttribute.SetPersistingCheck<SOOrderExtension.FieldName>(cache, null, PXPersistingCheck.NullOrBlank);
}
else
{
PXUIFieldAttribute.SetVisible<SOOrderExtension.FieldName>(cache, null, false);
PXDefaultAttribute.SetPersistingCheck<SOOrderExtension.FieldName>(cache, null, PXPersistingCheck.Nothing);
}
}
}
Thank you, this worked in making it visible or invisible depending on order type. However the fields still not mandatory
setting [PXDefault()] in the DAC will also be trigger even when order type is not “XR” and will not allow saving of document
Try this attribute in Field
[PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]
+4
Hi
Do the validation on RowPersisting checking for the order type XR.
[PXLocalizable()]
public static class Messages
{
public const string FieldErrorMessage = "Field Error Message";
public const string ErrorMessage = "Error Message";
}
public static class SOOrderTypeConstantsExt
{
public static string XR { get { return new xr().Value; } }
public class xr : PX.Data.BQL.BqlString.Constant<xr>
{
public xr() : base("XR") { }
}
}
protected void _(Events.RowPersisting<SOOrder> e)
{
if (e.Row != null)
{
PXEntryStatus entryStatus = e.Cache.GetStatus(e.Row);
if (entryStatus == PXEntryStatus.Inserted || entryStatus == PXEntryStatus.Updated)
{
SOOrder so = e.Row as SOOrder;
SOOrderExt ext = e.Row.GetExtension<SOOrderExt>();
if(so.OrderType == SOOrderTypeConstantsExt.XR)
{
if(ext.UsrField == null /* && <YOUR BUSINESS RULE> */)
{
e.Cache.RaiseExceptionHandling<SOOrderExt.usrField>(e.Row, null, new PXSetPropertyException(Messages.FieldErrorMessage, PXErrorLevel.Error));
throw new PXException(Messages.ErrorMessage);
}
}
}
}
}Happy to help
+11
Using [PXUIRequired] would possibly be a less verbose option, as indicated here.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.