MaxQ

PARTNER CONNECTION

Business Solutions for Maximum Performance

November 2016 Newsletter

The Superb Combination of Power BI, IoT, and Azure Stream Analytics.

If John Greenough, who is a Senior Research Analyst for BI (Business Insider) Intelligence is to be believed, there will be an astounding 24 billion devices comprising the IoT by the year 2020, according to an article by John Greenough and Jonathan Camhi titled How the ‘Internet of Things’ will affect the world.  This monumental development now in play is being called the next Industrial Revolution and is expected to generate $6 trillion worth of spending over the next 5 years.

For the business management or high-tech professional in the line of decision making the question naturally becomes, how is value generated from the use of hundreds, thousands, or even millions of sensors, from automated and internet-enabled machinery on assembly lines, in supply chains and throughout transportation networks, from continuous video feeds emanating from countless intelligent devices, etc.  A big part of the answer lies in turning all of this data into a form that the human mind can readily comprehend.  Herein lies the genius of Microsoft Power BI.

NEW Releases

Customer Collections
Improve Cash Flow and Collections Management

View all your Account Receivable data and manage your collection activities in one easy to use screen.

Consulting Corner

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. Most of the requirements can be handled by what appears to be a little know feature already in Acumatica’s Inventory Module, Non-Stock Kits.

Development Tips

Acumatica Localization
Before you can utilize the localization features of Acumatica, you must ensure that your environment has more than one active locale configured. This is done on the System Locales page (System -> Management -> System Locales).

Support Hints & Tricks

Customer Service Tip
The save button is missing on the MaxQ forms until the products are registered

The Superb Combination of Power BI, IoT, and Azure Stream Analytics

If John Greenough, who is a Senior Research Analyst for BI (Business Insider) Intelligence is to be believed, there will be an astounding 24 billion devices comprising the IoT by the year 2020, according to an article by John Greenough and Jonathan Camhi titled How the ‘Internet of Things’ will affect the world.  This monumental development now in play is being called the next Industrial Revolution and is expected to generate $6 trillion worth of spending over the next 5 years.

For the business management or high-tech professional in the line of decision making the question naturally becomes, how is value generated from the use of hundreds, thousands, or even millions of sensors, from automated and internet-enabled machinery on assembly lines, in supply chains and throughout transportation networks, from continuous video feeds emanating from countless intelligent devices, etc.  A big part of the answer lies in turning all of this data into a form that the human mind can readily comprehend.  Herein lies the genius of Microsoft Power BI.

Power BI has about 5 million users and features excellent graphic visuals that turn live data into rich displays.  And Power BI just received an extremely useful and powerful update with the addition of Azure Stream Analytics, which acts as a bridge between Power BI and the IoT.  “By integrating Power BI, Microsoft’s business intelligence and analytics product, and Microsoft’s Azure Stream Analytics, it is now possible to create interactive, live dashboards that offer users an up-to-the-minute overview of their IoT device deployments,” according to a blog by apacciooutlook.com titled Azure Stream Analytics Integrates with Power BI; Converts IoT Data into Real-time Insights.

“Devices are becoming smarter and more connected, and the expectation of what can be done with the data generated and collected from these devices continues to evolve both in the commercial and consumer spaces. Whether you are doing health monitoring, building or home automation, social media analytics, application monitoring, energy management, manufacturing, etc., there are millions of events or messages being generated from devices from which you need to gain real-time insights,” according to comments derived from a speech by Dipanjan Banik, Bryan Hollar, Richard McCormack, Clemens Szyperski, and Todd Van Nurden titled Gaining Real-Time IoT Insights using Azure Stream Analytics, AzureML and PowerBI.  The devices which generate events or messages can include things like internet-intelligent sensors, tracking devices, and alerts in appliances and in machinery, to name but a few of the myriad possibilities.  Of course, there are intelligent cars, airplanes, and even entire ‘smart cities’ currently under development, with an untold number of internet-intelligent devices built-in.

One of the things that makes all of this up-to-the-minute information rendered in the graphical format of Power BI so great is that oftentimes problems can be spotted immediately, greatly shortening the response time.  Ryan CrawCour, a program manager at Microsoft Azure Stream Analytics, states:  “This (adding the power of Azure Stream Analytics to Power BI) will dramatically reduce the latency and time to action on your most important business metrics,” from an article by Pedro Hernandez titled Microsoft Power BI Visualizes IoT Data From Azure Stream Analytics.  A good implementation can conceivably upload, process, analyse and display all manufacturing and other procedural data instantaneously, regardless of physical location.  So “Intelligent systems enable users to parse vast quantities of data from multiple disparate sources and then display the data visually in a way that helps business trends to stand out,” according to Brien Posey in an article titled Microsoft’s Power BI puts business users at forefront.

In the world of software development, APIs that feed data into Power BI are being built left and right, because “data is exploding and the ability to take that and do interesting things with it so you can provide more productive apps is the opportunity everyone wants to embrace,” according to James Phillips, here quoted in an article by Mary Branscombe titled Embedded Power BI Microsoft cloud apps could all turn into platforms.  Software developers like Carl de Souza, writing in an article titled Why I Love Power BI, Top 10 Reasons, love Power BI because of its ability to easily create great visualizations, share reports, run on a wide variety of mobile devices, refresh data according to schedule, and pull data from many different sources, among other great advantages.

The future is shaping up to be an amazing arena of great challenge as more billions of intelligent devices come online and the data continues to flood in at volumes that are so vast and from so many disparate sources that it boggles the human imagination.  Microsoft Power BI and Microsoft Azure Stream Analytics will continue to be right in the thick of this intense and unprecedented wave of development that’s poised to change the world forever.

For more information, please contact us.

New Releases

3d-consulting

Customer Collections

View all your Account Receivable data and manage your collection activities in one easy to use screen.

  • Improve Cash flow
  • Manage the entire AR collection process
  • Track Activities and Calls
  • Reduce Credit Risk
  • Track Customer Payment Histories

nr1

Consulting Corner

3d-consulting

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.

non-stock-items-1

Create Kit Specifications

Enter the kit specifications.

non-stock-items-2

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

non-stock-items-3

Component Inventory Check

Try to create Shipment.

non-stock-items-4

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

non-stock-items-5

non-stock-items-6

Receive Component Inventory

Create Shipment when component inventory is available.

non-stock-items-7

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

Print Pick List

Notice  Components Show on Pick List

non-stock-items-8

non-stock-items-9

Development Tips

 

3d-development

Acumatica Localization

 

Before you can utilize the localization features of Acumatica, you must ensure that your environment has more than one active locale configured. This is done on the System Locales page (System -> Management -> System Locales). Once you have configured at least two active locales, click the “SET UP LANGUAGES” button. Use the window that pops up to select a default language and click the “APPLY” button.

dev1

Once this is done, you will notice two changes in Acumatica. First, on the top right side of the login page there will be a combo box that allows you to select a language when you login.

dev2

Second, on many fields throughout the system you will notice a localization hyperlink next to fields that can contain localized values.  Below is the Non-Stock Items page.  Notice the localization hyperlink next to the description field.

dev3

To make your own custom fields localizable, you must first ensure that the table that contains the field(s) to be made localizable includes a column named NoteID of uniqueidentifier type. This field should be decorated with the PXNote attribute in your DAC. Next, you must create a localization table in the database to hold the localized values. This table must have the same name as the table containing the column(s) to be localized plus “KvExt” (e.g. the table that holds the localized values for columns residing on the InventoryItem table is named InventoryItemKvExt). This table must have the following columns:

dev4

The primary key of the this new table must be on the CompanyID, RecordID and FieldName columns.

Note that you can make more than one field on the same table localizable. The localized values for all of the localizable fields on a table will be stored in a single localization table.

You do not need to create a DAC for the localization table.

Finally, to make a field in your custom DAC localizable, you must decorate it with the PXDBLocalizableString attribute. This attribute will be used in place of the PXDBString attribute. Here’s the definition of the Descr (Description) field from the InventoryItem DAC:

#region Descr
public abstract class descr : PX.Data.IBqlField

}
{
protected String _Descr;

/// <summary>
/// The description of the Inventory 
/// </summary>
[PXDBLocalizableString(255, IsUnicode = true)]
[PXUIField(DisplayName = “Description”, Visibility = PXUIVisibility.SelectorVisible)]
[PX.Data.EP.PXFieldDescription]
public virtual String Descr
{
    get
    {
        return this._Descr;
    }
    set
    {
        this._Descr = value;
    }
}
#endregion

Support Hints and Tricks

 

3d-support

Customer Service Tip

The save button is missing on the MaxQ forms until the products are registered.

cs1

Register the module(s),

cs2

Save button now appears

cs3