Hey Acumatica Community,

Just wanted to share a write up on something that I have been utilizing frequently to get results that Clients have been wanting in their Generic Inquiries. This is not of my own invention but something that I learned how to do on the Acumatica Community forums and have had the need for on many occasions for varying scenarios. Get ready for a slight read but if you're interested in learning/understanding how to isolate the most recent record entered into any data table in Acumatica then you're in the right place.

I was unable to copy paste the document directly into this post, so you will need to review the attached .PDF file. The .XML file for the Generic Inquiry from the document is also attached here to this post.


Credit for this method belongs to a user in the Acumatica Community who goes by Gabriel Michaud. Here is a link to the original Community post where I found this method that was presented by Gabriel as an answer to someone else’s post. How to get the last sales price and qty using GI? | Community (acumatica.com) -> https://community.acumatica.com/reports-and-generic-inquires-115/how-to-get-the-last-sales-price-and-qty-using-gi-4856