LEDGERTRANS &INVENTTRANS

(0) Share

Report

Posted on by Peace Out

185

hi all, I am nw to Dynamics AX so I apologize for asking a silly question. How can I link/join LEDGERTRANS with INVENTTRANS table? Are all inventory transactions posted to Ledger? tahnks for helping out.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ronald Richter on at

Like (0)

Report

Hi,

the two tables are linked by the voucher. If an inventory transaction is posted financially (StatusIssue = Sold or StatusReceipt = Purchased) it always goes to the ledger Transactions which are physically posted in advance (e.g. by posting a packing slip) can also have a financial posting and have filled the VoucherPhysical in the inventTrans table. If physical and finacial post will be done in one step - voucher and physical voucher have the same value.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Peace Out,

What do you want to achieve with the linking of these tables? For reconciliation there is a report in AX2012 (Inventory value report).

Was this reply helpful? Yes No
Peace Out 185 on at

Like (0)

Report

we are using a product for reporting and it requirs identifying all the relaitonship between tables.

so i queried the two tables for a apecifi voucer and found 8 rows in one LEDGERTRANS and 5 rows in INVENTTRANS table. What am I doing wroing here?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Peace out,

There is no 1 on 1 relation between ledger transactions and inventory transactions. To understand the relation correctly, you need a deep dive into the transactions, as well as the tables InventTransPosting and InventSettlement.

Multiple inventory transactions can be summarized on one ledger transaction.

The 8 rows in your LedgerTrans sample are perhaps the complete voucher for all ledger accounts.

Example: when you post a loss of a product you will have two ledger ledger transactions for one inventory transaction: Inventory account posted credit and profit and loss account posted debit.

Example: when you post a loss of 4 products of the same item group you will have two ledger ledger transactions for 4 inventory transactions: Inventory account posted credit and profit and loss account posted debit.

When doing an inventory closing or recalculation the affected inventory transactions do not contain information about the new created ledger transactions. This is then in the table InventSettlement.

You will need an expert on this to create a combined report. Doing it outside of AX will make life not easier.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You can link InventTrans to LedgerTrans

InventTrans is linked to InventTransPosting table and

InventTransPosting is linked to ledgerTrans

Please analyse the Relations node of these tables you will be able to set the relation

and will be able to find the data as per your requirement

Was this reply helpful? Yes No