AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Everything Else
Sales Order Custome...
 
Notifications
Clear all

Questions Sales Order Customer Lookup

 
Everything Else
Last Post by Tim Rodman 8 years ago
5 Posts
2 Users
0 Reactions
3,796 Views
RSS
Paul
Posts: 18
 Paul
Topic starter
July 3, 2018 12:35 pm
(@pmccormack)
Eminent Member
Joined: 6 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: 3204
 Tim Rodman
Admin
July 4, 2018 4:28 pm
(@timrodman)
Famed Member
Joined: 11 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: 6 years ago

Thanks Tim.


Reply
Paul
Posts: 18
 Paul
Topic starter
July 6, 2018 12:06 pm
(@pmccormack)
Eminent Member
Joined: 6 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: 3204
 Tim Rodman
Admin
July 12, 2018 3:43 am
(@timrodman)
Famed Member
Joined: 11 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,533 Topics
  • 11 K Posts
  • 19 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×