News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL forum Different # of invoice...

Microsoft Dynamics SL forum

Unanswered

Different # of invoices printed for two companies

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello,

We are running two companies/application databases. One company would like 2 invoices to print from the shippers screen. Another company would just like 1 invoice to print.

I am familiar with using SQL to update the system database to update the copies allowed.

https://community.dynamics.com/product/sl/f/35/t/23472.aspx

USE <systemdatabase>
UPDATE RptControl
SET CopiesAllowed = 2
WHERE ReportNbr = '40680'

However this updates for both companies. Is there a way to have different copies for each company?

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Different # of invoices printed for two companies

Perhaps there is a way to print only one report, but customize the Crystal Report to determine which company is printing and then print 1 or 2 copies based on that? I'm not experienced in Crystal enough to know how to go about that, but it seems like an interesting idea...

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2

Martin Dráb 228,588 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans