Does anyone know how we can get a report showing the last inventory transaction for an item? We are on version 9 and would need to get this report into excel.
Thanks,
Jennifer Pegg
Engine Control Systems Limited
*This post is locked for comments
Hi Jennifer,
Go to Inquiry --> Inventory --> Item Transaction. In the Item Transaction Inquiry window, select an item and check the Sort by Date to see all the transactions for the selected item. Also you can generate this as a report.
Thanks,
Prakash
The following SQL query will get the result you are looking for. It takes the most recent posted invoice for a particular item.
SELECT TOP 1 * FROM sop30300 a
JOIN sop30200 b ON a.SOPNUMBE=b.SOPNUMBE
WHERE ITEMNMBR='5004pc' AND b.soptype='3'
ORDER BY b.DOCDATE desc
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (