hi all, I created a custom report based off of the "Stock Ledger" report under Reports>Inventory/Items>Stock Ledger. I am trying to find a way to pull the Document # or Transaction ID of the "Last Item Receipt" and "Last Invoice or Item Fulfillment". I was able to pull the last receipt and sales dates so i was hoping i could also pull the document numbers that relate to those dates. Any insight would be greatly appreciated. Thanks!

Is there some reason you’re not using the Inventory detail report instead of stock ledger?

We are basically using the stock ledger to do a form of inventory roll forward/inventory valuation as of a certain date range. So we are displaying the beginning inventory balance and ending balance based on that date range while also showing the date of last sale & receipt. Getting to be a pretty lengthy report but was hoping to find a simple way to incorporate the document numbers relating to those dates if possible