Can LPL Use an Array to Create, Display, and Export a List?

Darryl Howard

The Item Lifecycle Managment (ILM) application sometimes displays very longs lists of POs for items matching recalls. I need to add a couple of buttons that will pop-up lists, similar to helper lists, to summarize the PO list.

One pop-up list would display the unique Cost Centers and their descriptions from the PO list, and the other would display the unique item numbers in the PO list, with a count of each item.

Ideally, this would be an array declared as a local field. Once displayed, I want to be able to export the list to a CSV, as I can for any helper list.

Is this possible?

Darryl Howard

I don't think using an array here is possible. I can create a Report for the list, but I haven't been able to get the desired results.

For this list:

Company	Purchase Order	Line	Ship To	Item	Item Type	CEID	Cost Center
1000	92001311813	1	SSC	29525	Special	31721540	813921
1000	92001311814	1	SSC	29525	Special	50890304	813921
1000	92001311815	1	SSC	29525	Special	50890335	813920
1000	92001311816	1	SSC	29525	Special	14423652	813920
1000	92001311817	1	SSC	UH29525	Special	14418727	813920
1000	92001311818	1	SSC	UH29525	Special	50741116	813920
1000	92001311819	1	SSC	UH29525	Special	50741197	813920

I want to produce the lists below. The Company columns can be removed if needed.

The first shows the unique Items and the count of each. I can get this list by exporting the full list to Excel and using a Pivot Table, but I want an Infor-based solution.

The second shows the unique Cost Centers. This can also be achieved with an Excel export and removing duplicates.

Company	Item	Count
1000	29525	4
1000	UH29525	3

Company	Cost Center
1000	813921
1000	813920

I created a Report, but it just lists all the item numbers from the original list. Here's the LPL.

RecallPurchaseOrderLines is a List
    is report
        module is recall
    title is "PurchaseOrderLines"
    single select
    initially display search
    orientation is landscape
    font offset is 0
    Display Fields
        instance count of RecallProductTransaction.PurchaseOrderLineRel.Item
            label is untranslatable:"Item"
    open action is restricted
    restrict action HoldToggleContractLine
    Actions
        action is search
            label is untranslatable:"Search"