Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Fix to Address Blank Statement Printing with Quick Send

Like (3) ShareShare
ReportReport
Posted on 31 Oct 2017 15:30:49 by

We recently configured Quick Send for a customer and one of the issues we ran into was with their customized AR statement, which would print blank if you did a print preview. We found this article, which helped solve this problem, but introduced other issues: https://support.microsoft.com/en-us/help/2722450/customized-ar-statement-08-600-00-report-prints-incorrectly-when-you-u

The recommendation is to remove the select criteria ({ar08600_wrk.ri_id}=tonumber(riparam("RI_ID")) and {AR08600_wrk.ASID} = 0))

from the selection formula in Crystal on the format that you are using for Quick Send, but the problem with this is that it effectively removes the RptCompany table from the query that runs (as is the case in the standard 08600PP report), meaning that if you end up with records stuck in the AR08600_wrk table (if the screen ever crashes when printing statements and the post process to clear out the table never runs), or if multiple people run statements at once, you end up with records in your report that were created as part of a separate AR08600_wrk table population process/statement run. I imagine that this select criteria was included in the report originally to prevent this problem, and this workaround is a lazy attempt at fixing one problem while removing a fix for a separate problem. Is this really the best solution? The problem is that the users cannot print preview a report and see the same result as what will go through Quick Send if records are ever stuck in AR08600_wrk (which the users don't have any way of knowing is happening).

*This post is locked for comments

  • Steve Martin Profile Picture
    Steve Martin 90 on 31 Oct 2017 at 15:49:02
    RE: Fix to Address Blank Statement Printing with Quick Send

    I've seen this problem too.

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

Congratulations 2024 Spotlight Stars!

Kudos to all of our 2024 community stars!

Meet the Top 10 leaders for December!

Congratulations to our December super stars!

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,559 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,579 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started