Development Tools in Acumatica

Hi Everyone, Today I want to speak about tools and application that Acumatica team uses during development. Development Microsoft Visual Studio 2012+ ReSharper from JetBrains for faster development Databases and SQL Microsoft Sql Server Express + Microsoft Sql Server Management Studio Microsoft Sql Server Profiler My Sql + SQLyog MySQL GUI for MySQL Apex SQL Refactor – SQL Formating Tool Performance DotTrace from JetBrains for performance testing Memory .Net Memory Profil for memory analysing Windbg for deep process dump analysing Sources Git + Stash for sours control and analysing SourseTree + GitExtension as GUI tools for Git. Documentation and Tracking Jira for bugs tracking Confluence for specification, features and documents traking Mockups and Flow WireFrameSketcher… Read more

How to Debug Customization Code

Hi Everyone, Today I want to discuss how can you debug customization code that has been added from the user interface. The general plan is to move your code to from customization manager to Extension Library, than open in in visual studio and debug. 1) Select code that you need to debug. 2) Create Extension Library. 3) Move your code to Extension library 4) Open extension Library in Visual Studio 5) Find your code in Solution Explorer and put Breakpoint where you need it. 6) Use button “Attach to process” and select all w3wp.exe processes. 7) Click Attach 8) Use browser to trigger your code. Than system will automatically hit breakpoint and… Read more

Acumatica License Mode: Track users count Users instead of Sessions

Hi Everyone, Acumatica product licenses limit the number of concurrent user sessions. By default, a user is allowed to login with the same credentials from any number of browsers within this limit. You can disallow multiple sessions of the same user account, making licenses limit the number of users rather than user sessions. This is called Manage Per-User Session Count. To do this, you should set the concurrentUserMode property to true in the membership provider in web.config of your site as follows: <membership defaultProvider=”PXActiveDirectorySyncMembershipProvider”> <providers> <remove name=”MySQLMembershipProvider” /> <add name=”PXActiveDirectorySyncMembershipProvider” type=”PX.Data.PXActiveDirectorySyncMembershipProvider, PX.Data” mainProviderType=”PX.Data.PXDatabaseMembershipProvider” ………………………………………… concurrentUserMode=”true” /> ………………………………………… </providers> </membership> As a result, a user will be able to log in with the same… Read more

Test Tenants

Hi Everyone, As you know, Acumatica license restricts number of tenants that you can have on the instance. Depend on size it can be 3, 10, 20 and so on. If you create more tenants than is allowed by your license, system will hide it on login screen and write a message “Companies list is restricted due to the license”. This is correct behavior for production instances, where you entering your businesses data, but what should you do if you want to test something (import data, close financial year, implement new module). Acumatica tracks in the system 2 types of tenants: Production and Test. Your license limits only amount of production tenants, but you can create… Read more

Trial Mode in Acumatica

Hi Everyone, Today I want to speak little-bit about Acumatica Trial License and the way how you can use it. You need to know that Acumatica trial license is very good and flexible, so it can be a big advantage for you and your team. When you install new instance of Acumatica with no license, you have just two restrictions – number of simultaneously working users and numbers of cores. Simultaneously working users means that you are not able to have more than 2 users who are using the same instance in the same time. When new user tries to logic, licensing core will automatically logout one user with oldest activity in… Read more

Consolidation Demo

Hi Everyone, Today I want to speak about consolidation functionality in Acumatica. By using this functionality you can consolidate financial data from subsidiaries into a the parent company. The general process is described on this image: You can easily reproduce this scenario for your customer. To do this, fist of all I recommend you what very good consolidation demo video on YouTube: Using Acumatica to consolidate financials across systems and currencies On the next step you should prepare your demo environment. To do this you should install 2 instances of Acumatica locally/in the cloud and upload corresponding demo data there (you can find in on Acumatica Partner Portal). Demo data consist… Read more

Update of Dependant Fields

Hi Everyone, Today I want to share with you one scenario when you have dependent field – one field is depend on the value of another field and should be recalculated on change of primary field. But you also have user interface where user can change dependent field as well. So you may have situation when user has changed dependent field and business logic has to recalculate the same field also. By default system will keep user changes as a more important comparing to default changes. But in this article you will learn, how to override this process and make business logic changes more important than users. Here you can find an image that illustrated scenario above.… Read more