Skip to main content

Acumatica Visual Cues - How to colorize the grid in 2019 R1?

Acumatica introduced the concept of visual cues, this is a platform feature which means its available across all screens, modules and plugins for customers, partners and ISVs.
Visual cues are sensory cues received by the eye in the form of light and processed by the visual system during visual perception 
ERP users love the fact they would like to see few color indicators providing visual cues to data so they can work and organize better, they would like to setup few threshold or trigger points to take action eg: Show green  =  for everything that's good, Or show   red  = for something wrong, these visual cues really help users to to view their next set of tasks/activities and get it done.

Here is a quick snapshot of Sales order screen where we were able to colorize the grid for certain threshold or parameters.

a) Show all rows as green color for those records where the order type is invoice, who doesn't like green (money) when we get paid or invoiced.
b) We indicated the column order total as red if the order or invoice amount is beyond $300,000 so users can watch for this big order and process them or whatever the reasoning could be

You can setup your visual cues in generic inquiry (G.I. Joe, that's right I named it) by opening the sales order GI and editing the rowstyle level and field level as shown in the screenshot below.
You can use field values to validate certain conditions and set the pre-defined values of color or create your own set of colors. (Now pls don't ask for flashing red color lol)

Do's and Dont's

1. Do add visual colors to minimal for actionable items, indicators that ever user would like to monitor
2. Don't colorize more than 2 or 3 colors, stick with low coloring scheme for rows such as cyan, silver, light blue, light yellow etc and
3. Do color specific column or cell with red or bright colors to stand out just that individual column/row/cell where the conditions occur sparingly to indicate and assist you

Have fun with visual cues in 2019 R1.

Comments

Popular posts from this blog

Acumatica JewelShop - JCK Las Vegas Convention for Jewelry Business

Acumatica JewelShop , new plugin for Jewelry wholesale business and custom jewelry manufacturers. Visit us at JCK LAS VEGAS - Booth B50042 | May 31 to Jun 2nd. SANDS EXPO & THE VENETIAN LAS VEGAS, NV https://lasvegas.jckonline.com/ Visit our website for product information  Visit our website for more information about Acumatica JewelShop

Acumatica Snapshots - Uploading and restoring large files

In Acumatica ERP, you can create company snapshots containing your company’s full or partial data. Snapshots that can be saved locally in the same database, or at a specified location. You can import and restore snapshot to another company, in this case test company, it's pretty handy tool very useful during implementations, customization and support/troubleshooting while you work with data. You will occasionally run into few technical issues with snapshots, the newer version now needs you to keep all users logged out and in maintenance mode to take snapshot, link to blog article here. Today we are going to discuss how to export and import snapshots which are larger in file size of above 1GB, this is not a limitation from Acumatica and more to do with constraint and default value set in IIS (Internet Information Server). IIS by default allows uploading of a file size of 1GB and it limits the upload process and it can be tweaked to upload upto 4 GB file size and that's

Acumatica User Defined Fields/Values - UDF using attributes in 2018 R2

In 2018 R2 version Acumatica introduced new feature called "User Defined fields" in short UDF's. These fields allow users to configure existing document screens to capture custom data per document basis. New features like this really helps partner/customer to configure business workflow process, this capability built on a framework can now enhance existing documents like Sales order, purchase order or other document to collect custom data at transaction level using attributes. For more information on which documents/screens you can collect UDF's refer to Acumatica help  In this example I have created few custom data that we would like to accept in our Print industry, this works pretty well with our Acumatica plugin PrintShop for Screen printing and embroidery companies, as business do accept different type of data and allows us to do minimal customizations. If your accepting custom data related to art work, then you can create those attributes ahead of