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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Remove batch number fr...
Microsoft Dynamics AX (Archived)

Remove batch number from Inventory dimension

(0) ShareShare
ReportReport
Posted on by Paul1 1,200

Hi,

I have a scenario wherein a batch number was created to InventDim table via a web service through an Inventory movement logic. By some mistake in the past, this batch number should never been created since the customer does not manage their inventory per batch number. And they want this to be removed.

Now my plan is to update/remove the value from InventBatchId in InventDim table for the following reasons:

  1. Avoid creating new Inventory dimension as it is already used in many transactions, and consequently
  2. Avoid inventory recalculation
Are there any risks or issues with the said implementation? OR should I create another InventDim record without the batch number?
Thanks,
Paul

*This post is locked for comments

I have the same question (0)
  • Paul1 Profile Picture
    Paul1 1,200 on at
    RE: Remove batch number from Inventory dimension

    Thank you Tim. I think it answers now my question.

    Upon checking the setup, yes, the batch ID is active and allows blank issue and receipt.

    But, how about those posted Inventory transactions with the old InventDim? I think they should NOT be updated for the fact that they were already posted and since a new Inventory transactions are to be created by the transfer journal. Am right on this? :)

    Thanks,

    Paul

  • Verified answer
    Tim Schofield Profile Picture
    Tim Schofield on at
    RE: Remove batch number from Inventory dimension

    Hi Paul, I'm not sure now what your issue is. I thought that your issue was that you simply had some records in the InventDim table with a batch id - and you're not using batches so you wanted to delete them.

    If you have inventory transactions related to those InventDimId's then you'll have to create transfer journals to  move the on hand inventory to the required inventory dimensions (without batch) but you won't be able to do that if the batch id isn't active on the item number. You'll have to create a Inventory Dimension group which has Batch ID active, but allows blank issue and receipt.

  • Paul1 Profile Picture
    Paul1 1,200 on at
    RE: Remove batch number from Inventory dimension

    Thanks!

    I'm using AX 2009.

    Does it also mean that I have to create a movement journal from old Invent dimension (with batch#) to new Invent dimension (without the batch#)?

    Best regards,

    Paul

  • Tim Schofield Profile Picture
    Tim Schofield on at
    RE: Remove batch number from Inventory dimension

    What about running the standard job at Inventory management > Periodic > Clean-up > Inventory dimensions cleanup?

    Sorry but I don't know which version that appeared in.

    Tim

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,785 Super User 2025 Season 2 on at
    RE: Remove batch number from Inventory dimension

    Hi Paul,

    There is a possibility to use inventory journals in AX. You can use these or fill these with a script. I don't have code sample available for it. If you are using AX2012, you might use Data Import/Export Framework or write an own script.

  • Paul1 Profile Picture
    Paul1 1,200 on at
    RE: Remove batch number from Inventory dimension

    Hi André,

    Thanks!

    Batch number is not activated as tracking dimension. It's just a record was created in InventBatch and InventDim by customization a very long time ago by previous developers. :)

    With regards to InventDim, well yeah, I should never update those. I mistook the part of duplicate combinations. About your comment

    " try to post the quantity on batches to zero and repost them on an empty batch number"

    Can you please give me a code sample or maybe a reading material on how the various methods and classes with regards to qty posting can be implemented?

    Your assistance is very much appreciated. :)

    Thanks,

    Paul

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,785 Super User 2025 Season 2 on at
    RE: Remove batch number from Inventory dimension

    Hi Paul,

    Updating the InventDim records might cause duplicate combinations. Please don't do this. Is the batch number activated as Tracking dimension in the groups?

    The best would use one (new or already existing) InventBatchId, but...

    Note that related to a setting the Batch number can be part of financial inventory and could have a cost price per batch. I don't know these settings in your environment.

    Note that changing the InventDimId on transactions might cause data corruption. The InventDimId is used in several transaction and worksheet tables.

    Personally I would not update the data, but try to post the quantity on batches to zero and repost them on an empty batch number.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Community Member Profile Picture

Community Member 2

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans