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
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
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,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156