I want to modify report 111 to show top 10 customers for a particular branch and departments if the filter is added on the request form. We have branches and departments as GL dim 1 and GL dim 2 and this info is available on cust. ledger table.
I tried adding a data item (cust. ledger) and linked it with customer table.When I tried to run the report with my filters it just kept sorting. Nothing comes out.
Can someone help me.
One more thing is that we don’t have these dimensions on customer table itself.
I needed some help with the coding that’s why I posted in the developers forum. I have been modifying the reports succesfully and understand the logic of coding a little bit. I have not come across the sumindex problem before.
Adding removing or modifying keys in a Navision database is one of the most dangerous things you can do if you don’t know what you are doing.
Its a simple job for your partner to do. In fact almost certainly the key is alrady there and just needs activation. It will probably be just a quick 10 min phone call, since THEY KNOW YOUR SYSTEM. We don’t. If you activate the wrong key, or add a new key with the wrong field sequence or in the wrong position it can affect yoru system dramatically.