Hi
Is there a report I can run where it shows the approval date of a supplier invoice in Business Central ?
Hi
Is there a report I can run where it shows the approval date of a supplier invoice in Business Central ?
As Alfredo’s screenshot shows you can in fact filter with the RecordID - which will require less lines of code. However, you could consider an excel report layout and add a power query to the approval entries and then have an excel lookup. Would potentially avoid any coding. You could achieve this without an excel layout report too. Just use power query to relevant pages you publish as web services.
There isn't a standard report for that.
You can add a new field to the purchase invoice using a link to the Approval Entry table.
The purchase header table and the approval entry tables are linked through three fields
Table No.
Document Type.
Document No.
Here is an example of a link for an approved sales order
Keep in mind that once posted, the purchase invoice will be archived and the approval entry will no longer be available.
André Arnaud de Cal...
294,281
Super User 2025 Season 1
Martin Dráb
233,019
Most Valuable Professional
nmaenpaa
101,158
Moderator