tag:blogger.com,1999:blog-4889748320010274206.post8358004447780938087..comments2024-03-20T00:45:30.946-04:00Comments on AX WONDERS: Save an Microsoft Dynamics AX 2009 report to a PDF file (Second Part) - Save the file to a network locationAxWondershttp://www.blogger.com/profile/01901411966215366187noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-4889748320010274206.post-73695101447207980192014-07-09T07:32:48.425-04:002014-07-09T07:32:48.425-04:00hi
Can u please help me out this issue ax 2009 ,
...hi <br />Can u please help me out this issue ax 2009 ,<br />i want to send one Report pdf file on email thorugh batch process ...For this run time i am generating the report reportrun.run and saveing in one folder , my issue was when i am runing the batch (normal process) report is generating as 38 Kb it is working file , when i attached to batch process it is giveing me report 1 kb it is not generating may i no the reason. <br />Aslamhttps://www.blogger.com/profile/08739537869760374923noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-27149899172110326852013-12-16T01:47:37.663-05:002013-12-16T01:47:37.663-05:00Nice one . U r doing well job.
This is axapta ERP...Nice one . U r doing well job.<br /><br />This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions.<br /><br /><br /><a href="http://daynamicsaxaptatutorials.blogspot.com/" rel="nofollow">axapta ERP blog</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-30081093445208085422012-09-29T10:57:45.615-04:002012-09-29T10:57:45.615-04:00thank for post the links..
and
i nee...thank for post the links..<br /> and<br /> i need AIF&EP Fundamentals ple send blog names or creation steps post here...pleAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-16114381356939594032012-05-23T07:27:55.952-04:002012-05-23T07:27:55.952-04:00Hi!
If I'm not mistaken, the email invoice fu...Hi!<br /><br />If I'm not mistaken, the email invoice function comes with AX 2012.<br /><br />Let's take the following from MSDN:<br /><br /><br />Send e-mail <br /><br />"Select this check box to send the invoice for a sales order to the customer as an email attachment after the invoice is posted. Attachments are sent as PDF and XML files. This check box is available only if you select the Enable CFD (electronic invoices) check box in the Electronic invoice parameters form."<br /><br />The above instructions comes from here http://msdn.microsoft.com/en-us/subscriptions/aa550287.aspx<br /><br />Just click the link and search for the word "Email"<br /><br />Now, if you still want to write your own code (Which I would not recommend with AX 2012), please take a look at the following code and see what serves your purpose.<br /><br />Thanks for reading my blog and let me know if you have any questions.<br /><br /> Args args=new Args();<br /> SalesFormLetter salesFormLetter;<br /> SysMailer mailer;<br /> PrintJobSettings printJobSettings;<br /> str _fileName;<br /> InteropPermission permission;<br /> FileIOPermission dirPermission, filePermission;<br /> Set permissionSet;<br /> ;<br /> args.record(_custInvoiceJour); <br /> _fileName=strfmt('%1\\%2.pdf',filepath,_custInvoiceJour.InvoiceId); <br /> if(_custInvoiceJour)<br /> {<br /> salesFormLetter = SalesFormLetter::construct(DocumentStatus::Invoice,false);<br /> printJobSettings = new printJobSettings();<br /> printJobSettings.setTarget(PrintMedium::File);<br /> printJobSettings.format(PrintFormat::PDF_EMBED_FONTS);<br /> printJobSettings.fileName(_filename);<br /> salesFormletter.updatePrinterSettingsFormLetter(printJobSettings.packPrintJobSettings());<br /> _custInvoiceJour.printJournal(SalesFormletter);<br /> {<br /> permission = new InteropPermission(InteropKind::ComInterop);<br /> dirPermission = new FileIOPermission(_fileName,'W');<br /> permissionSet = new Set(Types::Class);<br /> permissionSet.add(permission);<br /> permissionSet.add(dirPermission);<br /> CodeAccessPermission::assertMultiple(permissionSet);<br /> mailer = New SysMailer();<br /> mailer.fromAddress('abc@xyz.com');<br /> mailer.subject(strfmt("Invoice %1,date %2", _custInvoiceJour.invoiceId,_custInvoiceJour.InvoiceDate));<br /> if(email) //<--dialog field<br /> {<br /> mailer.tos().appendAddress(email);<br /> }<br /> if(!email)<br /> {<br /> mailer.tos().appendAddress(CustTable::find(_custInvoiceJour.InvoiceAccount).Email);<br /> }<br /> mailer.htmlBody("Please see attached");<br /> mailer.SMTPRelayServer( SysEmailParameters::find().SMTPRelayServerName,<br /> SysEmailParameters::find().SMTPPortNumber,<br /> SysEmailParameters::find().SMTPUserName,<br /> SysEmailParameters::find().SMTPPassword,<br /> SysEmailParameters::find().NTLM);<br /> mailer.attachments().add(_fileName);<br /> mailer.sendMail();<br /> }<br /> CodeAccessPermission::revertAssert();<br /> }<br /> <br />Good Luck!AxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-67103290719289337482012-05-23T00:30:46.562-04:002012-05-23T00:30:46.562-04:00Hi,
I am using AX2012 and I am trying to send invo...Hi,<br />I am using AX2012 and I am trying to send invoice directly to customers via email. When the invoice is attached to the email it should bear the name as Customer name - Invoice no. How to automate this when we post the invoice. What changes should i make to your code given above to achieve it. I will be saving files locally and not on any network.<br /><br />Thanks you have already done a very job keep up the good work.DawsYhttps://www.blogger.com/profile/18224989814418016727noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-7318729320511783962012-04-23T08:17:57.155-04:002012-04-23T08:17:57.155-04:00Ankita,
I'm sorry you didn't get what you...Ankita,<br /><br />I'm sorry you didn't get what you were expecting for the links. It seems that you are new to this and it can be frustrated when we cannot find the exact answer we are looking for.<br /><br />Please follow and execute each of the following exercises. I'm sure you will be able to get what you need from them as they cover everything you need to accomplish.<br /><br />http://www.youtube.com/watch?v=JVNisza0BQI<br /><br />http://www.youtube.com/watch?v=JVNisza0BQI<br /><br />http://msdn.microsoft.com/en-us/library/cc622728(v=ax.50).aspx<br /><br />http://msdn.microsoft.com/en-us/library/cc636713(v=ax.50).aspx<br /><br />http://msdn.microsoft.com/en-us/library/cc639019(v=ax.50).aspx<br /><br />I hope this helps!AxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-20064707914725803512012-04-23T08:00:26.698-04:002012-04-23T08:00:26.698-04:00Hi,
I am trying to learn that how to create data ...Hi,<br /><br />I am trying to learn that how to create data methods and already seeing the same links which you have told but if you will help me out in writing data methods then it will be benefited for me because till now i haven't create it.<br /><br />I also want to know that where I will create a class and 1 static method (in ax or in Visual Studio). And i didn't get this statement - "The method will receive the customer id as a parameter and with this you can create a while loop that will insert the values into your tmpTable, then in Visual Studio, your data method will have to return a data table, so it will be like this<br /><br />public DataTable getAppointments (string custNum)<br /><br />Then, you will have to call your new class and assign it to the data table from C# and then set it back to your appointment parameter value in your SSRS report".<br /><br />Please elaborate that how to perform the steps mentioned by you in the previous post.ankitanoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-57774407097062011352012-04-23T07:31:32.509-04:002012-04-23T07:31:32.509-04:00Hi,
Please look at the following links, they will...Hi,<br /><br />Please look at the following links, they will help you understand ow to create a report for AX in visual studio, and create a report data method. <br /><br />Introduction to Reporting with Visual Studio 2008<br />http://msdn.microsoft.com/en-us/library/cc622374(v=ax.50).aspx<br /><br />Report Data Method Overview<br />http://msdn.microsoft.com/en-us/library/cc587341(v=ax.50).aspx<br /><br />I think it would be a good idea for you to take a few hours and read through this material. Also, if yopu can, try to follow a walkthrough exercise and you'll get it right away.<br /><br />I hope this helps!AxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-33494120266278191702012-04-23T01:12:00.978-04:002012-04-23T01:12:00.978-04:00Hi,
Thanks for your reply.
I have never create a...Hi,<br /><br />Thanks for your reply. <br />I have never create any data method so please help me in making it and please tell me the process step wise so that i will be able to solve my issue.<br /><br />Thanks in advance.ankitanoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-82486046010946219922012-04-12T08:41:55.183-04:002012-04-12T08:41:55.183-04:00Ankita,
You can do this taking a few different ap...Ankita,<br /><br />You can do this taking a few different approaches. The one I recommend if you are new to SSRS and AX is the following:<br /><br />1- Create a DataSet in Visual Studio that is linked to a query in AX that brings all the customer id's. This query in AX already exists, so you don't have to build anything.<br /><br />2- For the second parameter, you will have to write a data method in Visual Studio that calls a method (and/or custom class) in AX. So, for this you will have to create a tmpTable in AX that will be used to store the results of what the info related to a customer id. <br /><br />Then, I would recommend creating a class and 1 static method. The static will have the name of the tmpTable, so you will return this table back to visual studio.<br /><br />So you will write public static tmpTable_AppoinemntNumbers(CustNum _custNum)<br /><br />The method will receive the customer id as a parameter and with this you can create a while loop that will insert the values into your tmpTable, then in Visual Studio, your data method will have to return a data table, so it will be like this<br /><br />public DataTable getAppointments (string custNum)<br /><br />Then, you will have to call your new class and assign it to the data table from C# and then set it back to your appointment parameter value in your SSRS report.<br /><br />Let me know if you have any questions.AxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-88141678682986275542012-04-12T04:49:33.412-04:002012-04-12T04:49:33.412-04:00Hi,
Please help me out in finding the solution to...Hi, <br />Please help me out in finding the solution to my problem. This is very <br />urgent. <br />I am creating a AX 2009 SSRS report. In the report I have two <br />parameters, based on the first parameter which is a drop down , the <br />second <br />parameter needs to be filtered with specific values. For eg AccountNum <br />is the <br />first parameter which displays all the CustomerId. Based on the <br />AccountNum selected, the second parameter should display the <br />AppointmentNumber. Can you <br />let me know how to achieve this scenario. Is this scenario possible in <br />AX <br />2009 SSRS? <br />Thanks & regards, <br />Ankitaankitanoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-63797064041674755732011-09-21T09:31:19.545-04:002011-09-21T09:31:19.545-04:00Not a problem. I hope you can solve your problem.
...Not a problem. I hope you can solve your problem.<br /><br />So, just to clarify and wrap-up. You can have many sales orders in one PDF for the same customer (or invoice account). <br /><br />You cannot, however, do this for different sales orders from different customers (different invoice account). In this case, AX will create one invoice for each invoice account.AxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-67484836922091954702011-09-21T09:22:40.035-04:002011-09-21T09:22:40.035-04:00Thank you so much for taking the time to look into...Thank you so much for taking the time to look into this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-27159022583504605302011-09-21T08:53:41.560-04:002011-09-21T08:53:41.560-04:00Hi,
You can't just save a bunch of sales orde...Hi,<br /><br />You can't just save a bunch of sales orders on the same PDF without a customization. <br /><br />First, it is important to remember that you can have several sales order (for the same invoice account) given one single invoice number. So, let's say you have customer account 123456789 (same invoice account for this example). You create 6 sales orders for the customer 123456789. When posting (SalesEditLine Form), you can go to the "Other Tab" and choose "Invoice Account" under the "Summary Update for" drop down list. When this is done, then you can have many sales orders in one PDF.<br /><br />Now, if you want to have different sales orders on the same PDF, you will need to customize your system as this is not possible given the way AX groups the sales order data.<br /><br />I hope this helpsAxWondershttps://www.blogger.com/profile/01901411966215366187noreply@blogger.comtag:blogger.com,1999:blog-4889748320010274206.post-69993938978308608872011-09-20T18:36:45.645-04:002011-09-20T18:36:45.645-04:00How do I save multiple Sales invoices to the same ...How do I save multiple Sales invoices to the same pdf file? I process hundreds on invoices on weekly basis and need a way to save them in one pdf file instead of saving them one by one. is there a way to do so? thank youAnonymousnoreply@blogger.com