• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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: