Notifications
Announcements
No record found.
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…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader