0

Table Builder Payment Journal link to Approval ID

Bryony Griggs

April 14, 2020 18:56

None

Follow

Hi

 

We run payment journals to enable BACS payments to our vendors. I need to build a report that displays these payments and approval IDs, so that we can identify who has approved invoices before they are paid.

I have spent hours looking for links in table builder, but am really finding it tricky.

Can anyone help please.

Thanks

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 20, 2020 18:05

  What table contains the payment information?  I would wager that if you had the document number, document type and possibly Table ID, you could find the associated approver ID in the Approval Entry table.

  https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2015/hh895772(v=nav.80)