speed up filtering field from another table

julkifli33julkifli33 Member Posts: 1,073
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

Comments

  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • julkifli33julkifli33 Member Posts: 1,073
    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
Sign In or Register to comment.