Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Accessing GP invoice reports from asp.net

Posted on by 35

Hi all,

We're trying to get our website to have the functionality to show the GP SOP invoice report for an order when the user clicks a link.

The first issue we're running into is we're trying to find where the pdf file for the invoice report is being stored. I see that when you choose to email an invoice batch, each customer is emailed the invoice in pdf format. I'm assuming the file is being saved to some temporary location but we can't find where that is. If you know where these are stored please let me know.

We're also not sure if it makes more sense to find these files that are emailed and store them, or if we should call some component through .net and run the invoice report from gp. But I don't know what component I would use to run a gp invoice report from our asp.net website. We are using the webservices, but as far as I can tell that's for running procs and accessing data. We're looking to get the SOP invoice report as it is from GP.

I found 2 links related to this question, and both seem to indicate that trying to get to the saved file may not work.

community.dynamics.com/.../65227.aspx

community.dynamics.com/.../106071.aspx

Please let me know if anyone has any ideas, thank you.

*This post is locked for comments

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: Accessing GP invoice reports from asp.net

    If you have SSRS, then why not using it?

    You can provide links of GP reports on your web page, report can be print on browser.

    Also you can export data to PDF or any other format.

  • mgmedick Profile Picture
    mgmedick 35 on at
    RE: Accessing GP invoice reports from asp.net

    I'll answer my own question here.

    Basically we never found where GP is storing the invoice PDFs that it emails. So that left us with 2 choices.

    1. Have GP save all of the invoices in a batch to a single word file. This option is built into GP, when user goes to print the invoices (or email them) there is also a check box that allows them to save the invoices of the entire batch to a single word file. We then would have to separate this file into each separate invoice document using c# or something.

    2. Use Exchange web services to access the emails and download the attachments to a folder. This requires that we BCC every email with the account we will get to using the exchange web services. This is the option we ended up going with.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans