Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2013 Sales Transaction "Print and Delivery"

Posted on by Microsoft Employee

Hello,

Last night we had an issue with the Forms Printer Delivery System sending out the wrong invoice in the attachments. This only happened between 10pm and 10:20pm for about 6 invoices. The user would go into sales inquiry pull up the invoice print it then select Deliver to email the invoice as a pdf attachment to the email in the customer card. When we went to outlook this morning and opened up the sent folder to check out the invoice that were sent out we noticed that even though the email subject stated the correct invoice number to the correct customer, the attachment showed something comepletely different. In the same Attachment it pulled in other several invoices not releated to the customer at all. This caused a big problem because it exposed some of our customer to other customer and this could potentially cause us to lose business. We have been using this feature for many years and we have never experience this. Has anyone seen this or heard of this happening? Is there a log somewhere i can see of the sent items? I tested it this mornig with the same 6 invoices and they all worked like normal but i need to get a report on what happened and how i can prevent it in the future. Thanks in advance for any help.

2251.Capture.PNG

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 Sales Transaction "Print and Delivery"

    Yes I we are using Accountable Sofware Forms Printer. This is the reply I got and I think this will fix out problem.

    "The Crystal report you sent, does not have the correct Record selection formula, which is needed to exclude previously printed documents in a range or batch – I commented out the old Record selection formula  (Crystal->Report->Selection Formula ->Record , and replaced it with the one from our sample report (I had to modify the location code conditional back to your version since your report does not contain the SOP30200 table directly (probably in one of the sql views..)  But I think it should work

    When Forms Printer “Delivers” a document, it always passes the SOP Number  (which it does not pass when just printing ..), and this SOP Number if Present should be used to select the correct document for the report (which ends up in the Attached pdf).

    See below for what I changed it to, and attached for a copy of the modified report.

    I believe this should work, but you should check it for your environment.  And you should modify the record selection formula for any other SOP reports that you use Forms Printer to “Deliver” so that they have a similar conditional as below.

    This probably occurred because the user delivering, had previously printed a range or batch of invoices,  and they were still in the SOP50200 table in the company database, when she attempted to deliver new documents.   This would not normally be a problem, but was in this case, because the Crystal report was not selecting the document by Document number when delivering (i.e when it had a value passed in ).

    Let us know what you find,  and  if you have further questions,

    Regards,

    "

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: GP 2013 Sales Transaction "Print and Delivery"

    Are you using a 3rd party product like Accountable Software Forms Printer for this functionality?

    If so, it may be worth contacting that company for this information.

    Tim.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans