Export notes to excel from the grid

Hi All, Today want to share with you simple trick. Starting from version 5.2 Acumatica does not export notes to the excel file from the grid by default. This was done for performance optimizations. So if you go to Journal Transactions and export data, you will see something like this: But fortunately it can be easily changed by using Acumatica customization engine. Just click Customization->Inspect element and then click on the grid, than click customize. Customize button will open additional window where you can specify some configurations for the grid and other elements. We need just one – Export Notes. Set property to “True” and than you can publish customization… Read more

Using PXView in DataView Delegate

Hi Everyone, Today I want to share with you one way how you can keep your code simpler. Lets assume you have some big data view declaration – PXSelect<Table, <InnerJoin, …. <AnotherJoin, … <MoreJoins, …. <Where<, …. <MoreWheres< …. SomeDataView And something like this for 10-20-30 lines of code. I’m pretty sure that you can understand what do i mean. And also this select declaration may be inside Acumatica base code and you want to customize it. Your task is to create a new data view delegate and select the same data with some additional filtering or dynamic calculations. But we cannot just create delegate and call dataview data, as… Read more

Restricting the list of fields selected from database

Hi Everyone Sometimes you need better control on how Acumatica selects data from database. And here Acumatica Framework provides you some ways to optimize data query. Using PXFieldScope you can specify what fields will be selected form database. This can save some traffic and processors time in large and extra-large statements. Also it can improve performance in case you have plenty of data, but use very few fields from the selected tables. And of course excluding of some complex sub-selects may significantly improve data selecting on SQL servers side. No RowSelecting events (e.g. from attributes) will be fired for the fields not fed into the FXFieldScope constructor. Note, that for… Read more

Mobile Acumatica on Desktop

Hi All, Today I want to share with you one way how you can play around or even show through the online demo Acumatica mobile application on your laptop/desktop computer. Actually there are a lot of ways how you can mirror the real device screen, but today I want to go with you with setting up an android emulator on your desktop. Here you can find step by step instruction of how to setup working instance: First of all you need to download emulator software to your machine from the official web site. I recommend you to use Andy Android Emulator Click download and save the file. (installation file will be… Read more