I have a request to create an AGING type lobby tile. Not even sure that this is a possibility.
Has anyone created something like this before? and if so would not mind to show me the data element behind the tile?
The only thing I can think is to create a series of tiles, with 1-30, 31-60, 61-90 days as a criteria.
Assuming you are talking about customer aging, your starting point should probably be the “customer credit analysis” window. Here, the customer debt is displayed in aging buckets.
There is basic data that allows you to set the length of each bucket.
Note that you have to populate this window via a separate function which, from memory, is called “calculate customer credit information”
Just checking in Cloud, there is a customer aging analysis lobby element which I think is also there in 10?
Hope that helps a little,
Steve
Hello,
You could create an IAL and use this as the view on the Data Source. The IAL could hold data as,
Part Qty1-30 Qty31-60 Qty61-90
x 15 30 45
y 15 30 45
z 15 30 45
You could then show this as a List element?
You can also enter select statements in as custom columns on the Data Source, if you add a column and enter something like this,
(SELECT QTY_ONHAND FROM &AO.INVENTORY_PART_IN_STOCK_UIV WHERE PART_NO = INVENTORY_PART.PART_NO AND CONTRACT = INVENTORY_PART.CONTRACT)
The data in BOLD are the fields from the view within the Data Source.
actually an outstanding invoice by salesperson aging….but same concept as the ar aging.
where rows would be sales person and columns would be the total $ amounts outstanding per day bracket.
thanks,
Cindy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.