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) / Relation between seria...
Microsoft Dynamics AX (Archived)

Relation between serial number and batch number

(0) ShareShare
ReportReport
Posted on by Community Member

hi. i want to create a sales order. when i want to select serial number, i want AX automatically select the batch number that is related to this serial number that i see on on-hand inventory of product. can anyone help me?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at

    Hi,

    There is no direct relation between Serial and Batch Numbers. These are generated based on setup of serial and batch number groups.

    All the combination of inventory dimensions are stored in InventDim table and every combination has a unique InventDimID to identify the values of different dimensions. U can refer to a nice blog here:

    basicax.blogspot.in/.../ax2012-understanding-inventdimid.html

    I feel in your case serial numbers are unique. If this is the case you can find the InventDim table record for this serial number and then u can get the batch number of that inventDim record.

    Hope this helps.

    Thanks,

    Rachit Garg

  • Community Member Profile Picture
    Community Member on at

    Agreed, there is no forced hierarchy between serial number and batch number as with site and warehouse. However, with serial number control turned on, a developer could find the batch no from serial no.

  • Community Member Profile Picture
    Community Member on at

    Thanks Rachit Garg for your answer. I think you are right :)

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