Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Customer statement (Re...
Small and medium business | Business Central, N...
Suggested answer

Customer statement (Report 1316) Word layout fails to Render

(0) ShareShare
ReportReport
Posted on by Casper 10
I have a custom Word Layout for Report 1316, customer statement.  We use this same layout on almost 70 companies.  It works on all of them and suddenly just stop working for one specific company.
 
To be clear, this is only happening on one company.  I have tried the following.
 
  1. Customer Reports (RDLC) works just fine.
  2. I tried different Customer Statement (1316)  Word Layouts, they also don't work.  In short (No report 1316 Word Layouts work on this company), not even the email layout.
  3. On furhter investigation, it seems no Word layout reports works on this company
 
the error below
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Customer statement (Report 1316) Word layout fails to Render
    Try to create a new Custom Word layout for this Report, and add just few values - to check if the word can be generated at all. If yes, then it is issue with the layout or some specific data.
    Next thing You can try to delete this Company Bank account value from the current layout - where Company bank account is generated, and see if then it generates normally. If yes - try adding it back manually. (You can copy this part to some online tool to view if there are any invisible symbols copied - for example in here: View non-printable unicode characters (soscisurvey.de))

    If the first part already failed and You cannot generate a word layout report with only 1 value in the layout, then it could be that some more technical issue is happening. You can also try to do this from different computer ( but as other companies work well for You, I don't think it is a local pc problem)
  • Casper Profile Picture
    Casper 10 on at
    Customer statement (Report 1316) Word layout fails to Render
    Thanks TimH, 
     
    Considering that I use the exact same report on 70 other companies where it still workd perfectly, the embedded code must be in the Filed, and not the report.  Do you know how I can check that and remove it, if it's part of the field?
  • TimH Profile Picture
    TimH 2 on at
    Customer statement (Report 1316) Word layout fails to Render

    a bit of a clue maybe that could point you in the right direction:

     

    &#xC' is  (I think !) a form feed (FF) code that was designed to control printer behaviour. it looks like you have two of those codes either in the field data or somehow embedded into the design of the word report. The Form Feed code will usually cause the printer to spit out a piece of paper.

     

    CTRL + L replicates this in Word ("Page Break"). Wondering if someone input that into a record somewhere (from pasting data from somewhere else) maybe something like Company Information or one of the other fields the word layout is using.


    It's almost certainly not an XML compatible code.

  • Casper Profile Picture
    Casper 10 on at
    Customer statement (Report 1316) Word layout fails to Render
    I checked latest Error, but could not find that it reported anything.
     
    I found something in the mean time.
     
    1. It seems that I can create a layout of type Word, BUT have only successfully done this with report 1320, which is a notification.
    I found a problem with the Bank Account number if I pull report 1316 in both Excel and XML. (I obviously changed the account numbers)
     
    Example from Report 1316 Word Layout - company with the issue
    <Column name="BankAccNo_CompanyInfo">123456789&#xC;&#xC;</Column>
     
    Example from Report 1316 RDLC Layout - company with the issue
    <Column name="BankAccNo_CompanyInfo">123456789</Column>
     
    Example from Report 1316 Word Layout - company without the issue
    <Column name="BankAccNo_CompanyInfo">123456789</Column>
     
    I went to Company information, removed the bank account number entirely, pulled the same report then it returned this.
     
    Example from Report 1316 Word Layout - company with the issue
    <Column name="BankAccNo_CompanyInfo">&#xC;&#xC;</Column>
     
    It seems this is added to the Word layouts and that I am unable to create any word layouts with this issue, it does not happen on RDLC layouts.  Does anyone know what this is and why this would happen.  I don't know how to remove that.
     
  • gdrenteria Profile Picture
    gdrenteria 12,167 Most Valuable Professional on at
    Customer statement (Report 1316) Word layout fails to Render
    Hi
    Is there a way for you to debug the process, that is, when you run the report?
    If you are looking for the "latest error" of business central. do you see something different?
    BR
    GR

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans