Transaction page · Accounts receivable
Remittance journal
The journal page for the Customer bank remittance journal type.
- Used by
- Accounts receivable clerk, Accounts receivable manager, Auditor and 10 more roles
- Business process
- —
- Menu item
LedgerJournalTable_CustPaymRemittance- Main table
LedgerJournalTable- Data entity
ExpenseJournalHeaderEntity- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | The journal page for the Customer bank remittance journal type. |
|---|---|
| What you do here | Used 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. |
| Example | For example, a company can send a bill of exchange to its bank on the due date, which is called remit for collection. |
Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | Accounts receivable › Payments › Bill of exchange › Remittance journal |
| Set up first | Journal names Microsoft Learn ↗Customer posting profiles Microsoft Learn ↗Methods of payment Microsoft Learn ↗Accounts receivable parameters Microsoft Learn ↗Accounts receivable parameters: Automatic settlement Microsoft Learn ↗ |
| Used next by | Bill of exchange journal Microsoft Learn ↗Bill of exchange statistics Microsoft Learn ↗Settle bill of exchange journal Microsoft Learn ↗ |
| Related pages | Draw bill of exchange journal Microsoft Learn ↗Protest bill of exchange journal Microsoft Learn ↗Redraw bill of exchange journal Microsoft Learn ↗Settle bill of exchange journal Microsoft Learn ↗ |
End user · Functional consultant
3How to do it
Microsoft's steps
- Go to Accounts receivable > Payments > Bill of exchange > Remittance journal.
- Create a journal.
- On the Bill of exchange tab, select the Remittance type, Discount or Collection.
- In the Bank account field, select the bank account for the bill of exchange.
- Select Lines and select the customer account for the invoice.
- Open settlement and select the open transaction, or use a payment proposal to select transactions.
- Generate the remittance file for the bank.
- Post the journal.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Bill of exchange | Tab on the journal where you enter the bill of exchange details.Microsoft Learn ↗ | — | — |
| Remittance type | Whether the bill is remitted for discount or for collection.Microsoft Learn ↗ | — | — |
| Bank account | The bank account affected by the bill of exchange.Microsoft Learn ↗ | — | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | Per company: each legal entity has its own records. Microsoft data model ↗ |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | If 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
6Technical
| Menu item | LedgerJournalTable_CustPaymRemittance Checked in Dynamics 365 |
|---|---|
| Form | LedgerJournalTable Checked in Dynamics 365 |
| Table | LedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365 |
| Data entities | ExpenseJournalHeaderEntityProject 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 it | PrivilegesMaintain 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 PaymBillOfExchangeTransactionsMaintain13 security rolesAuditorAuditPolicyManagerCollections 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 |
| Actions on the page | Buttons: Lines, Validate, Post, Approval, Inquiries, PrintChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=LedgerJournalTable_CustPaymRemittance |
|---|---|
| Integrate with | ExpenseJournalHeaderEntity data entity Microsoft data model ↗ |
| Table definition | LedgerJournalTable columns and relations Microsoft data model ↗ |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-journal-types
- learn.microsoft.com/previous-versions/dynamicsax-2012/appuser-itpro/remit-a-bill-of-exchange
- learn.microsoft.com/common-data-model/schema/core/operationscommon/tables/finance/accountingfoundation/worksheetheader/ledgerjournaltable
- learn.microsoft.com/dynamics365/finance/accounts-receivable/set-up-bills-exchange
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-journal-types
- learn.microsoft.com/previous-versions/dynamicsax-2012/appuser-itpro/settle-a-bill-of-exchange
- learn.microsoft.com/dynamics365/finance/accounts-receivable/close-accounts-receivable
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.