Reordering lines on an Acumatica sales order

A popular requested enhancement to sales orders has just been added to the Acumatica release number 6.10.0472.  This lets you reorder document lines by using any of the following ways:

  • You can drag-and-drop lines to reorder document lines within one page.
  • You can cut a line on one page by usingCut Rowin the context menu and paste the line on another page by using Insert Cut Row in the context menu.

See below for an example.


Acumatica Sales Order Line Reorder- MaxQ

A very useful feature that you may have missed in the release notes.

Microsoft Power BI, offering small businesses the opportunity to compete with the enterprise-level corporation

Power BI

Power BI, how to level the playing field for your small business.

Small to medium-size businesses often struggle with implementing company-wide analysis programs due to the high cost associated with big data reporting and assessment. In the past, these types of planning software packages required lots of money to purchase and roll out. On top of that, a business owner had to spend money on training someone to be able to read and interpret the information provided.

Microsoft Power BI, offering the same level of performance analytics the big companies use for a fraction of the cost.

Power BI is a cloud-based, business data analysis application. Geared specifically for the small to medium business, Power BI makes big data analytics available to the business owner at a fraction of the cost of other resource tracking/planning softwares. No matter the size of your company, the importance of big data and programs that analyze it correctly is essential. Collecting, assessing, and interpreting data from all pertinent business activities is the way to move your company forward quickly. From sales to production, manufacturing and delivery, Power BI gathers information from all departments on a daily basis, then presents that information to the user.

Easy to use, easy to understand.

Power BI implements a series of user-friendly dashboards and color-coded spread sheets designed to be user friendly and easily understood. By connecting users to a broad scope of data pertaining to all aspects of their business, it allows for rapid analysis and the ability to focus on areas of concern immediately. Power BI runs the analytics daily, there is never a lag time for fresh data.

Top benefits of Power BI.

  • Your data belongs to you. No longer do you have outside companies storing your data and providing it only after a lengthy request Your marketing data, lead and website tracking data, sales data are all kept in-house and available at the touch of a key. This kind of “information immediacy” and internal resource tracking allows your company to make quicker decisions, resulting in faster turn-around and reduced costs. With Power BI you own the data, you mine it yourself and perform the analysis of that information on-site and in-house.
  • For a small business to stay competitive and ahead of the curve requires quick responses on important business decisions. From determining the best products to carry based on market analysis to selecting the best suppliers based on cost and quality analysis, quick decisions are key. The faster an informed decision is made, the sooner you can move product to market. Power BI gives your company the back-story on all data interpreted with the express intent of helping you make the right decision. When you know which markets are growing and where demand is flourishing, you can take advantage of that dynamic instantly.

Because Power BI runs its analytics daily, any deviation in performance will be reported to you. Whether it be marketing shifts, sales force lulls or inventory movement above and beyond regular patterns When you are made aware of an issue at the moment it occurs, you can focus your energies more closely on resolving an issue. Being this agile and resilient in the milieu of a small business is key to success.

  • Low- Cost.Power BI offers “enterprise- level” data analysis at a fraction of the cost. Because it is a cloud-based service you pay a low monthly fee and enjoy all the benefits the big companies pay thousands for. As a small business, anything you can leverage to enhance your bottom line helps you stay competitive.


Big data; collection and analysis is no longer reserved for the larger companies. Smaller companies need to take advantage of every resource they can in order to stay competitive in the modern business world. Power BI was created with small to medium sized businesses in mind to level the playing field. When you are ready to move your company into the data fast-track please contact us.

Non-Stock Kits in Acumatica

I have repeatedly been asked if MaxQ had a product that could help get shippers created for kit items that were not in stock.  While we are about to release an Auto-Kit module (more on this later), most of the requirements can be handled by what appears to be a little known feature already in Acumatica’s Inventory Module, Non-Stock Kits.

Taken from the Acumatica help:

“When a non-stock kit is listed on a sales order as a line item, its stock components are specified on a pick list and shipped to the customer. Upon shipment confirmation, the quantity of stock components is decreased while the quantities of non-stock components and kits are not tracked in any way.

Only the standard cost valuation method may be assigned to non-stock kits.

On the sale of a non-stock kit with stock components, the system generates an inventory issue and debits the COGS accounts of the stock components (by their costs). On the sale of a non-stock kit with only non-stock components, no inventory issue is generated.”

Create Non-Stock Kit Inventory ID

Create a non-stock inventory item to be the parent part.


Create Kit Specifications

Enter the kit specifications.


Note: The was a fix in release 5.3.249 properly displayed the Non-stock check box.

Enter a Sales Order

Create a sales order for the non-stock kit

Enter a sales order that has the non-stocking kit inventory Id on it


Component Inventory Check

Try to create Shipment.


An error will be raised if a component does not have sufficient availability.



Receive Component Inventory

Create Shipment when component inventory is available.


After the component is received into inventory, a shipment can now be generated.

Print Pick List

Notice Components Show on Pick List



6 Uses for Microsoft Power BI

Microsoft Power BI is an essential software system for businesses with large amounts of disparate data created during the normal course of business operations. There are many uses for a software system like Power BI (BI stands for Business Intelligence).

The following six uses, visualization, server-level management, integrated analytics, streamlined processes, and detail oriented visualization give your business the tools to process information and create quality management systems.

  1. Intuitive Visualization

Visualization of data is essential for human management of business systems. While computer programs eat data for lunch, business people have rather more varied diets and need to be able to easily see and understand data regarding their business. A great program like Power BI gives you the tools to swiftly and accurately visualize key data points regarding your business from many different sources in a single dashboard.

Not only does Power BI provide great visualization, but it also integrates with Cortana by default. This means that you can visualize data, interact with it in your OS, and search your data with Cortana’s powerful AI systems.

  1. Server-Level Data Management

Data comes into your business from a variety of sources. Most of those sources touch a server at some point. Power BI gives you tools to manage business information at the server level so that you have more comprehensive and complete information systems than would be provided if you merely collected data from a program operating on several computers.

  1. Integrate Analytics With Internal Software Systems

What software systems do you use to manage your business? These are your internal software systems. Managing your business processes requires that you access data from the entire software system you use to manage your business. As seen by the list of compatible software programs, Power BI integrates with almost any software platform you will use for business management. This includes mail management, social media platforms, accounting software, CRMs, and traditional data platforms like Azure and MySQL. Integrated data management means your business does not need to use multiple dashboards for data management: Power BI will give you all the information you need.

  1. Provide Complex Information Within Your Own External Software and Apps

Not only does Power BI take information from a variety of sources, but it also provides it in a variety of contexts, including embedded within your own apps through Microsoft’s API. Not only does this give you tools to manage your own business with custom apps, but it also gives you a product value-add that you can create for your customers where they are able to track and identify key data sets regarding your product or service.

  1. Streamline Processes (Sales, Marketing, Operations, etc.)

Sales, marketing, operations, HR, and other business departments often create their own data sets, their own KPIs and need their own data management. Power BI provides specific functionality for customers who can use its comprehensive data management to streamline processes in different departments.

Rather than recreating the wheel for each part of your business, Power BI comes with the templates for intuitive dashboards and reporting systems to give teams the ability to manage their quality and efficiency without customizing the software.

  1. Visualize Details Easily

A great BI dashboard like Power BI gives you the capability to dial in to any level of detail you need to ensure that your business is running successfully. While some businesses need to be able to track small amounts of inventory, others need to track sales calls made by sales team members. Each of these data sets can be called up with Power BI’s algorithms and delivered in a readable and understandable format.

For more information on business management and quality control systems, please contact us today and ask how to integrate Power BI with your current software systems.


Changing Acumatica Grid Column Headings at Runtime

Changing Acumatica Grid Column Headings at Runtime

Acumatica allows developers to dynamically change the headings of grid columns when the user changes the values of fields that are not in the grid.

For this to work, there are three things that the developer must do.  First, the controls that the non-grid fields are bound to must have their CommitChanges property set to True.  This is to ensure that changes to their values will cause a postback and that the RowSelected event of the associated cache will be fired.

Next, within the RowSelected event handler of the non-grid cache, the developer must call the PXUIFieldAttribute.SetDisplayName method to specify what the new column heading will be.

Finally, the Grid’s RepaintColumns must be set to True in order to ensure that the grid gets repainted when the postback completes.

Below is an example implementation of the RowSelected event that changes the heading of the Sales Orders screen’s Free Item column. This will change the column heading from “Free Item” to “Ext Free” or “Free” based on the value of the CustomerRefNbr field.




protected void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e)


    if (e.Row == null) return;

        SOOrder data = (SOOrder)e.Row;


    PXUIFieldAttribute.SetDisplayName<SOLine.isFree>(Base.Transactions.Cache, (data.CustomerRefNbr == “A1”) ? “Ext Free” : “Free”);






Cloud Computing Soon Used by The Pentagon: Why Do Companies Hold Off on Technology?



Cloud computing is a technology that’s virtually revolutionized the storage of data and in how businesses potentially operate. But even the largest corporations hold off on technology that’s seemingly mainstream. The cloud is one piece of technology where even a few major government organizations have sat on the fence. The Pentagon is one surprising government source that’s shied away from the cloud as a major part of their data management.

This is about to change with reports The Pentagon will soon start using the cloud on a wider basis, even if there’s still worries about secure implementation. What’s kept major government organizations and even some corporations from using the cloud to their benefit? Most of this comes in misconceptions, especially through the media that sometimes paints the cloud as not a safe place for sensitive documents.

All of this has to change with a new sense of education about what cloud computing does and how it’s used.

Setting the Record Straight on Using the Cloud

Fear seemed to permeate in the corporate atmosphere late this last year when Apple experienced hacks through their iCloud that leaked private celebrity photos. This led to unfounded fears about how safe the cloud really is without realizing how careful monitoring would have prevented it. No matter what kind of technology you use, it’s easily abused when not managed right. It’s been the same with TV for years where many criticize the device rather than the content.

In truth, the cloud is the safest data storage technology out there, as well as a major cost-saver. The Pentagon is moving to the cloud for the same reasons, as well as realizing the efficiency it brings. Corporations locating a cloud provider with excellent management find out how much the cloud is a lifesaver when budgets need tightening and when disasters strike.

The cloud saves you money because it eliminates the extreme expense of running your own server. Then, when an unexpected disaster strikes, all your corporate data is still accessible in another location with an Internet connection.

In time, it’s going to serve The Pentagon well. It also can serve your corporation well through our own cloud solution here at MaxQ Technologies, Inc.

Contact us to find out more about cloud computing and why it isn’t necessary to ever have ambivalence about the cloud’s ability to make corporate life more efficient.


Five Demand Planning Mistakes That Could Cost You Money

Past Future Buttons Showing Progress Or Time

Investing in a good demand planning tool and using it to create accurate forecasts for your inventory is a great start. However, relying on an automated solution does not prevent you from making these common mistakes that could cost your business money.

  • Some businesses make the mistake of using demand planning solely to make their distribution channels more efficient. You will get more out of your investment if you rely on the data to optimize the production process as well. Demand planning can for instance be used to determine what your manufacturer should be producing.


  • Do not adopt a demand planning model that is too simplistic. Relying on an automated tool will give you access to detailed reports regarding demand but you should use this data to create a comprehensive inventory forecast. Take factors such as products, time and locations into account.


  • Failing to establish some best practices for demand planning could lead to incorrect data. Since inventory forecast tools gather data from several departments and business processes, make sure best practices are relevant for each department or process.


  • Use your demand planning tool to look for patterns that repeat themselves on the long-term instead of using it to create inventory forecasts that will be used no the short-term. Focusing on the short-term helps you deliver products on time but patterns allow you to improve business processes.


  • Do not optimize business processes too soon. Gathering relevant data takes time and it might be months before the reports created by your demand planning tool are comprehensive enough to be helpful.


Getting the most out of your demand planning tool requires you to become familiar with its features and with several concepts related to inventory forecasting. You can easily avoid these mistakes by working with the right demand planning software provider. You should contact us at MaxQ Technologies to learn more about the solutions we offer.