--- title: "Before You Run Planning Calculations" slug: "before-you-run-planning-calculations" description: "Review the required setup, data, and parameters before running DDMRP planning calculations to ensure that planning results are calculated correctly." tags: ["DDMRP"] updated: 2026-07-31T07:45:01Z published: 2026-07-31T07:45:01Z canonical: "instrukcijos.softera.lt/before-you-run-planning-calculations" --- > ## Documentation Index > Fetch the complete documentation index at: https://instrukcijos.softera.lt/llms.txt > Use this file to discover all available pages before exploring further. # Before You Run Planning Calculations Before you run the DDMRP calculations, clean up and verify your open documents in Business Central. The calculations read the item quantities and dates from **open sales, purchase, transfer, and production orders and their lines**, so outdated or unrealistic documents directly distort the calculated demand, supply, and buffer states. Make sure that: - You have no irrelevant open documents — delete or finish sales, purchase, transfer, and production orders (and their lines) that are no longer real. - Sales orders: the **planned shipment dates** match reality. - Purchase orders: the **outstanding (not yet received) quantity and the due date** are correct on each line. - Transfer orders: the **open quantities and receipt dates** are up to date. - Production orders: the **remaining (unconsumed) component quantity and its date** are correct on each component line. Then review the DDMRP log for errors and register or adjust your external inventories — both are described in the subsections below. ## Log Errors The DDMRP Log records the errors and warnings raised while the planning routines run — for example, a SKU skipped because of missing data (ADU, DLT, BOM), a configuration problem, or a calculation that could not complete. It is useful because these routines often run unattended in the job queue, so the log is where you see what went wrong without watching each run; the Role Center Log Errors tile shows the count for the Error Entry Type set in General Setup. Open it from the Role Center Log group by choosing Log Errors or searching for the DDMRP log. Check it regularly — an unresolved error usually means a SKU is missing from the plan or its buffers are wrong, which leads to planning inaccuracies downstream. The Role Center Log Errors tile shows how many log entries match the Error Entry Type set in General Setup. Choose the tile to open the log. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-2YP0VBFK.png) The Log Entries list shows each logged event with its description, date-time, entry type, and user — here two Warning entries flag a missing SKU record. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-HA5B4DT5.png) Clear Logging Filter removes any active filter, so the list shows all log entries again. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-0P6UD5TQ.png) With the filter cleared, the log shows the full detail — including Information-level entries that trace each calculation step (DLT, ADU, order spikes, net flow) for every SKU. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-XJDS4S22.png) Apply Logging Filter limits the list to the entry types set by the Logging Filter which is set in the [General Setup](/v1/docs/how-to-get-started-2#general-setup), so you can focus on just one type of log. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-UPWK9NA1.png) Show Source opens the record that the selected log entry refers to (for example, the SKU or document behind the message). ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-1YQDU8Z9.png) Show Full Description opens the complete text of the selected entry when the message is too long to read in the list. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-LED4LIEV.png) ## External Inventory External inventory lets you track and adjust stock held in external (Vendor-Managed Inventory) warehouses, so DDMRP planning works from an accurate external on-hand balance. Because this stock is not posted through normal item ledger entries, Softera DDMRP keeps its own external ledger and provides tools to register and adjust those quantities. This applies only to warehouses marked as external in Location Setup. ### Location Setup Location Setup is where you mark warehouses as external. An external warehouse represents stock you plan and replenish but do not physically own in the usual way — for example, inventory held at a customer site under Vendor-Managed Inventory (VMI). Open the page from the Links, as shown in the picture below, or by searching for *Location Setup (Softera.DDMRP)*. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-2WHKEBM7.png) ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-KDV7R0ZZ.png) If you have business case of Vendor-Managed Inventory (VMI) with Dedicated Stock, you may create and mark warehouses as external. By marking warehouse as external you enable following planning features: - Possibility to register on hand inventory in external ledger entries for SKUs in external warehouses. - Run DDMRP planning features for supply chain including external warehouses. - Plan and create external purchase orders for replenishment of external stock. - Plan and create purchases from external stock. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-XOKVVHRV.png) ### Adjust External Inventory Worksheet The Adjust External Inventory Worksheet lets you correct the on-hand quantities of several external (VMI) SKUs in one place. It is needed because external stock is not posted through normal receipts and shipments, so its balance can drift from the real quantity at the vendor or customer site; the worksheet keeps DDMRP planning based on accurate external on hand without adjusting each SKU one by one. Open it from the Role Center Setup group via Links, or search for *Adjust External Inventory Worksheet (Softera.DDMRP)*. On the Links page, under Miscellaneous, choose Adjust External Inventory Worksheet. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-2WHKEBM7.png) ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-382XDZVW.png) The worksheet lists every external SKU on one page, with its current inventory and an editable New Inventory / Qty. to Adjust column. Enter the corrected figures for the lines you need and run Adjust Quantities to post them all at once. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-6CXUEG9V.png) | Field Name | Field Meaning | | --- | --- | | Item No. | The item this line is for. | | Variant Code | The item variant, if applicable. | | Location Code | The external location the line applies to. | | Description | The item description, shown for reference. | | Vendor No. | The vendor for the SKU. | | Item Category Code | The item category, used for classification and filtering. | | Current Inventory | The current external on-hand quantity for the SKU. | | New Inventory | Enter the corrected external on-hand quantity here. | | Qty. to Adjust | The change to apply (the difference between New Inventory and Current Inventory). | #### Adjust Quantities Adjust Quantities is the action that posts the figures you entered on the worksheet. It is what updates the external on-hand balance — the New Inventory and Qty. to Adjust values are only proposed corrections until you run it, so this step commits them to the external item ledger in one go. Enter the corrected New Inventory (or Qty. to Adjust) for each line, then choose Adjust Quantities to post the changes. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-HNEDW0JW.png) Once posted, the SKU's external on hand reflects the new figure (here the Lamp drops from 960 to 900, a Qty. to Adjust of -60), and the change is written to the external item ledger, so DDMRP plans from the corrected balance. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-C1LSLSK0.png) ### Ext. Item Ledger Entries Ext. Item Ledger Entries is the ledger of stock movements for external warehouses. It is where the external on-hand quantity comes from, so you can review what has been registered before planning. Open the Ext. Item Ledger Entries from the Role Center Setup group: choose Links to open the list of additional DDMRP pages. You can also search for *Ext. Item Ledger Entries (Softera.DDMRP)* to open it directly. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-2WHKEBM7.png) On the Links page, under Miscellaneous, choose Ext. Item Ledger Entries. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-B00WUBSI.png) The Ext. Item Ledger Entries list shows the recorded external stock movements — entry no., location, item, date, quantity, and entry type — that make up the on-hand balance DDMRP uses for external warehouses. ![](https://cdn.document360.io/ba34aeb5-9f99-4d32-9b31-bbae99032468/Images/Documentation/image-1JUAMGPJ.png) | Field Name | Field Meaning | | --- | --- | | Entry No. | The entry number of this external ledger entry. | | Location Code | The external location the entry applies to. | | Item No. | The item this entry is for. | | Variant Code | The item variant, if applicable. | | Entry Date | The date of the entry. | | Quantity | The quantity recorded by the entry. | | Entry Type | The type of entry (for example, Incoming). | | Source Type | The source type of the entry. | | Source Subtype | The source subtype of the entry. | | Source ID | The source document number for the entry. | | Unit of Measure Code | The unit of measure for the quantity. | | External Order Type | The external order type associated with the entry. | | ***Additional columns (hidden by default — can be added through Personalization)*** | | Entry Origin Record ID | The record ID of the source document for the entry. | | Qty. (Calculated) | The calculated quantity for the entry. | You can read more about the individual buttons and page navigation in section [Detailed Navigation](/v1/docs/detailed-navigation).