MaxQ

PARTNER CONNECTION

Business Solutions for Maximum Performance

May 2016 Newsletter

New Research Offers Insights into Users of Mobile Devices

Technological change is occurring at a pace rapid enough to disorient even the savviest IT professionals. Staying on top of these trends has become an obsession in many organizations. But new technology doesn’t emerge in a vacuum. It proceeds from marketing forces that have shaped the business world since the dawn of the free enterprise system.

Understanding these dynamics can help businesses to respond to, and even anticipate, emerging opportunities for gaining market share. Put another way, there’s no substitute for knowing as much as possible about your customer.

Fortunately, as more and more people integrate mobile computing technology into their daily lives, it’s possible to create an increasingly accurate profile of these consumers. With that in mind, here are five attributes of mobile device users culled from a recent a recent Pew Research study:

NEW Releases

ARM Advanced Analytics
A major rewrite of our ARM Analytics module, built for Power BI and Excel using OData Generic Queries feeds from Acumatica. It provides a complete picture of your subscription business.

Consulting Corner

Generic Inquiry Changes in Acumatica 5.3 explained
In Acumatica version 5.3 you may have noticed some mysterious warnings appearing on your generic inquiries

Development Tips

Programmatically Dealing with Graphs that Launch Long Running Operations

Some Acumatica graphs launch “long running operations” when certain actions occur. These operations are executed on a different thread from the graph’s normal operations.

Support Hints & Tricks

Q: Check amounts are only showing as *’s in AP laser checks.

A: customer using the MaxQ AP Laser Checks module for Acumatica and finds themselves printing a check. They go through all the proper steps…

New Research Offers Insights into Users of Mobile Devices

Technological change is occurring at a pace rapid enough to disorient even the savviest IT professionals. Staying on top of these trends has become an obsession in many organizations. But new technology doesn’t emerge in a vacuum. It proceeds from marketing forces that have shaped the business world since the dawn of the free enterprise system.

Understanding these dynamics can help businesses to respond to, and even anticipate, emerging opportunities for gaining market share. Put another way, there’s no substitute for knowing as much as possible about your customer.

Fortunately, as more and more people integrate mobile computing technology into their daily lives, it’s possible to create an increasingly accurate profile of these consumers. With that in mind, here are five attributes of mobile device users culled from a recent a recent Pew Research study:

  1. Those who rely on a smartphone as their primary link to the Internet are, as a whole, both young and not yet at their peak earning potential. Of this group, a significant number are “smartphone dependent” in the same way that past generations relied on automobiles and wired telephones to function economically and socially.
  2. Older and upper-income consumers, while also avid smartphone users, rely on a greater variety of devices to access the Internet. While smartphones have become a virtual necessity across income levels, tablets and other mobile devices are largely regarded as luxuries reserved for people of means.
  3. 97% of smartphone users send text messages on a regular basis. Text messaging has become more common than email as a way of sharing information and staying in touch.
  4. Almost half of smartphone owners report using their device to avoid human interaction. For many, their mobile computing device has become a de facto friend and companion throughout their daily activities. This trend is expected to accelerate as improving technology creates ever more useful applications.
  5. About half of smartphone users have a greater appetite for data than their plans are designed to accommodate. 51% report exceeding the limits of their data plan either frequently or occasionally.

Conclusions to Draw

Unsurprisingly, the Pew Research study provides further confirmation that America has become a mobile society. However, the report also offers less obvious nuggets of insight that can benefit businesses. These include:

  • Primary dependence upon smartphones as opposed to other mobile devices like tablets, especially among younger and lower-income consumers.
  • Use of mobile devices to serve entertainment and socialization needs, often as a substitute for direct person-to-person interaction.
  • An ever-growing demand for applications that can benefit users in every aspect of their lives on both emotional and informational levels.

These findings offer value as springboards for discussion at all levels of management. Those organizations that can match these insights to their portfolio of goods and services can enjoy rich returns in this age of the mobile consumer. Of course, in order to exploit these opportunities, you must first have a supply chain capable of responding to an ever-changing market. To find out how to achieve this capability, contact us today.

New Releases

3d-consulting

ARM Advanced Analytics

A major rewrite of our ARM Analytics module, built for Power BI and Excel using OData Generic Queries feeds from Acumatica. It provides a complete picture of your subscription business. A complete model that includes and extensive set of pre-built measures allows you to easily create any visual you would like to see. Bring your business to the next level!

Consulting Corner

 

3d-consulting

Generic Inquiry Changes in Acumatica 5.3 explained

In Acumatica version 5.3 you may have noticed some mysterious warnings appearing on your generic inquiries. I could not find any documentation on why this started showing up. After a little digging this is what I discovered.

Problem

Let’s start with a simple test generic query.

Just use the SOOrder table

On the Results Grid add OrderNBR and CustomerID_Description and you will see the warning.

MaxQ Acumatica Generic Inquiry Warning

Generic Inquiry has automatically joined to the BAccount table to get the Account Name (customerID_Description – BAccount.AcctName) to be displayed.

Acumatica created the following SQL Statement to retrieve the SOOrder records. Not so easy to understand, lots of things going on.

SELECT TOP (33)  [SOHeader].[OrderType] [SOHeader_OrderType],  [SOHeader].[OrderNbr] [SOHeader_OrderNbr],  [SOHeader].[CustomerID] [SOHeader_CustomerID],  [SOHeader].[NoteID] [SOHeader_NoteID],  (SELECT TOP (1) [NoteText] FROM [dbo].[Note]  WHERE ([dbo].[Note].CompanyID IN (1, 7) AND 32 = SUBSTRING([dbo].[Note].CompanyMask, 2, 1) & 32) AND [Note].[NoteId] = [SOHeader].[NoteID]) [SOHeader_NoteText],  (SELECT TOP (1) COUNT(*) FROM [dbo].[NoteDoc]  WHERE ([dbo].[NoteDoc].CompanyID IN (1, 7) AND 32 = SUBSTRING([dbo].[NoteDoc].CompanyMask, 2, 1) & 32) AND [NoteDoc].[NoteId] = [SOHeader].[NoteID]) [SOHeader_NoteFiles],  [SOHeader].[CuryID] [SOHeader_CuryID],  [SOHeader].[CuryInfoID] [SOHeader_CuryInfoID] FROM SOOrder [SOHeader]  WHERE ([SOHeader].CompanyID = 7) AND ([SOHeader].BranchID IS NULL OR [SOHeader].BranchID IN (5, 6, 10, 11, 12, 13)) ORDER BY  [SOHeader].[OrderType] ASC,  [SOHeader].[OrderNbr] ASC OPTION(OPTIMIZE FOR UNKNOWN) /* 00.00.00.00 */

To simplify, we can manually create a simplified SQL statement that will provide what we need to see to understand what is Generic Inquiry is doing.

First it returns all of the SOOrder header records.

Select OrderNbr, CustomerID From SOOrder Where CompanyID = 7 Order By SOOrder.OrderNbr

Next, it then loops through each of the customer ids and retrieves the AcctName. It caches the results so that for each name it only does the BAccount look up once.

Select AcctName From BAccount Where BAccountID = 2470 And CompanyID = 7

From BAccount Where BAccountID = 260 And CompanyID = 7

Select AcctName From BAccount Where BAccountID = 262 And CompanyID = 7

Example of this in SQL

With bigger record sets this can get very inefficient.

Solution

So how do we improve the performance and get rid of the warning. Easy!

We add the BAccount table to the Tables tab on the generic inquiry.

Create the relations between the Tables  (join).

Replace the default customerID_Description with AcctName from the BAccount Table and warning disappears.

Now when Acumatica executes the query it runs the equivalent of:

Select SOOrder.OrderNbr, BAccount.AcctName

From SOOrder Inner Join BAccount On SOOrder.CompanyID = BAccount.CompanyID

And SOOrder.CustomerID = BAccount.BAccountID

Where SOOrder.CompanyID = 7

Order By SOOrder.OrderNbr

A much more efficient SQL query. Mystery solved.

Development Tips

 

3d-development

Programmatically Dealing with Graphs that Launch Long Running Operations

 

Some Acumatica graphs launch “long running operations” when certain actions occur. These operations are executed on a different thread from the graph’s normal operations. In some instances, this can cause the graph’s cache to become out of date as the long running operation may modify the records that it contains.

One example of the this is the AR Invoices and Memos graph (PX.Objects.AR.ARInvoiceEntry) in environments where the Alavara integration is enabled. In these environments, the ARInvoiceEntry graph, will start a long running operation to calculate the tax amount when the Save.Press() method is called. This will result in the graph’s current ARInvoice instance in the its Document view becomming out of date (it will not include the updates made by the tax calculation). So, if you try to perform another operation after the save (for example releasing the invoice), you will get an error.

The solution to this problem is to clear the graph’s cache and reload the invoice after it has been saved. The code snippet below saves an invoice, clears the cache, reloads the invoice and finally releases it.

// save the document
InvEntry.Save.Press();

// preserve the reference number and doc type so we can reload the document
RefNbr = InvEntry.Document.Current.RefNbr;
DocType = InvEntry.Document.Current.DocType;

//clear the cache and reload the document to ensure that we have the most recent version
InvEntry.Clear();
InvEntry.Document.Current = InvEntry.Document.Search<ARInvoice.refNbr>)RefNbr, DocType);

//release the document
InvEntry.release.Press();

Support Hints and Tricks

 

3d-support

Q) Check amounts are only showing as *’s in AP laser checks.

A) A customer using the MaxQ AP Laser Checks module for Acumatica and finds themselves printing a check. They go through all the proper steps, have the check print and upon further examination of the check they find the amount which was intended to be $100.00 is now showing as *’s. Obviously not correct but easily solved. Navigate to the Branches Screen under Organization Structure and select the branch, they are currently using they will find that the Currency Symbol field is blank. Enter a dollar sign ($), in the field and the next time the checks will correctly.