Dynamics NAV 5.0 and Style Sheet issues, issue with '/' character in customer(vendor) name

  • Article

When running forms like Customer (Vendor) Ledger Entries and Apply Customer(Vendor) Ledger Entries, and selecting: send-to Excel, the following error occurs  if customer (vendor) name contains character '/':

Problems came up in the following areas during load:

Workbook setting ....

To correct this issue, open the style sheet file in notepad, default file is NavisionFormToExcel, placed in Stylesheet folder of the Client folder. Browse to the following section and replace the marked line :  

 <xsl:template match="Control[@type='TableBox']">
<Worksheet xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="//Object/@caption"/> <!-- replace this line !-->
</xsl:variable>

with 

     <xsl:value-of select="translate(//Object/@caption,'\/:*?>|','')"/>

 

Then browse to the following section and replace the section:

 <xsl:template match="Control[@type='Frame']">
<Worksheet xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:value-of select="@caption"/> <!--changed line!-->
<xsl:if test="@caption = ''">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="//Object/@caption"/> <!--changed line!-->
</xsl:variable>

 

with:

 

 <xsl:template match="Control[@type='Frame']">
<Worksheet xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<xsl:attribute name="ss:Name">
<xsl:value-of select="translate(@caption,'\/:*?>|','')"/> <!--changed line!-->
<xsl:if test="@caption = ''">
<xsl:variable name="TableBoxCaption">
<xsl:value-of select="translate(//Object/@caption,'\/:*?>|','')"/> <!--changed line!-->
</xsl:variable>

 

Jasminka Vukovic

Microsoft Dynamics NO

Microsoft Customer Service and Support (CSS) EMEA

These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.