Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Relation between Inventtrans and Inventtransjour

Posted on by 20

Hi,

I'm new to AX dynamics.

I am stuck in joining Inventtrans and Inventtransjour. I saw that these two tables can be joined using voucherid. But there are some records in Inventtransjour for which voucherid's are not available in inventtrans. Kindly help me to resolve this.

Thanls

  • SamYIP Profile Picture
    SamYIP 5 on at
    RE: Relation between Inventtrans and Inventtransjour

    Do you think about InventTransferJourLine.InventTransId field?

  • Verified answer
    David Thai Vo Profile Picture
    David Thai Vo 60 on at
    RE: Relation between Inventtrans and Inventtransjour

    Hi prashanthr,

    Voucher and transdate, you can try again. (inventtrans.datefinancial = inventtransferjour.transdate).

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Relation between Inventtrans and Inventtransjour

    Hi Prashanthr,

    Can you confirm if your question is about InventTransferJour and not InventTransJour? The last mentioned table does not exists. Do you have this situation in a production environment or a development environment?

  • prashanthr Profile Picture
    prashanthr 20 on at
    RE: Relation between Inventtrans and Inventtransjour

    Hi Ludwig,

    Thanks. But I am asking about the attributes by which I can join these two tables.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Relation between Inventtrans and Inventtransjour

    Hello prashanthr,

    Not all inventory transactions create vouchers.

    If you operate a company e.g. with a US localization then transfers of items between warehouses of the same site don't generate a voucher but an inventory transaction.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans