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

Notifications

Announcements

No record found.

News and Announcements icon
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)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    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.

  • Paul1 Profile Picture
    Paul1 1,200 on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    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.

  • Tim Schofield Profile Picture
    Tim Schofield on at

    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

  • Paul1 Profile Picture
    Paul1 1,200 on at

    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

  • Verified answer
    Tim Schofield Profile Picture
    Tim Schofield on at

    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

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans