I have tried different methods for this case. I could change the lookup using an attribute, but for manual entry and for the Prev/Next/Last buttons, it doesn’t work. When I write e.NewValue = null or e.Cancel, or throw some exception in FieldUpdating/FieldVerifying, in some cases it returns an error, but the record still gets displayed. I tried using a Current Document delegate to change and add restrictions and also wrote a restriction attribute, but these options didn’t work either.
Solved
How to prevent selecting certain order numbers in Sales Order Entry using customization?
Best answer by darylbowman
Try this:
[PXViewName(Messages.SOOrder)]
[PXCopyPasteHiddenFields(typeof(SOOrder.showDiscountsTab))]
public SelectFrom<SOOrder>
.LeftJoin<Customer>
.On<SOOrder.customerID.IsEqual<Customer.bAccountID>>
.LeftJoin<UserPreferences>
.On<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>
.Where<SOOrder.orderType.IsEqual<Optional<SOOrder.orderType>>
.And<Customer.bAccountID.IsNull
.Or<Match<Customer, AccessInfo.userName.FromCurrent>>>
.And<SOOrder.branchID.IsEqual<UserPreferences.defBranchID>
.Or<UserPreferences.defBranchID.IsNull>>>.View Document;If you don’t already have it defined, you’ll need to add this ‘using’ statement:
using PX.Data.BQL.Fluent;
+16What version of Acumatica are you using?
+16In 25 R1, the original BQL looks like this:
[PXViewName(Messages.SOOrder)]
[PXCopyPasteHiddenFields(typeof(SOOrder.showDiscountsTab))]
public PXSelectJoin<SOOrder,
LeftJoinSingleTable<Customer, On<Customer.bAccountID, Equal<SOOrder.customerID>>>,
Where<SOOrder.orderType, Equal<Optional<SOOrder.orderType>>,
And<Where<Customer.bAccountID, IsNull,
Or<Match<Customer, Current<AccessInfo.userName>>>>>>> Document;Your desired BQL (according to you) looks something like this:
...I want to add something like the second code...
[PXViewName("Sales Order")]
[PXCopyPasteHiddenFields(new Type[] { typeof(SOOrder.showDiscountsTab) })]
public PXSelectJoin<SOOrder, LeftJoinSingleTable<Customer, On<Customer.bAccountID, Equal<SOOrder.customerID>>>, Where<SOOrder.orderType, Equal<Optional<SOOrder.orderType>>, And<Where<Customer.bAccountID, IsNull, Or<Match<Customer, Current<AccessInfo.userName>>>>>>> Document;.LeftJoin<UserPreferences>
.On<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>
.Where<
Where<
SOOrder.orderType.IsEqual<SOOrder.orderType.AsOptional>
.And<Where<Customer.bAccountID, IsNotNull>>
.And<SOOrder.branchID.IsEqual<UserPreferences.defBranchID.FromCurrent>
.Or<UserPreferences.defBranchID.FromCurrent.IsNull>>
.Or<Exists<Select<SOOrderType, Where<SOOrderType.orderType, Equal<SOOrder.orderType>, And<SOOrderType.aRDocType, Equal<ARDocType.noUpdate>, And<SOOrderType.behavior, In3<SOBehavior.sO, SOBehavior.tR>>>>>>>
>
>
.OrderBy<Asc<SOOrder.orderNbr>>
So I repeat, what is this code block supposed to be doing?
.Or<Exists<Select<SOOrderType, Where<SOOrderType.orderType, Equal<SOOrder.orderType>, And<SOOrderType.aRDocType, Equal<ARDocType.noUpdate>, And<SOOrderType.behavior, In3<SOBehavior.sO, SOBehavior.tR>>>>>>>
>
>
+16Try this:
[PXViewName(Messages.SOOrder)]
[PXCopyPasteHiddenFields(typeof(SOOrder.showDiscountsTab))]
public SelectFrom<SOOrder>
.LeftJoin<Customer>
.On<SOOrder.customerID.IsEqual<Customer.bAccountID>>
.LeftJoin<UserPreferences>
.On<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>
.Where<SOOrder.orderType.IsEqual<Optional<SOOrder.orderType>>
.And<Customer.bAccountID.IsNull
.Or<Match<Customer, AccessInfo.userName.FromCurrent>>>
.And<SOOrder.branchID.IsEqual<UserPreferences.defBranchID>
.Or<UserPreferences.defBranchID.IsNull>>>.View Document;If you don’t already have it defined, you’ll need to add this ‘using’ statement:
using PX.Data.BQL.Fluent;
Try this:
[PXViewName(Messages.SOOrder)]
[PXCopyPasteHiddenFields(typeof(SOOrder.showDiscountsTab))]
public SelectFrom<SOOrder>
.LeftJoin<Customer>
.On<SOOrder.customerID.IsEqual<Customer.bAccountID>>
.LeftJoin<UserPreferences>
.On<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>
.Where<SOOrder.orderType.IsEqual<Optional<SOOrder.orderType>>
.And<Customer.bAccountID.IsNull
.Or<Match<Customer, AccessInfo.userName.FromCurrent>>>
.And<SOOrder.branchID.IsEqual<UserPreferences.defBranchID>
.Or<UserPreferences.defBranchID.IsNull>>>.View Document;If you don’t already have it defined, you’ll need to add this ‘using’ statement:
using PX.Data.BQL.Fluent;
Thank you, this really helps.
+16Please start a new question. You can reference this one and tag me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.