BeyondERP.Subscribe

Transaction page · Accounts receivable

Customer payment journal

The journal used to record customer payments.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor and 11 more roles
Business process
—
Menu item
LedgerJournalTable_CustPaym
Main table
LedgerJournalTable
Data entity
ExpenseJournalHeaderEntity
Setup steps
—
Show what matters for

Everyone

1What it is and why

What it isThe journal used to record customer payments.
What you do hereCreate a payment journal, enter payments (one at a time with Enter customer payments, or on Lines), mark the invoices each payment settles, and post.
ExampleRecording a customer's check: enter the customer, use the check number as the payment reference, enter the amount, mark the paid invoices, save in journal, and post.
Customer 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 receivable › Payments › Customer payment journal
Set up firstJournal names Microsoft Learn ↗Methods of payment Microsoft Learn ↗Accounts receivable parameters Microsoft Learn ↗
Used next byCustomer payments Microsoft Learn ↗
Related pagesDraw bill of exchange journal Microsoft Learn ↗

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to Accounts receivable > Payments > Customer payment journal.
  2. Select New and select the journal name for customer payments.
  3. Select Lines.
  4. Select New and select the customer, or enter the invoice to fill in the customer.
  5. Select Settle transactions, mark the invoices the payment covers, enter the amount to settle, and select OK.
  6. In the Payment reference field, enter the customer's check number or payment reference.
  7. Check the method of payment and offset account.
  8. On the Action Pane, select Post.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Payment referenceThe customer's check number or electronic payment reference; needed when the payment goes on a deposit slip.Microsoft Learn ↗——
Deposit slipWhether the payment is included on a deposit slip.Microsoft Learn ↗——
AmountThe amount received; it doesn't default and must be entered.Microsoft Learn ↗——
Offset accountThe bank or main account that the payment is posted to.Microsoft Learn ↗—OffsetLedgerDimension
Method of paymentThe customer's method of payment for this line.Microsoft Learn ↗——
Prepayment journal voucherMarks the line as a prepayment that's posted with the prepayment posting profile.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 later—

Technical architect

6Technical

Menu itemLedgerJournalTable_CustPaym 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 customer payment journal transactions LedgerJournalTable_CustPaymMaintainView customer payment journal transactions LedgerJournalTable_CustPaymViewDutiesInquire into collections status CollectionLetterCollectionsStatusInquirReview invoice and cash process performance CustInvoiceInvoiceAndCashProcPerfReviewMaintain customer payments PaymCustomerPaymentsMaintainInquire into customer payments status PaymCustomerPaymentsStatusInquireMaintain customer invoices for payment RentalCustomerPaymentMaintain
14 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 PaymAccountsReceivablePaymentsClerkRental manager RentalManager
Checked in Dynamics 365
Actions on the pageButtons: Enter customer payments, Lines, Open lines in Excel, Validate, Post, Approval, Inquiries, PrintChecked in Dynamics 365

Developer

7Developer

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

Everyone

8Sources and checks