Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Journal number and batch journal number

Posted on by 35
Hi,
Wondering if anyone can help. Running the voucher transaction report (general ledger - Inquiries and reports - Voucher transactions) from D365 F&O and the report has the journal number and the voucher (which is the journal line number). I need to show who created the journal but the created field populates with the user assigned to the Excel upload not the user who entered the journal. the workflow history gives me the correct user for the created field but contains the journal batch number. I can't seem to add to the workflow history report the journal number or voucher and I can't add the journal batch number to the voucher transaction list report.
Is there a report I can run from D365 that shows the journal batch number and it's corresponding journal number. I could then merge the two reports so that I had the information required.
I've attempted adding columns to both reports but none seem to have the correct information that I need to compare.
Audit trail report doesn't give the correct created user either.
Google hasn't been helpful thus far, hoping someone in this group can help. 
Thanks
Natascja
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Journal number and batch journal number
    Hi Partner,
    Based on your description, you should post the question in the following forum:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans