Aging type lobby tile

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.

@ArcStephA 

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