BeyondERP.Subscribe

Transaction page · Accounts payable

Vendor payment journal

The vendor payment journal, where vendor payment lines are created and posted.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 6 more roles
Business process
—
Menu item
LedgerJournalTable5
Main table
LedgerJournalTable
Data entity
ExpenseJournalHeaderEntity
Setup steps
—
Show what matters for

Everyone

1What it is and why

What it isThe vendor payment journal, where vendor payment lines are created and posted.
What you do hereUsed to create vendor payments, either with a payment proposal that selects invoices for payment or by manually entering a one-off payment.
ExampleRun a payment proposal that selects invoices by due date, cash discount, or both, review the proposed invoices, and then select Create payments to add the vendor payments to the journal.
Vendor payment journal page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process—
Menu pathAccounts payable › Payments › Vendor payment journal
Set up firstJournal names Microsoft Learn ↗Methods of payment Microsoft Learn ↗Bank accounts Microsoft Learn ↗
Used next byVendor postdated checks Microsoft Learn ↗
Related pagesVendor payments Microsoft Learn ↗

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to Accounts payable > Payments > Vendor payment journal.
  2. Select New and choose the payment journal name.
  3. Select Lines.
  4. Select Payment proposal > Create payment proposal.
  5. Choose to select invoices by due date, cash discount or both, enter the dates and any filters, then select OK.
  6. Review the proposed invoices and select Create payments.
  7. To add a one-off payment, select New, choose the vendor and use Settle transactions to mark the invoices to pay.
  8. Make sure every payment has a method of payment.
  9. Select Generate payment, choose the method of payment and bank account, and select OK to print checks or create the file.
  10. Select Post.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Payment proposalSelects the invoices to pay by due date, cash discount or both; the list can be edited before payments are created.Microsoft Learn ↗——
Minimum payment dateThe earliest date used as the payment date when payments are created.Microsoft Learn ↗——
Create payments without invoice previewSkips the preview of selected invoices when the proposal runs.Microsoft Learn ↗——
Method of paymentHow the vendor is paid; it also supplies the bank account and is needed to generate payments.Microsoft Learn ↗——
Amount to settleThe amount applied to each marked invoice, which sets the payment amount.Microsoft Learn ↗——
Generate paymentPrints checks or creates the electronic payment file for one method of payment and bank account at a time.Microsoft Learn ↗——

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
— No setup is made on this page.

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it laterDeleting a payment line removes only the payment; the invoices it was paying can still be paid by another payment. Microsoft Learn ↗

Technical architect

6Technical

Menu itemLedgerJournalTable5 Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesExpenseJournalHeaderEntityProject expense journal header Microsoft data model ↗VendInvoiceJournalHeaderEntityVendor invoice journal header Microsoft data model ↗VendInvoiceRegisterHeaderEntityVendor invoice register header Microsoft data model ↗VendorPaymentJournalHeaderEntityVendor payment journal header Microsoft data model ↗CustInvoiceJournalHeaderEntityCustomer invoice journal header Microsoft data model ↗CustomerPaymentJournalHeaderEntityCustomer payment journal header Microsoft data model ↗BankJournalHeaderEntityBank journal header Microsoft data model ↗AssetJournalEntityFixed asset journal Microsoft data model ↗AssetJournalHeaderEntityFixed asset journal table Microsoft data model ↗AssetJournalV2EntityFixed asset journal V2 entity Microsoft data model ↗LedgerJournalEntityGeneral journal Microsoft data model ↗LedgerJournalHeaderEntityLedger journal table Microsoft data model ↗LedgerReportingCurrencyAdjustmentJournalHeaderEntityReporting currency adjustment journal header Microsoft data model ↗SlipJournalEntitySlip journal Microsoft data model ↗RAssetJournalHeaderEntityFixed asset journal header (Russia) Microsoft data model ↗
Who can open itPrivilegesMaintain vendor payment journal transactions LedgerJournalTable5MaintainView vendor payment journal transactions LedgerJournalTable5ViewDutiesMaintain vendor payments PaymVendorPaymentsMaintainInquire into vendor payment status PaymVendorPaymentStatusInquire
9 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Actions on the pageButtons: Lines, Open lines in Excel, Validate, Post, Approval, Inquiries, PrintChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=LedgerJournalTable5
Integrate withExpenseJournalHeaderEntity data entity Microsoft data model ↗
Table definitionLedgerJournalTable columns and relations Microsoft data model ↗

Everyone

8Sources and checks