Notifications
Announcements
No record found.
*This post is locked for comments
Hi Rosemary,
You can find this information in the Customer Summary Master table. There's a field called Last Transaction Date.
If you need more assistance with finding tables for report writing, Victoria Yudin has a very good description of tables and some field constants by module. Here are the RM tables: victoriayudin.com/.../rm-tables
Let me know if I can help you any further.
Thanks,
Mike
Thanks a million, just what I needed.
I am trying to determine slow moving items, this field is relative to AR??
My pleasure. Please accept the answer so others will be able to benefit from your question.
Hi Mike,
I am trying to determine slow moving items for our Inventory department, this field is relative to AR??
Rosemary
The Inventory Module has a table IV30300 which stores a document date and Item Number. I often use this table to identify last transaction date of items.
It can also be used to identify items with no transactional history.
The table name is Inventory Transaction Amounts History. It gets updated every time an inventory item is posted (sold, received, adjusted, varianced, etc.).
With Smartlist builder you could easily construct a SQL view which contains item number and last transaction date....
Good Luck
Another option would be to look at the Sales Order Processing tables for this:
SELECT ITEMNMBR Item_Number, max(DOCDATE) Last_Sale_Date
FROM SOP30300 D
INNER JOIN SOP30200 H
ON H.SOPTYPE = D.SOPTYPE AND H.SOPNUMBE = D.SOPNUMBE
WHERE H.SOPTYPE = 3 AND H.VOIDSTTS = 0 --only invoices and not voided
GROUP BY ITEMNMBR
ORDER BY ITEMNMBR
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
