Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Different # of invoice...

Different # of invoices printed for two companies

(0) Share

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?

*This post is locked for comments

All responses (1)

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...