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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156