Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Invoice Email

(0) ShareShare
ReportReport
Posted on by

When generating a batch of SOP Invoices and selecting the email option, we get a Document Exception Report. Note that not all customers are setup for email, so on this report it gives errors that the email is missing, etc… I can’t see where we can add the Customer Number which would be EXTREMLY helpful, to determine if this customer is setup to receive email or not…. This is causing a lot of research to make sure the Invoices are actually being sent, and there is not a mistake in setups. I would think if the customer is not MARKED to receive emails they would not show on the report, but if we could at least get the customer number it would make life easier.  Any ideas?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: SOP Invoice Email

    Hi

    GP 2013 R2 has the customer ID showing on the exception reports for statements so assumption is that this is available for SOP invoices also.  Have you tried editing the report in GP report writer.

    Our company could modify the report to add a function if not available in report writer. 

  • L Vail Profile Picture
    65,271 on at
    RE: SOP Invoice Email

    Brenda,

    What is the exact name of the report? If it's a Report Writer report, we may very well be able to add the customer ID to it. The Report Writer Name can be easily find by hitting the 'Modify' button near the top of the report if you print it to screen.

    Let me know if you find it and I'll look at it in Report Writer.

    Kind regards,

    Leslie

  • soma Profile Picture
    24,410 on at
    RE: SOP Invoice Email

    I think you can get the customer list which are not setup email address in GP with help of SQL query.

    Hope this helps!!!

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans