Notifications
Announcements
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
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
Hi Ludwig,
Thanks. But I am asking about the attributes by which I can join these two tables.
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?
Hi prashanthr,
Voucher and transdate, you can try again. (inventtrans.datefinancial = inventtransferjour.transdate).
Do you think about InventTransferJourLine.InventTransId field?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 663 Super User 2026 Season 1
Abhilash Warrier 289 Super User 2026 Season 1
Martin Dráb 232 Most Valuable Professional
