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

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Update Missing Batch Numbers in Posted Inventory Transactions

(0) ShareShare
ReportReport
Posted on by 64
HI All, 

     In our live environment, the batch number is missing for two inventory transactions, even though the transfer orders were successfully created and financially posted.

Is it possible to update the inventory transaction records using a custom script, or is there any way—either through the frontend or backend—to update the batch numbers in the inventory transaction records? Additionally, the batch numbers should also be updated in the on-hand inventory.


 
Categories:
I have the same question (0)
  • Suggested answer
    H.M.Burhan Profile Picture
    296 Super User 2026 Season 1 on at

    You can reverse the entry and record it again with the batch number.

    Alternatively, you can use the Transfer journal to move the on-hand quantity from a blank batch number to a specific batch number.

    However, it is not recommended to update the data directly in the database.

    Cheers,
    Burhan
  • charanch Profile Picture
    64 on at
    Hi @H.M.Burhan thanks for your reply.

       why it is not recommended to update database directly, I mean what are the conflicts may happen.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 662 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 201 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans