Reply To: Items with no transactions since a given date

  • Tiffany Collums

    May 7, 2024 at 8:54 am

    I agree with Lewis on using the Item Ledger Entries and Item tables.

    I go to Item Ledger Entries and sort Posting Date by descending order then export to Excel, then I delete duplicates by Item No. Then to get a comprehensive list of items with no activity or latest transaction date, I also take an export of all Items and do a vlookup against Item No and bring in the Posting Date from the Item Ledger Entries export. I can then filter by whatever date period I am looking for and it also will show me items with no transaction history too.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!