In Microsoft Dynamics 365 Business Central, the credit memo locking date is the posting date that determines which general ledger period a credit memo is posted to, and it cannot be earlier than the last closed accounting period. This date is set on the credit memo header and controls financial reporting, VAT settlement, and inventory valuation, making it a critical control point for period-end closing.
What Is the Credit Memo Locking Date?
The locking date is a system-enforced restriction that prevents users from posting transactions to closed accounting periods. When you create a credit memo in Business Central, the Posting Date field on the header acts as the locking date. If the posting date falls in a period that has been closed (e.g., via the Accounting Periods page or the Close Year function), the system blocks posting and shows an error. This ensures that financial statements remain accurate after period-end close.
For example, if your fiscal year ends on December 31 and you close that period on January 15, any credit memo with a posting date of December 31 or earlier will be rejected. You must either change the posting date to an open period or reopen the period (if you have permission).
How the Locking Date Works in Posting
When you post a credit memo, Business Central uses the posting date to:
- Determine the G/L entry date and the corresponding period.
- Calculate VAT and post to the correct VAT entry.
- Update inventory quantities and costs (if the credit memo is for items).
- Apply the credit memo to an open invoice or customer ledger entry.
The locking date is not a separate field—it is the same as the posting date. However, some users confuse it with the Document Date (the date on the physical document) or the Due Date (payment due date). The posting date is the only date that affects the financial period.
Setting the Posting Date on a Credit Memo
To set the posting date on a credit memo:
- Open the Sales Credit Memos list and create a new credit memo.
- On the General FastTab, locate the Posting Date field.
- Enter a date that falls within an open accounting period.
- If you need to post to a closed period, you must first reopen that period (if allowed) or use a different date.
Business Central also has a Allow Posting From and Allow Posting To setting under General Ledger Setup. These global date ranges further restrict posting dates. If the credit memo’s posting date is outside these ranges, the system will block it even if the period is open.
Common Problems and Errors
Users often encounter the error: “Posting date is not within the allowed range.” This occurs when the posting date is earlier than the Allow Posting From date or later than Allow Posting To. Another common issue is trying to post a credit memo to a closed fiscal year, which triggers: “The period is closed. Posting is not allowed.”
In those cases, you have three options:
- Change the posting date to the current open period.
- Reopen the accounting period (requires the Finance permission set).
- Adjust the Allow Posting From/To ranges in General Ledger Setup (if you are an administrator).
Note that reopening a period can affect previously reported financials, so it should be done carefully and only when necessary.
Credit Memo vs. Sales Invoice Locking
Both sales invoices and credit memos use the same locking mechanism based on the posting date. However, credit memos have a unique feature: they can be applied to one or more invoices. When you apply a credit memo to an invoice, the application date is also controlled by the posting date. If the credit memo’s posting date is after the invoice’s due date, the credit memo may not reduce the invoice’s outstanding balance correctly for aging reports. This is a common misconception—users think the locking date only affects the G/L, but it also impacts customer ledger entries and payment application.
Template for Credit Memo Posting Date Control
Credit Memo Posting Date Checklist
| Field | Value | Notes |
|---|---|---|
| Credit Memo No. | ___________ | Auto-assigned |
| Posting Date | ___________ | Must be in open period |
| Document Date | ___________ | Optional, for reference |
| Customer No. | ___________ | Existing customer |
| Invoice No. to Apply | ___________ | If applying to specific invoice |
| Reason Code | ___________ | e.g., RETURN, REBATE |
Sample (fictional):
| Field | Value |
|---|---|
| Credit Memo No. | CM-1024 |
| Posting Date | 2025-04-15 |
| Document Date | 2025-04-14 |
| Customer No. | 10012 |
| Invoice No. to Apply | INV-2098 |
| Reason Code | RETURN |
How to Choose the Correct Posting Date
Choosing the right posting date is not just about avoiding errors—it affects financial accuracy. Consider these factors:
- Period of the original sale: If the credit memo relates to a sale in a prior period, you may want to post it to that period for accurate revenue matching, but only if the period is still open.
- VAT reporting: Posting to a different period can change VAT liability. Ensure the date aligns with the VAT period you intend to report.
- Year-end closing: After year-end close, you cannot post to the closed year. Use a new period and consider a prior-period adjustment.
- Customer communication: The posting date affects when the credit memo appears on the customer’s statement. Choose a date that matches the transaction date for clarity.
If you are unsure about the correct period, consult your finance team or accounting manager before posting.
Frequently Asked Questions
Can I change the posting date after a credit memo is posted? No. Once posted, the G/L entries are locked. You can reverse the credit memo and create a new one with the correct date, or post a general journal correction.
What is the difference between posting date and document date? The posting date is the accounting date that determines the period. The document date is the date on the physical credit memo and is used for reference only—it does not affect posting.
How do I reopen a closed accounting period? Go to Accounting Periods, select the period, and clear the Closed checkbox. You need the Finance permission set. Be aware that reopening a period can affect previously reported financials.
Why does my credit memo show an error about posting date not in allowed range? This is due to the Allow Posting From/To settings in General Ledger Setup. Check those dates and adjust them if you have administrator rights.
Can I post a credit memo to a future date? Yes, if the future date is within the allowed posting range and the period is open. However, this may affect cash flow projections and VAT reporting, so use caution.
Does the credit memo locking date affect inventory valuation? Yes, if the credit memo includes items, the posting date determines which inventory period the cost adjustment is posted to. Posting to a closed inventory period will be blocked.
Safety and Best Practices
To avoid errors and financial misstatements, always verify the posting date before posting. Use the Posting Date field as the locking date, and never set it to a closed period. If you need to record a credit memo for a prior period after year-end close, consult your accountant—you may need to use a prior-period adjustment journal instead. For tax or legal advice, ask a qualified professional.