Information about Macola Solutions for Small to Midsize Businesses

Webinar Recording: Introducing Algo Apps--Custom Solutions for Macola

While your Macola system offers plenty of functionality on its own, as you know there are many out-of-the-box limitations.

Over the years we've had hundreds of requests from customers for custom solutions to fix data issues and improve cumbersome processes in both Macola and Synergy. 

Today the result of those efforts are our Algo Apps.

Continue Reading →

Importing Orders from the Web and E-Commerce Into Macola

That’s right, even today, there are companies still new to the Internet, or at least new to figuring out what’s needed to get orders from their website into their Macola Order Entry system. And the reality is, there isn’t a one-size-fits-all solution, but the main considerations for putting your plan together are similar across the board:  Customers, Inventory, and Orders.

Continue Reading →

The Underutilized Notes Function in Macola Progression and ES

The notes function in Macola Progression and Macola ES isn't widely utilized, but it can be a very helpful tool for storing additional data specific to items, customers, and vendors. 

Macola Progression has two types of Notes buttons, the Note button on the toolbar and the Notes button beside fields on Progression screens.

Continue Reading →

Breaking Down Macola ES/EM10 Vendor Discounts

When companies make the transition from Macola Progression to Macola ES/EM10, they often struggle with making sure they capture all their vendor discounts in a timely manner to pay them within the discount period.

Continue Reading →

Macola ES Receiving Accrual Account Best Practices


In Macola ES the one account that can provide the most headaches is the Receiving Accrual Account. It is difficult to balance and many transactions flow through this account on a monthly basis.

The number one thing that will help regain control of this account is to prohibit changes to purchase orders after they have been received. If a change to a line on a purchase order is made after that line has been received, it cannot remove itself from the accrual account and results in this quickly getting out of hand.

Continue Reading →

Are You Ready to Upgrade To Macola ES?

The time has come to give serious thought to upgrading from Macola Progression to Macola ES. Is your company ready for the upgrade? What are the differences in the software? How will the upgrade affect your internal processes? These are all important questions to ask, and rather than let you worry, we’ve compiled a complete resource guide to address them.

Our resources include:

Continue Reading →

Macola Help: How To Fix Macola ES Errors Caused by Network Interruption

Ever return to your desk after a meeting or lunch and see this message in Macola ES?

“Unknown Error!”

This error is very common with a loss of connection to the Database. This also can be the culprit for many other errors or problems in Macola ES. Other problems that can be associated with this type of problem and/or a network interruption are:

  1. AR/AP One sided transactions, or incomplete transactions
  2. POP/SF Orphaned Dependent Work Orders.
  3. PO Line allocations, leaving a transaction screen open during network connectivity loss.

Now don't get me wrong, there are other possible reasons for this error or issues similar to this. This is not the only reason for seeing similar errors, but it can definitely cause these types of issues. I hope that by making this change, Macola ES users might reduce a great amount of errors or cleanup of erroneous data.

The Solution 

The fix is a workstation setting that all too often gets overlooked by IT staff, and really makes a difference when using Macola ES. Making sure this is set correctly for anyone using Macola ES can greatly reduce problems that are often attributed to network loss. I have seen companies have great success in reducing errors after making this change.

Continue Reading →

A Crystal Reports Shortcut to Return Customer Data from Macola ES

Crystal Reports allows the reports to have many selection criteria. The select criteria can use fixed values or parameter values.

Here is a basic Crystal Report to return customer data from Macola ES. The select criteria eliminates any records where the customer number (debnr) is null (empty). The text reads “{cicmpy.debnr} <> ‘NULL’”.

Continue Reading →

Steps For Moving a Macola Database From SQL 2000 to SQL 2012

So you have a brand new Windows Server 2008 R2 server loaded with a sparkling fresh copy of Microsoft SQL 2012 standard. How do you get your precious Macola database off of the old and busted SQL 2000 server and onto the new one without losing your data (and your mind) in the process? 

If It Ain’t Broke…

Many of us have waited way too long to upgrade our Macola databases and servers to a version that was actually created in this century. But in this economy you do what you have to do to survive. Not to worry, there is still hope for a well-planned and successful migration to a new SQL 2012 server with just an extra step or two.

Continue Reading →

How to Create a Financial Report in Macola ES Using the Interactive Statement Tool

In this video, I review the interactive statement tool in Macola ES. This tool allows you to print a financial report, export it to Excel, review financial statements and analyze underlying data and transactions.

To get to this tool, click on the G/L tab and under reports select Interactive balance. The initial view includes date range, type of layout (trial balance, balance sheet, etc) and type of columns you wish to present (year, quarter, month, period). You can also compare your budget to budget scenario, previous year or previous two years.

Continue Reading →

Subscribe to Our Blog


Algorithm hosts live webinars each month on Acumatica, Macola, budgeting, and more! Register in advance here.

Recent Posts