web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Error when trying to Email Confirmation from Sales Order: Report does not have a valid layout

(2) ShareShare
ReportReport
Posted on by 311
Hello!
 
I have made a custom report for Sales Order Confirmations. The report is a Word layout report, and used to work decently across every instance I uploaded it to.
Usually what we did, was that we added report extensions to add fields specific to the company and their needs. Then we went to Report Layout Selection in Business Central, exported the layout, added the new XML fields, and imported the new layout. We then set it to default, and everything worked well.
 
Recently there was a change in Business Central where Report Layout Selection is being deprecated, and they want us to use User Defined Report Layouts through the Report Layout page. The issue I am facing here, is that I can't seem to get new XML fields in the exported report layout as I used to, so we had to find another way of getting them in there and using the new fields.
 
Now though, I am facing a problem when I go to a Sales Order and press Print/Send > Email Confirmation.
I get the following error: /Report 50102 does not have a valid layout. Valid layout types are: Word, RDLC, Excel, and Custom./
Report 50102 is the custom report I have made. Then I have added a couple fields in a reportextension.
I have a feeling I get the error because the XML fields available in the report does not match the XML fields that have been added through the old method.
A side note is that I am allowed to preview the report when pressing Print/Send > Print Confirmation.
 
Does anyone have an idea of how I can get the right layout using Report Layouts, and how I can avoid getting the error when I try to send the order confirmation?
Even better would be a little guide on how to use the Report Layouts page exclusively to export current layout to get new XML fields if I add more later, because I can't seem to find a good way to do that.
I have the same question (0)
  • KasparsSemjonovs Profile Picture
    4,774 Super User 2025 Season 2 on at
    Check in the "Report Layout Selection" what layout is assigned as default layout. 
    Try to change it? You can create a copy of Built-in RDLC layout, export it and try to import it back. See if there are no errors, if there are - adjust the RDLC layout, or switch to Word layout. Even if the Report Layout Selection will be depreciated - You can still use it to check if the layout works. But I haven't yet tried the new ways....
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    Hi, first of all, as of now, Report Layout Selection is still available, and Microsoft has not yet abandoned this feature.
     
    As for the error you mentioned, it seems to have nothing to do with the missing fields, but the report does not have any layout set. You can specify the default layout on the Report Layouts page.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • Community member Profile Picture
    4 on at
    You can add "DefaultLayout" - property to the report, then it is solved. Worked for me.
  • Suggested answer
    Andyha11 Profile Picture
    4 on at
    Hi Folks,
     
    We had the same error message but trying to email out statements (Report 1316).
    The statement was all configured correctly and would print correctly from report layouts but when we tried to email it out we were getting "Report 1316 does not have a valid layout. Valid layout types are: Word, RDLC, Excel, and Custom., occurred when running report Customer Statement for Customer: " 
    On the customers Document Layout, the statement had the correct statement layout, but there was a checkbox set to use this layout for the body of the email. The problem is you can ONLY use a Word layout for the body of the email and the Statement was an RDLC. If you untick the box, then the statements are sent, but there is no body text in the email. So, we had to create a basic Statement Word Layout to use in conjunction with this for the email body.
     
    Hope this helps someone out :-)

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans