Finance | Project Operations, Human Resources, ...

Trace Settlement Voucher Number from Expense Voucher

(0) Share

Report

Posted on by Jehanzeb

I am not a consultant rather a finance professional using Dynamics 365

Part of our requirement is to keep physical copies of payments, they are physically filed by Journal Batch Number (JBN) of the payment.

The expenses are recorded via Invoicing # and then are settled through marking them.

I need help tracing the JBN (of Payment) from Expense Invoice Vouchers. I am trying to use voucher transactions from GL and modifying the query to include settlement but this is not working. Please guide

Categories:

Financial Management

All responses (2)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 10,829 Moderator on at

Like (0)

Report

RE: Trace Settlement Voucher Number from Expense Voucher

Hi Jehanzeb,

Vendor transaction (i.e Vendor invoice) will be settled to vendor payment journal line while posting of vendor payment journal that its journal lines are associated (i.e marked) to vendor invoices.

When you check vendor transaction against invoice or payment you click on "View settelement" to find the settled voucher:

You can check this routine from voucher transaction by filtering with voucher number, choose "Original document" and click view detail on document "Purchase invoice"

and then click on "Transaction" to check the settled trans on vendor transactions:
André Arnaud de Cal... 283,860 Test role Public on at

Like (0)

Report

RE: Trace Settlement Voucher Number from Expense Voucher

Hi Jenanzeb,

When you have posted expenses as invoices, there are vendor transactions created. When posting the payment journal, it will create a new vendor transaction and these vendor transactions will be settled; not the vouchers. From the vendor transactions you can find the source document which should tell you the JBN as well.