Feature Overview
Credit Limit Check adds a structured credit monitoring layer to sales orders in Business Central. While standard Business Central already provides a basic credit limit warning, Commerce Manager's Credit Limit Check introduces a formal status field on every sales order — Ok, Approved by user, or Blocked — that makes the credit position explicit, persistent, and visible at a glance across the sales order list, on individual order headers, and on the customer card.
When a sales order is released or reopened, Commerce Manager automatically records the event in a Sales Order Release History. This gives finance and order management teams a complete, timestamped log of every status change on every sales order, without requiring any manual record-keeping. The history is useful both for audit purposes and for investigating disputed orders.
The credit limit calculation that drives the status can be configured in Sales & Receivables Setup: you choose which field BC uses to compare against the credit limit threshold, and you can define a date formula controlling how far into the future planned orders are considered. When a customer has at least one sales order with a Blocked credit limit status, a calculated field on the Customer Card — Credit Limit Blocked Sales Order — shows this immediately, so the sales team and credit controllers can identify at-risk customers without opening individual orders.
This feature is designed to be enabled or disabled per environment via Detailed App Feature Setup (Show Credit Limit Check). When disabled, the credit limit fields and groups are hidden throughout the BC interface.
| Key fact | Detail |
|---|---|
| Status values | (blank), Ok, Approved by user, Blocked |
| Fields added to Sales Order | Credit Limit Status, Credit Limit Status Date, Credit Limit Blocked Amount |
| Customer Card field | Credit Limit Blocked Sales Order (flow field) |
| History | Sales Order Release History — logged on every Release and Reopen event |
| Configuration | Sales & Receivables Setup (Credit Limit section) |
| Feature toggle | Detailed App Feature Setup: Show Credit Limit Check |
Getting Started
- Enable the Credit Limit Check feature: search for Detailed App Feature Setup and find the entry for
Show Credit Limit Checkin the Commerce Manager app. Enable it. - Open Sales & Receivables Setup. In the Credit Limit group (added by the app), configure:
- Credit Limit Field Calculation — choose which field to use when evaluating credit exposure against the customer's limit.
- Order Status Approved Credit Limit Control — the sales order status that represents an approved credit limit override.
- Planned Credit Limit Control Date Formula — how far forward to look when calculating planned credit exposure.
- Set credit limits on customer cards using the standard BC Credit Limit (LCY) field.
- Open a sales order for a customer with a credit limit. The Credit Limit group on the order header shows the current Credit Limit Status, Credit Limit Status Date, and Credit Limit Blocked Amount.
- When a sales order is released or reopened, the action is logged automatically in the Sales Order Release History.
- On the Customer Card, the Credit Limit Blocked Sales Order field shows
Yesif any sales order for that customer currently has status Blocked.
Related Features
Credit Limit Check is part of the Commerce Manager Core feature set and works alongside Sales Order Import: when orders are imported from external systems, their credit limit status is evaluated and visible immediately, allowing the order management team to identify blocked orders before they proceed to fulfilment. The Sales Order Types and Statuses feature can be used in conjunction with the credit limit status to build classification-based workflows around approved or blocked orders.
User Stories
US-01: Monitor credit limit status on a sales order
As a Sales Order Processor
I want to see the current credit limit status on a sales order at a glance
So that I can immediately identify whether the order is within credit limits, has been manually approved, or is blocked
Setup:
- Ensure the Show Credit Limit Check feature is enabled in Detailed App Feature Setup.
- Open any Sales Order.
- In the Credit Limit group on the header (under the Invoice Details FastTab), review:
- Credit Limit Status: Ok, Approved by user, Blocked, or blank.
- Credit Limit Status Date: the date the status was last set.
- Credit Limit Blocked Amount: the calculated amount blocked by the credit limit check (flow field summing all blocked lines).
US-02: Identify all customers with a blocked sales order
As a Credit Controller
I want to quickly see which customers currently have at least one blocked sales order
So that I can prioritise credit reviews without having to search through individual orders
Setup:
- Open Customers (Customer List).
- Use the column chooser to add the Credit Limit Blocked Sales Order field to the list view (or open individual Customer Cards).
- Filter the list where Credit Limit Blocked Sales Order =
Yesto see only customers with blocked orders. - From a Customer Card, choose Commerce Manager → Order Buffer Conversions to review recent order import activity for that customer.
US-03: View the release history for a sales order
As a Sales Manager
I want to see a complete, timestamped history of every time a sales order was released or reopened
So that I can audit the order handling process and understand which users made status changes and when
Setup:
- Open the Sales Order.
- Navigate to the Sales Order Release History associated with this order (accessible from the order via related records or by searching for the page directly and filtering by document number).
- Each row shows the document type, document number, date, and the status value at the time of the release or reopen action.
Note: Release history entries are created automatically on every OnAfterReleaseSalesDoc and OnAfterReopenSalesDoc event. No manual action is required.
US-04: Configure the credit limit calculation method
As a Business Manager
I want to configure which calculation method the credit limit check uses
So that the blocked amount and status reflect our company's credit policy accurately
Setup:
- Open Sales & Receivables Setup.
- In the Credit Limit section, set Credit Limit Field Calculation to the appropriate method.
- Set Order Status Approved Credit Limit Control to the status value that represents a manually approved override.
- Set Planned Credit Limit Control Date Formula to control how far forward planned orders are included in the credit exposure calculation (e.g.
<30D>for 30 days forward). - Save and close the setup page.
US-05: Manually approve a blocked sales order
As a Credit Controller
I want to manually override a Blocked credit limit status on a sales order and record my approval
So that the order can proceed to fulfilment despite the customer being over their credit limit, and the approval is documented
Setup:
- Open the Sales Order with a Credit Limit Status of
Blocked. - Change the Credit Limit Status field to
Approved by user. - The Credit Limit Status Date is updated to today's date automatically.
- The release history logs the status change.
- The Credit Limit Blocked Sales Order field on the Customer Card is recalculated — if this was the last blocked order, the field returns
No.
US-06: View blocked orders from the Sales Order List
As a Sales Order Processor
I want to see the credit limit status directly in the Sales Order List
So that I do not need to open individual orders to identify which ones are blocked
Setup:
- Ensure the Show Credit Limit Check feature is enabled.
- Open the Sales Order List.
- The Credit Limit Status column is visible after the Status column. Orders with status
Blockedare identifiable at a glance. - Filter by Credit Limit Status =
Blockedto see only the orders requiring credit review.
Field Reference
| Field | Where to find it | What it does | Default |
|---|---|---|---|
| Credit Limit Status | Sales Order (header) | Current credit limit evaluation result: blank, Ok, Approved by user, or Blocked | Blank |
| Credit Limit Status Date | Sales Order (header) | Date the credit limit status was last set | Blank |
| Credit Limit Blocked Amount | Sales Order (header) | Calculated sum of credit-limit-blocked amounts across all order lines (flow field) | 0 |
| Credit Limit Blocked Sales Order | Customer Card | Shows Yes if the customer has at least one sales order with status Blocked (flow field) | No |
| Credit Limit Field Calculation | Sales & Receivables Setup | Controls which field is used to compare against the credit limit | — |
| Order Status Approved Credit Limit Control | Sales & Receivables Setup | The status value that represents a manually approved credit override | — |
| Planned Credit Limit Control Date Formula | Sales & Receivables Setup | How far forward planned orders are included in credit exposure calculation | Blank |