Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 390
	Members: 0
	Total: 390

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

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

11/11/2010 3:59 PM

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

David Williams

Veteran Member Send Private Message

Posts: 1127

11/11/2010 4:25 PM

Are you using the HTML Inbasket display or one created with Design Studio?

Daniel

Basic Member Send Private Message

Posts: 24

11/11/2010 4:52 PM

David, we are using the HTML Inbasket.

Daniel

David Williams

Veteran Member Send Private Message

Posts: 1127

11/11/2010 5:29 PM

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?

Daniel

Basic Member Send Private Message

Posts: 24

11/11/2010 5:36 PM

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.

David Williams

Veteran Member Send Private Message

Posts: 1127

11/12/2010 12:01 PM

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.