Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Friday, March 03, 2006

Speeding up Zipcode lookup form

Have you ever looked up a new zipcode within axapta and it takes forever to actually take you to the one you entered? Well below is code that you can use that replaces the lookup, and only pulls in what you have typed:

// Changed added that will make the lookup faster based on what is typed in - JBG -
if(CallerAddressMap.ZipCode != "")

zipCode_ds.query().dataSourceTable(tableNum(ZipCode)).addRange(fieldNum(ZipCode, ZipCode)).value(CallerAddressMap.ZipCode);

// END

So with this you get only the addresses you are looking for to pull up, plus it happens a whole lot faster.

Well look for more code, To Increase posting, and my review of the book by Scott Hamilton "Managing your Supply Chain with Axapta"

Find a job at: www.DynamicsAXJobs.com


Post a Comment

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved