Hello,
This is standard system behavior. When you create a financial report in d365 FO and add the attribute Created By in column definition in the report designer , if the transaction type is a vendor invoice, it always shows as admin for each entry. The reason is that the voucher is automatically posted by the system.
However, if you drill into the voucher for those vendor transactions, you will notice multiple "Created By" values:
One with the admin value on the voucher line
,Another under the General section when selecting the line , which shows the correct user (the person who actually created the vendor invoice).This data comes from the LedgerTransVouch table.
Our developer attempted to resolve this by creating a custom column that points to the correct table using conditional logic (since for General Journal vouchers, the report shows the value correctly). They created a deployable package, deployed it to UAT, and tested it, as financial reports cannot be validated in DEV (Tier 1). However, even after refreshing the entity store and resetting the data mart, the custom column is still not appearing.
At this point, our technical team has confirmed that from a technical standpoint, it is not possible to create such a custom column.
is this True ?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,140
André Arnaud de Cal... 762 Super User 2025 Season 2
Sohaib Cheema 706 User Group Leader
