web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Assembly Output Duplicating Quantity During Cost Adjustment - Average Cost Components Issue

(6) ShareShare
ReportReport
Posted on by 76

Hello BC Community,

 

I'm experiencing a critical issue with Assembly Order cost adjustments in Business Central 2023 Wave 2 (v23.0.17) on-premises and wondering if anyone else has encountered this.

 

The Problem

 When "Adjust Cost - Item Entries" runs for assembly orders that consume components and output with Average costing method, the system creates multiple value entries for the assembly output that incorrectly add quantity instead of just adjusting cost.Every time a component's average cost is adjusted, the system creates a new value entry for the assembly output with full quantity instead of zero quantity with just a cost adjustment.
 
Is this expected behavior?

When adjusting assembly output costs due to component average cost changes, should the adjustment value entries have:


  • Valued Quantity = 0 (cost-only adjustment), OR

  • Valued Quantity = full quantity (what we're seeing)?

  •  

It appears the system is treating each cost adjustment as a new quantity movement rather than a pure cost adjustment.

I have the same question (0)
  • Suggested answer
    OussamaSabbouh Profile Picture
    11,792 Super User 2026 Season 1 on at
    Hello,
    This behavior is by design for Assembly Orders using Average Cost. When component average costs change, Business Central revalues the full assembly output quantity, so Adjust Cost – Item Entries creates new value entries with the full quantity, not zero-quantity cost-only entries. These are not additional inventory movements—they’re how average costing recalculates value, and the net item quantity remains correct at the item ledger level. If this causes reporting or audit issues, the only real workaround is not using Average Cost for assembly outputs (use FIFO or Standard Cost instead), as this behavior isn’t configurable.
    Regards,
    Oussama 
  • Suggested answer
    YUN ZHU Profile Picture
    98,569 Super User 2026 Season 1 on at
    Hi,As far as I know, this only affects Valued Quantity, and has no effect on ILE Quantity or Invoiced Quantity.
     
    Thanks
    ZHU
  • Suggested answer
    Dhiren Nagar Profile Picture
    2,882 Super User 2026 Season 1 on at
    Hi,
     
    This is by system design. For Quantity values system relies on Item ledger entry Quantity and Remaining Quantity columns. However for value of such quantity is dependent on Value entries. So each time there is quantity transaction i.e. Sales, Purchase, Item adjustment etc. And each time there is a value adjustment like Adjusting cost, Addition to the cost, loading of the cost or expected to actual cost movement etc, a value entry is created.
    Now in value entry if you see Item ledger entry quantity is 0. Valued Quantity is to show that the cost adjustment is for how many quantity in order show per unit changes. Also Invoiced quantity is to show how many quantities are invoiced in case of Sales or Purchases etc.
     
    Regards,
    Dhiren.
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    9,106 Super User 2026 Season 1 on at
    Hi,

    When you run Adjust Cost – Item Entries for an item that uses Average costing, the system creates new adjustment value entries to reflect updated costs on all related outbound value entries (including outputs from assembly orders) whenever component costs change. Those adjustment entries will include cost changes, and they can appear associated with an outbound quantity, but that doesn’t mean BC is treating the adjustment as additional physical quantity. It’s just how the cost adjustment mechanism works for average cost: it forwards cost differences to existing value entries so that inventory valuation stays accurate. 

    Why you see multiple value entries at full quantity:
    • For average items, BC detects cost changes using the Average Cost Adjustment Entry Point and Order Level detection functions. Value entries that represent assembly outputs get adjusted cost entries based on the original quantities so that their total inventory value matches the recalculated average cost. 
    • In the Adjust Cost – Item Entries batch job, the system doesn’t post a zero‑qty adjustment with only cost; instead, it posts adjustment entries that mirror the quantity of the original outbound (assembly) entry so that the total cost value is correct. This is by design for average costing logic.
       

    So, is this a bug?
    No, what you’re seeing is BC’s defined adjustment behavior for average cost items. The system will create adjustment entries that reflect the original quantity of the output when forwarding cost differences. This ensures inventory valuation and cost of goods sold remain accurate according to average costing principles.

    If you expected cost‑only adjustments (zero quantity):
    The average costing engine in BC does not create separate zero‑quantity cost‑only entries, it adjusts value entries in a way that maintains consistent quantity/valuation relationships. If you need a different behavior (e.g., purely cost adjustments separate from quantities), that would require a custom solution or a reporting interpretation layer rather than a change to the core average cost logic.

    In short: BC’s cost adjustment for average costing always posts adjustment entries tied to the original quantity, multiple value entries aren’t duplicates of physical movement, they’re adjustment entries needed to forward costs. That’s standard system behavior.

    Helpful References
    Manually adjust the costs of items - Business Central | Microsoft Learn
    Design Details - Cost Adjustment - Business Central | Microsoft Learn

    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,822 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,136 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 956 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans