How to output to excel from UBE?


Well Known Member
Here's my requirements. I have records in F44H501 and there are different types of individuals in there like brokers and agents. I want to put brokers on one sheet of excel and agents on another sheet. On each sheet, I want to group by an individual and list their commissions and sales and totals below it.

I want the output to be in excel from my UBE. So in my Report Definition I'll select Excel as output. How do I place the report variables in the UBE to get what I need to do above please? I've never output to excel before. Do you have a tutorial how to do this?

JDE 9.1
Last edited: