Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Generating Invent Trans Record

(0) ShareShare
ReportReport
Posted on by 1,262

Hello Community, 

Would it be possible to tell me when records are inserted into InventTrans Table during Confirmation and posting Of a purchase order?

and which classes, tables are involved during this process?

Thanks a lot for your help

Kind regards

Jihane

*This post is locked for comments

  • jihane Profile Picture
    jihane 1,262 on at
    RE: Generating Invent Trans Record

    thank you all for your answers, i will take these answers as a first step to achieve the requirement

  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,626 Super User 2024 Season 2 on at
    RE: Generating Invent Trans Record

    Hi jihane,

    Records are inserted into InventTrans when a PO Line is created. I cannot think of a reason that would cause PO Confirmation to create records in InventTrans, since PO Confirmation does not affect inventory.

    Posting subsequent statuses of a PO could cause extra records to be created in InventTrans if, for example, the quantity being posted was not for the full quantity on the PO Line. For example, if you've a PO Line for a quantity of 3, posting the Product receipt for a quantity of 2 would result in one record in InventTrans with the receipt status Received, and another with a quantity of 1 with a different status.

    Sorry, I do not know which classes are responsible for the creation of records in InventTrans.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Generating Invent Trans Record

    apologies, let me correct my wording.

    InventTrans is created, only once for each PO Line

    there is also an index on PO Lines Table for it

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Generating Invent Trans Record

    InventJournalTrans is created only once at time of PO creation.

    in later stages (confirmation, receiving, invoicing) only status of InventTrans is changed. It is not recreated again.

    what you want to do actually?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Generating Invent Trans Record

    Set a breakpoint in the insert() method of the table and execute the logic (confirmation, posting). You can then see the classes involved in the debugger. It's a really vague question though. There are tons of classes involved in posting the main one probably being PurchFormLetter (and it's derived classes).

    You might want to read up on the parmTable framework.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans