Options

How to add Shortcut dimension 3,4 and 5

oslecoslec Member Posts: 7
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

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

    thanks ufuk for the help
  • Options
    ufukufuk 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
  • Options
    krikikriki Member, Moderator Posts: 9,098
    [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!


  • Options
    oslecoslec Member Posts: 7
    Thanks alot ufuk
Sign In or Register to comment.