Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Generating Invent Trans Record

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

  • 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,486 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.

  • sohaibcheema Profile Picture
    sohaibcheema 46,594 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

  • sohaibcheema Profile Picture
    sohaibcheema 46,594 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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans