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

After finishing production order, invoiced quantity in value entry is not updated for some records

(7) ShareShare
ReportReport
Posted on by 18
After finishing the production order, the Invoiced Quantity field in the Value Entry table is not updated for a few records. Due to this issue, the Inventory Valuation report is showing incorrect quantities.(Adjust Cost batch job has already been run successfully)

Our immediate requirement is to understand the following:

  • How the already created Value Entry records can be corrected.

  • The issue has already impacted posted transactions, and our priority is to correct the affected data in the current environment.

Kindly guide us on:

  • Recommended steps or tools to align the Value Entry data correctly

  • Precautions or validations to be followed while performing these corrections

The current requirement is data correction, as the client needs to close the books for audit purposes.

An immediate solution or guidance on the data correction approach would be highly appreciated.

Value Entry Table.jpg
Finished Production Order.jpg
I have the same question (0)
  • Suggested answer
    Dhiren Nagar Profile Picture
    2,876 Super User 2026 Season 1 on at
     
    It is not advisable to change value entry directly. Considering there is only one value entry I think the problem is with the Expected to Actual move at the time of Finishing the order.
     
    Following the below steps might solve the issue in standard way.
     
    1 - Go to the Item card and check if Cost is Adjusted Boolean is true. If Yes, Make it false through Configuration Package (Do not worry it is ok to do it).
    2 - Run the Adjust Cost - Item entries batch job for that particular item again.
     
    You will see if another value entry is created with actual cost then the issue is solved.
     
    If with above steps it is not solve then follow below steps.
     
    1 - Reopen the Finished Production order (New Feature in Business Central).
    2 - Without doing any change Change the status of Production Order again to Finish and mark true the Boolean Update unit cost. This will retry to Finish and Invoice the already posted output entries.
     
    If none of the above solves it, its better to take Microsoft support rather than doing any customization to solve it quick. Report can be corrected outside the system requesting auditor for support due to system issue. Because this one change might affect your future posting and costing.
     
    Regards,
    Dhiren.
  • Suggested answer
    OussamaSabbouh Profile Picture
    11,606 Super User 2026 Season 1 on at
    Hello,
     
    This issue means the production output was posted but its cost was never fully finalized, so Value Entries show Valued Quantity but Invoiced Quantity = 0, which breaks Inventory Valuation; this is not something to fix manually. The supported correction is to rerun cost posting properly: first run Adjust Cost – Item Entries (All Items, All Levels), then Post Inventory Cost to G/L (this step is mandatory and often missed). If the Invoiced Quantity still doesn’t align, it indicates a historical posting interruption or corruption, and the only supported fix is reversing and re-posting the affected production output/order, not editing Value Entry or Item Ledger tables (even for audit). Take a full backup, ensure no users are posting, and reprocess in posting-date order; direct table edits or SQL updates will break costing and audit integrity.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    21,573 Super User 2026 Season 1 on at
    Correction must be done via reversal and re-posting, not direct data changes.
  • Suggested answer
    Sumit Singh Profile Picture
    11,751 Super User 2026 Season 1 on at
    Hi, 
     
    We faced similar kind of issue and we raised this issue with MS as well however we haven't found significant solution. Then, we resolved it internally with the help of technical resource in Sandbox environment by editing the Invoiced quantity field as manually did the changes as other details are correct.  
  • Suggested answer
    YUN ZHU Profile Picture
    98,358 Super User 2026 Season 1 on at
    While I personally don't recommend it, I hope the following information can give you some hints.
    Dynamics 365 Business Central: Can we insert/modify/delete posted data (Posted Documents & Posted Entries) via AL???
     
    Thanks.
    ZHU
  • Suggested answer
    CU22010325-0 Profile Picture
    18 on at
    We have tried all the methods suggested in this forum; however, the issue is still not resolved. The production order was created by the client two years ago. We have not made any direct changes in the Value Entries, as this is not advisable.

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,965 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,125 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 961 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans