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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Different # of invoice...
Microsoft Dynamics SL (Archived)

Different # of invoices printed for two companies

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    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...

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans