If this message bother you, here you have it easy
Let’s set the scene: Month-end close. The pressure is on, and you have to process a flat file with miscellaneous expenses. The hard part isn't just data entry; it's the logistics: separating by Company, identifying different Currencies, and ensuring the G/L Date is correct.
Doing this manually in P0911 is a guarantee for human error and leaving the office late.
The Turn: Intelligent Grouping with Orchestrator
Thanks to a brilliant idea from Victor Figueroa (thanks for the challenge!), we are going to build a solution that doesn't just load data, but "thinks" like an accountant.
The Goal: CSV -> Grouped Entries -> Audit Report -> Notification to Manager.
The Challenge Steps (The Recipe):
The Executor (Child Orchestrator): Create a simple orchestration for P0911.
Header: Explanation, Company, G/L Date, Currency.
Detail: Account, Amount, and Detail Explanation (Remark).
The Brain (Parent Orchestrator): Here lies the magic. You need Tool Release 9.2.7.4+ to read the CSV natively.
2.1 The Grouping Trick: In the CSV Custom Request, mark the grouping fields (Company, Currency, Explanation) as "Header". This tells JDE: "Everything sharing this data goes into the same Journal Entry." Goodbye manual Excel separation!
2.2 The Iteration: Call the Orchestrator from step 1. It will create one entry per unique group found.
2.3 The Audit (R09321): Call the Journal Entry report filtering by the batch explanation. ⚠️ Tip: Uncheck "Fire and Forget". We need the system to wait for the report to finish so we can attach it.
2.4 Peace of Mind (Notification): Configure a notification for you and your manager. In the attachments, pass the Server and Job Number from the previous report step.
The Result: You run the process, the system separates and books the entries, and your manager gets an email with the PDF report saying: "All done."
Are you up for this challenge?
Let me know in the comments if you've used the CSV grouping feature or if you're still struggling with manual logic. And keep sending ideas like Victor's—that's how we all learn!
