Is there a way or something I am missing that will not show discounts on the line or document level to select if they are expired, a sequence doesn’t exist, or the sequence is marked as inactive? We have old discounts codes we don’t use anymore and even if I have deleted all sequences or inactivated all sequences they still show up to select on sales orders. There is an error when selected, but we don’t want these to even show.
Solved
A way to hide Inactive Discount Codes on Sales Orders?
Best answer by nasir
Hi
No, there is no functional configuration (screen checkbox, feature toggle, or setup option) in Acumatica to automatically hide expired, inactive, or sequence-less discount codes (ARDiscount) from sales order selectors (SOLine.DiscountID, SOOrderDiscountDetail.DiscountID). The selector shows all ARDiscount records regardless of DiscountSequence status—inactivating sequences or unchecking Active on ARDiscount reduces errors but doesn't filter the dropdown.
Hello
but you can use this snippet and keep Uncheck that Active checkbox & it will hide those Inactive discount codes without deleting sequence or code :
[PXMergeAttributes(Method = MergeMethod.Replace)]
[PXSelector(typeof(Search2<
ARDiscount.discountID,
InnerJoin<DiscountSequence,
On<DiscountSequence.discountID, Equal<ARDiscount.discountID>>>,
Where<
DiscountSequence.isActive, Equal<True>,
And<DiscountSequence.isActive, Equal<True>,
And<Where<
DiscountSequence.endDate, IsNull,
Or<DiscountSequence.endDate, GreaterEqual<Current<AccessInfo.businessDate>>>>>>>>))]
protected void _(Events.CacheAttached<SOOrderDiscountDetail.discountID> e)
{
}you can add this in SO graph.
I hope it helps!
Hi
No, there is no functional configuration (screen checkbox, feature toggle, or setup option) in Acumatica to automatically hide expired, inactive, or sequence-less discount codes (ARDiscount) from sales order selectors (SOLine.DiscountID, SOOrderDiscountDetail.DiscountID). The selector shows all ARDiscount records regardless of DiscountSequence status—inactivating sequences or unchecking Active on ARDiscount reduces errors but doesn't filter the dropdown.
Hi
can modify the CacheAttached or DAC attribute on ARSalesPrice/DiscountCode selector used on the sales order to add a Where<DiscountSequence.isActive, Equal<True>>
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.