Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

report, Inventory journal line - Movement logic

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

The report, Inventory journal line - Movement does not include physical count transaction ? can anyone give logic for this report , possible select statement will help.

thanks

*This post is locked for comments

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: report, Inventory journal line - Movement logic

    Hi,

    Below is the query used by InventJournalTrans - Movement report to fetch data.

    Path: Inventory management > Journals > Item transactions > Movement.Select Print and then click Journal

    VALUE:

    Query InventJournalTrans object:

           SELECT BOMLine, CostAmount, CostMarkup, CostPrice, Counted, Worker, InventDimId, InventOnHand,

            ItemId, JournalId, JournalType, LineNum,

           ProjCategoryId, ProjId, ProjUnitID, Qty, SalesAmount, TransDate, Voucher, TableId, LedgerDimension FROM

           InventJournalTrans(InventJournalTrans)

           ORDER BY InventJournalTrans.JournalId ASC, InventJournalTrans.LineNum ASC

           WHERE ((JournalType = 0)) AND ((JournalId = N'123'))

           JOIN FIRSTFAST FIRSTONLY * FROM InventDim(InventDim)

           ON InventJournalTrans.InventDimId = InventDim.inventDimId

           JOIN JournalId, PostedDateTime FROM InventJournalTable(InventJournalTable)

           ON InventJournalTrans.JournalId = InventJournalTable.JournalId

           OUTER JOIN FIRSTONLY CategoryId, Name FROM ProjCategory(ProjCategory)

           ON InventJournalTrans.ProjCategoryId = ProjCategory.CategoryId

           OUTER JOIN FIRSTONLY PersonnelNumber FROM HcmWorker(HcmWorker)

           ON InventJournalTrans.Worker = HcmWorker.RecId OUTER JOIN DisplayValue, MainAccount

           FROM DimensionAttributeValueCombination(DimensionAttributeValueCombination)

           ON InventJournalTrans.LedgerDimension = DimensionAttributeValueCombination.RecId

           OUTER JOIN MainAccountId, Name, RecId FROM MainAccount(MainAccount)

           ON DimensionAttributeValueCombination.MainAccount = MainAccount.RecId

    TYPE:

    Query

    Hope this helps you.

    Thanks,

    Chaitanya Golla

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans