Acumatica Archives

Microsoft Partners With Acumatica For Power Fx

Microsoft partners with Acumatica for Power Fx

Microsoft has announced the partnership with Acumatica to evaluate how Power Fx can be leveraged with the low code/no code experience they offer to their customers. With businesses investing in automation, development is also moving towards a no/low code environment of interconnecting systems and performing tasks. This is what makes the partnership between Acumatica and Microsoft even more valuable.

What is Microsoft Power Fx?

Microsoft Power Fx is the low code language for expressing logic across the Microsoft Power Platform.  It is the same language that is at the heart of Microsoft Power Apps canvas apps today inspired by Microsoft Excel.  It enables the full spectrum of development from no code to pro code with no cliffs in between, enabling diverse teams to work together and saving everyone time and money.

By enabling an entirely new level of “being ready to code in plain English.” Previously, Microsoft’s Power Platform users still needed to know the essential logic of writing formulas. But now they will type commands like “Show 10 orders of product A in alphabetical order” and obtain the desired result.

Acumatica Cloud

Acumatica Cloud ERP provides a business management solution so mid-sized companies can transform their business to thrive in the digital economy. It is extremely powerful and provides flexibility, agility, and connectivity and can connect to almost any system and perform any task requested by clients.

In this demo, a number of calculated fields have been added to the form with Power Fx.  They use the same Excel language that so many users already know.  Note that the Sum and Average function are used to aggregate information in related tables. The result you can see at the end of the animation when the discount is updated for one of the records and the field automatically recalculates.

Demo: Acumatica on Power Fx


About Acumatica

Acumatica ERP (Enterprise Resource Planning) is an Award-Winning Cloud ERP. It delivers adaptable cloud and mobile technology with a unique all-inclusive user licensing model. This enables a complete, real-time view of your business anytime, anywhere. Acumatica ERP provides the full suite of integrated business management applications, including Financials, Distribution, Manufacturing, Project Accounting and CRM. The one true Cloud ERP platform designed for mid-sized customers is Acumatica.

Acumatica’s expertise lies in

  • Increased Productivity
  • Inventory Control
  • Remote Connection From Anywhere

Contact Acumatica here

Tel: +27 (0)11 568 2900.

Contact Palladium Business Solutions here


Best rated Cloud ERP system of 2017!

We’re delighted to share the awards and recognition which Acumatica recently received. We believe that these awards lend credence to the fact that Acumatica is ahead of the curve in both functionality and technology so do continue with us on the Acumatica journey!



PC Editor’s Choice Award 2017
Acumatica wins another PC Editor’s Choice Award for the best Inventory Management Software in 2017. To find out how Acumatica fared against the competition, click here.



SIIA CODiE Award 2017
Acumatica wins the 2017 SIIA CODiE Award for the Best Cloud ERP application. These awards are unique since they are the only peer recognised program in the software technology industry, thereby adding validation to Acumatica’s vision, innovation and the impact on industry. For further details, click here.


Acumatica named Visionary in Gartner Magic Quadrant June 2017
Acumatica is named as Visionary in the June 2017 Gartner Magic Quadrant for Cloud Core Financial Management Suites for Midsize, Large and Global Enterprises. The Gartner Magic Quadrant reports are widely distributed to businesses considering software purchases, as well as to industry leaders and journalists. This will increase Acumatica’s brand awareness, brand recognition as well as lead generation. The report highlights Acumatica’s platform, ease of use and focus on the mid-sized market space.

Palladium Scoops Top Cloud ERP Global Award

Local ERP innovator Palladium Business Solutions has outclassed its global counterparts by winning the prestigious Acumatica International Partner of the Year Award for 2015. The awards were presented at Acumatica’s sixth annual summit in Orlando, Florida. During the summit, Acumatica also released the much-anticipated version of Acumatica 5.3 the leading Cloud solution for CRM integrated to financials and ERP.

Palladium Business Solutions managing director Stephen Corrigan is upbeat about the future of ERP. “We are extremely proud to be awarded this accolade, considering the landscape of Cloud and ERP in Africa. To put it into perspective, Acumatica is the fastest-growing provider of cloud-based accounting and ERP software, with an unsurpassed triple digit year on year growth.”

“The African Cloud market is progressing rapidly, with ever-improving connectivity and high adoption levels of smart devices. We are proud to have a partner like Palladium in Africa driving our message of involving everyone, on any device, anywhere with Cloud ERP” says Laurent Dedenis, President of International Operations, Acumatica, congratulating Palladium Software on its achievements.

Corrigan says this market is growing at a rapid pace. “According to IDC, more than 90 percent of new applications are built for the cloud and more importantly, SaaS revenue is growing five times faster than packaged software.”

Acumatica 5.3 continues providing the foundation of full ERP suite including financials, distribution, accounting and CRM, with new features focused of delivering higher performance, stability and mobility alongside tight integrations to Microsoft’s Power BI.

“The updates in Acumatica 5.3 enable customers to accelerate their businesses by delivering more powerful performance and new mobility features. It gives users an even better experience with a faster user interface and expanded mobility features that make it quicker and easier to get their jobs done on any connected mobile,” he concludes.

Acumatica helps service providers grow revenue and profit

Customer satisfaction drives profitability, especially in today’s highly competitive services industry. To stay ahead of the competition, businesses need an integrated system that will provide a powerful 360-degree view of customers’ activities.

Stephen Corrigan, managing director of Palladium Business Solutions, says Acumatica is the answer. “The goal in customer service is simply to deliver the service on-time and on-budget while avoiding surprises like unexpected additional charges. Acumatica can help tackle the issues of customer relations and productivity simultaneously.”

“Equip your team with the best tools available – comprehensive and integrated management applications, with workflow, document management, mobile access, and role-specific dashboards. You’ll find those tools and more in the Acumatica solution for the services and projects-based industries,” he explains.

Providing modern tools to the staff plays an important role in job satisfaction by easing the reporting and administrative burden while enabling ready access to information that service providers need to do their jobs effectively.

Automating sales, marketing, and service processes, integrated with financials, provides the tools to efficiently and effectively handle customer relationships while increasing the productivity of everyone involved.

Customers will appreciate and reward one’s ability to uncover problems early, prevent delays, and keep costs in line while providing a more responsive service experience. For simple and straightforward service work, Acumatica provides a simple order entry and billing process using unique order types.

“Set up and modify the workflows and approvals to immediately integrate with the accounts receivable, general ledger, and financial reporting,” he adds.

For project-based services firms, including engineering or those in the construction industry, the Project Accounting application manages budgeting, time sheets and disbursements, billing, profitability, and reporting for projects. Additionally, for business services of a customer support nature, the Service and Support Automation functionality in Acumatica effectively handles service-based activities, including case management, contract management and even prospect or tender management.

Corrigan says for repair and maintenance services firms handling warranty or billable parts requiring stocking inventory, Acumatica supports the requisitioning, purchasing, warehousing as well as invoicing with recurring and specialised billing requirements.

Acumatica’s embedded document management functionality ensures complete compliance with the impending POPI Act with the complete management and control of all document revisions, ensuring that all changes are tracked to ensure strict corporate governance compliance.

“Whether you specialise in long-term, complex projects or short turnaround jobs, you succeed by acquiring and maintaining clients while ensuring that projects/jobs are executed profitably. It all starts with managing relationships and making your deadlines. Competing on value is necessary, but the real challenge is to be better than the competition at ongoing relationship management,” he adds.

Acumatica is comprehensive and completely integrated, it provides accurate history and costs for past and current projects, for quality control and more intelligent bidding, resulting in more projects and higher profits.

“A services business is all about the professional staff – keeping them billable and productive, and managing turnover. Acumatica can help with both by providing timely and accurate information that gets the right people assigned to the right project at the right time to keep customers happy and billable hours high,” says Corrigan.

Maximise your income by providing productivity tools that increase job satisfaction and reduce unproductive time usage.

Improved decision-making with self-service BI tools and dashboards that increase productivity by enabling users to uncover information lost in the data – and doing it efficiently without waiting for IT or data specialists to develop the analysis. Additionally, Acumatica leverages the new Microsoft Power BI as its self-service analytical toolset with its Odata connection.

“Self-service paralytics can empower users in so many different ways, especially when supported by a cloud data hub, it fosters a larger, more active user base that will make better decisions and disseminate insight across all lines of business,” he concludes.