Recipe: Days since last consumption

When did you last time sell this item? Yesterday or last year?

WHAT:

This calculation gives you the number of day since last sales/consumption. Use it for example when you have to identify high-frequency items that suddenly do not sell.

WHY CALCULATE DAYS SINCE LAST CONSUMPTION?

Items, that no customer is buying any longer, take unnecessary storage space. By calculating days since last consumption, you can set up extra categories and/or reports containing items that have not been sold in a given period.

You can benefit from creating a report called “Items to be phased out?” or “AA items without sales in 20 days” based on “Days since last consumption”.

COLUMNS NEEDED IN THE CALCULATION:

• Last date of sales (DATE) or
• Last date of consumption (DATE)

FORMULA:

FileDate()-days([Last date of consumption])