Item and Item Description Error on entry

noved

I have stumbled on a peculiar situation in our Navision 3.6 environment that I cannot explain. It relates to the Item Number and Description field that can best be described by example:

Item Number = 1117335
Description = VPL-8503 24X24X12 Filter

Here is the problem: A sales line is entered and the Item No. value VPL-8503 is entered (which does not exist). Rather than the expected error message stating that the item number does not exist, the value 1117335 is populated in the item number field on the sales line when you tab off the field. (':shock:')


I cannot find any rhyme or reason for this happening. The Description field on the Sales Line table is not a flow field or anything unique. Now if the VPL-8503 portion of the Description field in the Item Table is moved to the end of the field (resulting in the description being 24X24X12 Filter VPL-8503), this situation does not occur. That is, if VPL-8503 were entered on a sales line in the No. field, the expected error that the item does not exist is provided. ('](*,)')


This situation described literally happens wherever you would enter the item as described (sales price entries, purchase price entries, PO Lines, etc.)

Has anyone seen this before or have any idea how it would occur or be prevented other than what was described?

Thanks in advance for your response.

Savatage

It's an AltSearchProperty..

Go to the item table->designer->View the properties of the "No." field

you will see a AltSearchField.

Since you item # is very similar to the description it's finding it.

For example if you changed that altsearchfield to look at UPC codes then you could either enter an item # or a UPC code and get the proper item appearing.

you can also F1 on the altsearchfield - to get further details on how it works. Removing the property value will disable it.

You'll see this in many places. try typing the customers name instead of the cust# in the cust no field on the sales order, etc etc.

DaveT

Hi Noved,

This is a "feature" of Nav - if the item does not exist then it searches the search description of the item - try entering touring into the No. field in Cronus and you get Item 1001.

This doesn't seem to fire any C/AL code so I don't think you can turn it off. Only thing I can suggest is to blank the search descriptions if you don't want this "feature"

It's handy once you get the hang of it

DaveT

Hi Harry,

Didn't know this one :oops: -thanks for enlightening me

Alex_Chow

The only way you can turn this feature off is to set the ValidateTableRelation property to No.

Then on the OnValidate Trigger of the form, do a Item.GET("No.") on the No. field to ensure they're getting the proper item no.

the problem with this solution is that if you decide to RENAME an item number, sales lines will not be affected.

Alex_Chow

Ooppss.. Should've read Harry's post... :oops:

noved

Thank you, Harry. That setting was set to Search Description. That resolved the issue. That was driving me nuts.

Thanks again,
Devon

Savatage

That's one of the reasons we DON'T use descriptive item Numbers.

we use #'s 10000..99999 - make order entry very easy when the person doesn't have to take there hand off the Num Keys.

We used to have Descriptive #'s but after a while they fell apart for us and having to switch between letters & numbers is really time consuming.

So when we went from Macola to Nav it was suggested we change our item numbers at that time (still keeping the old numbers in field No. 2 just in case) But now No.2 is a relic and nobody ever looks at that old # anymore.

It was a good change..for us.