The sum of the values in Outst. field cannot be calculated

strangiato

Symptom:
When selecting a production line in "Manufacturing / Order Planning" the following message appears:

The sum of the values in the Outstanding Qty. (Base) field cannot be calculated because the filter contains question marks (?), asteriks (*), or 'at' symbols (@). See attached file.

Questions:
As a user, I am not familiar with this kind of messages. While the selection of the Production line has nothing to do with the mentioned filter (I do not define a filter in this case, just selecting one line), I can not understand the reason for this error message.

Thanks for guiding to a solution and/or reason for this problem.

Dynamics NAV 2009 SP1, version BE Dynamics NAV 6.0 SP1 (running as SQL)

afarr

The error message also lists the filters that are being applied.
In particular, Variant Code is being filtered to *. Of course, this just lists all entries, so that filter is redundant.

1. List all the filters (View - Table Filter), and remove the one on the Variant Code.

2. Since you're not setting filters yourself, it may be that there's some code that is setting it.
So contact your solution provider to tell them about the issue.

strangiato

ok, thanks for the advice.

Probably, the error message will be caused by some code, as you indicate. As a result, we need to check it with our provider.

One remark is that exactly the same process works fine in the Native database (and fails with the error message in the SQL server).