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) / Difference Inventdimid...
Microsoft Dynamics AX (Archived)

Difference Inventdimid between purchline and inventtrans

(0) ShareShare
ReportReport
Posted on by Colin Lee 60

Hi. Expert. 

Could you please advise me? 

I have found a situation what a inventdimid is different between purchline and inventtrans. 

this data can be create as follow steps. 

1. add a purchase line on the purchase order 

2. fill an item and batch number 

3. save the line 

4. remove batch number and save again, And then you can see a massage  

  "Dimension Batch number is still specified on the inventory transaction with value  xxxx"

5. check inventdimid record in purchline and inventtrans table 

i think it's standard logic but i can't understand why. 

sometimes an  user do PO process like upper steps by mistake. and the man would find missing batch number in the purchase line. 

maybe the user would think it's error.

please advise me about this. 

*This post is locked for comments

I have the same question (0)
  • Colin Lee Profile Picture
    Colin Lee 60 on at
    RE: Difference Inventdimid between purchline and inventtrans

    Hi. Virginia Santamaria 

    thanks very much for your kindly explain. 

    i understood clearly !! 

    thanks again~!! 

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Difference Inventdimid between purchline and inventtrans

    Hi Colin,

    I'll try to explain this situation as well as I can. I hope you understand me!

    This situation is correct. One purchase line can have several inventory transactions (with the same inventTransId of the purchase line, related through InventTransOrigin table), each of one with distinct InventDimId. For example, you create a purchase line with one item and buy 100 units of it. But this item is controled by Serial Number, so, when you register your receipt (through register form, inventory reception journals, etc.) you will assing each unit to a distinct serial number. This action will split the original transaction (which was created when you created the purchase line) in other transaction linked to the new inventory dimension.

    There is no way to indicate this information in one line of purchase orders, unless you create as many lines as you need from the item and the inventory dimension combination you want.

    So, you can find distinct inventDimId in inventTrans table and PurchLine table, but in all the queries about on hand inventory (for example), the valid inventory dimensions are the ones specificate on inventTrans table.

    Regards!

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

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Rahul Shah Profile Picture

Rahul Shah 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans