How to add Shortcut dimension 3,4 and 5

oslec

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

ufuk

Do you want to filter amounts by dimensions?

oslec

Yes i want to filter it in amounts by dimension

thanks ufuk for the help

ufuk

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.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

oslec

Thanks alot ufuk