Dynamics NAV 2013 R2 Trailing space in vendoe card

Asharaf

Hi,

I have been upgraded from 2009 R2 to 2013 R2 and after the upgrade I have noticed that when opening some vendors system throws one message "The record that you tried to open is not available. The page will close or show the next record"

I have found that in in 2009 R2 for some vendors having trailing spaces and in 2013 R2 trailing space is not acceptable.

How can I remove these training spaces in Card and also in ledger entry ?

geordie

What about parsing the vendors and all the related tables with a code like this?

CharsToKeep := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
NewVendorNo := DELCHR("Vendor No.",'=',DELCHR("Vendor No.",'=',CharsToKeep));

Of course on Vendor table a rename statement will be required, on most of the related entities a modify will have to be performed.