I created a custom record type called 'stock status changes' and I made it a child of item records.  On every item record I now have a sublist of these stock status changes so I can see historically all of the stock status changes and I can see how long things were backordered and so on (I should also say that we dont use the Netsuite standard In Stock field).  What I want to do is source the latest stock status record and display in a custom field on the item record.
So I may have 5 stock status records - some say In Stock or Backordered but I want my custom item field to source the latest one.  That way I can display the most recent stock status on our website.  I created a custom item field and put in the formula {custstockstatus.custitemstockstatus} and I nested that within MAX statement.  It does indeed work but the behavior is not exactly what I was expecting.  Is there away to tweak this formula to show the most recent stock status record?