Alter GL Transaction during Inventory Release

Hi All Today I want to share with you one of possible ways how you can catch the process how Inventory release created a GL Batch and GL Transactions. Lets assume that we want to change description or Sub-Account during inventory receipt release, than i need to do following things: Create extension of INReleaseProcess, that is responsible for release operation. Override ReleaseDocProc, that is doing main release job. In this method we have links to JournalEntry and INRegister, where we can check what is going on and add some additional logic Add RowInserting event to JournalEntry that will handle creation of batch or tran Change description or sub-account where it is required In the… Read more

Encrypted batch payment file (ACH, GIRO)

Hi All, In Acumatica you can easily generate electronic payment files (such as ACH, GIRO and others). By using this process you will have a file that will have payment amounts and other required information. But what about data protection? Bu default payment file will have clear text amounts. Today i want to share with you how you can easily encrypt this file. Payment file will be generated by Acumatica Integration Services Export Scenario. The main class that is responsible for generation file is Integration Services Data Provider. In Acumatica out of the box we have only 2 providers : ACH and GIRO. In my Example i will show you… Read more

Acumatica Test Framework

Hi All, Acumatica has a strong focus on the Platform and Development tools, that can help all our clients and partners to provide better product faster and with lower cost. One of the nice and free tool that Acumatica provides as part of platform is Acumatica Test Framework. Acumatica test Framework is a set of tools and libraries that can be used for unattended black-box testing of any product or customization that is based on Acumatica Platform right in your favorite browser. For interacting with UI controls and components Acumatica Test Framework uses Selenium Web Driver. You can read more about Selenium here. The high level diagram of Test Framework… Read more

Replacing Cache with custom class

Hi All, Today i want to share with you a good trick how you can override original PXCache object. Why you may need it? To replace base cache logic, that should not be executed in some cases. Forbid cache to read data for database in case of virtual DAC Inject required logic to the standard workflow Do not clear cache data on graph clearing Access protected method And many other things. As you may know, that when you (or system) create a new instance of a graph, it will automatically instantiate all caches for each data views that are declared. Unfortunately, because this is unattended process it is almost impossible… Read more

Provide Default Value for Report Parameter from Branch

Hi All, Really often you may want to have some default values for report parameters, that may depend on environment. For example different default warehouse depend on branch where are you working now. Or different warehouse depend on current employee. But unfortunately it is not out of the box functionality in Acumatica. Luckily, using powerful Acumatica Customization engine it is quite easy to do. Let me share with you a way to archive it. Scenario: lets assume that we want to have different default warehouse on Inventory Valuation report based on different branch that is selected as current. We will do this task in 3 steps: Adding custom field to… Read more

Generate Grid Columns Dynamically

Hi All, Today I want to show you an example how you can generate grid columns dynamically. Sometime it is really important for dynamic inquiry report, where you want to show data that may be changed due to some other configurations. To add columns dynamically you should follow this plan: Create a separate method that will generate columns. Call method create above from the graph constructor. Please not that if you put method into any event you need to make sure that you generation columns only once. Also you logic assume that columns may be changes if user select some other values on the same screen you need to make… Read more