Hi everybody,
I am creating a new menusuite for a customer after upgrading from 3.70. We were using the table view option in version 370 and I don't know how to use this feature in version 400.
For example:
in 370 we were opening the customer card with a filter (for example country code=D). In 370, we just entered the runformview option in the command button on the menu. The entry there was "WHERE(Country code=FILTER('D'))". This saved a couple of new forms because we were able to use the standard customer form.
How can I do that in version 400? I don't see any properties to set! Did I miss it? Or do I need to create extra forms and set the filter in the form?
Any hints?!
Thanks a lot.
Best regards.
N. Gebhard
ProTAKT Projekte & Business Software AGMicrosoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt 0
Comments
Only workaround options are
1. Create different forms with different tableviews
2. Create a codeunit which calles the form with a filter
3. Start a 3.70 menu from the navigation pane.
If anyone knows other workarounds, let me know please,
greetz,
Marq
I think this filter will only appear for specific users. Some users should see all customers or customer from GB, ...
Another workaround (or possibly a solution for your case) could be:
Put a new field "Country Code Filter" in the table "User Setup".
In the customer card in the trigger OnOpenForm get this value and apply this to the customer records.
Microsoft Dynamics NAV Developer since 1997
MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
By the reason that we have a couple of users which are supposed more than one option the workaround is not usable. The customer card was just an example, we use it with orders as well. We have different categories of orders which should show up in different menus and some user use all of them.
If I found out something new I will let you know. Maybe I try the codeunit hint. Otherwise I just created own forms.
Thanks!
N. Gebhard
Microsoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt
well I just know this theoretically, means I have just read that such problems might get solved by the feature: "Responisibility Center"?
Michael
Since some user are supposed to have more than one option? Otherwise this would be a good help..
Microsoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt
Expect this to be much further developed in the future where you will be developping more role-based forms.
However it would be nice to be able to run a form with a pre-defined filter from a menu.
Maybe this is Microsofts way to force you to make different forms for different roles? 8)
But I will try the codeunit solution first. Seems to be a good idea to save forms..
Microsoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt
Solution:
make a form for every option?!
(I think I need to buy some more forms first!!!! =D> )
Microsoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt
You can use codeunits if:
A) You have more free codeunits available in your license than free forms
I am sending it as suggestion to MS... you can add your vote to this...
http://www.microsoft.com/Businesssoluti ... 94dc5cc939
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Here is the answer:
"Unfortunately the new menu system doesn't let us to play with the properties we got in earlier versions. It is because the main focus of the developers was to make it work for the 4.00 release, but there were no more time to do such additional improvements. But I expect to have it in the next version.
The only way to I can suggest is to create small menu forms that you can open from the MenuSuit. And on this menu forms you can create controls (Command Buttons), that already has the desired property.
I know that this isn't the answer you really like to hear, but I hope you can accept this explanation."
Microsoft Dynamics NAV Partner
Bad Nauheim, Germany
http://www.protakt.de
http://twitter.com/protakt