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

Sales invoice report 10074 instead of 1036?

(0) ShareShare
ReportReport
Posted on by 149

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
    133 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
    149 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

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,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans