Item Number with an invisible line character

(0) Share

Report

Posted on by Community Member

We got an issue with an item number that is created in Navision. It seems the item number was created and there is an invisible line character on it. So when we are trying to do the bin movement on this item we are getting an error since this is affecting the "Available Quantity to Move".

This is causing some warehouse issue since we cannot do a bin movement due to this problem.

What is the best way to remove the invisible line character from an existing item number? We already have a ledger entries on this item.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

What is the error you are getting ?

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

Did you try renaming the Item by opening the Item Card and edit the "No."?

Best Regards,

MMV

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

If you rename the item no. from the "item card" all the related ledger entries will be also renamed.

Can you post a screen capture with the error?

Good luck!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I do not think we got an error message. It is just when doing a bin movement we cannot do it and when you try to find the item using Whole Field - we are not able to do it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We do not allow the No. to be edit once there are item ledgers transactions involved.

We might go to the SQL script route to fix this issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are not allowed to rename the No. in the Item Card. So we are thinking going to route of the SQL script to handle this.

Will keep you posted if we have done it - we are going to test this out first.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

If you rename "No." on the Item Card, it renames everywhere automatically everywhere.

If you use the SQL script, you need to modify everywhere by using the SQL Script (for all the tables). So what is the difference between SQL Script and renaming on the Item Card. Instead, the SQL Script is more time consuming (to write) and it takes enough time verify whether you have modified everywhere.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

I see what you mean. Thanks for the suggestion.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

If you rename an item, NAV will automatically rename all the places where it is properly linked. That is the beauty of Microsoft Dynamics NAV. Having said that there is an small point to be made. If you or your Microsoft Dynamics NAV partner has modified or created new field which hold item number and if the developer didn't set the table relations, then system will not rename the item number for you.

Therefore please be careful when you change item number or any existing masters in the system.

Was this reply helpful? Yes No