slindsay14

Log Report

Discussion created by slindsay14 on Feb 5, 2016
Latest reply on Feb 5, 2016 by siplus

I am working on a script that will run a inventory position report. Have been focusing getting the report from our product log which creates a record in a related table when a item is invoiced. What I want to do is call up totals from the log on a specific date going backwards. Problem is there may not be a log entry for every item on the particular date so I'm thinking I need to call up the last entry in the log prior to the date in question.  I've experimented with different variations of Last, Max, Get(RecordNumber), Get(RecordID) and other Get functions with no success yet, but not sure I am using them correctly. Any suggestions ? 

Outcomes