Has anyone ever come up with anything that "resembles" Fishbowl for inventory purposes?
In regards to the color coding, red, yellow, green... ok to ship orders. I know you can do KPI's but on an actual GI.
Solved
Fishbowl for Inventory
+16Best answer by bwhite49
I guess the biggest issue with the color coding is the limitation on aggregated calculations. We can’t color code based on a COUNT or SUM formulas for example. This limits what we can do.
Attached is something close, but not perfect.
Do you have a screenshot of Fishbowl? I’m not familiar with the layout.
I’m curious what this looks like. I’ve created a few GIs color coding shipping logic (can be shipped, etc.). Filters around calculated fields that define whether an order can be shipped.
1 person likes this
+16ricoybanez wrote:
Yes, color coded for shipments and inventory.
I guess the biggest issue with the color coding is the limitation on aggregated calculations. We can’t color code based on a COUNT or SUM formulas for example. This limits what we can do.
Attached is something close, but not perfect.
+1Hi
On your GI do the following depending on what condition you will be using, for my sample I used the STATUS as my condition on the color coding:
Condition:
=IIf( [RQRequest.Status]='N','yellow', 'default')
Rico P. Ybanez
+16bwhite49 wrote:
I guess the biggest issue with the color coding is the limitation on aggregated calculations. We can’t color code based on a COUNT or SUM formulas for example. This limits what we can do.
Attached is something close, but not perfect.
Thank you
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.