mibuso.com

Microsoft Business Solutions online community
It is currently Thu Oct 23, 2014 4:27 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: speed up filtering field from another table
PostPosted: Thu Dec 29, 2011 11:08 am 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
hi all
my item ledger entry, I add another field which is using flowfield (lookup from ledger entry dimension)O
and it show for dimension 3 which is not available in table item ledger entry
because my customer's database is very huge, it is very slow to filter it
is there any idea how to speed up filtering the flowfield field?
thanks


Top
 Profile E-mail  
 
 Post subject: Re: speed up filtering field from another table
PostPosted: Thu Dec 29, 2011 11:26 am 
Offline
Site Admin
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Sun Nov 07, 1999 8:01 am
Posts: 3501
Location: Wilrijk
Country: Belgium (be)
If you go for speed, you'll have to add a normal field "Dimension 3" on the Item Ledger Entry table and populate that during posting. "Flowfields" and "speed" are usually two opposites.

_________________
No support using PM or e-mail - Please use this forum.
Search is your friend || Mark your Topic as SOLVED (= green checkmark) when your question is answered || Read the Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: speed up filtering field from another table
PostPosted: Thu Dec 29, 2011 11:31 am 
Offline

Joined: Wed Sep 29, 2010 3:18 am
Posts: 764
Country: Australia (au)
Luc Van Dyck wrote:
If you go for speed, you'll have to add a normal field "Dimension 3" on the Item Ledger Entry table and populate that during posting. "Flowfields" and "speed" are usually two opposites.


hmmm... that's mean cant be done
ok then... thanks for the share


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Exabot [Bot], nverma and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: