Actions and Primary View

Hi There, Today we are going to speak about Actions in Acumatica, as well known as Buttons. When you creating a button you basically just need to write a simple code snippet like here: #region Event Handlers public PXAction<PX.Objects.GL.Batch> MyButton;   [PXButton(CommitChanges = true)] [PXUIField(DisplayName = “My Button”)] protected void myButton() { } #endregion As soon as you add this button as extension and publish it, you will see button appeared on the screen. But from platform standpoint there is much more than button handler, let check how does it work: Action Data View – “public PXAction<Batch> MyButton;” PXAction is special version of Data View in Acumatica, that defines action name, as well as button handler name. But you may see… Read more

Getting Report PDF through Web Servies

Hi All, Today want to show you very simple example of getting printing report and getting it’s PDF representation thought Screen Based API. For doing this we need: Screen-based Endpoint to Report. Import Web services References to our project Fill report parameters using Value command. Request Report to be formatted as PDF (schema.ReportResults.PdfContent). Please note that you also can get a HTML representation of report. Receive report binary data from Acumatica using Submit command from Web Services. Save data somewhere. In my case i’m just saving report as a file to file system, but you can process it however you need. Full Code Sample: View the code on Gist. Have… Read more

Negative Number Representation in Reports

Hi There, Just want to share with you short tip: if you want to have a different representations of negative numbers in the report, it is easy to do using format file in control properties. So if you have negative numbers with “-” sign, like here: You can change format in control Properties. For that example, if you want to show it in brackets (1) instead of -1, than just use following mask: #,##0.00;(#,##0.00) As you can see here, negative representation is specified after “;” sign. Masks are related to standard .NET formatting rules. And than you can check it in browser. Have a fast reporting!

Fast Attaching to IIS Process

Hi Everyone, What to share with you one more cool trick – how to save few seconds on attaching Visual Studio for debugging Acumatica ERP or Customization Library. Visual Studio has really good Extensions Market, where you can easily find something developed by other great guys. You can find in under “Tools -> Extensions and Updated” And one of the apps I really like there is “Attach To” plugin. It is super simple and has just few buttons, but in the same time it does essential thing – attaching to IIS process with one click! May be it is really big deal, but as less routine operations you have, as… Read more

SQL Formating Tools

Hi There, If you are working with Generic Inquiries or Reports or doing a lot of development on Acumatica you most probably have seen already such big and nice queries. And that one is just simple invoice form with one record 🙂 Even if you copy it to SQL Management Studio, it will not be better. But fortunately there are few tools that can help you a lot! 1) Apex SQL Refactor ( https://www.apexsql.com/sql_tools_refactor.aspx ) Even better free plugin to SQL Management Studio that can immediately format query right in place with one button click. 2) Instant SQL Formatter ( http://www.dpriver.com/pp/sqlformat.htm ) Great free cloud app that can format SQL query right in the browser for… Read more

Discovery and Demo Preparation

Hi Everyone. Past some time I have a great opportunity to participate and even run some product presentations with end prospects. And it was really great. One think that I have noticed from day first there is that even if demo not always go as planned, but it still mostly depend on proper preparations. So here we have logical conclusion – as more prepared you are as more chances to win you have. But when it really comes to demo preparation how are you doing that? If you are doing your demo number 100 than may be you already have your own strategy and you definitely knows what you need… Read more