BeyondERP.Newsletter
Menu

Transaction page · Credit and collections

Remittance journal

A journal page for the Customer bank remittance journal type.

Used by
Auditor, Collections agent, Collections manager and 10 more roles
Business process
Remit a bill of exchange in Dynamics 365 Finance
Menu item
LedgerJournalTable_CustPaymRemittance
Main table
LedgerJournalTable
Data entity
AssetJournalEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA journal page for the Customer bank remittance journal type.
What you do hereUse this journal to create a bill of exchange remittance file to send to the organization's bank; this journal type requires the Automatic settlement option on Accounts receivable parameters to be cleared.
ExampleFor example, a company can send a bill of exchange to its bank on the due date, which is called remit for collection.
Remittance journal page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Credit and collections > Payments > Bill of exchange > Remittance journal.
  2. Create a journal.
  3. On the Bill of exchange tab, select the Remittance type, Discount or Collection.
  4. In the Bank account field, select the bank account for the bill of exchange.
  5. Select Lines and select the customer account for the invoice.
  6. Open settlement and select the open transaction, or use a payment proposal to select transactions.
  7. Generate the remittance file for the bank.
  8. Post the journal.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Bill of exchangeTab on the journal where you enter the bill of exchange details.Microsoft Learn
Remittance typeWhether the bill is remitted for discount or for collection.Microsoft Learn BankRemittanceType
Bank accountThe bank account affected by the bill of exchange.Microsoft Learn BankAccountId
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
If you change it laterIf Automatic settlement is selected in the Accounts receivable parameters, the remittance file is generated automatically when invoices are posted with a bill of exchange method of payment. Microsoft Learn
Technical architect

5Technical

Menu itemLedgerJournalTable_CustPaymRemittance Checked in Dynamics 365
FormLedgerJournalTable Checked in Dynamics 365
TableLedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365
Data entitiesAssetJournalEntityFixed asset journal Microsoft data model AssetJournalV2EntityFixed asset journal V2 entity Microsoft data model BankJournalHeaderEntityBank journal header Microsoft data model CustInvoiceJournalHeaderEntityCustomer invoice journal header Microsoft data model CustomerPaymentJournalHeaderEntityCustomer payment journal header Microsoft data model ExpenseJournalHeaderEntityProject expense journal header Microsoft data model LedgerJournalEntityGeneral journal Microsoft data model LedgerReportingCurrencyAdjustmentJournalHeaderEntityReporting currency adjustment journal header Microsoft data model RAssetJournalHeaderEntityFixed asset journal header (Russia) Microsoft data model SlipJournalEntitySlip journal Microsoft data model VendInvoiceJournalHeaderEntityVendor invoice journal header Microsoft data model VendInvoiceRegisterHeaderEntityVendor invoice register header Microsoft data model VendorPaymentJournalHeaderEntityVendor payment journal header Microsoft data model AssetJournalHeaderEntityFixed asset journal table Microsoft data model LedgerJournalHeaderEntityLedger journal table Microsoft data model
Who can open itPrivilegesMaintain bill of exchange remittance journal transactions LedgerJournalTable_CustPaymRemiMaintainView bill of exchange remittance journal transactions LedgerJournalTable_CustPaymRemittViewDutiesReview invoice and cash process performance CustInvoiceInvoiceAndCashProcPerfReviewInquire into bill of exchange status PaymBillOfExchangeStatusInquireMaintain bill of exchange transactions PaymBillOfExchangeTransactionsMaintain
13 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerk
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkTo use itCollections manager CollectionLetterCollectionsManagerCollections agent CollectionLetterCollectionsAgentAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 13 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=LedgerJournalTable_CustPaymRemittance
Integrate withAssetJournalEntity data entity Microsoft data model
Table definitionLedgerJournalTable columns and relations Microsoft data model
Everyone

7Sources