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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Sales invoice report 10074 instead of 1036?

(0) ShareShare
ReportReport
Posted on by 171

We have requested a Sales Invoice customization that requires a new 'report' ID. Our vendor is claiming that the --hidden-- Posted Sales Invoice report 10074 is the 'U.S. version" of the Sales Invoice report, rather than 1036. The vendor also states that 10074 is better setup as a starting point for them (something about 10074 containing a temp table already which they can leverage for the customization). 

It seems like Microsoft is pushing Word for documents. 10074 is RDLC. They are unable to answer whether it is usable in Word; I was not able to get it working. We want to preserve the ability to produce custom layouts for the new custom 'report' we will get.

Any insight into 10074? Is it really the 'recommended U.S. Sales Invoice'? Is it usable in Word? Anywhere to read up on all of this?  

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    150 on at

    The recommendation to use word stems from the ease of use. It’s worth considering that in some cases word isn’t suitable as you can’t manipulate data in word it is just a presentation tool for the data. I’m not clued up on the US version but I would give your partner the advantage here. They are correct that report 1306 (think you made a typo) is used in other localisations, such as GB. That one comes with a word layout already but it is a simple invoice. For example it doesn’t have a detailed VAT breakdown. With sales tax in the mix I’d assume you need something fit for purpose.

  • Len C Profile Picture
    171 on at

    Thanks, Josh. Yes, 1306. For what it's worth, MS' recommendation to use Word also appears related to performance advantages. Though a couple of extra seconds may not be an issue for us. Ease of use was the primary objective.

    One concern with RDLC: formatting. Word allows very fine control. I was able to produce a 1306 template with first-page vs. subsequent page headers; widow and orphan control (no split rows or split paragraphs); and precise spacing. A 2-page invoice generated with this Word template came out as 6 pages using the default 10074 RDLC template - largely due to 10074's header taking up around 60% of every page. Perhaps RDLC has finer control than the default 10074 report utilized.

    The 10074 dataset contains line-level tax info, but it's not clear to me where overall invoice totals are available in the dataset. I.e., where are the lines for printing the traditional closing 'Subtotal'/'Tax'/'Grand Total' lines. 1306 includes a collection for summary lines.

    10074 is currently missing job# and job task# for lines associated with jobs, at least as of v16.5. We may have the VAR add these.

    I'll have to dig-in to RDLC. It's a little disappointing, however, that the 10074 dataset appears tied to RDLC, rather than being usable in Word.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans