Dynamics 365 Finance & Operations, now split into Dynamics 365 Finance and Dynamics 365 Supply Chain Management, offers one of the most powerful and flexible architectures on the market for inventory management in large-scale organizations. Its modular approach enables the integration of production, purchasing, accounting, warehousing, advanced logistics and taxation, ensuring precise, traceable and IFRS-compliant accounting valuation.
This article addresses how the main inventory valuation methods are configured and applied within the system, and how they align with the regulatory and operational requirements of Colombia and the Dominican Republic.
Inventory Model Configuration in F&O: Functional Logic and System Rules
In Dynamics 365 Finance & Operations (SCM), the accounting valuation logic for inventory is based on the correct configuration of the inventory model. This model defines how the system assigns a cost to stock outflows (sales, consumption, negative adjustments), and determines how accounting and settlement processes behave.
Unlike other ERPs that use the concept of a “cost method” on the product card, F&O organizes this logic through inventory models, which can be applied at the product or product group level.
Where the Model Is Configured
The inventory model definition is carried out in:
Product information management > Released products > [Product] > Manage inventory > Inventory model
It can also be defined automatically by assigning an item group, which includes the general inventory management policy, reservations, dimensions and default model.
Once the product has had recorded movements (posted inventory transactions), the inventory model cannot be changed, making correct planning from the start of the project essential.
Inventory Models Available in F&O
Dynamics 365 SCM allows selection from multiple models. The most relevant for IFRS environments are:
- FIFO: values outflows based on the oldest available inflows.
- Average: calculates the accumulated average cost, with the option of continuous or periodic settlement.
- Standard: applies a predefined fixed cost, generating variances from the difference between standard and actual.
- Specific identification (“Marked physical inventory”): links each outflow manually or automatically to a specific inflow.
- Oldest/newest date: technical variants of the FIFO/LIFO model, not recommended under IFRS.
- LIFO: technically available, but not permitted in IFRS contexts, and therefore must not be used in Colombia or the Dominican Republic.
Functional Structure of Valuation
The inventory model determines how F&O handles the following elements:
- The physical and financial reservation of stock
- The order in which costs are assigned to movements
- The automatic settlement structure carried out at the end of each period
- The method of calculating accounting adjustments for differences between inflow and outflow
- The traceability capacity by inventory dimension (batch number, serial number, location, etc.)
Critical Considerations for Correct Configuration
- The model must respect the accounting principle of consistency: each product line must use a cost logic consistent with its operational behavior.
- In environments with multiple warehouses or countries, it is possible to create duplicate products with different models, but not within the same legal entity if accounting is unified.
- The choice of model impacts not only margin calculation, but also the determination of tax cost, the income tax base and traceability in audits by the DIAN or the DGII.
- In regional or multi-company projects, it is recommended to apply the model from the released product template configuration to ensure consistency from the outset.
window.hsFormsOnReady = window.hsFormsOnReady || []; window.hsFormsOnReady.push(()=>{ hbspt.forms.create({ portalId: 7555051, formId: "69ee043b-74a0-4723-8133-9ea7d8275ca1", target: "#hbspt-form-1784418495000-0119328129", region: "na1", })});
Continuous vs. Periodic Valuation in F&O: Operational and Accounting Impact
One of the key concepts for understanding inventory management in Dynamics 365 F&O is the difference between continuous valuation and periodic valuation. Although the system records all movements in real time, the definitive cost of each transaction is not always fixed immediately: it depends on the inventory model and whether the inventory settlement has been executed.
This distinction has a direct impact on:
- The accuracy of unit margins
- The precision of the cost of sales
- The consistency between inventory and general accounting
- The taxable base declared for tax purposes
Continuous Valuation: Immediate Cost Availability
In models configured as “moving average” or “standard cost”, F&O assigns a cost immediately at the time of recording the movement. This value is used to automatically generate accounting entries, without the need for subsequent adjustment.
Examples:
- In moving average, each inflow updates the accumulated average cost and this is applied to subsequent outflows.
- In standard cost, the predefined value is applied directly, generating variances if there are differences with actual costs.
Advantages:
- Generates immediate accounting results.
- Does not depend on the settlement process.
- Simplifies the monthly financial close.
Limitations:
- In average, the applied cost may be provisional if there are gaps between delivery and invoicing.
- The accuracy of margins requires maintaining synchronization between operations and accounting.
Periodic Valuation: Precision After Settlement
In FIFO, specific identification or periodic average models, the cost assigned to each outflow is provisional until the inventory settlement process is executed. During that time:
- The movement is recorded in inventory.
- The accounting entry may be generated with an estimated (temporary) cost.
- The definitive cost is calculated when the settlement is executed, which links each outflow to the applicable actual inflows.
Advantages:
- Greater precision in traceability and calculation of the actual cost of each unit.
- Automatically adjusted based on the order of entry, even with multiple suppliers or dates.
Limitations:
- Requires executing the periodic settlement process, normally at the end of each month.
- Until settlement is performed, margin data may be inconsistent.
- Audits require evidence that all inventory closes have been correctly executed.
Practical Cases
Continuous Valuation – Moving Average:A Dominican hardware company imports products every week. The moving average allows the cost to be kept up to date, but care must be taken with the order of entry and price updates to avoid distorting margins.
Periodic Valuation – FIFO:A Colombian pharmaceutical distributor works with FIFO and needs to close inventory at the end of each month. Until the settlement is executed, the cost of sales may be temporarily distorted if there are inflows not yet invoiced.
Operational Recommendations
- Document the inventory settlement policy: who, when and how the inventory close is executed.
- Establish a pre-close review process to ensure that all inflows (purchases, production, transfers) are recorded and invoiced.
- Activate alerts to detect movements without applied cost or pending settlement.
- For sensitive or high tax-impact products, consider using continuous valuation if the model allows it.
The Inventory Settlement Process: Adjustments, Corrections and Accounting Impact in F&O
In Dynamics 365 SCM, the inventory settlement process is the mechanism that allows the definitive assignment of actual cost to inventory outflows (sales, consumption, negative adjustments), according to the configured inventory model (FIFO, periodic average, specific identification).
This process is mandatory in all scenarios where cost is not determined on a continuous basis and must be executed periodically — normally as part of the monthly accounting close.
What Does the Settlement Technically Do?
- Links inventory inflows and outflows applying the logic of the configured model.
- Recalculates the actual costs of outflows (sales, transfers, consumption).
- Records automatic accounting adjustments to correct deviations between estimated and actual costs.
- Updates sales margins and pending inventory values.
- Formally closes the period for audit and tax compliance purposes.
The settlement works with the transaction history of the product and checks whether any outflow has been left without a link to a specific inflow, adjusting the cost according to the established policy.
Where Is It Executed?
Path:Inventory management > Periodic > Settle and close inventory
From here you can:
- Execute a full inventory settlement for all products.
- Select date ranges, warehouses, products or specific groups.
- Schedule the task as a batch process, recommended for companies with high transaction volumes.
There is also the option of a settlement simulation, useful for previewing the effects before applying them definitively.
Types of Adjustments Generated
During settlement, the system may generate the following cost adjustments:
- Positive or negative value adjustment on the outflow movement
- Automatic accounting entries to correct the cost of sales
- Reallocations between inventory accounts and cost variance
- Reversals or corrections of previous closes if inconsistencies are detected
All these movements are traced in the product settlement history, accessible from the item card.
Prerequisites for Settlement
Before executing the settlement it is essential that:
- All product inflows are recorded and invoiced (purchases, production, transfers).
- There are no open movements without prior valuation.
- The accounting configurations are correct (product posting groups, adjustment accounts).
- There are no errors in the inventory dimensions needed to calculate traceability.
F&O does not prevent settlement if there are errors, but will report them as unsettled or incorrectly closed transactions.
Consequences of Not Settling
- The reported cost of sales may be inaccurate.
- The inventory value on the balance sheet will be understated or overstated.
- There may be observations in external audits or rejections from the DIAN or the DGII.
- Accumulated deviations can distort gross margin reports by customer, channel or product.
Best Practice Recommendations
- Include settlement in the corporate monthly accounting close as a mandatory task.
- Establish an internal pre-reconciliation policy, with checklists of movements without cost.
- Always run a simulation first, especially in companies with multiple warehouses or international movements.
- Schedule settlement as a batch process during low operational load hours.
- Validate the result using reports such as “Inventory adjustment journal” or “Cost history by product”.
Standard Cost Management in F&O: Definition, Review and Variance Control
The standard cost inventory model allows assigning each product a predetermined fixed value for all its outflows. This cost does not vary based on actual purchases or production, but remains constant until the company formally decides to change it.
This approach enables accounting predictability, facilitates budget control and generates operational efficiency reports through the measurement of cost variances, essential for financial analysis in industrial environments.
Standard Model Configuration
To use this model, the “Standard cost” inventory model must be selected on the product card. It is then necessary to configure:
- The standard price of the product
- The active costing version
- Calculation rules (raw material, indirect cost, labor, etc.)
- Validity dates and possible escalations
This cost is associated with a costing version that must be marked as standard and active. There can be no inventory movements until this version is published.
Path:Cost management > Costing versions > Create and publish standard version
Publishing the Standard Cost
Once the costs are defined, they must be published through the process:
Cost management > Calculation > Publish standard prices
This process converts the calculated or manually entered prices into active values within the system, blocking any previous cost.
Once the cost is published:
- All inventory outflows (sales, consumption, adjustments) will be recorded at the standard price.
- Differences between the actual entry price and the standard will be posted as cost variances.
- These variances can be analyzed by product, production order, supplier or accounting period.
Types of Variances Generated
F&O allows classifying and analyzing different types of variance between actual and standard cost:
- Purchase price variance: when the supplier invoices at a value different from the standard cost.
- Quantity variance: if actual consumption differs from planned.
- Indirect cost variance: when allocated overhead is higher or lower than expected.
- Route or resource variance: if a different process than planned is used or with different efficiency.
Each of these variances can be assigned to a different accounting account, enabling detailed reports on production efficiency or logistical deviations.
Changes to the Standard Cost
To update the standard cost, you must:
- Create a new costing version with a future date
- Calculate or manually define the new prices
- Execute the publishing process
- Review the accounting impact through prior simulation
Important: the active standard price must not be modified directly, as this would break traceability and accounting reports. The only valid method is through a newly published version.
Accounting Control of Variances
The generated variances are automatically posted to the accounts defined in:
Cost management > Setup > Item posting groups > Variance accounts
These accounts must be aligned with cost centers, financial dimensions and production lines, enabling information to be exploited from Power BI or Excel with full visibility of operational efficiency.
Key Recommendations
- Define the standard cost using a combination of historical data and technical analysis (routes, bills of materials, hourly rates).
- Review and publish new versions with each significant update to the economic environment, exchange rate or operational structure.
- Validate that variances do not accumulate high balances month after month; this indicates a calculation problem or an obsolete standard.
- Include cost variance reports in financial and production dashboards for decision-making.
Specific Identification Valuation in F&O: Traceability Through Inventory Dimensions
The Specific identification inventory model allows each inventory outflow (sale, consumption, transfer) to be linked directly to a specific inflow, preserving the exact actual cost of that unit. For this to be possible, Dynamics 365 F&O uses what are known as inventory dimensions as a traceability support: batch, serial number, warehouse, location, etc.
This type of valuation is essential in sectors such as:
- Medical devices or pharmaceuticals (batch or expiry control)
- Electronic equipment or machinery (serial number)
- Processed foods or cosmetics (health traceability)
- High individual value goods (vehicles, precision instruments, technology)
Activating the Specific Identification Model
To use this valuation method, the product must be associated with:
- The “Specific identification” inventory model
- A mandatory inventory dimension configuration, such as batch or serial number
Path:Product management > Released products > Storage dimensions > Configure tracking dimensions
There you define whether the batch or serial number is:
- Mandatory on inflow
- Mandatory on outflow
- Mandatory on both
- Controlled manually or automatically
This ensures that each unit is perfectly identified from the moment it enters the warehouse until it is consumed or sold.
Physical and Financial Marking
To link a specific inflow to a specific outflow, the system allows two mechanisms:
- Physical marking: performed when recording the outflow, manually linking it to the desired inflow. This preserves the original cost of that inflow.
- Financial marking: the link is made at a later stage, allowing associations to be adjusted before settlement.
Both markings can be done from:
Inventory management > Transactions > Mark against specific inflow
This process allows the user or the system to:
- Manually select which inflow will be used for each outflow
- Ensure that the assigned cost is exactly that corresponding to that unit
- Comply with traceability regulations and internal or external audit requirements
Accounting Implications
When specific identification is used:
- The cost of sales accounting entry is generated using exactly the value of the associated inflow
- There is no average, no estimate, no additional calculation
- In the inventory settlement, the system does not need to calculate differences, since traceability is exact
- Traceability can be consulted from inventory tracking reports by batch or serial number
Key Reports
Relevant reports for this model include:
- Tracking history by batch/serial number
- Inventory transactions filtered by tracking dimension
- Cost per unit sold report
- Backward tracing in the event of an audit, return or health inspection
Operational Considerations
- This model requires rigorous operational discipline: if inflow dimensions are not correctly recorded, outflows cannot be executed.
- It is mandatory to use barcode readers or integrations with MES systems if human errors in traceability are to be avoided.
- In return scenarios, it is essential that the batch or serial number of the return exactly matches the original inflow.
Practical Recommendations
- Define a clear batch or serial number management policy by product type and warehouse
- Train warehouse and production staff in the correct use of inventory dimensions
- Integrate tracking dimensions with production logic (manufacturing orders, routes)
- Validate that configurations are reflected in regulatory compliance reports (INVIMA, DIGEMAPS, external audit)
Report Management and Accounting Integration in F&O: Reconciliation and Inventory Value Traceability
One of the great differentiators of Dynamics 365 F&O is its ability to maintain total consistency between logistical operations and financial accounting. Each inventory transaction generates automatic accounting movements that are recorded in the general ledger, in accordance with the inventory model, accounting configurations and applied financial dimensions.
This traceability is critical to ensuring the integrity of financial statements, correct tax reporting and compliance with IFRS.
How Is Accounting Integration Produced?
Each inventory movement (purchase, sale, production, transfer, adjustment) generates an accounting entry based on:
- The inventory model (FIFO, standard, average, etc.)
- The item posting group assigned to the item
- The inventory posting group, which defines the accounting accounts to use
- The financial dimensions assigned (cost center, warehouse, business line)
The system automatically generates entries of the type:
- Inventory to accounts payable (goods receipt)
- Cost of sales to inventory (sale)
- Inventory to work in progress (consumption)
- Cost variance to inventory (adjustments for standard or settlement)
These movements are recorded with full traceability and can be consulted from the general journal modules or from the product’s inventory transaction.
Accounting Configuration by Group
For this integration to work correctly, F&O allows configuring:
- Inventory accounts by product type
- Cost of sales accounts
- Cost variance accounts
- Production deviation accounts
- Positive/negative adjustment accounts
Configuration path:Inventory management > Setup > Inventory accounting > Item posting groups
It can also be extended by warehouse, customer group or distribution channel, as needed.
Reconciliation Between Inventory and Accounting
Dynamics 365 SCM provides specific tools to verify that the inventory value matches the accounting balance in the general ledger.
Main report:
Inventory and accounting reconciliation reportPath:Inventory management > Inquiries and reports > Inventory reconciliation
This report allows:
- Comparing inventory value by warehouse, product or group
- Viewing differences between physical and financial value
- Identifying mismatches due to pending settlements, configuration errors or unclosed movements
- Confirming the value declared on the general balance sheet
It can also be cross-referenced with the report:Summary of inventory transactions by date and product, to validate accumulated cost, quantity pending settlement and date of last movement.
Support for Audit and Tax Inspection
Accounting movements generated from inventory can:
- Be filtered by transaction type, product group, accounting period, warehouse
- Include the detail of the original transaction (for example, supplier invoice, production order or delivery note)
- Be exported to Excel, Power BI or tax formats defined by the localization
This enables compliance with the requirements of bodies such as the DIAN (Colombia) or the DGII (Dominican Republic) regarding:
- Auxiliary inventory register
- Asset declarations
- Cost reconciliation
- Documentary evidence in tax inspections
Recommendations to Ensure Traceability and Control
- Validate with accounting managers that all accounts in the item posting group are correctly assigned
- Ensure that inventory movements are fully settled before the accounting close
- Run the reconciliation report monthly and retain it as documentary backup
- Use financial dimensions to assign costs to responsibility centers, product lines or projects
- Document the inventory accounting structure and its maintenance in internal policies
Technical Limitations and Specific Considerations in LATAM Environments
Dynamics 365 F&O is a world-class solution, designed to cover complex operations at a global level. However, in implementations for Latin American companies, especially in countries with rigorous tax regulations such as Colombia and the Dominican Republic, it is necessary to consider certain standard limitations and apply functional adjustments or extensions to ensure regulatory and operational compliance.
1. Absence of Standard Tax Localization for Colombia and the Dominican Republic
Unlike countries such as Mexico or Brazil, F&O does not offer a complete official localization for Colombia or the DR. This means that:
- Local tax reports are not natively generated (inventory book, DIAN 1007, DGII annexes, etc.).
- The standard accounting structure does not contemplate some specific requirements such as XML formats, electronic audit or mandatory reconciliations in certain official formats.
- It is necessary to acquire and integrate a tax localization developed by a certified partner, such as Artware, Go2Latam, SION, E-Consulting, among others.
These localizations enable:
- Integration with electronic invoicing in accordance with DIAN/DGII
- Official asset and inventory reports
- Tax declarations compatible with local IFRS environments
- Compliance with audits and tax inspections with a validated structure
2. Complexity of the Settlement Process in Multi-Level Operations
In companies with complex operations (for example, multi-stage production, subcontracting, logistics with multiple warehouses), the inventory settlement process can become critical. The main difficulties are:
- Cross transactions without correctly applied cost
- Consumption without prior settled inflows
- Close failures if dimensions are incomplete (for example, missing batch or warehouse)
In these environments it is recommended to:
- Execute well-segmented batch settlements
- Integrate automatic alerts to detect movements without prior valuation
- Enable traceability audit reports between production orders and consumption
3. Implementation and Maintenance Cost of the Standard Model
The standard cost logic, very powerful in industrial environments, requires continuous maintenance that many companies have not adequately budgeted for. The following are needed:
- Precise calculations of bills of materials, routes and indirect costs
- Regular publication of new versions
- Training of the financial team to correctly interpret variances
Furthermore, the system does not automatically generate a multi-year history of versions, so if not adequately documented, there may be problems justifying adjustments to tax inspectors.
4. Integration with Accounting and Tax Reports
Standard F&O reports do not include:
- Specific formats required by the DIAN (such as 1009, 1010, 1007 or 2516)
- Annexes required by the DGII (such as IR-2, asset detail, inventory and cost of sales)
- Consolidation in local currency and functional currency simultaneously for tax purposes
This requires developing custom reports or using external tools such as Power BI with financial connectors that structure data in accordance with local tax frameworks.
5. Advanced Traceability by Batch or Serial Number Without Health Control
Although F&O allows traceability by batch or serial number, it does not natively incorporate key regulatory functions required by entities such as INVIMA or DIGEMAPS, such as:
- Cold chain
- Batch quarantine control
- Expiry dates with operational alerts
- Health certification associated with the batch
These functionalities are usually developed as ISV extensions or through integration with specialized LIMS or WMS systems.
Strategic Recommendations
- Evaluate with the implementation partner the most appropriate tax localization, according to sector and country.
- Include from the functional analysis a accounting and tax close strategy aligned with the DIAN or the DGII.
- Validate the configuration of inventory and accounting dimensions from the design to avoid structural mismatches.
- Establish internal controls for the monthly validation and review of the accounting valuation of inventory.
- Use Power BI with a validated financial model for tax reports and reconciliations adapted to the country.
Technical Conclusion
Inventory valuation in Dynamics 365 Finance & Operations represents a highly robust accounting and operational control model, capable of adapting to the most demanding environments in terms of traceability, taxation and financial efficiency. Thanks to its architecture based on inventory models, automated settlement processes and integrated accounting recording, it enables large-scale industrial companies and distributors to guarantee total consistency between their physical inventory and their financial accounting, in accordance with IFRS.
However, the power of the system demands an expert level of configuration and maintenance. The correct selection of the inventory model, operational discipline in the use of dimensions, the systematic execution of closes, and integration with tax localizations are indispensable conditions to avoid distortions in the cost of sales, in the stock value and in tax declarations.
In the context of Colombia and the Dominican Republic, where the accounting framework is harmonized with IFRS but tax requirements impose specific formats and reports, the success of an implementation depends on combining the native capacity of the ERP with:
- A clear and standardized accounting strategy from the functional design.
- Integration with certified localizations for tax compliance.
- A monthly close model that includes settlements, adjustments and reconciliations.
- And ongoing training of the financial and logistics team to interpret and maintain the applied valuation logic.
Dynamics 365 F&O does not only allow inventory valuation: it allows transforming stock management into a competitive advantage, improving profitability, minimizing deviations and ensuring the traceability demanded by both the regulator and the market.