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
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
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156