I need to transfer stock to one of my stores. However, i don’t want to keep sending stock that they are not selling. Is there a report on NAV that allows you to see a list of all your inventory items, the last qty sold and the date it was sold on?
We had to add a field to our Item Card Called “Last Sale Date”, based on the Item Ledger Entry table.
It’s a Flowfield and the CalcFormula is
CalcFormula = Max(“Item Ledger Entry”.“Posting Date” WHERE (Item No.=FIELD(No.),Entry Type=FILTER(Sale),Quantity=FILTER(<0)))
Then we can use the new field for use in reports to figure out what hasn’t been recently sold.