How to add Shortcut dimension 3,4 and 5

oslec
oslec Member Posts: 7
edited 2010-06-03 in NAV/Navision Classic Client
Hi Expert,

Im working with Customer Top 10 List Report and I want to add Shortcut dimension 3,4 and 5 on the report. how can i add this fields?

Sory for a newbie post

Thanks

Comments

  • ufuk
    ufuk Member Posts: 514
    Do you want to filter amounts by dimensions?
    Ufuk Asci
    Pargesoft
  • oslec
    oslec Member Posts: 7
    Yes i want to filter it in amounts by dimension

    thanks ufuk for the help
  • ufuk
    ufuk Member Posts: 514
    You have to sum amounts in Cust. Ledger Entry table by querying the Dim values you pass.
    You can write a function in the report in which you pass the customer no and dimension value. You filter CLE with customer no and go ledger entry dimension with CLE's entry no. If it has the dim. value you pass then you continue to sum. When it's finished, assign this value to the related field in Customer Amount table.
    Ufuk Asci
    Pargesoft
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • oslec
    oslec Member Posts: 7
    Thanks alot ufuk

Categories