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) / Link the InventbatchID...
Microsoft Dynamics AX (Archived)

Link the InventbatchID to the Salesline

(0) ShareShare
ReportReport
Posted on by FrankRaij 50

Hello,

I guess not very difficult but I am still can't. How can I link the Inventbatchid to the Salesline. I know via the Inventdim, Inventtrans, Inventtransorigin, but I am struggeling with it.

I am working on the SalesConfirm SSRS report and I want to add the batchnumber to the salesline (from SalesconfirmDetailsTmp).

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,162 Moderator on at

    SalesLine.InventDimId has relation to InventDim.InventDimId. And in InventDim you have field InventBatchId.

  • FrankRaij Profile Picture
    FrankRaij 50 on at

    Hi Nikolaos,

    Thanks!! For some reason I don’t get a match on the inventdim. The batch is reserved. Maybe the route via inventtransorigin?

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Hi FrankRaij!

    You can get InventBatchId values from InventTrans.InventDimId. To get it you should use InventTransOrigin table.

    SalesLine.InventTransId == InventTransOrigin.InventTransId

    InventTrans.InventTransOrigin == InventTransOrigin.RecId

    InventDim.inventDimId == InventTrans.inventDimId

  • FrankRaij Profile Picture
    FrankRaij 50 on at

    Thanks! It works! Do you have experience with the tmp table SalesconfirmdetailsTmp most ideal would be that I can link with that table but the only link I can make is to the Custconfirmjour / custconfirmtrans but then I have the details of all the saleslines linked to a individual sales line (from the salesconfirmdetailsTmp

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    I think you can't directly link SalesLine to SalesConfirmDetailsTmp.

    The SalesConfirmDetailsTmp has only ItemId field, and if sales order will have more than one lines with the same ItemId you can't determine needed row.

  • FrankRaij Profile Picture
    FrankRaij 50 on at

    Ok! Thanks Rustem. Then I'll have to find another way. I think I am going to use the CustconfirmTrans then. Problem there that I need the taxpercentage (only have the the Taxgroup, Taxitemgroup and Taxwritecode).

  • guk1964 Profile Picture
    guk1964 10,888 on at

    Note also that there may also be more than one batch picked per sales order line. or that the same batch may be used to fulfill many sales orders.

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