Dynamics NAV 2013 R2 Trailing space in vendoe card

Asharaf
Asharaf Member Posts: 12
edited 2014-05-20 in NAV Three Tier
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 ?

Comments

  • geordie
    geordie Member Posts: 655
    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.
    * Daniele Rebussi * | * Rebu NAV Diary *

Categories