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
Do you think about InventTransferJourLine.InventTransId field?
Hi prashanthr,
Voucher and transdate, you can try again. (inventtrans.datefinancial = inventtransferjour.transdate).
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 Ludwig,
Thanks. But I am asking about the attributes by which I can join these two tables.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156