AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Sales Order Custome...
 
Notifications
Clear all

Questions Sales Order Customer Lookup

 
Everything Else
Last Post by Tim Rodman 7 years ago
5 Posts
2 Users
0 Reactions
3,355 Views
RSS
Paul
Posts: 18
 Paul
Topic starter
July 3, 2018 12:35 pm
(@pmccormack)
Eminent Member
Joined: 5 years ago

Hi again Tim,
 Hope all is well.
I'm attempting to initially sort the customer lookup by account name.
In the DAC, selecting SO.SOrder and Customizing the attributes, I selected "Replace Original" and added this: 

[PXDefault]
[CustomerActive(typeof(Search<BAccountR.bAccountID,Where<Customer.type, IsNotNull,
Or<Current<SOOrder.aRDocType>, Equal<ARDocType.noUpdate>,
And<BAccountR.type, Equal<BAccountType.companyType>>>>, OrderBy<Asc<BAccountR.acctName>>>),
Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName), Filterable = true)]

Notice I only added , OrderBy<Asc<BAccountR.acctName>>.

After a successful build and opening SOOrder screen, I get this error:
Error: The parameter length exceeds the allowed value.
Parameter name: types 

   at PX.Data.BqlCommand.Compose(Type[] types) 
   at PX.Objects.AR.CustomerAttribute..ctor(Type search, Type[] fields) 
   at System.Reflection.CustomAttribute._CreateCaObject(RuntimeModule pModule, IRuntimeMethodInfo pCtor, Byte** ppBlob, Byte* pEndBlob, Int32* pcNamedArgs) 
   at System.Reflection.CustomAttribute.CreateCaObject(RuntimeModule module, IRuntimeMethodInfo ctor, IntPtr& blob, IntPtr blobEnd, Int32& namedArgs) 
   at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimeModule decoratedModule, Int32 decoratedMetadataToken, Int32 pcaCount, RuntimeType attributeFilterType, Boolean 

Thanks for your help.

--Paul


4 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
July 4, 2018 4:28 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Paul,

I recommend posting this on StackOverflow:

http://stackoverflow.com/questions/tagged/acumatica


Reply
Paul
Posts: 18
 Paul
Topic starter
July 5, 2018 11:39 am
(@pmccormack)
Eminent Member
Joined: 5 years ago

Thanks Tim.


Reply
Paul
Posts: 18
 Paul
Topic starter
July 6, 2018 12:06 pm
(@pmccormack)
Eminent Member
Joined: 5 years ago

Here is the answer on StackOverflow.

https://stackoverflow.com/questions/51195699/initially-sort-sales-order-customer-lookup-on-acctname

https://stackoverflow.com/questions/47205078/modify-selector-default-sorting


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
July 12, 2018 3:43 am
(@timrodman)
Famed Member
Joined: 10 years ago

Thanks for posting the links Paul


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 49 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×