Monday, March 11, 2019

Saved Search to Show the Last Item Receipt Date per Item and its Age as of Today

1. Navigate to Lists > Search > Saved Searches> New > Item.


2. Under Criteria tab, enter the following:

   a. Type: Inventory Item
   b. Transaction Fields..Type: Item Receipt


3. Under Results tab, enter the following:

   a. Name | Summary Type: Group

   b. Display Name | Summary Type: Group

   c. Transaction Fields..Date | Summary Type: Maximum

   d. Formula (Text) | Summary Type = Maximum | Formula = round({today}-{transaction.datecreated},0)


4. Enter a Search Title and hit Save.


  1. It's truly very difficult in this busy life to listen news on Television, thus I just use world wide web for that reason, and take the most recent news.

  2. Howdy! I realize this is sort of off-topic but I had to ask.
    Does operating a well-established blog like yours require a large
    amount of work? I'm brand new to operating a blog but I do write in my
    journal daily. I'd like to start a blog so I will be able to share my own experience and views online.
    Please let me know if you have any kind of recommendations
    or tips for new aspiring blog owners. Thankyou!

  3. I have learn a few good stuff here. Certainly worth bookmarking for revisiting.
    I wonder how a lot effort you place to create one of these magnificent informative site.

  4. Awesome blog! Is your theme custom made or did you download it from somewhere?

    A design like yours with a few simple adjustements would
    really make my blog jump out. Please let me know where you got your theme.

  5. I am extremely impressed with your writing skills as well as
    with the layout on your blog. Is this a paid theme or did you modify
    it yourself? Either way keep up the nice quality writing, it is
    rare to see a great blog like this one these days.