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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
