Did you know Acumatica 2019R1 now offers CoLoRs on your generic inquiry screen? Are you tired of having to click through tabs to see what is won or lost on an opportunity?
How many times have you had to click on each tab to see the data you were looking for? Well, the wait is over. While the tab view is very helpful in the daily processing of items, sometimes you just need an overview of everything at once. That is where the new color options (think of conditional formatting) on a generic inquiry would help.
Humans are visual creatures. To get an overview (a page at a time) I modified the Generic Inquiry for Opportunities to see which ones were won or lost then I went a little further and highlighted the dates that were prior to “today’s date”.
The white rows are still open. While the green rows show the won opportunities and the red rows show the lost opportunities. Talking about the step further above, I decided I wanted to see which estimated closed dates were prior to today’s date in order to help me see which open items we needed to work on first. Any date within the open status that is highlighted red means those should have been won or lost by now.
In order to accommodate the picture I had in my head, I went into the Generic Inquiry> Results grid> and under the Row Style section I input a little formula like the one below:
This allows the line items to be color coded as red or green depending on the status.
I went a little further and wanted to see which open items would be considered “past due”, so I had it highlight anything prior to today’s date in red.
While still on the results grid, I clicked in the style box of the line with the date I wanted to see, and I used the below formula:
=IIf([CROpportunity.Status]<>'L' And [CROpportunity.Status]<> 'W', IIf([CROpportunity.CloseDate]<Today(),'bad','default'),'default')
This makes the dates show up red because they were expected to be either won or lost by that date. This will help me know which items will need to be worked first or give to someone as a clean up so we can focus on the items that are current and could be a potential win instead of wasting time on older opportunities that have run their course and we won’t get back.
The reason the won and lost lines do not have a highlighted date is because I specified I didn’t want those in my conditional format as those items are already closed.
This type of formatting can be done on any Generic Inquiry screen. I just wanted to show how “this particular” screen would be helpful to management as an overview instead of the large white spreadsheet format they are used to seeing and having to filer or decipher on their own.
While having tab views in Acumatica is helpful in the day to day world of what needs to be processed, sometimes you just want a large picture view of what is going on in your world. That is where the new color formatting within an Acumatica Generic Inquiry screen comes to play.
Have fun playing around with colors.
Learn about the 5 main challenges manufacturing companies face in HR. Find out how to attract, retain, and engage top talent. Find out how technology and effective management strategies can ensure success in this ever-changing industry with CS3 Technology.
In this intro to our blog series Thriving in the Digital Age: CS3 Technology's Philosophies for Success, our CEO Gary Crouch explains the principles behind CS3 Technology's work philosophies that have guided our business for years.
Discover how Scissortail's Multi-factor Authentication (MFA) release improves sign-in security, protecting your data. Learn about the password requirements and MFA options to ensure a secure experience. Stay informed with the UKG update.
Discover the exceptional culture and commitment of CS3 Technology. Explore how they seamlessly integrate software solutions, provide ongoing support, and foster a close-knit community. Join a transformative journey of collaboration, growth, and empowerment with CS3 Technology.