Redirect On Page Load

Hi There, You know that you can embed custom pages right inside Acumatica. Best examples here are YouTube, Binq, Stack Exchange, Currency Rates or something else But what if you need something like this, but dynamic – have a special URL depend on user, screen or other environment variables. In that case you cannot just hard-code URL in sitemap, as it will be always the same. Here we need to be able to redirect user to special URL form code. And I can suggest you 2 possible options to do that: PXRedirectToUrlException When page is shown and graph is loaded, you can throw a redirect exception that will be handled… Read more

Acumatica Cloud xRP Summit

Hi All, Join us for our inaugural interactive & engaging Virtual Developer Conference, where we have lined up some great speakers & content that will help you, the developer – whether you’re a seasoned veteran or new to the platform. Learn a new tip or trick in the advanced framework session or learn about new features in our roadmap session. And I am one of panelists! Join us and we will have great fun there!

Maintain Table Schema within Customization Project

Hi There, Today I want to stop your attention on how Acumatica handles updates for custom tables/columns. In Case you doing medium to complex customization to Acumatica, you most probably will have a lot of custom columns. You know you can add all these custom columns to the standard tables in Acumatica, but in this case you several issues Each new column has to have an Usr prefix to each column. That is required to split standard and custom columns in one table You columns depend on Acumatica table. In case Acumatica have any changes in the tables, you columns may also be affected. But do not worry, they are… Read more

Validating AP/AR Accounts Balances before Releasing Imported Invoices

Hi There, If you ever was involved in any implementation project and data migration process you have seen how complicated is to validate data after migration. It is especially important if you have documents that have to be released – if you release wrong document than there is now way to change document anymore and you have to reverse and create it again, that basically litteres documents history. Ok, we can see the problem, but is there any way to validate balances before releasing of the documents to minimize number of errors? When I have faced that problem, I have tried to find a solution and basically have found it… Read more

Recurring Notifications about Expiring Quotes

Hi There, Any ERP system is designed to help users as much as it is possible. And one of very common human bug is bad memory. So ERP should solve this issues by recurring notification on multiple possible documents/items. Just as for example, how cool is to have notification on expiring contract, quote or cases, so we can take an action in advance. Based on the previous article on notification from templates that I have shared with you few days before, we can design an processing screen that will send notifications for us. So the main idea around it is – every day Acumatica scheduler will trigger our logic, that… Read more