Inbasket, multiple line distributions

 5 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Daniel
Basic Member Send Private Message
Posts: 24
Basic Member
Were in the process of implemetning requisition approvals through PF, one of the issues we have encountered is that the Inbasket does not show the multiple distributions in a req line that has been split between accounting units. Accounting will be reviewing req's for correct acct usage and needs to be able to see the multiple distributions on a line. Drilling on the req is not an option as accounting will not know which line has been split and there could be 100 lines in a req. Does someone have a customized Inbasket that shows multiple distributions on req line that has been split?

Env. 9.0.1
Apps. 9.0.1
Windows/Sql

Thanks

Daniel Burrus
Director, MIS
Special School District of St. Louis County
Daniel Burrus,PMP
Special School District, St. Louis County
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
Are you using the HTML Inbasket display or one created with Design Studio?
David Williams
Daniel
Basic Member Send Private Message
Posts: 24
Basic Member
David, we are using the HTML Inbasket.


Daniel
Daniel Burrus,PMP
Special School District, St. Louis County
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
You can add another DME query to get to the data you're looking for and add it to the Dispay. If the Req line has multiple distributions, what shows up in the display?
David Williams
Daniel
Basic Member Send Private Message
Posts: 24
Basic Member
It just displays the one line and the accounting unit, I'm guessing it just grabs the one line from MMDIST and moves on as there is no looping structure in the html code, if you look in MMDIST there are 2 records for the particular line that has been split and showing the distribution for each.
Daniel Burrus,PMP
Special School District, St. Louis County
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
Daniel - you can query MMDIST and either display all of the distributions or display "MULT" to indicate there are multiple distributions. You would have to build a query within your REQLINE query section to pick up the AU's by line.
David Williams