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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / How to prevent Quick S...
Microsoft Dynamics SL (Archived)

How to prevent Quick Send from printing an invoice

(0) ShareShare
ReportReport
Posted on by Dennis C 110

We're setting up Quick Send in SL 7.0  We're finding that in order to automatically send an invoice via email, we need to first initiate a print process in order to send the email.  The problem is that the invoice we want to send via email is also printing (kinda defeats the purpose for us).  Is there a setting in either App Server, Quick Send setup, or the Customer Quick Send tab that would indicate that the invoice should not print?

Thanks.

Dennis

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Dennis,

    Normally if the customer is set up for Quick Send, the invoices do not print.  However, if your invoice report is customized, it could cause the problem.  Can you perhaps try and use the uncustomized invoice report?    Or, open the customized report using Crystal Reports for Solomon.  In the Field Explorer see if the ARPrintQueue table is listed.  Let me know what you find.

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Dennis,

    Do you need any otherhelp with this issue?

  • Suggested answer
    abarron Profile Picture
    abarron 10 on at

    Hi Carolyn,

    I have the same situation as Dennis, though we are on Dynamics SL 2011 FP1.

    We are using a customized invoice format.

    The invoice format has the ARPrintQue table (I already verified)

    What do I need to do?  Shall I remove this table from the report?

    Thanks much!

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at

    How did you join to the ARPrintQueue table?  Should be inner join.

  • abarron Profile Picture
    abarron 10 on at

    Hi Adam,

    The link is inner join.

    Here's the SQL query from the Custom Crystal rpt

    SELECT "ARDoc"."CustId", "ARDoc"."RefNbr", "ARDoc"."DocType", "Customer"."BillName", "Customer"."BillAddr2", "Customer"."BillAttn", "Customer"."BillCity", "ARTran"."Qty", "ARTran"."CuryTranAmt", "ARDoc"."CuryTaxTot00", "ARDoc"."CuryTaxTot01", "ARDoc"."CuryTaxTot02", "ARDoc"."CuryTaxTot03", "ARDoc"."TaxId00", "ARDoc"."TaxId01", "ARDoc"."TaxId02", "ARDoc"."TaxId03", "ARDoc"."DocDate", "Terms"."Descr", "ARTran"."CuryUnitPrice", "ARDoc"."Rlsed", "ARTran"."TranClass", "ARTran"."DrCr", "ARDoc"."CuryOrigDocAmt", "ARTran"."InvtId", "ARTran"."ProjectID", "ARTran"."UnitPrice", "ARTran"."TranAmt", "Customer"."BillAddr1", "RptCompany"."RI_ID", "Customer"."BillState", "Customer"."BillZip", "ARSetup"."DecPlPrcCst", "ARSetup"."DecPlQty", "ARTran"."TaskID", "ARTran"."TranDesc", "PJPROJ"."project_desc", "ARDoc"."User1", "ARTran"."User1", "ARTran"."CustId"

    FROM   (((((("EDUAPP"."dbo"."ARPrintQueue" "ARPrintQueue" INNER JOIN "EDUAPP"."dbo"."ARDoc" "ARDoc" ON ("ARPrintQueue"."CpnyID"="ARDoc"."CpnyID") AND ("ARPrintQueue"."INNbr"="ARDoc"."RefNbr")) INNER JOIN "EDUAPP"."dbo"."RptCompany" "RptCompany" ON ("ARPrintQueue"."CpnyID"="RptCompany"."CpnyID") AND ("ARPrintQueue"."RI_ID"="RptCompany"."RI_ID")) LEFT OUTER JOIN "EDUAPP"."dbo"."Customer" "Customer" ON "ARDoc"."CustId"="Customer"."CustId") LEFT OUTER JOIN "EDUAPP"."dbo"."ARTran" "ARTran" ON (("ARDoc"."CustId"="ARTran"."CustId") AND ("ARDoc"."RefNbr"="ARTran"."RefNbr")) AND ("ARDoc"."DocType"="ARTran"."TranType")) LEFT OUTER JOIN "EDUAPP"."dbo"."Terms" "Terms" ON "ARDoc"."Terms"="Terms"."TermsId") INNER JOIN "EDUAPP"."dbo"."PJPROJ" "PJPROJ" ON "ARTran"."ProjectID"="PJPROJ"."project") INNER JOIN "EDUAPP"."dbo"."ARSetup" "ARSetup" ON "Customer"."AcctNbr"<>"ARSetup"."CreditHoldType"

    WHERE  "ARDoc"."Rlsed"=1 AND ("ARDoc"."DocType"='CM' OR "ARDoc"."DocType"='DM' OR "ARDoc"."DocType"='IN') AND (("ARDoc"."DocType"='DM' OR "ARDoc"."DocType"='IN') AND ("ARTran"."TranClass"<>'D' AND "ARTran"."DrCr"='C' OR "ARTran"."DrCr"='D' AND "ARTran"."TranClass"='D') OR "ARDoc"."DocType"='CM' AND ("ARTran"."DrCr"='D' AND "ARTran"."TranClass"<>'D' OR "ARTran"."DrCr"='C' AND "ARTran"."TranClass"='D'))

    ORDER BY "ARDoc"."CustId", "ARDoc"."RefNbr", "ARTran"."ProjectID", "ARTran"."User1"

    Any suggestions?

    Thanks Much!

  • Mark Schurmann Profile Picture
    Mark Schurmann 4 on at

    I have this same issue.  My invoice is customized as well but there is no join to the ARPrintQueue table.  I also do not see one in the uncustomized report.  In fact the queries are the same.  the customizations are just cosmetic.

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…

Congratulations to the November 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