Build out a slow moving inventory report by location – this would bucket inventory items that have not moved in 3-6 months, 6-12 months, and inventory that has not moved in over a year. It would show item, stock qty, description, received date or adjusted date, and last sold date.
I can get on hand but I can’t get last sold date. Also our Turn and Earn Report isn’t working is their a setting not turned on?
Hi Rob
There is both last_sale_date and last_purchase_date in the inv_loc table. Please be aware, in my experience the last_sale_date is the not equal to the last invoice for that item but rather the last date it was entered on an order. I would typically use invoice history to find the last sale date.
The last_purchase_date might be the same thing, not the date is was received but rather the date it was placed on a PO. I would probably go to inv_tran to find the actual receive date.