Relation between Inventtrans and Inventtransjour

(0) Share

Report

Posted on by prashanthr

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

All responses (5)

Answers (1)

SamYIP 5 on at

Like (0)

Report

RE: Relation between Inventtrans and Inventtransjour

Do you think about InventTransferJourLine.InventTransId field?
Verified answer

David Thai Vo 60 on at

Like (0)

Report

RE: Relation between Inventtrans and Inventtransjour

Hi prashanthr,

Voucher and transdate, you can try again. (inventtrans.datefinancial = inventtransferjour.transdate).
André Arnaud de Cal... 293,238 Super User 2025 Season 1 on at

Like (0)

Report

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 20 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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