Form doesn't open due to filter

Marcel

The following happend:

A filter is set on the field No. in the form Posted Sales Invoices. The filter is set with a value that doesn't exist. When (after closing the form) trying to open the form Navision gives the error message:

"Sales Invoice Heder No. VFA060001 does not exist"

The error message is correct but how can i open the form ignoring the message or filter?

I know that renaming the zup file is a solution. but i'am looking for a solution to be used by the end-users

Can anyone help me out?

Marije_Brummel

You can design the form and save without changes. The zupfile will think it is modified and ignore the previous filter.

Phenno

Mark Brummel wrote:

You can design the form and save without changes. The zupfile will think it is modified and ignore the previous filter.

At the end, I made a small batch file that delete zup file (or files) in user folder. Named it "Delete ZUP" and put it on the desktop.

End user (specially if he/she is sales manager or non-it person) should not have privileges to edit forms...

kine

How to precede these situations:

Look into standard Card form (for example Customer card). You will se in the OnAfterGetRecord trigger this line:

SETRANGE("No.");

This line will reset the PK filter to precede this error. This "filter reset" is done on nearly all standard card forms which are opened from main menu.

And another solution if you are not using this filter reset: if you have form designer, you just needs to save the object without any change. Of course, do not forget to restore Date and time of modification and the Modified flag.

kriki

Other solutions:

-in the properties of the form:"SaveTableView" put this to No. Like this the filters will NOT be saved into the zup-file.

-Somewhere in the form a GET or a FIND is programmed without using it's return-value, so if a record is not found, you get an error. To avoid that:use the return-value.