Purchase Order Grouping on a listpage. Im trying to add grouping on a simple list page that uses three custom tables for my Dataloader into AX. I am then trying to extract that data into forms to who the reconiliated accounts. When they come in each line has a transaction type associate to it. I then use that transaction type on another table and have it associated to a group; 100, 200, 300. I am having an issue with grouping on the form. I want to use the grouping cost so that when the client opens the form their will be 3 lines on the list page. 100,200, and 300; one for each grouping code. then give access to the Reconciliated line associated to each of the three Groups. 2012 has a different sorting and grouping then in the old system and im still need to AX so im having an issue in creating this grouping. I trying using a Query to create the grouping and range but was unsuccessful. If anyone could give me assistance in this that would be appreciated. The three tables I use for create the form is MOREconciliationTable, MOReconciliationTrans, and MOTransactionTypet. MOTransactionType this table has the transaction type and group association on it.
*This post is locked for comments