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 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...

Acumatica Import Scenario - Importing Attributes

Acumatica Attributes are type of pre-defined custom fields that users can utilize in capturing data, validating or storing information across Customers, Vendors, Inventory and various other data entry screens such as Leads, Opportunities, Projects, AP, AR etc. There are 5 different attribute types that you can store data in Acumatica Text : A text box into which the user can type text (Control Value 1) Combo : A list box users can use to type or select options (Control Value 2) Not available :) Checkbox : A check box users can select or clear (Control Value  4) Datetime : An element for selecting date and time (Control Value 5) Multi Select Combo : A list box where users can select multiple options (Control Value 6) You can manually configure each attribute by navigating to Configuration --> Common Settings --> Attribute screen and create attributes if they are fewer to keyin, however if you have large set of attributes that you would like ...